| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ sX d d l Z d d l Z d d l m Z d d l m Z d Z d e f d � � YZ d S( i����N( t
WizardPage( t MiniTemplatesx
------------------------------------------------------------------------------------
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]]
t FinalReportViewc B s> e Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C sk t j | | d � | j j | d d � t j t j � | _ | j j | j t
t
� | j j d � d S( Ns Migration Reportt Reportt Finish(
R t __init__t maint add_wizard_paget mformst
newTextBoxt VerticalScrollBart _reportt contentt addt Truet next_buttont set_text( t selfR ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR d s
c C sx | rd | j � d | j j j j j � k rQ | j j d � | j j t � qd | j j t
� n t j | | � d S( Nt GenerateBulkCopyScripts* Open folder that contains generated script(
t generate_migration_reportR t plant statet dataBulkTransferParamst keyst advanced_buttonR t showR t FalseR t page_activated( R t advancing( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR o s
c s
| j j j } | j } | j } d � � � f d � � � � f d � � � � � f d � } d � } d � } d d l } i | j � d 6| j j j j
d 6d
| j j | j j
| j j f d 6| j j j j
d 6d
| j j | j j
| j j f d
6| j j d 6| j j d 6g | j D]' } t | j � d k r$| | � ^ q$d 6g | j D]' } t | j � d k r\| | � ^ q\d 6g | j D]' } t | j � d k r�| | � ^ q�d 6i | j d 6| j d 6g | j D] } | | | � ^ q�d 6d 6}
|
S( Nc S s. x' | j D] } | j | k r
| j Sq
Wd S( N( t migrationLogt logObjectt refObjectt None( t objectR t log( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt find_migrated_object s c
s g } x- | j D]" } | j | k r | j } Pq q Wg } x- | j D]" } | j | k rF | j } PqF qF Wi g | D]? } i d d d g t t | j d � d � d 6| j d 6^ qv d 6g | D]? } i d d d g t t | j d � d � d 6| j d 6^ q� d 6} | r�x� | j D]� } t | | � } t
| � t t t
t f k r\| | | <q t
| � t j k r�| j d t j t j f k r�d
j | � | | <q�g | D] } � | | � ^ q�| | <q t | t j � r�| | | <q | | | <q Wn | S( Nt notet warningt errori i t typet messaget migrationMessagest createMessagess , ( R R t entriest creationLogt maxt mint entryTypet namet __grtmembers__t getattrR' t intt floatt strt unicodet grtt Listt __contenttype__t STRINGt INTt joint
isinstancet Object(
R! R t
logEntriesR" t
createEntriest et ot membert vt x( t reportize_object( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyRF � s4 MP
)
c s� � | | � } � | | � } | j i | j d 6| r\ g | j D] } � | | � ^ qA n g d 6| r� g | j D] } � | | � ^ qs n g d 6| r� g | j D] } � | | � ^ q� n g d 6� | S( Nt
sourceNamet columnst foreignKeyst indices( t updateR0 RH RI RJ ( t tableR t migratedt objt columnt fkt index( R# RF ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_table� s
226c s% � | | � } � | | � } | j i | j d 6g | j D] } � | | � ^ q; d 6g | j D]% } | j D] } � | | � ^ qn qa d 6g | j D] } � | | � ^ q� d 6g | j D]$ } | j d k r� � | | � ^ q� d 6g | j D]$ } | j d k r� � | | � ^ q� d 6� | S( NRG t tablest triggerst viewst FUNCTIONt functionst PROCEDUREt
procedures( RK R0 RS RT RU t routinest routineType( t schemaR t tschemat schema_dataRL t triggert viewt funct sp( R# RF RR ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_schema� s
&6&59c S s� i i | j j d 6d 6i | j r/ | j j n d d 6d 6g | j D]? } i d d d g t t | j d � d � d
6| j d 6^ qD d 6S( NR0 R t R R$ R% R& i i R/ R+ ( R R0 R R+ R- R. R/ ( R" RA ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt
reportize_log� s #c S se i i | j d 6d 6g | j D]? } i d d d g t t | j d � d � d 6| j d 6^ q d 6S(
NR0 R Rd R% R& i i R/ R+ ( R0 R+ R- R. R/ ( R" RA ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_transfer_log� s i����t datet sourceRdbmsNames %s.%s.%st sourceRdbmsVersiont targetRdbmsNamet targetRdbmsVersiont sourceServert targetServeri R, R i t dataTransferLogRG R0 t schematat catalog( R R R t
sourceCatalogt
targetCatalogt timet ctimet sourceConnectiont drivert ownert captiont sourceDBVersiont majorNumbert minorNumbert
releaseNumbert targetConnectiont targetDBVersiont hostIdentifierR, t lenR+ R Rn R0 Ro ( R R t source_catalogt target_catalogRc Re Rf Rs RB R\ t report_data( ( R# RF RR sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt generate_report_dataz s4
&&
888
-c C s | j j � d S( N( R t close( R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt go_next� s c C sY | j � } y t t � j | � } Wn t k
rD } d | } n X| j j | � d S( Ns Error generating report: %s( R� R t
text_templatet rendert ExceptionR t set_value( R R� t reportt exc( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR � s c C s$ t j j | j j j j d � d S( NR ( R t Utilitiest reveal_fileR R R R ( R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt go_advanced� s ( t __name__t
__module__R R R� R� R R� ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR c s e
( R R7 t workbench.uiR t workbench.templateR R� R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt <module> s
J