| 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 @ sv d d l Z d d l Z d d l m Z d � Z e e _ d � Z d e j f d � � YZ d e f d � � YZ d S( i����N( t
WizardPagec G s$ t j � } | j � | j � | S( N( t mformst
CodeEditort set_managedt set_release_on_add( t argst c( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt find_object_with_old_name s
t ReplaceFormc B s e Z d � Z d � Z RS( c C se t | _ t j j | d t j t j Bt j B� | j | � t j
t � } | j | � | j d � | j
d � t j
t � } | j | t t � | j
d � | j t j | � t t � t j � } | j d � | j | t t � | j d � | j d � | j d � | j d � | j t j d � d d d d � | j t j d � d d d d � t j � | _ | j | j d d d d � t j � | _ | j | j d d d d � t j
t � } | j | t t � | j
d � t j � | _ | j j d � | j | j t t � t j � | _ | j j d
� | j | j t t � | j d d � d S(
Ni i i i s Find:i i s
Replace with:t Cancelt OKiX i� ( t Falset _canceledR t Formt __init__R
t FormDialogFramet
FormResizablet FormMinimizablet set_titlet newBoxt set_contentt set_paddingt set_spacingt addt newLabelt newTablet
set_row_countt set_column_countt set_row_spacingt set_column_spacingt newTextEntryt from_type_entryt
to_type_entryt Truet add_endt newButtont
cancel_btnt set_textt ok_btnt set_size( t selft titlet descriptiont contentt v_boxt tablet h_box( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR ) sD '
""
c C sG | j j | � | j | j | j � } | | j j � | j j � f S( N( R& t set_valuet run_modalR- R+ t get_string_valueR' ( R/ t type_to_replacet modal_result( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt showU s ( t __name__t
__module__R R; ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR ( 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 d � Z d � Z 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 R R( t maint add_wizard_paget _object_dictt sett _source_objects_with_errorst error_countt
warning_count( R/ RA ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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 � | _ | j j | j! � | j j" d | j# d � | 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 � | _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 t j) d d t � | _6 | j( j t j) d d t � | _7 | j( j t j/ d d t � | _8 | j( j t j/ d d t � | _9 | 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= t � | j( j> t j? � | j( j | j � | j j | j( t t � | j( j | j@ � | j( jA t � t j � | _B | jB j | jC � | jB jD d# | jE d$ � | jB jD d% | jF d& � | jB jD d' | jG d( � | jB jD d) | jH d* � | jB jD d+ | jI d, � | j( j$ | jB � t j d- � | _J | jJ j t jK � | j j | jJ t t � t jL t jM � | _N | jN jO d. � t j t � } t jP � | _Q | jQ jR t jS � | jQ j | jT � | j | jQ t t � t j t � } | jU d/ � | j d0 � t jV � | _W | jW jX d1 � | jW jY d2 � | jW jZ | j[ � | j | jW t t � t jV � | _\ | j\ jX d3 � | j\ jY d4 � | j\ jZ | j] � | j | j\ t t � t j d5 � | _^ | j^ jA t � | j^ jY d6 � | j | j^ t t � t j_ � | _` | j` jX d7 � | j | j` t t � | j` jZ | ja � t j_ � | _b | jb jX d8 � | j | jb t t � | jb jZ | jc � | j | t t � | jN j | � | jN jd d9 d � t | _e | jf � | j j | jN t t � t | _g | 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 Skip Objectt skip_objects
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 Collations& Set Target Type of Selected Columns...t set_target_types Find and Replace Target Type...t replace_target_types Find and Replace Target Flags...t replace_target_flagss( Find and Replace Target Default Value...t replace_target_default_values$ Find and Replace Target Collation...t replace_target_collationsg 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����(h R2 R R R R R R( R t tree_head_labelt newSelectort _filtert add_itemst add_changed_callbackt _filter_changedR) t _no_errors_textt
_no_errorst set_stylet BigStylet set_text_alignt
MiddleLeftt newTreeViewt TreeDefaultt _treet
add_columnt IconStringColumnTypet end_columnst _selection_changedt set_cell_edited_callbackt _cell_editedt newContextMenut _all_menut add_will_show_callbackt all_menu_will_showt add_check_item_with_titleRI t set_context_menut 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 set_selection_modet TreeSelectMultiplet _columns_cell_editedR; t _menut menu_will_showt add_item_with_titleRL RM RN RO RP t
help_labelt
SmallStylet newPanelt TitledBoxPanelt _advboxR R t _codet set_languaget
LanguageMySQLt
_code_changedR t newCheckBoxt _lock_checkR, t set_tooltipt add_clicked_callbackt
_lock_clickedt _comment_checkt _comment_clickedt _sql_outdated_labelR* t _revert_btnt _discard_clickedt
_apply_btnt _apply_clickedR. t
_advbox_shownt go_advancedt _filter_errors( R/ t hboxt boxt vbox( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt create_uie s�
#!!!!!!!!!!!!!!!!!!
c C s | j j j � | j � d S( N( RA t plant generateSQLRc ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( RS t get_selected_indexR t _showing_columnsRo R; R� R( RD RE t scan_objects_with_errorsRA R� t migrationSourcet catalogt migrationTargett refresh_full_treeRF R_ R� RQ t advanced_buttonR� R� RX R, RW RG ( R/ t i( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRV � sb (
( c
C s� | d k r�| j � } | r�| j j | d � } | r�t | 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 � q�t | t j j � r�t | t j j � r�t | t j j � r�t j d d
| j | f � | j d | � | | _ | j � q�t j j d d d d d � q�q�n 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: %sR RH s( User renamed target object '%s' to '%s'
s
Rename Objects+ The object cannot be renamed from the tree.( t get_tagRC t getR
t
isinstancet grtt classest db_Columnt log_infot
get_stringt partitionR t setParseTypet ExceptionR t Utilitiest
show_errort
set_stringt formattedRawTypeR� t db_Viewt
db_Routinet
db_Triggert show_message(
R/ t nodet columnt valuet oidR
R t sept typet exc( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRe 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 r�y) | 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 rt| j | t | � d k � t | � d k | _ t j d d | j | f � | j � q�| | j! k r�| j | t | � d k � t | � d k | _" 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 discard your edits to apply this change?s
Unlock ObjectR RH 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'
i 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'
(( RC R� R� R
R� R� R� R� t ownert
customDataR R R� R� t ResultCancelR� R R| R� R� R} R� R� R� R~ t flagst
remove_allt extendt splitR t set_boolt intt
autoIncrementR� t isNotNullR� t defaultValuet defaultValueIsNullR� t
collationName( R/ R� R� R� R
R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� ; 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� Ro t get_selected_nodeR_ R� RC R� R
R� R� R� R� R� ( R/ t selectedR� R
( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt _selected_objectq 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 R� t
get_activeR, t replacet
startswitht set_enabledt commentedOutR� ( R/ R
t text( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� 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� R� R� R� R� t temp_sqlRc ( R/ R
( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s c C s | j � } | r� t | d � r� | j j | j � | j j | j � | j j | j d k � | j j t
| 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� i s migration:lock_temp_sqlRH ( R� R R� R, R� R� R� R� t
set_activeR� t boolR� R� R R� R( R� R� ( R/ R
( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRc � s %c C s$ | j j t � | j j t � d S( N( R� R� R( R� ( R/ t xt yt z( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � 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� R� R� R� R( R� Rc ( R/ R� R
( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s c C s | j � d S( N( Rc ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � 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( R� R� R, R� R; ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s
c C s0 | j � r, | j j j � t j | � n d S( N( t validateRA R� t migrationUpdateR t go_next( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s c C s1 t j | | � | r- | j � | j � n d S( N( R t page_activatedRV t refresh( R/ t advance( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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 has identical names.
Please rename the target schema to allow the migration to continue.R RH s All Objectsi����R� s1 Could not get the index of the "All Objects" view( RA R� R� t
connectiont hostIdentifierR� R� t schemataR R R R� R� RS t index_of_item_with_titleR� t log_warningt set_selectedt call_changed_callbackR R( ( R/ R� t schemat tschemat idx( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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 RH s , ...s Object was not migrated( i i s Object was not migrated( RA R� t statet findMigrationLogEntryR
t entriest entryTypeR ( R/ t sourcet targett log_entryt errorst warningst
first_problemt entry( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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( NRH s i s n/ai ( t add_childR_ t add_nodeR� R� R� R� R� R� R R t set_tagt __id__RC ( R/ t parentR R t iconR� t sextrat textra( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt _add_node s& !
c C sV t | j | j � } | j | | | d � } | j | | | � \ } } } | r�x�d 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]@ } | r�t | j
| j � } n d } | j | | | d � q�Wq� | 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 viewRH ( 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 getattrR� R RE 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( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 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 � q�q�Wxk | j D]` } | | | j � \ } } | r7� j j | j � � j j | j � � j j | j � q7q7Wqi Wxy | j
D]n } � j j j j d | � r�q�n | | | j
� \ } } | r�� j j | j � � j j | j � q�q�Wxy | 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/ ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt check_objectp s R t viewst routines( R� RE R R R RA R� R� t isObjectIgnoredR R R R R= R> ( R/ t source_catalogt target_catalogR< R� R� R; R4 R$ R� t tcolumnt indext tindext fkt tfkt triggert ttriggert viewt tviewt routinet troutine( ( R/ sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� o sl c C sL t � | _ | j | j j j j | j j j j � | j � | j � d S( N(
RD RE R� RA R� R� R� R� R� t refresh_columns_tree( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s (
c C s� | j j � | j j j j } | j j j j } xI| 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 d k � | j | j | j � | j | j | j � | r| j | j! | j � n | r9| j | j" d � | j | j" | j � n | r^d }
| j j | � r`d }
n | j# | j$ � | | j% | j$ <| j | j& |
� | j | j& | j � | j | j' | j � | j | j( d j | j � � | j | j) | j* d k � | j | j+ | j d k � | 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 i s The column was not migrated(0 Ro t clearRA R� R� R� R� R� R R R
R R R R� R! R� Rq R Rr Rs Rt R� Ru t joinR� R� Rw R� Rx R� Ry R� Rz R{ R R RC R| R} R~ R R� R� R� R� R R� ( R/ R@ RA t sschemaR� R# R$ t scolumnRB R� R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRM � 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 r�qln | 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 q�n t | | j � } | j | | | | � } | j | | | � \ } } } | | 7} | | 7} q�W| 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 viewRH s
.16x16.pngs migration:postamble( i i ( i i ( i i ( R_ RO RA R� R� R� R� RC RF RG R� R� R R
R� R RE R R R R
R� R R R6 t supportedObjectTypesR t expandRc ( R/ R@ RA R7 RQ 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/ R0 R1 t it_errst it_warnsR� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� � s�
c C sc | j j � } | j � } | r_ | | j k r_ | j | } t | d � r_ | j | _ q_ n d S( NR� ( R_ R� R� RC R R� ( R/ R� t tagR7 ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRI M s
c C s� | j j � } | j � } | j j d � j t � | r� | | j k r� | j | } t | d � r� | j j d � j | j
� | j d k r� | j j d � j t � q� q� n d S( Ni R� s db.Indexs
db.ForeignKey( s db.Indexs
db.ForeignKey(
R_ R� R� Rg t get_itemR� R RC R t set_checkedR� t __grtclassname__R( ( R/ R[ R� Ra R7 ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRi U s
c C s2 | j j d � j t | j j � � d k � d S( Ni i ( R� Rb R� t lenRo t
get_selection( R/ R[ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR� ` s c C sj | j j � } | rf t j j d d d � \ } } | rf x' | D] } | j | | j | � q@ Wqf n d S( Ns Change target columns types Please specify the target typeRH ( Ro Rf R R� t
request_inputR� R} ( R/ t selected_nodest retR� t n( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRL c s
c C s� | j j � d } | r� | j | � } t | | � } | j t | � � \ } } } | r� x] t | j j � � D]C } | j j | � }
|
j | � | k rq | j |
| | � qq qq Wq� n d S( Ni (
Ro Rf R� R R; R� t ranget countt node_at_rowR� ( R/ R0 R1 R� t
selected_nodet
to_replacet repl_formRi t replace_withR� R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt replace_targetk s c C s | j d d | j � d S( Ns Find and Replace Target Typesc Target/migrated data types matching the search term will be replaced for all columns of all tables.( Rr R} ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRM w s c C s | j d d | j � d S( Ns Find and Replace Target Flagss^ Target/migrated flags matching the search term will be replaced for all columns of all tables.( Rr R~ ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRN | s c C s | j d d | j � d S( Ns% Find and Replace Target Default Valuesg Target/migrated default values matching the search term will be replaced for all columns of all tables.( Rr R� ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRO � s c C s | j d d | j � d S( Ns! Find and Replace Target Collationsc Target/migrated collations matching the search term will be replaced for all columns of all tables.( Rr R� ( R/ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyRP � s ($ R< R= R R� R� RV Re R� R� R� R� Rc R� R� R� R� R� R� R� R R R R6 R� R� RM R� RI Ri R� RL Rr RM RN RO RP ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyR> [ sD ~ 6 6
E > 9 _ ( R R� t workbench.uiR R R R R R> ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_editing.pyt <module> s 3