| 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 @ s� d d l Z d d l Z d d l Z d d l m Z d d l m Z d e f d � � YZ d e f d � � YZ d e f d � � YZ d S(
i����N( t
WizardPage( t WizardProgressPaget MainViewc B s5 e Z d � Z d � Z d � Z d � Z d � Z RS( c C s� t j | | d � | j j | d d � t j d � } | j j | t t � t j
t j � } | j d � | j j | t t � t j
t � } | j | � | j d � t j � | _ | j j d � | j | j t t � | j t j d � t t � t j � | _ | j j d � | j j | j � | j | j t t � t j
t � | _ | j j d � | j j t j d
� t t � t j � | _ | j j t j j t j j d � d � � | j j | j t t � t j � } | j d
� | j | j � | j j | t t � | j | j t t � t j
t j � } | j d � | j j | t t � t j
t � } | j | � | j d � | j d � t j � | _ | j j d � | j | j t t � | j j! t � | j � t | _" d S( Ns Target Creation Optionst ObjectMigrationsp Select options for the creation of the migrated schema in the target
MySQL server and click [Next >] to execute.s Schema Creationi s Create schema in target RDBMSt s Create a SQL script filei s Script File:t ~s migration_script.sqls Browse...t Optionsi s` Keep schemas if they already exist. Objects that already exist will not be recreated or updated.(# R t __init__t maint add_wizard_paget mformst newLabelt contentt addt Falset Truet newPanelt TitledBoxPanelt set_titlet newBoxt set_paddingt newCheckBoxt
_create_dbt set_textt _create_scriptt add_clicked_callbackt _toggle_sql_scriptt
_file_hboxt set_spacingt newTextEntryt _create_script_filet set_valuet ost patht joint
expandusert newButtont
_browse_filest _keep_schemat
set_activet _check_file_duplicate( t selfR t labelt panelt boxt button( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR sT
+
c C s | j j | j j � � d S( N( R t set_enabledR t
get_active( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR T s c C s
t | _ d S( N( R R( ( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt _filename_changedW s c C s� t j t j j � t j � } | j d � t j j | j j
� � } | j t j j t j j
| � rm | n t j j | � � r� | n t j j d � � | j � r� | j j | j � � t | _ n d S( Ns Save SQL Script AsR ( R
t newFileChoosert Formt main_formt SaveFileR R R! t abspathR t get_string_valuet set_patht existst isdirt dirnameR# t run_modalR t get_pathR R( ( R) t formt default_path( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR% Z s
' c C s� | j j � | j j j j d <| j j � | j j j j d <| j j � r>| j j � } | s� t
j j t
j j
| � � r� t j j d d d d d � d St
j j | � r� t j j d d | d d d � d St
j j | � r%| j r%t j j d d | d d
d � t j k r%d Sn | | j j j j d <n1 | j j j j j d � ro| j j j j d =n t j | � d S( Nt KeepSchematat
CreateInDBs Create Script Filesb Create Script File option was enabled, but the provided path is invalid.
Please correct and retry.t OKR sX '%s' is a directory name. Please provide a file name for saving the script as and retry.sT The file '%s' provided for the SQL script already exists. Do you want to replace it?t Replacet Cancelt
CreateSQLFile( R& R/ R t plant statet objectCreationParamsR R R R6 R R! R9 R: R
t Utilitiest
show_errorR8 R( t ResultCancelt has_keyR t go_next( R) R! ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRL h s( &
( t __name__t
__module__R R R0 R% RL ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR s
9 t CreationProgressViewc B sP e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C s9 t j | | d d d �t | _ | j | d d � d S( Ns Create Schemast descriptions� The SQL scripts generated for the migrated schema objects will now be executed
in the target database. You can monitor execution in the logs. If there are errors
you may correct them in the next step. Table data will be migrated at a later step.R ( R R R t
_autostartR ( R) R ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR � s c C sn | j � | j | j d � | _ | j | j d � | _ | j | j d � | _ | j | j d � | _
d S( Ns Create Script Files Connect to Target Databases Perform Checks in Targets Create Schemas and Objects( t clear_taskst add_taskt _create_script_taskt _script_taskt
_connect_taskt _db_task1t _validate_existing_schematat _db_task2t add_threaded_taskt _create_taskt _db_task3( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt create_ui� s
c C s� t j | | � | r� | j j j j j d d � rG | j j t � n | j j t
� | j j j j j d t � r� | j j t � | j j t � | j
j t � q� | j j t
� | j j t
� | j
j t
� n d S( NRD R R@ ( R t page_activatedR RE RF RG t getRU R. R R RW RY R\ ( R) t advancing( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR^ � s c C s | j � t j | � d S( N( t resetR t go_back( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRb � s
c C s' | j j j | j j j j d � d S( NRD ( R RE t createTargetScriptRF RG ( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRT � s c C s | j j j j � d S( N( R RE t migrationTargett connect( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRV � s c
C sL t j d d � t d � | j j j j j D� � } t d � t j j j
| j j j j � D� � } t | j
| � � } t } t | � d k r8| j j j j j d t � r�d } x� | j j j j j D]� } | j j � | k r� q� n t d � t j j j | j j j j | j � D� � } g | j D]$ } | j j � | k r/| j ^ q/} | r� | d | j d
7} | d j | � d 7} q� q� W| r5t j j d
d | d d d � t j k r�t } q�q5q8t j j d d t | � d k r�d n d d j | � f d d d d d � t j k r8t } q8n | j j | � d S( Ng s9 Validating for existing schemas on target MySQL Server...c s s | ] } | j j � Vq d S( N( t namet upper( t .0t schema( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pys <genexpr>� s c s s | ] } | j � Vq d S( N( Rg ( Rh Ri ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pys <genexpr>� s i R? R c s s | ] } | j � Vq d S( N( Rg ( Rh t
table_name( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pys <genexpr>� s s
In schema s :
s , s
s Existing Tabless� The following tables already exist in their target schemas:
%sThey won't be recreated. Delete those tables before continuing if you want them to be recreated. Do you want to continue?t Yest Nos Existing Schemass
The %s %s i Ri t schematasL will be dropped in the target MySQL Server and all the existing data will bes lost. Do you want to continue?( t grtt
send_progresst setR RE Rd t catalogRm t modulest DbMySQLFEt getSchemaNamest
connectiont listt intersectionR t lenRF RG R_ R Rf Rg t
getTableNamest tablesR" R
RH t show_messageRJ R\ R. (
R) t
schema_sett target_schema_sett existing_schemast continue_migrationt messageRi t target_schema_tablest tablet existing_tables( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRX � s4 %1 .4 2 c C s� t j d d d � | j j j j j d t � rF | j j j � n | j j j � | j j j
j � t j d d d � d S( Nt =iP s
R? ( Rn t send_outputR RE RF RG R_ R t generateSQLt createTargetRd t
disconnect( R) ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR[ � s (
RM RN R R] R^ Rb RT RV RX R[ ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRO � s &t CreationReportViewc B st 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
RS( c C s� t j | | d d t �| j j | d d � d } | j j t j | � t t � t j
t � } | j d � | j t � t j
t j � | _ | j j t j d d t � | j j t j d d t � | j j � | j j | j � | j | j t t � t j t j � | _ | j j d
� t j
t � } t j � | _ | j j t j � | j j | j � | j | j t t � t j
t � } | j d � | j d � t j � | _ | j j! d � | j j" | j# � | j | j t t � t j$ � | _% | j% j! d
� | j& | j% t t � | j% j" | j' � t j$ � | _( | j( j! d � | j& | j( t t � | j( j" | j) � | j | t t � | j j | � | j* j! d � | j | j t t � | j j | t t � t j t j � | _+ | j+ j d � t j
t � } | j d � t j, t j- � | _. | j | j. t t � | j+ j | � | j j | j+ t t � | j+ j/ d d � g | _0 d S( Ns Create Target Resultst wideR sZ Scripts to create the target schema were executed. No data has been migrated yet. Review the creation report below
for errors or warnings. If there are any errors, you can manually fix the scripts and click [Recreate Objects] to retry
the schema creation or return to the Manual Editing page to correct them there and retry the target creation.i t Objecti� t ResultiX s% SQL CREATE Script for Selected Objecti s Comment outt Discardt Applys Recreate Objectss Output Messagesi����(1 R R R R R R R
R
R R R R t set_homogeneoust newTreeViewt TreeFlatListt _treet
add_columnt IconStringColumnTypet end_columnst add_changed_callbackt _selection_changedR R t _advboxR t
newCodeEditort _codet set_languaget
LanguageMySQLt
_code_changedR R t _comment_checkR R t _comment_clickedR$ t _revert_btnt add_endt _discard_clickedt
_apply_btnt _apply_clickedt advanced_buttont _msgboxt
newTextBoxt VerticalScrollBart _msgst set_sizet
_error_tables( R) R t textt hboxR, t vbox( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR � sd
c C sn | j r] t j j d d d d d � } | t j k rV x! | j D] } d | _ q@ Wq] d Sn t j | � d S( Ns Table Creation Errorss� Some tables could not be created in the target database.
Would you like to flag them to be skipped and copy the data for the remaining tables only?s Skip Failed TablesRC R i ( R� R
RH t show_warningt ResultOkt commentedOutR RL ( R) t rR� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyRL . s c C sk | j j � } | rg | j � rg | j � } | j j | d � } t | t j j � rc | j
} n | Sd S( N( R� t get_selected_nodet get_tagt _object_dictR_ t Nonet
isinstanceRn t classest db_Columnt owner( R) t selectedt oidt object( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt _selected_log_object< s c C s | j � } | r | j Sd S( N( R� t logObjectR� ( R) t log( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt _selected_objectG 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 j t � | j
j t � n d S( Ns -- s
s
-- i ( R� R� t get_textR R� R/ R t replacet
startswithR. R� R� R R� ( R) R� R� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� M s ##c C s� | j � } | rg } x� | j D]� } | j d k r\ | j d j | j j d � � � q" | j d k r� | j d d j | j j d � � � q" | j d k r� | j d d j | j j d � � � q" | j d j | j j d � � � q" W| j j d j | � � n | r | j n d } | r�t | d � r�| j j
| j � | j j | j � | j j | j d k � | j j t � | j j t � | j j t � d S| j j
d
� | j j t � | j j t � | j j t � d S( Ni s
s
i s WARNING: %si s ERROR: %ss
t temp_sqlR ( R� t entriest entryTypet appendR" Rf t splitR� R R� R� t hasattrR� R R� R. R� R� R' R� R R� R R� ( R) R� R� t entryR� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� ] s2 %))& c C s$ | j j t � | j j t � d S( N( R� R. R R� ( R) t xt yt z( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� | s c C sf | j j t � } | j � } | rB | | _ | j j � | _ n | j j t � | j
j t � d S( N( R� R� R R� R� R� R/ R� R� R. R� ( R) R� R� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� � s c C se | j � } | rA | j j | j � | j j | j d k � n | j j t � | j
j t � d S( Ni ( R� R� R R� R� R' R� R� R. R R� ( R) R� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� � s c C s� i | _ g | _ | j j � xw| j j j j D]c} | j j � } | j } d } x[ t
j j t
j j
t
j j t
j j t
j j g D]& } t | | � r� | j d } Pq� q� W| s� t
j d d | j � q2 n | j } | j } x= | r(| j d | } t | t
j j � r Pn | j } q� W| j d | � | j d | � | j | j � | | j | j <g } d } x� | j D]� }
t | |
j � } |
j d k r�| j d |
j � q|
j d k r| j d d
|
j � t | t
j j
� r| j j | � qq| j d � qW| d k r>| j d d � n> | d k r]| j d d
� n | d k r|| j d d � n | j d d j | � � q2 Wd S( Ns GrtObject.16x16.pngs
.16x16.pngt Migrations- Object creation log '%s' referenced no objectt .i i s WARNING: %si s ERROR: %ss Script executed successfullys task_checked.pngs task_warning.pngs task_error.pngs ,
(! R� R� R� t clearR RE RF t creationLogt add_nodeR� Rn R� t db_Schemat db_Tablet db_Viewt
db_Routinet
db_TriggerR� t __grtclassname__t log_warningRf R� t
set_stringt
set_icon_patht set_tagt __id__R� R� t maxR� R� t insertR" ( R) R� t nodet objt icont ct full_namet oR� t worstR� ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt refresh� sV
:
c C s' | r | j � n t j | | � d S( N( R� R R^ ( R) R` ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR^ � s
c C s | j j � } | j � d S( N( R t go_previous_pageRa ( R) t page( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt go_advanced� s ( RM RN R RL R� R� R� R� R� R� R� R� R^ R� ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyR� � s G
0 ( R
Rn R t workbench.uiR R R RO R� ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.pyt <module> s ka