ó Ü@Qc@s]ddlZddlZddlmZd„Zee_d„Zdefd„ƒYZdS(iÿÿÿÿN(t WizardPagecGs$tjƒ}|jƒ|jƒ|S(N(tmformst CodeEditort set_managedtset_release_on_add(targstc((s&..\modules\migration_object_editing.pyt newCodeEditors   cCs;x4|D],}t|dƒs dS|j|kr|SqWdS(NtoldName(thasattrtNoneR(tlisttnametobject((s&..\modules\migration_object_editing.pytfind_object_with_old_names  tMainViewcBsìeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z d „Z d „Z d „Zd „Zd„Zd„Zd„Zd„Zdd„Zd„Zd„Zd„Zd„Zd„Zd„ZRS(cCsZtj||ddtƒ|jj|ddƒi|_tƒ|_d\|_|_ dS(NsManual EditingtwidesOBJECT MIGRATIONi(ii( Rt__init__tTruetmaintadd_wizard_paget _object_dicttsett_source_objects_with_errorst error_countt warning_count(tselfR((s&..\modules\migration_object_editing.pyR)s   cCsÀ|jjdƒ|jjtjdƒttƒtjtƒ}tjdƒ|_|j|jttƒtj ƒ|_ |j j dddgƒ|j j |j ƒ|j|j ttƒ|jtjdƒttƒ|jj|ttƒd|_tjd ƒ|_|jjtjƒ|jjtjƒ|jj|jttƒtjtjƒ|_|jjtjd d tƒ|jjtjd d tƒ|jjtjd dtƒ|jjƒ|jj |jƒ|jj|jttƒ|jj|jƒtjtjtjBtj Bƒ|_!|j!jtj"ddtƒ|_#|j!jtjddtƒ|_$|j!jtjddtƒ|_%|j!jtj"ddtƒ|_&|j!jtj"ddtƒ|_'|j!jtj(ddtƒ|_)|j!jtj"ddtƒ|_*|j!jtj"ddtƒ|_+|j!jtj"ddtƒ|_,|j!jtjddtƒ|_-|j!jtjddtƒ|_.|j!jtj"ddtƒ|_/|j!jtj"ddtƒ|_0|j!jtj(ddtƒ|_1|j!jtj(ddtƒ|_2|j!jtj"ddtƒ|_3|j!jtj"d dtƒ|_4|j!jtjd dtƒ|_5|j!jƒ|j!j6tƒ|j!j |jƒ|jj|j!ttƒ|j!j|j7ƒ|j!j8tƒtjd!ƒ|_9|j9jtj:ƒ|jj|j9ttƒtj;tj<ƒ|_=|j=j>d"ƒtjtƒ}tj?ƒ|_@|j@jAtjBƒ|j@j |jCƒ|j|j@ttƒtjtƒ}|jDd#ƒ|jd$ƒtjEƒ|_F|jFjGd%ƒ|jFjHd&ƒ|jFjI|jJƒ|j|jFttƒtjEƒ|_K|jKjGd'ƒ|jKjHd(ƒ|jKjI|jLƒ|j|jKttƒtjd)ƒ|_M|jMj8tƒ|jMjHd*ƒ|j|jMttƒtjNƒ|_O|jOjGd+ƒ|j|jOttƒ|jOjI|jPƒtjNƒ|_Q|jQjGd,ƒ|j|jQttƒ|jQjI|jRƒ|j|ttƒ|j=j|ƒ|j=jSd-d ƒt|_T|jUƒ|jj|j=ttƒt|_V|j ƒdS(.NisvReview and edit migrated objects. You can manually edit the generated SQL before applying them to the target database.sMigrated ObjectssMigration Problemss All ObjectssColumn MappingssView:s]No migration problems found. %d warning(s). Use the View pulldown menu to review all objects.ts Source ObjectiÈs Target ObjectsMigration Messagei,s Source Schemaids Source Tables Source Columns Source Types Source FlagstNNisSource Default ValuesSource Collations Target Schemas Target Tables Target Columns Target Types Target FlagstAIsTarget Default ValuesTarget CollationsfYou can rename target schemas and tables and change column definitions by clicking them once selected.s%SQL CREATE Script for Selected Objecti isLock edited SQLs€Lock the SQL code to the edited one, preventing automatic regenerations from discarding changes made directly to the SQL script.s Comment outslMark the object to be commented out on the generated script, making it not get created in the target server.sCode 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.sDiscard Changess Apply Changesiÿÿÿÿ(Wtcontentt set_spacingtaddRtnewLabeltFalseRtnewBoxttree_head_labelt newSelectort_filtert add_itemstadd_changed_callbackt_filter_changedtadd_endt_no_errors_textt _no_errorst set_styletBigStyletset_text_alignt MiddleLefttnewTreeNodeViewt TreeDefaultt_treet add_columntIconStringColumnTypet end_columnst_selection_changedtset_cell_edited_callbackt _cell_editedtTreeShowColumnLinestTreeShowRowLinest TreeFlatListt_columnstStringColumnTypetCOL_SOURCE_SCHEMAtCOL_SOURCE_TABLEtCOL_SOURCE_COLUMNtCOL_SOURCE_TYPEtCOL_SOURCE_FLAGStCheckColumnTypetCOL_SOURCE_NOTNULLtCOL_SOURCE_DEFAULTtCOL_SOURCE_COLLATIONtCOL_TARGET_SCHEMAtCOL_TARGET_TABLEtCOL_TARGET_COLUMNtCOL_TARGET_TYPEtCOL_TARGET_FLAGSt COL_TARGET_AItCOL_TARGET_NOTNULLtCOL_TARGET_DEFAULTtCOL_TARGET_COLLATIONt COL_MESSAGEtset_allow_sortingt_columns_cell_editedtshowt help_labelt SmallStyletnewPaneltTitledBoxPanelt_advboxt set_titleRt_codet set_languaget LanguageMySQLt _code_changedt set_paddingt newCheckBoxt _lock_checktset_textt set_tooltiptadd_clicked_callbackt _lock_clickedt_comment_checkt_comment_clickedt_sql_outdated_labelt newButtont _revert_btnt_discard_clickedt _apply_btnt_apply_clickedtset_sizet _advbox_shownt go_advancedt_filter_errors(Rthboxtboxtvbox((s&..\modules\migration_object_editing.pyt create_ui2s¸  #!!!!!!!!!!!!!!!!!!      cCs|jjjƒ|jƒdS(N(Rtplant generateSQLR7(R((s&..\modules\migration_object_editing.pyt_regenerateSQLžscCs |jjƒ}t|_|dkrl|jjtƒ|js‡t|_tƒ|_ |j |j j j j|j j jjƒ|jƒn|jdkr|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jrì|jƒn|jj|j|jƒ|jjtƒq|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒnš|dkr.|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jrt|_tƒ|_ |j |j j j j|j j jjƒ|jƒqnØ|dkr¦|jjtƒt|_|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒn`|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒ|jjtƒdS(Niii(R&tget_selected_indexR"t_showing_columnsR=RTRqRRRtscan_objects_with_errorsRRvtmigrationSourcetcatalogtmigrationTargettrefresh_full_treeRR3RUR$tadvanced_buttonRoRpR,RbR+R(Rti((s&..\modules\migration_object_editing.pyR)¥sb     (       (  c CsÈ|dkrÄ|jƒ}|rÄ|jj|dƒ}|rÁt|tjjƒrtjdd|j |ƒ|fƒ|j dƒ\}}}||_ y)|j |dƒsºt d|ƒ‚nWn4t k rñ} tjjdd| dd d ƒdSX|jd|d|jƒ|jƒq¾t|tjjƒ rŸt|tjjƒ rŸt|tjjƒ rŸtjdd |j |fƒ|jd|ƒ||_ |jƒq¾tjjd d dd d ƒqÁqÄndS( Nit Migrations8User changed target column definition from '%s' to '%s' s s'Could not parse column type string '%s'sChange Column TypesError changing column type: %stOKRs(User renamed target object '%s' to '%s' s Rename Objects+The object cannot be renamed from the tree.(tget_tagRtgetR t isinstancetgrttclassest db_Columntlog_infot get_stringt partitionR t setParseTypet ExceptionRt Utilitiest show_errort set_stringtformattedRawTypeRxtdb_Viewt db_Routinet db_Triggert show_message( RtnodetcolumntvaluetoidR R tsepttypetexc((s&..\modules\migration_object_editing.pyR9Ûs.  #   B  cCs€|jj|jƒdƒ}|r|t|tjjƒr||jj jdt ƒr£t j j dddddƒt jkrydStjdd|jƒt |jj d  8(RR‡t workbench.uiRRRR(((s&..\modules\migration_object_editing.pyts