| 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 : C:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc @ s d d l Z d d l m Z d d l Z d d l m Z e d d d d d d Z d
Z 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( iN( t DefineModule( t GenericMigrationt namet DbSql92Migrationt authors Oracle Corp.t versions 1.0i t Sql92Migrationc B s5 e Z d Z d Z d Z d Z d Z RS( c C sU t t | j | | | } | j | | j j | j j | | \ | _ | _ | S( N( t superR t migrateTableToMySQLt migrateCharsetCollationt ownert defaultCharacterSetNamet defaultCollationName( t selft statet sourceTablet targetSchemat targetTable( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR s 3c
s | } d d d d g t f d d d d d g t f d
d d d
d d d g d f d d g f d f d g f d f d g f d f d g f d f d g f d f g } | j r~| j j } | r~x | D] } | | d k r y | d | Wn1 t k
rId } | j d | | d | qtX| d k rt| j d! k rtd" } qtq q Wq~n | S(# Nc S s5 t j | | d k r1 t d | | f n t S( Ns/ "%s" does not match the regular expression "%s"( t ret matcht Nonet
ValueErrort True( t re_strt target( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt raise_on_no_match' s t SMALLINTt INTt BIGINTt NUMERICt DECIMALt FLOATt REALs DOUBLE PRECISIONt CHARt VARCHARt NCHARt NVARCHARt BLOBt CLOBt XMLc S s t S( N( R ( t _( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt <lambda>/ s t BITs BIT VARYINGc s
d | S( Ns [Bb]?'?[10]+'?( ( t val( R ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR) 0 s t DATEc s
d | S( Ns (\d{4}|\d{2})-\d{1,2}-\d{1,2}( ( R+ ( R ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR) 1 s t TIMEc s
d | S( Ns" (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2}( ( R+ ( R ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR) 2 s t TIMESTAMPc s
d | S( Ns_ ((\d{4}|\d{2})-\d{1,2}-\d{1,2}( (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2})?|CURRENT_TIMESTAMP|now\(\))( ( R+ ( R ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR) 3 s t BOOLEANc s
d | S( Ns (TRUE|FALSE)( ( R+ ( R ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR) 5 s i i t s+ Default value %s is not supported. Removed!s NOW()t CURRENT_TIMESTAMP( t intt floatt
simpleTypeR t Exceptiont addMigrationLogEntryt upper( R
R t
default_valuet
source_columnt
target_columnt target_default_valuet value_validatorst source_datatypet value_validator( ( R sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt migrateColumnDefaultValue$ s0 !
c C s | j } t d | j D } | j } | r` | j r` | j j } | j j | j j n | r| j j } d } | d1 k r d | j
k o d k n r d } qXd | j
k o d k n r | j j d k r d } q d } qXd
} n]| d2 k r(| j
d k r d } qXd
} n0| d3 k rF| } d | _
n| d4 k r[d } n| d5 k rpd } n| d k rd } n| d k rd | j
k od6 k n rd } n d | j
k od7 k n rd } qXd | j
k od8 k n r d } qXd } nF| d k rd | j
k o8d9 k n rFd } n d | j
k o`d: k n rnd! } qXd | j
k od; k n rd } qXd
} n | d" k rd" } n | d# k rd# } n | d$ k rd$ } nz | d< k rd% } ne | d' k r'd( } d) | _
| j d | | d* n1 | d+ k rRd! } | j d | | d, n | } | j | rw| | | _ nJ t j d- d. | | f | j d | | d/ | j | j j | f t St S| j d | | d0 | j | j j | j f t St S(= Nc s s$ | ] } | j j | f Vq d S( N( R R7 ( t .0t datatype( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pys <genexpr>M s R0 R" R$ i i i i t
MEDIUMTEXTt LONGTEXTR! R# R R R iR R R R s DOUBLE PRECISIONt DOUBLER% i i t TINYBLOBi i t
MEDIUMBLOBt LONGBLOBR& t TINYTEXTt TEXTR. R, R- R* s BIT VARYINGR/ t TINYINTi s5 Source column type BOOLEAN was migrated to TINYINT(1)R' s+ Source column type XML was migrated to TEXTs! SQL-92 migrateTableColumnsToMySQLs# Can't find datatype %s for type %s
s< Could not migrate column "%s" in "%s": Unknown datatype "%s"s2 Could not migrate type of column "%s" in "%s" (%s)( s VARCHARs NVARCHAR( s CHARs NCHAR( s BIGINTs INTs SMALLINT( s DECIMALs NUMERIC( s REALs FLOATi i i i i i ( s BITs BIT VARYING( t
targetCatalogt dictt simpleDatatypesR4 t userTypet
actualTypet flagst extendR R7 t lengthR t majorNumbert precisionR6 t has_keyt grtt log_warningR
t FalseR t formattedRawType( R
R R9 R: RK t mysql_simpleTypest source_typeR= t target_datatype( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt migrateDatatypeForColumnJ s
c C s x | j D] } x | j D] } x | j D] } d } d } | j | } | rf t j | | } n | r* | r* | d k r d } n | r d | | j j d | j <q q* q* Wq Wq
W| S( s]
Create datatype cast expression for target column based on source datatype.
R' s CAST(? as NVARCHAR(max))s %s as ?s columnTypeCastExpression:%sN(
t schematat tablest columnsR t lookupSourceObjectR t getColumnDataTypeR
t
customDataR ( R
R t target_catalogR R R: t type_cast_expressionR= R9 ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt migrateUpdateForChanges s -c C s. | r$ | j d | | d | d S| | f S( Ni s( Collation %s migrated to utf8_general_ciR0 t utf8_general_ci( R0 s utf8_general_ci( R6 ( R
R t charsett collationt
source_objectt
target_object( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR s
( t __name__t
__module__R R? R] Rf R ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR s
& e c C s d S( Nt Sql92( ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instancet migrateIdentifier( R t log( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRq s c C s t j | | S( N( Rp t migrateCatalog( R t source_catalog( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRs s c C s t j | | | S( N( Rp t
migrateSchema( R t sourceSchemaRK ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRu s c C s t j | | | S( N( Rp R ( R R t
target_schema( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR s c C s t j | | | S( N( Rp t migrateTableToMySQL2ndPass( R R R ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRx s c C s t j | | | S( N( Rp t migrateTableForeignKeyToMySQL( R t source_fkR ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRy s c C s t j | | | S( N( Rp t migrateTriggerToMySQL( R t source_triggert target_table( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR{ s c C s t j | | | S( N( Rp t migrateViewToMySQL( R t source_viewRw ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR~ s c C s t j | | | S( N( Rp t migrateRoutineToMySQL( R t source_routineRw ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyR s c C s t j | | S( N( Rp Rf ( R Rd ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyRf s c C s" t j t j t j j j } | S( N( RV t Listt OBJECTt classest db_migration_MigrationParametert __grtclassname__( R t list( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt getMigrationOptions s () R t wbR RV t db_generic_migration_grtR t
ModuleInfot truncated_identifier_serialR Rp t exportt STRINGRo R t GrtLogObjectRq t
db_Catalogt db_migration_MigrationRs t db_SchemaRu t db_TableR R Rx t db_mysql_ForeignKeyt
db_ForeignKeyRy t db_mysql_Triggert
db_TriggerR{ t
db_mysql_Viewt db_ViewR~ t db_mysql_Routinet
db_RoutineR Rf t LISTR R ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sql92_migration_grt.pyt <module> s& *099699990