Xׯd%NddlZddlZddlmZddlmZdZGddeZdS)N) WizardPage) MiniTemplateax ------------------------------------------------------------------------------------ MySQL Workbench Migration Wizard Report Date: {{date}} Source: {{sourceRdbmsName}} {{sourceRdbmsVersion}} Target: {{targetRdbmsName}} {{targetRdbmsVersion}} ------------------------------------------------------------------------------------ I. Migration 1. Summary Number of migrated schemas: {{#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]] c2eZdZdZdZdZdZdZdZdS)FinalReportViewcZtj||d|j|ddt jtj|_|jd|j |jdd|j ddS)NzMigration ReportReportTFinish) r__init__mainadd_wizard_pagemforms newTextBoxVerticalScrollBar_reportset_namecontentadd next_buttonset_text)selfr s ..\modules\migration_summary.pyr zFinalReportView.__init__hsD$(:;;; !!$2DEEE()ABB  0111 tT222 !!(+++++ch|r|dt|jjjjvr5|jd|j dn|j dtj ||dS)NGenerateBulkCopyScriptz*Open folder that contains generated scriptTF) generate_migration_reportlistr planstatedataBulkTransferParamskeysadvanced_buttonrshowrpage_activated)r advancings rr#zFinalReportView.page_activatedts  1  * * , , ,'4 0D0[0`0`0b0b+c+ccc$--.Z[[[$))$////$))%000!$ 22222rc |jjj j} j}dfdfd  fddd ddl}| jjj j j j d j j d j j jjj j jj d jj d jj jj jjfd  jDfd  jD fd  jD|j|j fd |jDd d }|S)NcB|jD]}|j|kr |jcSdSN) migrationLog logObject refObject)objectrlogs rfind_migrated_objectzBFinalReportView.generate_report_data..find_migrated_objects9) ) )=F**=(((+4rctg}jD]}|j|kr |j}ng}jD]}|j|kr |j}nd|Dd|Dd}|r|jD]}t ||}t |ttttfvr|||<At |tj urQ|j dtj tjfvrd|||<fd|D||<t!|tjr|||<|||<|S)Nc tg|]5}gdtt|jdd|jd6Snotewarningerrorr)typemessagemaxmin entryTypename.0es r zRFinalReportView.generate_report_data..reportize_object..sa#S#S#SCD.J.J.J3sSTS^`aObObdeKfKf.guvu{$}$}#S#S#Src tg|]5}gdtt|jdd|jd6Sr0r8r=s rr@zRFinalReportView.generate_report_data..reportize_object..sa S S S@A+G+G+GCPQP[]^L_L_abHcHc+drsrx!z!z S S Sr)migrationMessagescreateMessagesrz, c(g|]}|SrE)r>xreportize_objectrs rr@zRFinalReportView.generate_report_data..reportize_object..s'(O(O(O)9)9!U)C)C(O(O(Or)r(r)entries creationLog__grtmembers__getattrr6intfloatstrgrtList__contenttype__STRINGINTjoin isinstanceObject) r+r logEntriesr, createEntriesomembervrGs ` rrGz>FinalReportView.generate_report_data..reportize_objectsJ)  =F**!$JE+M(  =F**$'KME+#S#SHR#S#S#S S SER S S SA &$3 & &F//AAww3sC"888$%& aCH,,,Q/CJ3HHH(, ! AfII(O(O(O(O(OQ(O(O(OAfII#Asz22&$%& $%& Hrc|}|}||j|rfd|jDng|rfd|jDng|rfd|jDngd|S)Nc(g|]}|SrErE)r>columnrGrs rr@zQFinalReportView.generate_report_data..reportize_table..s'XXXV))&%88XXXrc(g|]}|SrErE)r>fkrGrs rr@zQFinalReportView.generate_report_data..reportize_table..s'XXXR--b%88XXXrc(g|]}|SrErE)r>indexrGrs rr@zQFinalReportView.generate_report_data..reportize_table..s'VVVE))%77VVVr) sourceNamecolumns foreignKeysindices)updater<rdrerf)tablermigratedobjr-rGs ` rreportize_tablez=FinalReportView.generate_report_data..reportize_tables++E599H""8U33C JJ :\dlXXXXXxGWXXXXjl\dlXXXXX8CWXXXXjlZbjVVVVVXEUVVVVhj     Jrc 0|}|}||jfd|jDfd|jDfd|jDfd|jDfd|jDd|S)Nc(g|]}|SrErE)r>rhrkrs rr@zRFinalReportView.generate_report_data..reportize_schema..s%QQQ%u55QQQrc<g|]}|jD]}|SrE)triggers)r>rhtriggerrGrs rr@zRFinalReportView.generate_report_data..reportize_schema..s9tttuejesttZa**7E::ttttrc(g|]}|SrErE)r>viewrGrs rr@zRFinalReportView.generate_report_data..reportize_schema..s'NNN''e44NNNrc>g|]}|jdk |S)FUNCTION routineType)r>funcrGrs rr@zRFinalReportView.generate_report_data..reportize_schema..s6wwwTX\XhlvXvXv++D%88XvXvXvrc>g|]}|jdk |S) PROCEDUREru)r>sprGrs rr@zRFinalReportView.generate_report_data..reportize_schema..s6sssBUWUcgrUrUr,,R77UrUrUrr)rctablesroviews functions procedures)rgr<r{r|routines)schemartschema schema_datar-rGrks ` rreportize_schemaz>FinalReportView.generate_report_data..reportize_schemas**6599G**7E::K   !;QQQQQ6=QQQttttt tttNNNNNNNNwwwwwV_wwwsssss&/sss       rcnd|jjid|jr |jjndid|jDdS)Nr<c tg|]5}gdtt|jdd|jd6S)r1r5rr;r<r8r=s rr@zOFinalReportView.generate_report_data..reportize_log..s[LLLz{)E)E)Ec#ak[\J]J]_`FaFa)bmnmsuuLLLr)r)r*rH)r)r<r*rHr,s r reportize_logz;FinalReportView.generate_report_data..reportize_logsc!CM$68!#-$OCM$6$6RQLL@C@KLLL rc8d|jid|jDdS)Nr<c tg|]5}gdtt|jdd|jd6S))rr3r4r5rrr8r=s rr@zXFinalReportView.generate_report_data..reportize_transfer_log..s[HHHvw)A)A)A#c!+WXFYFY[\B]B])^ijioqqHHHr)r)rH)r<rHrs rreportize_transfer_logzDFinalReportView.generate_report_data..reportize_transfer_logsC!CH.HH{~|GHHH rr.cVg|]%}t|jdk|&SlenrHr>rYrs rr@z8FinalReportView.generate_report_data..s6[[[aAIYZHZHZq))HZHZHZrcVg|]%}t|jdk|&Srrrs rr@z8FinalReportView.generate_report_data..s6]]]q#ai..[\J\J\--**J\J\J\rcVg|]%}t|jdk|&S)rr)r>rYrs rr@z8FinalReportView.generate_report_data..s=lll1Y\]^]fYgYgjkYkYk33A66YkYkYkrc(g|]}|SrErE)r>rrrs rr@z8FinalReportView.generate_report_data..s'```f**6599```r)rcr<schemata) datesourceRdbmsNamesourceRdbmsVersiontargetRdbmsNametargetRdbmsVersion sourceServer targetServerrIr(dataTransferLogcatalog)r rr sourceCatalog targetCatalogtimectimesourceConnectiondriverownercaptionsourceDBVersion majorNumber minorNumber releaseNumbertargetConnectiontargetDBVersionhostIdentifierrIr(rr<r) rsource_catalogtarget_catalogr report_datar-rrGrrkrrs @@@@@@@rgenerate_report_dataz$FinalReportView.generate_report_datas $,,         >                     !29?G-2-B-N-N-NPUPePqPqPqsxtItWtW X!29?G-2-B-N-N-NPUPePqPqPqsxtItWtW X/>/>[[[[53D[[[]]]]E4F]]]llll@Ulll*.#(`````H_```    &rc8|jdSr')r closers rgo_nextzFinalReportView.go_nexts rc|} tt|}n#t$r}d|z}Yd}~nd}~wwxYw|j|dS)NzError generating report: %s)rr text_templaterender Exceptionr set_value)rrreportexcs rrz)FinalReportView.generate_migration_reports//11  9!-0077 DDFF 9 9 92S8FFFFFF 9 v&&&&&s'> AAAcxtj|jjjjddS)Nr)r Utilities reveal_filer rrrrs r go_advancedzFinalReportView.go_advanceds/$$TY^%9%PQi%jkkkkkrN) __name__ __module__ __qualname__r r#rrrrrErrrrgsw , , ,333cccJ'''lllllrr)r rO workbench.uirworkbench.templaterrrrErrrs, ######++++++ D NLlLlLlLlLljLlLlLlLlLlr