| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
ó
,¢2Sc @ 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 s5 e 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 ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyR d s
c C s' | r | j ƒ n t j | | ƒ d S( N( t generate_migration_reportR t page_activated( R t advancing( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 objectt statet log( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyt find_migrated_objectz 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( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyR? € 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 updateR) RA RB RC ( t tableR t migratedt objt columnt fkt index( R R? ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( NR@ t tablest triggerst viewst FUNCTIONt functionst PROCEDUREt
procedures( RD R) RL RM RN t routinest routineType( t schemaR t tschemat schema_dataRE t triggert viewt funct sp( R RK R? ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( NR) R t R R R R i i R( R$ ( R R) R R$ R& R' R( ( R R: ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(
NR) R R] R R i i R( R$ ( R) R$ R& R' R( ( R R: ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 dataTransferLogR@ R) t schematat catalog( R t planR t
sourceCatalogt
targetCatalogt timet ctimet sourceConnectiont drivert ownert captiont sourceDBVersiont majorNumbert minorNumbert
releaseNumbert targetConnectiont targetDBVersiont hostIdentifierR% t lenR$ R Rg R) Rh ( R R t source_catalogt target_catalogR\ R^ R_ Rm R; RU t report_data( ( R RK R? sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyt generate_report_datau s4
&&
888
-c C s | j j ƒ d S( N( R t close( R ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyR Þ s ( t __name__t
__module__R R R~ R€ R ( ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyR c s
e ( R R0 t workbench.uiR t workbench.templateR R R ( ( ( sP C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_summary.pyt <module> s
J