| 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 : /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
2zXc @ 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 rd | j k r| j j d qqnc | 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)ii 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 rt 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} qqWd 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|
} qd | j _ qqW| 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 | qqqWn | 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 rt | j t n t }
| j d k rt |
| 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 qn | 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 | Wqt k
rp} | j d | | d t | | j f t }
qXqW|
r| St }
x | j D] } y] | j | | } | st d | j | j d d t | j j f n | j j | Wqt k
r6} | j d | | d t | | j f t }
qXqW|
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