ó Þ@Qc@sdddlZddlZddlZddlmZddlmZdZdefd„ƒYZdS(iÿÿÿÿN(t WizardPage(t MiniTemplatesy ------------------------------------------------------------------------------------ MySQL Workbench Migration Wizard Report Date: {{date}} Source: {{sourceRdbmsName}} {{sourceRdbmsVersion}} Target: {{targetRdbmsName}} {{targetRdbmsVersion}} ------------------------------------------------------------------------------------ I. Migration 1. Summary Number of migrated schemata: {{#catalog.schemata}} [[catalog.schemata]] {{:#}}. {{name}} Source Schema: {{sourceName}} - Tables: {{#tables}} - Triggers: {{#triggers}} - Views: {{#views}} - Stored Procedures: {{#procedures}} - Functions: {{#functions}} [[/catalog.schemata]] 2. Migration Issues [[migrationLog]] - {{refObject.name}} [[entries]][[?name]]{{entryType}} {{name}}[[/name]][[/entries]] [[/migrationLog]] 3. Object Creation Issues [[creationLog]] - {{refObject.name}} [[entries]][[?name]]{{entryType}} {{name}}[[/name]][[/entries]] [[/creationLog]] 4. Migration Details [[catalog.schemata]][[tables]] 4.{{:#}}. [[?name]]Table {{owner.name}}.{{name}} ({{sourceName}}) [[?comment]]{{comment}}[[/comment]] Columns: [[columns]][[?name]] - {{name}} {{formattedRawType}} {{flags}} {{defaultValue}} [[?comment]]#{{comment}}[[/comment]] [[!name]]column not migrated [[/name]][[/columns]] Foreign Keys: [[foreignKeys]] - {{name}} ([[columns]]{{name}}[[/columns]]) ON {{referencedTable.name}} ([[referencedColumns]]{{name}}[[/referencedColumns]]) [[/foreignKeys]] Indices: [[indices]] - {{name}} ([[columns]]{{referencedColumn.name}}[[?if|columnLength > 0]]({{columnLength}})[[/if]][[?needsep]], [[/needsep]][[/columns]]) [[/indices]][[!name]]4.{{:#}} Table {{sourceName}} was not migrated [[/name]] [[/tables]][[/catalog.schemata]] II. Data Copy [[dataTransferLog]] - {{logObject.name}} [[entries]] [[?name]]{{entryType}} {{name}}[[/name]] [[/entries]] [[/dataTransferLog]] tFinalReportViewcBs5eZd„Zd„Zd„Zd„Zd„ZRS(cCsktj||dƒ|jj|ddƒtjtjƒ|_|jj |jt t ƒ|j j dƒdS(NsMigration ReporttREPORTtFinish( Rt__init__tmaintadd_wizard_pagetmformst newTextBoxtVerticalScrollBart_reporttcontenttaddtTruet next_buttontset_text(tselfR((s..\modules\migration_summary.pyRes cCs'|r|jƒntj||ƒdS(N(tgenerate_migration_reportRtpage_activated(Rt advancing((s..\modules\migration_summary.pyRps c s |jjj}|j}|j}d„‰‡fd†‰‡‡fd†‰‡‡‡fd†}d„}d„}ddl}i |jƒd6|jjj j d 6d |j j |j j |j jfd 6|jjj j d 6d |jj |jj |jjfd 6|jjd6|jjd6g|jD]'}t|jƒdkr$||ƒ^q$d6g|jD]'}t|jƒdkr\||ƒ^q\d6g|jD]'}t|jƒdkr”||ƒ^q”d6i|jd6|jd6g|jD]} || |ƒ^qãd6d6} | S(NcSs.x'|jD]}|j|kr |jSq WdS(N(t migrationLogt logObjectt refObjecttNone(tobjecttstatetlog((s..\modules\migration_summary.pytfind_migrated_object{s c sg}x-|jD]"}|j|kr|j}PqqWg}x-|jD]"}|j|krF|j}PqFqFWig|D]?}idddgtt|jdƒdƒd6|jd6^qvd6g|D]?}idddgtt|jdƒdƒd6|jd6^qÃd 6}|rÿxê|jD]Ü}t ||ƒ}t |ƒt t t tfkr\|||s   J