| 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 (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc @ 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] } | 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 logObjectt refObjectt None( t selft statet sourceObjectt log( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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
ignoreListt ownerR t Falset True( R R t otypet object( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt migrateIdentifierA 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 ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pys <genexpr>R 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_columnR1 t mysql_simpleTypest source_typet source_datatypet target_datatypeR ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt migrateDatatypeForColumnO sJ c C s? | j } | r( | j r( | j j } n | r; | j j Sd S( N( R4 R5 R6 R R R
( R R RD ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt migrateUpdateForChanges s c C s | S( N( ( R R t
default_valueRA RB ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt migrateColumnDefaultValue s c C s
| | f S( N( ( R R t charsett collationt
source_objectt
target_object( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 x | j D]| } t t | j <| j | | }
xQ | j D]F } | j | d | sq^n | j | | } | j! | | | q^Wq,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 R3 R8 R1 t
targetVersiont
GrtVersiont majorNumbert minorNumbert
releaseNumbert buildNumberR R t
send_progresst schematat begin_progress_stepR! t
migrateSchemaR) t end_progress_stept sett key_namesR RS R t migrateTableToMySQL2ndPass(
R R t source_catalogRI R t targetRdbmst aTargetVersionRX t it sourceSchemat targetSchemat sourceTablet targetTable( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt migrateCatalog sR 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 RR g?s' Migrating schema contents for schema %sg ?( R$ R% t db_mysql_SchemaR R< RQ t defaultCharacterSetNamet defaultCollationNameR- R RU t commentR^ R R` t migrateSchemaContentsRb ( R R Rj R1 Rk R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRa 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(
NRS t viewst routinesg|=g s Table %s.%s migratedi s View %s.%s migrateds Routine %s.%s migrated( R! RS R Rt Ru t migrateTableToMySQLR) R$ R^ R t migrateViewToMySQLt migrateRoutineToMySQL( R R Rk Rj t tablet viewt routinet totalRi t source_tablet target_tablet source_viewt target_viewt source_routinet target_routine( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRs 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 RR i c s s | ] } | j j Vq d S( N( t referencedColumnR ( R. R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pys <genexpr>6 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 RU Rr t isStubR Rc t columnst migrateTableColumnToMySQLR) t
collationNamet addR! Rq t popt indicest migrateTableIndexToMySQLt migrateTablePrimaryKeyToMySQLt
primaryKeyR
t enumerateR t
autoIncrementt reorderR R t migrateTriggerToMySQL( R R Rl Rk Rm R t column_collationst sourceColumnt targetColumnR t sourceIndext targetIndext first_autoinc_columnt idxt pk_colst
sourceTriggert
targetTrigger( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRv s^ !
! c C sF x? | j D]4 } | j | | | } | r
| j j | q
q
Wd S( Ni ( t foreignKeyst migrateTableForeignKeyToMySQLR) ( R R Rl Rm t sourceFKt targetFK( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRe I 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.RR s6 Could not migrate datatype of column %s in table %s.%s( R4 R t defaultValueR R R< R$ t send_warning( R R RA RB R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt" secondary_default_value_validationP 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 RR R* i i ( i i i ( R R$ R% t db_mysql_ColumnR< R- R R RU R7 R) t defaultValueIsNullt isNotNullR R= R> t datatypeExplicitParamsRQ t characterSetNameR Rr RG RL R R RZ R[ R\ R ( R R RA Rm RI RB R t flag( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR a s. - 'c C s+ | j r' t | j | j j | _ n d S( Ni ( R R R R ( R R Rl Rm ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 attributeRR R* sh The column "%s" is part of source table "%s" index "%s" but there is not 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 RU t isPrimaryt deferabilityt uniquet indexTypeRr R R t db_mysql_IndexColumnt columnLengthR4 t groupR t mint& MYSQL_MAX_INDEX_KEY_LENGTH_INNODB_UTF8t descendR) ( R R t source_indexRm Rl t target_indexR t source_index_columnt referenced_index_colt target_index_columnt prefix_length_limit( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 RR 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_ForeignKeyRd R R- R RU t
deleteRulet replacet
updateRuleR t mandatoryt referencedMandatoryt manyRr R t referencedTablet
ValueErrort ExceptionR# R R) t referencedColumnst index( R R t source_fkRm Rl Rj t target_fkR t fk_nameR t referenced_schemat errt referenced_tablet
column_errorst source_fk_columnt
target_fk_col( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR s *
.1 c C s d d d d d d d d d d
d d d
d d g } t j j } | j d | | d | | _ x' | D] } t | | t | | qh Wd | _ | S( NR RU t definert eventt conditiont ordert orientationt timingt referenceNewTablet referenceOldTablet referenceNewRowt referenceOldRowt sequenceNumbert enabledt
sqlDefinitioni RR i ( R$ R% t db_mysql_TriggerR< R t setattrt getattrt commentedOut( R R t source_triggerR~ t copy_memberst target_triggert m( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 RU t withCheckConditiont
isReadOnlyR i RR i ( R$ R% t
db_mysql_ViewR R< R R R ( R R R t
target_schemaR R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRw 4 s
c C sz d d d d d g } t j j } | | _ | j d | | d x' | D] } t | | t | | qJ Wd | _ | S( NR RU t routineTypeR R i RR i ( R$ R% t db_mysql_RoutineR R< R R R ( R R R R R R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRx B s
( t __name__t
__module__R R R R R- RG RH RJ RL RQ Rn Ra Rs Rv Re R R R R R R Rw Rx ( ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR s, 5 : ! F " ; a c C s d S( Nt Generic( ( ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt getTargetDBMSNameR s c C s t j | | S( N( t instanceR- ( R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR- V s c C s t j | | S( N( R Rn ( R Rf ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRn [ s c C s t j | | | S( N( R Ra ( R Rj R1 ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRa ` s c C s t j | | | S( N( R Rv ( R Rl R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRv e s c C s t j | | | S( N( R Re ( R Rl Rm ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRe j s c C s t j | | | S( N( R R ( R R Rm ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR o s c C s t j | | | S( N( R R ( R R R~ ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyR t s c C s t j | | | S( N( R Rw ( R R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRw y s c C s t j | | | S( N( R Rx ( R R R ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRx ~ s c C s t j | | S( N( R RJ ( R RI ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyRJ 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( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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" Rd R R R t exportt STRINGR R% t GrtLogObjectR- t
db_Catalogt db_migration_MigrationRn t db_SchemaRa t db_TableRv t INTRe R t
db_ForeignKeyR R t
db_TriggerR R t db_ViewRw R t
db_RoutineRx RJ t LISTR R ( ( ( sW C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_migration_grt.pyt <module> s0
3 *099699990