| 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 @ s] d d l Z d d l Z d d l m Z d Z e e _ d Z d e f d YZ d S( iN( t
WizardPagec G s$ t j } | j | j | S( N( t mformst
CodeEditort set_managedt set_release_on_add( t argst c( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt
newCodeEditor s
c C s; x4 | D], } t | d s d S| j | k r | Sq Wd S( Nt oldName( t hasattrt NoneR ( t listt namet object( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt find_object_with_old_name s
t MainViewc B s e Z d Z d Z d Z d Z d Z d Z d Z d Z d Z
d Z d
Z d Z
d Z d
Z d Z d Z d Z d Z d d Z d Z d Z d Z d Z d Z d Z RS( c C sZ t j | | d d t | j j | d d i | _ t | _ d \ | _ | _ d S( Ns Manual Editingt widet ObjectMigrationi ( i i (
R t __init__t Truet maint add_wizard_paget _object_dictt sett _source_objects_with_errorst error_countt
warning_count( t selfR ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR ) s
c C s | j j d | j j t j d t t t j t } t j d | _ | j | j t t t j | _
| j
j d d d g | j
j | j
| j | j
t t | j t j d t t | j j | t t d | _ t j d | _ | j j t j | j j t j | j j | j t t t j t j | _ | j j t j d
d t | j j t j d d t | j j t j d
d t | j j | j j | j | j j | j t t | j j | j t j t j t j Bt j B | _! | j! j t j" d d t | _# | j! j t j d d t | _$ | j! j t j d d t | _% | j! j t j" d d t | _& | j! j t j" d d t | _' | j! j t j( d d t | _) | j! j t j" d d t | _* | j! j t j" d d t | _+ | j! j t j" d d t | _, | j! j t j d d t | _- | j! j t j d d t | _. | j! j t j" d d t | _/ | j! j t j" d d t | _0 | j! j t j( d d t | _1 | j! j t j( d d t | _2 | j! j t j" d d t | _3 | j! j t j" d d t | _4 | j! j t j d
d t | _5 | j! j | j! j6 t | j! j | j | j j | j! t t | j! j | j7 | j! j8 t t j d! | _9 | j9 j t j: | j j | j9 t t t j; t j< | _= | j= j> d" t j t } t j? | _@ | j@ jA t jB | j@ j | jC | j | j@ t t t j t } | jD d# | j d$ t jE | _F | jF jG d% | jF jH d& | jF jI | jJ | j | jF t t t jE | _K | jK jG d' | jK jH d( | jK jI | jL | j | jK t t t j d) | _M | jM j8 t | jM jH d* | j | jM t t t jN | _O | jO jG d+ | j | jO t t | jO jI | jP t jN | _Q | jQ jG d, | j | jQ t t | jQ jI | jR | j | t t | j= j | | j= jS d- d t | _T | jU | j j | j= t t t | _V | j
d S(. Ni sv Review and edit migrated objects. You can manually edit the generated SQL before applying them to the target database.s Migrated Objectss Migration Problemss All Objectss Column Mappingss View:s] No migration problems found. %d warning(s).
Use the View pulldown menu to review all objects.t s
Source Objecti s
Target Objects Migration Messagei, s
Source Schemaid s Source Tables
Source Columns Source Types Source Flagst NNi s Source Default Values Source Collations
Target Schemas Target Tables
Target Columns Target Types Target Flagst AIs Target Default Values Target Collationsf You can rename target schemas and tables and change column definitions by clicking them once selected.s% SQL CREATE Script for Selected Objecti i s Lock edited SQLs Lock the SQL code to the edited one, preventing automatic regenerations from discarding changes made directly to the SQL script.s Comment outsl Mark the object to be commented out on the generated script, making it not get created in the target server.s Code is outdateds The locked SQL code seems to be outdated compared to a newer, automatically generated one. Unlocking the object will update it, but your changes will be lost.s Discard Changess
Apply Changesi(W t contentt set_spacingt addR t newLabelt FalseR t newBoxt tree_head_labelt newSelectort _filtert add_itemst add_changed_callbackt _filter_changedt add_endt _no_errors_textt
_no_errorst set_stylet BigStylet set_text_alignt
MiddleLeftt newTreeNodeViewt TreeDefaultt _treet
add_columnt IconStringColumnTypet end_columnst _selection_changedt set_cell_edited_callbackt _cell_editedt TreeShowColumnLinest TreeShowRowLinest TreeFlatListt _columnst StringColumnTypet COL_SOURCE_SCHEMAt COL_SOURCE_TABLEt COL_SOURCE_COLUMNt COL_SOURCE_TYPEt COL_SOURCE_FLAGSt CheckColumnTypet COL_SOURCE_NOTNULLt COL_SOURCE_DEFAULTt COL_SOURCE_COLLATIONt COL_TARGET_SCHEMAt COL_TARGET_TABLEt COL_TARGET_COLUMNt COL_TARGET_TYPEt COL_TARGET_FLAGSt
COL_TARGET_AIt COL_TARGET_NOTNULLt COL_TARGET_DEFAULTt COL_TARGET_COLLATIONt COL_MESSAGEt set_allow_sortingt _columns_cell_editedt showt
help_labelt
SmallStylet newPanelt TitledBoxPanelt _advboxt set_titleR t _codet set_languaget
LanguageMySQLt
_code_changedt set_paddingt newCheckBoxt _lock_checkt set_textt set_tooltipt add_clicked_callbackt
_lock_clickedt _comment_checkt _comment_clickedt _sql_outdated_labelt newButtont _revert_btnt _discard_clickedt
_apply_btnt _apply_clickedt set_sizet
_advbox_shownt go_advancedt _filter_errors( R t hboxt boxt vbox( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt create_ui2 s
#!!!!!!!!!!!!!!!!!!
c C s | j j j | j d S( N( R t plant generateSQLR8 ( R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt _regenerateSQL s c C s
| j j } t | _ | d k rl| j j t | j s t | _ t | _ | j
| j j j
j | j j j j | j n | j d k r| j j t | j j t | j j t | j j t | j r | j n | j j | j | j | j j t q| j j t | j j t | j j t | j j t | j j t n| d k r.| j j t | j j t | j j t | j j t | j j t | j j t | j rt | _ t | _ | j
| j j j
j | j j j j | j qn | d k r| j j t t | _ | j j t | j j t | j j t | j j t | j j t n` | j j t | j j t | j j t | j j t | j j t | j j t d S( Ni i i ( R' t get_selected_indexR# t _showing_columnsR> RU Rr R R R t scan_objects_with_errorsR Rw t migrationSourcet catalogt migrationTargett refresh_full_treeR R4 RV R% t advanced_buttonRp Rq R- Rc R, R ( R t i( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR* sb (
( c
C s | d k r| j } | r| j j | d } | rt | t j j rt j d d | j | | f | j
d \ } } } | | _ y) | j | d s t
d | n Wn4 t
k
r } t j j d d | d d d d SX| j d | d | j | j qt | t j j rt | t j j rt | t j j rt j d d
| j | f | j d | | | _ | j qt j j d d d d d qqn d S(
Ni t Migrations8 User changed target column definition from '%s' to '%s'
s s' Could not parse column type string '%s's Change Column Types Error changing column type: %st OKR s( User renamed target object '%s' to '%s'
s
Rename Objects+ The object cannot be renamed from the tree.( t get_tagR t getR
t
isinstancet grtt classest db_Columnt log_infot
get_stringt partitionR t setParseTypet ExceptionR t Utilitiest
show_errort
set_stringt formattedRawTypeRy t db_Viewt
db_Routinet
db_Triggert show_message(
R t nodet columnt valuet oidR
R t sept typet exc( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR: s. #
B
c C s | j j | j d } | r|t | t j j r|| j j j d t
r t j j
d d d d d t j k ry d St j d d | j t
| j j d <n | | j k r | | _ | j | | t j d d | j | f | j q|| | j k ry) | j | d s,t d
| n Wn4 t k
rc} t j j d d | d
d d d SX| j | | t j d d | j | f | j q|| | j k r
| j | | | j j | j j | j t j d d | j | f | j q|| | j k rh| j | t | t | | _ t j d d | j | f | j q|| | j! k r| j | t | t | | _" t j d d | j | f | j q|| | j# k r'| j | | | | _$ | d k | _% t j d d | j | f | j q|| | j& k r|| j | | | | _' t j d d | j | f | j q|n d S( Ns migration:lock_temp_sqls Object is Lockeds The object was manually edited and is locked against updates. Would you like to unlock the object discarding your edits to apply this change?s
Unlock Objectt CancelR R s2 User unlocked object '%s' by changing columns trees( User renamed target column '%s' to '%s'
s' Could not parse column type string '%s's Change Column Types Error changing column type: %sR s0 User changed target column type of '%s' to '%s'
s1 User changed target column flags of '%s' to '%s'
s9 User changed target column autoIncrement of '%s' to '%s'
s5 User changed target column isNotNull of '%s' to '%s'
t NULLs3 User changed target column default of '%s' to '%s'
s5 User changed target column collation of '%s' to '%s'
(( R R R R
R R R R t ownert
customDataR# R R R t ResultCancelR R RK R Ry RL R R R RM t flagst
remove_allt extendt splitRN t set_boolt intt
autoIncrementRO t isNotNullRP t defaultValuet defaultValueIsNullRQ t collation( R R R R R
R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRT sd
c C s | j r | j j } n | j j } | r | j r | j } | j j | d } t | t j
j r~ | j } n | Sd S( N(
R{ R> t get_selected_nodeR4 R R R R
R R R R R ( R t selectedR R
( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt _selected_object, s c C s | j } | r | j j t } | j j rV | j j d | j d d n2 | j d r | j j | j d d d n | j j | j
| j n d S( Ns -- s
s
-- i ( R R\ t get_textR# Rg t
get_activeRc t replacet
startswitht set_enabledt commentedOutRn ( R R
t text( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRh : s ##c C sj | j } | rf | j j | j d <| j sf | j j d rc | j d | _ | j qc qf n d S( Ns migration:lock_temp_sqls migration:new_temp_sql( R Rb R R R t temp_sqlR8 ( R R
( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRf J s c C s | j } | r t | d r | j j | j | j j | j | j j | j | j j | j
j d t | j
j t | j j t | j j t d S| j j d | j j t | j j t | j j t | j
j t d S( NR s migration:lock_temp_sqlR ( R R R\ Rc R R R Rg t
set_activeRb R R R# RZ R Rm Rk ( R R
( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR8 S s c C s$ | j j t | j j t d S( N( Rm R R Rk ( R t xt yt z( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR_ f s c C s] | j j t } | j } | rO | | _ | j j | _ t | j d <n | j
d S( Ns migration:lock_temp_sql( R\ R R# R R Rg R R R R R8 ( R R R
( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRn k s c C s | j d S( N( R8 ( R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRl u s c C sP | j | _ | j r) | j j d n | j j d | j j | j d S( Ns Hide Code and Messagess Show Code and Messages( Rp R Rc RZ RU ( R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyRq y s
c C s0 | j r, | j j j t j | n d S( N( t validateR Rw t migrationUpdateR t go_next( R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR s c C s1 t j | | | r- | j | j n d S( N( R t page_activatedR* t refresh( R t advance( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR s
c C s | j j } | j j j | j j j k r x | j j j D] } x | j j j D] } | j | j k rP | j | j k r t
j j d d d d d | j
j d } | d k r t j d d n | j
j | | j
j t SqP qP Wq: Wn t S( Ns Validation Errors The source and target are in the same server and a schema being migrated have identical names.
Please rename the target schema to allow the migration to continue.R R s All ObjectsiR s1 Could not get the index of the "All Objects" view( R Rw R} t
connectiont hostIdentifierR R~ t schemataR R R R R R' t index_of_item_with_titleR t log_warningt set_selectedt call_changed_callbackR# R ( R Rw t schemat tschemat idx( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR s
c C s/ | j j j j | | } | s? | j j j j | d } n | r'd } d } d } xy | j D]n } | j d k r | j } | j d k r | d 7} q | j d k r | d 7} q qa | j ra | j } qa qa W| | d k r | | | p d f S| | d k r| | | d f S| | | f Sn d Sd S( Ni i i R s , ...s Object was not migrated( i i s Object was not migrated( R Rw t statet findMigrationLogEntryR
t entriest entryTypeR ( R t sourcet targett log_entryt errorst warningst
first_problemt entry( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt get_log_entry_for s,
i c C sj | j | | \ } } } | j | | | rD | j | d n | r] | j | d n | | | f S( Ns task_error.pngs task_warning.png( R R t
set_icon_path( R R R R R t errt warR ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt _set_log_entry_for s c C s | r | j n | j j } d } d } t | t j j rh d | j } | rh d | j } qh n | r | j d | j | | j
d | n | j d d | r | j
d | | j d | j | n | j d d | r| j | j | | j
| j <n | S( NR s i s n/ai ( t add_childR4 t add_nodeR R R R R R R R t set_tagt __id__R ( R t parentR R t iconR t sextrat textra( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt _add_node s& !
c C sV t | j | j } | j | | | d } | j | | | \ } } } | rxd d d d g D]\ } }
} | j } | j d | | j d d | j d | | j d d t | | }
t | | } d } d } x|
D]y} | j r| j
| j k rq n t | | j } | re| d k re| j | re| j | | | d } n | j | | | |
} | j | | | \ } } } | | 7} | | 7} | d k r x | j
D]@ } | rt | j
| j } n d } | j | | | d qWq | d
k r xN | j
D]@ } | rFt | j
| j } n d } | j | | | d q"Wq q W| r| j d d | j d d n9 | r| j d d | j d d n | j d d | | 7} | | 7} qd Wn | r| j d d | j d d n9 | r<| j d d | j d d n | j d d | | f S( Ns db.Table.16x16.pngt Columnss db.Column.nn.16x16.pngt columnst Indicess db.Index.16x16.pngt indicest ForeignKeyss db.ForeignKey.16x16.pngt foreignKeyst Triggerss db.Trigger.16x16.pngt triggersi t folderi s db.Column.pk.16x16.pngs db.Column.16x16.pngi s task_error.pngs Migration errors, expand to views task_warning.pngs" Migration warnings, expand to viewR ( R s db.Column.nn.16x16.pngs columns( R s db.Index.16x16.pngs indices( R s db.ForeignKey.16x16.pngs foreignKeys( R s db.Trigger.16x16.pngs triggers( R t tablesR R R R R R t getattrRr R R t isPrimaryKeyColumnR R
( R t tables_nodeR t stablet ttablet
table_nodet
total_errst total_warnsR t captionR t list_namet sub_node_groupt slistt tlistt sub_errst sub_warnst sitemt titemt sub_nodet errst warnst icolumnt ticolumn( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt _add_table_node sp
!
!
c s f d } x| j D]~} | | | j \ } } | rS j j | j n | s_ q n x=| j D]2} j j j j d | r qi n | | | j \ } } | r j j | j j j | j n | s qi n xk | j D]` } | | | j \ }
} | r j j | j j j | j j j | j q q Wxk | j
D]` } | | | j
\ } } | r[ j j | j j j | j j j | j q[q[Wxk | j D]` }
| |
| j \ } } | r j j |
j j j | j j j | j qqWxk | j D]` } | | | j \ } } | r7 j j | j j j | j j j | j q7q7Wqi Wxy | j
D]n } j j j j d | rqn | | | j
\ } } | r j j | j j j | j qqWxy | j D]n } j j j j d | rLq%n | | | j \ } } | r% j j | j j j | j q%q%Wq Wd S( Nc sO t | | j } j | | \ } } } | d k pB | d k } | | f S( Ni ( R R R ( t objt object_listt tobjR R t txtt
has_errors( R ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt check_object+ s R t viewst routines( R R R! R R R Rw R} t isObjectIgnoredR R R R R R ( R t source_catalogt target_catalogR
R R R t tableR R t tcolumnt indext tindext fkt tfkt triggert ttriggert viewt tviewt routinet troutine( ( R sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR| * sl c C sL t | _ | j | j j j j | j j j j | j | j d S( N(
R R R| R Rw R} R~ R R t refresh_columns_tree( R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR h s (
c C so | j j | j j j j } | j j j j } x7| j D],} | r_ t | j | j } n d } x| j D]} | r t | j | j n d } | s qo n x| j D]} | r t | j | j n d } | j j
} d }
| j j | rd }
n | j | j | j | j | j d | j | j | j | j | j |
| j | j | j | j | j | j | j | j d j | j | j | j | j | j | j | j | j | j | j | r| j | j! | j n | r3| j | j" d | j | j" | j n | rLd }
| j j | rZd }
n | j# | j$ | | j% | j$ <| j | j& |
| j | j& | j | j | j' | j | j | j( d j | j | j | j) | j* | j | j+ | j | j | j, | j | j | j- | j | j. | | | | j/ q | j | j/ d q Wqo Wq; Wd S( Ns db.Column.nn.16x16.pngs db.Column.pk.16x16.pngs db.Table.16x16.pngt s The column was not migrated(0 R> t clearR Rw R} R~ R R R R R
R R R R R R R@ R RA RB RC R RD t joinR R RF R RG R RH t
collationNameRI RJ R R R RK RL RM RN R RO RP RQ R RR ( R R R t sschemaR R R t scolumnR R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR p s`
!! c
C s[ | j j | j j j j } | j j j j } i | _ d \ | _ | _ | j
s | j d } | r | j d d | d q n x| j D]} | j
r | j | j k r q n | r t | j | j } n d } | j d | | d } | j | | | | j } | j d d | j d d | j d d | j d d d \ } } | rxa | j D]V }
| j
r|
j | j k rqln | j | | |
\ } } | | 7} | | 7} qlW| j | 7_ | j | 7_ | r
| j d d | j d d
n9 | r6| j d d | j d d n | j d d
x| j j j j d D]}
|
\ } } } | d } | j } | j d | | j d d | j d | | j d d t | | } t | | } d \ } } x | D] } | j
r | j | j k r qn t | | j } | j | | | | } | j | | | \ } } } | | 7} | | 7} qW| j | 7_ | j | 7_ | r| j d d | j d d
q]| r| j d d | j d d q]| j d d
q]Wn | j q W| j
sM| j d } | rM| j d d | d qMn | j d S( Ni s migration:preambles GrtObject.16x16.pngs db.Schema.16x16.pngt Tablesi R i s task_error.pngs Migration errors, expand to views task_warning.pngs" Migration warnings, expand to viewR s
.16x16.pngs migration:postamble( i i ( i i ( i i ( R4 R! R Rw R} R~ R R R R Rr R R R
R R R R R R R R R R R t supportedObjectTypesR t expandR8 ( R R R R R$ R t schema_nodeR t sch_errst sch_warnsR t tab_errst tab_warnst itemR t struct_nameR R R R R t
group_errst group_warnsR R R t it_errst it_warnsR ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR s
( t __name__t
__module__R Rv Ry R* R: RT R Rh Rf R8 R_ Rn Rl Rq R R R R R R R R| R R R ( ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyR ( s2 l 6 6
E > 9( R R t workbench.uiR R R R ( ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\migration_object_editing.pyt <module> s