| 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 m Z d d l m Z d d l Z d d Z d Z d Z e d d d d
d d � Z d a i a
d
e f d � � YZ e � Z
e j e j � d � � Z e j e j e j e j j � d � � Z e j e j j e j j e j j � d � � Z e j e j j e j j e j j e j j � d � � Z e j e j j e j j e j j e j j � d � � Z e j e j e j j e j j e j j � d � � Z e j e j j e j j e j j e j j � d � � Z e j e j j e j j e j j! e j j � d � � Z" e j e j j# e j j e j j$ e j j � d � � Z% e j e j j& e j j e j j' e j j � d � � Z( e j e j j e j j e j j � d � � Z) e j e j* e j j+ f e j j � d � � Z, d S( i����( t DefineModule( t find_object_with_old_nameNi� i i t namet DbGenericMigrationt authors Oracle Corp.t versions 1.0t GenericMigrationc B s� e Z d � Z d � Z d � Z e 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 � Z RS( c C s� x� | j D]y } t | j � t | � k r
t | j j � t | j � k r
| j j j | j j k r
| j j | j k r
| j Sq
Wd S( s\ Finds the matching target object for a given source object, by searching in the migrationLogN( t migrationLogt typet logObjectt ownerR t refObjectt None( t selft statet sourceObjectt log( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt findMatchingTargetObject" s ! c C s� | j r� x� | j D]� } | j j � | j � k r | j d k rk | j d k rk | j | j k rk q n | j d k r� | j d k r� | j | j k r� q n | Sq Wn d S( Ni ( t genericDatatypeMappingst sourceDatatypeNamet uppert lengthConditionFromt lengtht lengthConditionToR ( R
R t columnt datatypet typemap( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt findDatatypeMapping, s 11 c C s@ d | | j k s8 d | | j j | j f | j k r< t St S( Ns %s:*s %s:%s.%s( t
ignoreListR
R t Falset True( R
R t otypet object( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt
shouldMigrate? s 8c C s� | } t | � d k r} t d 7a | d t t � } | r} t j j � } d | _ d | | f | _ | j j | � q} n | S( Ni@ i i> s5 Identifier `%s` is too long and was truncated to `%s`(
t lent truncated_identifier_serialt strt grtt classest GrtLogEntryt entryTypeR t entriest append( R
R R t dots_allowedt
mysql_namet entry( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateIdentifierD s
c
C s1 | j } t d � | j D� � } | j } | r` | j r` | j j } | j j | j j � n | r�| j } | } | j | | | � } | r�| j
| j j � � s� t
j d d | j | f � | j d | | d | j | f � t S| | j j � | _ | j d k r | j | _ n | j d k r>| j | _ n | j d k r\| j | _ n | j d k r�d | j k r�| j j d � q�q�nc | j
| j � � r�| | j � | _ n8 t
j d d | | f � | j d | | d
| � t St S| j d | | d | j | j j | j f � t St S( Nc s s$ | ] } | j j � | f Vq d S( N( R R ( t .0R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pys <genexpr>U s t migrateTableColumnsToMySQLs* Can't find mapped datatype %s for type %s
i sL Unknown mapped datatype "%s" for source type "%s" (check type mapping table)i����i t UNSIGNEDs# Can't find datatype %s for type %s
s Unknown datatype "%s"s2 Could not migrate type of column "%s" in "%s" (%s)( t
targetCatalogt dictt simpleDatatypest
simpleTypet userTypet
actualTypet flagst extendR R t has_keyt targetDatatypeNameR R% t log_warningt addMigrationLogEntryR R t scalet precisiont
isUnsignedR* R R
t formattedRawType(
R
R t
source_columnt
target_columnR2 t mysql_simpleTypest source_typet source_datatypet target_datatypeR ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateDatatypeForColumnR sJ c C s? | j } | r( | j r( | j j } n | r; | j j � Sd S( N( R5 R6 R7 R R R ( R
R RE ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt getColumnDataType� s c C s | S( s]
Create datatype cast expression for target column based on source datatype.
( ( R
R t target_catalog( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateUpdateForChanges� s c C s | S( N( ( R
R t
default_valueRB RC ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateColumnDefaultValue� s c C s
| | f S( N( ( R
R t charsett collationt
source_objectt
target_object( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateCharsetCollation� s c
C s� t j j � } | j d | | d � } | j | j | � | _ | j | _ | j j j } | j
j | j
� | | _ | j
r� | j
} t j j � } | | _ | j | j | j | j f \ | _ | _ | _ | _ | j | _ | | _ nH t j j � } | | _ d \ | _ | _ | _ | _ d | _ | | _ t r�t j d d � d } x� | j D]� } t j d | t | j � d d | d t | j � d � t j d | t | j � d d
| j � | j | | | � }
|
r�| j j |
� n t j � | d 7} q\Wt j d d � xu | j D]j } t � t | j <xQ | j D]F } | j | d | � smqLn | j | | � } | j! | | | � qLWq,Wt j d
d � n | S( Ni t i s 5.5.0g s Migrating...g�������?g�����|�=i s Migrating schema %s...s# Finalizing foreign key migration...t tablesg �?s Migration finished( i i i i (" R% R& t db_mysql_CatalogR= R. R t oldNamet targetConnectiont driverR
R4 R9 R2 t
targetVersiont
GrtVersiont majorNumbert minorNumbert
releaseNumbert buildNumberR R t
send_progresst schematat begin_progress_stepR" t
migrateSchemaR* t end_progress_stept sett key_namesRT R! R t migrateTableToMySQL2ndPass(
R
R t source_catalogRJ R t targetRdbmst aTargetVersionRY t it sourceSchemat targetSchemat sourceTablet targetTable( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt migrateCatalog� sP 6 >,
c C s� t j j � } | | _ | j d | | d � } | j | | j | j | | � \ | _ | _ | j | j | � | _ | j | _
| j | _ t j d d | j � t
r� t j d d � | j | | | � t j � n | S( Ni RS g�������?s' Migrating schema contents for schema %sg �?( R% R& t db_mysql_SchemaR
R= RR t defaultCharacterSetNamet defaultCollationNameR. R RV t commentR_ R Ra t migrateSchemaContentsRc ( R
R Rk R2 Rl R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRb � s -
c C sG t g | j D]! } | j | d | � r
| ^ q
� t g | j D]! } | j | d | � rA | ^ qA � t g | j D]! } | j | d | � rv | ^ qv � d } d } x� | j D]z } | j | d | � r� | j | | | � }
|
r� | j j |
� n t j | | d | j | j f � | d 7} q� q� Wx� | j D]z } | j | d | � r=| j
| | | � } | r�| j j | � n t j | | d | j | j f � | d 7} q=q=Wx� | j D]z }
| j | d |
� r�| j | |
| � } | r| j j | � n t j | | d | j |
j f � | d 7} q�q�Wd S(
NRT t viewst routinesg�����|�=g s Table %s.%s migratedi s View %s.%s migrateds Routine %s.%s migrated( R" RT R! Ru Rv t migrateTableToMySQLR* R% R_ R t migrateViewToMySQLt migrateRoutineToMySQL( R
R Rl Rk t tablet viewt routinet totalRj t source_tablet target_tablet source_viewt target_viewt source_routinet target_routine( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRt � s0 �$$$c C s t j j � } | j d | | d � } | | _ | j | j | � | _ | j | _ | j | _ | j | _ t
r t � } x[ | j D]P } | j
| | | � } | r� | j j | � | j r� | j | j � q� q� q� Wt | � d k r)| j d k r)x | j D] } d | _ qW| j � | _ n x? | j D]4 }
| j | |
| � } | r3| j j | � q3q3W| j | | | � | j r t | j j � d k r d } xP t | j j � D]< \ }
} | j j r�| d k r�|
} q�d | j _ q�q�W| d k r | j j j | d � q n | j rHt d � | j j D� � } n g } xR | j D]G } | j rX| j | k rXd | _ | j d | | d | j � qXqXWxZ | j D]L } | j | d | � r�| j | | | � } | r�| j j | � q�q�q�Wn | S( Ni RS i c s s | ] } | j j Vq d S( N( t referencedColumnR ( R/ R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pys <genexpr>9 s sd Autoincrement unset for column %s: Autoincrement for non primary key columns is not allowed in MySQLt triggers( R% R& t db_mysql_TableR= R
R. R RV Rs t isStubR Rd t columnst migrateTableColumnToMySQLR* t
collationNamet addR" Rr t popt indicest migrateTableIndexToMySQLt migrateTablePrimaryKeyToMySQLt
primaryKeyR t enumerateR� t
autoIncrementt reorderR� R! t migrateTriggerToMySQL( R
R Rm Rl Rn R t column_collationst sourceColumnt targetColumnR t sourceIndext targetIndext first_autoinc_columnt idxt pk_colst
sourceTriggert
targetTrigger( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRw s^ !
! c C sF x? | j D]4 } | j | | | � } | r
| j j | � q
q
Wd S( Ni ( t foreignKeyst migrateTableForeignKeyToMySQLR* ( R
R Rm Rn t sourceFKt targetFK( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRf L s
c C s� | j r� | j j d k r� | j d k r� xd | j j D]S } | | k rM Pn | j r7 | j j d k r7 | j d | | d � d | _ q7 q7 Wq� n, t j d | j | j j j | j j f � d S( Nt TIMESTAMPt CURRENT_TIMESTAMPi sm DEFAULT CURRENT_TIMESTAMP can only be used in the first TIMESTAMP column of the table. Default value removed.RS s6 Could not migrate datatype of column %s in table %s.%s( R5 R t defaultValueR
R� R= R% t send_warning( R
R RB RC R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt" secondary_default_value_validationS s ! c C s� | j j } t j j � } | | _ | j d | | d � } | j | j | d t �| _ | j | _ x3 | j D]( } | | j k rp | j j
| � qp qp W| j | _ | j | _ | j
| _
| j | _ | j | _ | j | _ | j | | j | j | | � \ | _ | _ | j | _ | j | | | � s5n | j | | j | | � | _ | j j | j j | j j f d k r�| j | | | � n | S( Ni RS R+ i i ( i i i ( R
R% R& t db_mysql_ColumnR= R. R R RV R8 R* t defaultValueIsNullt isNotNullR R> R? t datatypeExplicitParamsRR t characterSetNameR� Rs RH RM R� R R[ R\ R] R� ( R
R RB Rn RJ RC R t flag( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� d s. - 'c C s+ | j r' t | j | j j � | _ n d S( Ni ( R� R R� R ( R
R Rm Rn ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� � s c C s� | j } t | j � d k s3 t | j � d k rT | j d | d d | j � d St j j � } | j d | | d � } | | _ | j | j | d t
�| _ | j | _ | j | _ | j
| _
| j | _ | j | _ | j | _ x�| j D]�} t | j | j j � } | sG| j d | | d | j | j | j f � n t j j � } | | _ | | _ | j | _ | j | _ | j r�| j j j d k r�| j d k r�t | j t � n t }
| j d k r�t |
| j � | _ nr | j d k rI| j d k r%|
| j k r%|
| _ q^| j j j d
k r^|
| _ q^n t |
| j � | _ | j | j k r�| j d
| | d | j | j | j f � q�n | j | _ | j | _ | j j | � q� W| S( Ni i sr The migration of table %s indices was attempted but either the source or the target table has no columns attributeRS R+ sg The column "%s" is part of source table "%s" index "%s" but there is no such column in the target tablet stringt textt blobi s7 Truncated key column length for column %s from %s to %s( s strings textR� ( s textR� ( R
R" R� R= R R R% R& t db_mysql_IndexR. R RV t isPrimaryt deferabilityt uniquet indexTypeRs R R� t db_mysql_IndexColumnt columnLengthR5 t groupR t mint& MYSQL_MAX_INDEX_KEY_LENGTH_INNODB_UTF8t descendR* ( R
R t source_indexRn Rm t target_indexR t source_index_columnt referenced_index_colt target_index_columnt prefix_length_limit( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� � sT * ' # c C sm | j } | j } t | j � d k s< t | j � d k r] | j d | d d | j � d S| j d k rp d St j j � } | | _ | j d | | d � } | j } | t
| j k r'd } x< t r | j d | } | t
| j k r� Pn | d 7} q� W| j d | | d | j | f � n | j | | d t �| _ t
| j j
| � | j | _ | j j d d
� | _ | j j d d
� | _ | j | _ d | _ | j | _ | j | _ | j | _ | j | _ y. | j | | j j � }
|
st d � n Wn@ t k
rG} | j d | | d t | � | j j f � | SXy4 | j | | j � } | srt d
� n | | _ Wn= t k
r�} | j d | | d t | � | j f � | SXt }
x� | j D]� } yZ | j | | � } | st d | j | j d d t �| j f � n | j j | � Wq�t k
rp} | j d | | d t | � | j f � t }
q�Xq�W|
r| St }
x� | j D]� } y] | j | | � } | s�t d | j | j d d t �| j j f � n | j j | � Wq�t k
r6} | j d | | d t | � | j f � t }
q�Xq�W|
rE| S| j ri| j | | j � | _ n | S( Ni i sw The migration of table %s foreign keys was attempted but either the source or the target table has no columns attributei RS s _%dsC The foreign key constraint name "%s" is duplicated. Changed to "%s"R+ t _t s= The referenced schema does not refer to a valid schema objects6 "%s" while trying to get the schema for the table "%s"s; The referenced table does not refer to a valid table objectsF "%s" while trying to get the referenced table for the foreign key "%s"s+ The column "%s" was not found in table "%s"sD "%s" while trying to get the target columns for the foreign key "%s"so migrateTableForeignKeysToMySQL: "%s" while trying to get the referenced target columns for the foreign key "%s"( R
R" R� R= R R t modelOnlyR% R& t db_mysql_ForeignKeyRe R R. R� RV t
deleteRulet replacet
updateRuleR� t mandatoryt referencedMandatoryt manyRs R t referencedTablet
ValueErrort ExceptionR$ R R* t referencedColumnst index( R
R t source_fkRn Rm Rk t target_fkR t fk_nameR� t referenced_schemat errt referenced_tablet
column_errorst source_fk_columnt
target_fk_col( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� � s� *
.1 c C s� d d d d d d d g } t j j � } | j d | | d � | | _ x' | D] } t | | t | | � � qP Wd
| _ | S( NR RV t definert eventt timingt enabledt
sqlDefinitioni RS i ( R% R& t db_mysql_TriggerR= R
t setattrt getattrt commentedOut( R
R t source_triggerR t copy_memberst target_triggert m( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� ) s
c C sz d d d d d g } t j j � } | | _ | j d | | d � x' | D] } t | | t | | � � qJ Wd | _ | S( NR RV t withCheckConditiont
isReadOnlyR� i RS i ( R% R& t
db_mysql_ViewR
R= R� R� R� ( R
R R� t
target_schemaR� R� R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRx 5 s
c C sw d d d d g } t j j � } | | _ | j d | | d � x' | D] } t | | t | | � � qG Wd | _ | S( NR RV t routineTypeR� i RS i ( R% R& t db_mysql_RoutineR
R= R� R� R� ( R
R R� R� R� R� R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRy C s
( t __name__t
__module__R R R! R R. RH RI RK RM RR Ro Rb Rt Rw Rf R� R� R� R� R� R� Rx Ry ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR s,
5 9 ! G " ; a c C s d S( Nt Generic( ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt getTargetDBMSNameR s c C s t j | | � S( N( t instanceR. ( R R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR. V s c C s t j | | � S( N( R� Ro ( R Rg ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRo [ s c C s t j | | | � S( N( R� Rb ( R Rk R2 ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRb ` s c C s t j | | | � S( N( R� Rw ( R Rm R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRw e s c C s t j | | | � S( N( R� Rf ( R Rm Rn ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRf j s c C s t j | | | � S( N( R� R� ( R R� Rn ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� o s c C s t j | | | � S( N( R� R� ( R R� R ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyR� t s c C s t j | | | � S( N( R� Rx ( R R� R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRx y s c C s t j | | | � S( N( R� Ry ( R R� R� ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRy ~ s c C s t j | | � S( N( R� RK ( R RJ ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyRK � s c C s" t j t j t j j j � } | S( N( R% t Listt OBJECTR& t db_migration_MigrationParametert __grtclassname__( R t list( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt getMigrationOptions� s (- t wbR t workbench.utilsR R% R� t( MYSQL_MAX_INDEX_KEY_LENGTH_INNODB_LATIN1t% MYSQL_MAX_INDEX_KEY_LENGTH_NDBCLUSTERt
ModuleInfoR# Re R R R� t exportt STRINGR� R& t GrtLogObjectR. t
db_Catalogt db_migration_MigrationRo t db_SchemaRb t db_TableRw t INTRf R� t
db_ForeignKeyR� R� t
db_TriggerR� R� t db_ViewRx R� t
db_RoutineRy RK t LISTR� R� ( ( ( sQ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.pyt <module> s0
� � 3 *099699990