| 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 Z d d l m Z d d l Z d d l m Z e d d d d d 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 DbSQLAnywhereMigrationt authors Oracle Corp.t versions 1.0t SQLAnywhereMigrationc B s, e Z d Z d Z d Z d Z RS( c s | j j j } | } d d d d d g t f d d d d d
g t f d d 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 d g f d f g } d } | j r>| j j } | r>| j r| j j n | j j j } | j d k r;| j d } q;q>n | r| } | j
d! k r|| d- k r|| j j d" d# Sx| D]}
| |
d$ k ry |
d% | Wn1 t
k
rd# } | j d% | | d& | qX| j r| j j pd# } | d. k r| j
d/ k r| j j | j j | j j f d0 k r}| d k rTd) } qd# } | j d% | | d, | | f qd) } qqqWn | S(1 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( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt raise_on_no_match" s t TINYINTt SMALLINTt INTEGERt BIGINTt NUMERICt DECIMALt FLOATt REALt DOUBLEt CHARt VARCHARt NCHARt NVARCHARt TEXTt NTEXTUNIQUEIDENTIFIERSTRt BINARYs LONG BINARYt XMLc S s t S( N( R ( t _( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt <lambda>* s t VARBITs LONG VARBITc s
d | S( Ns [Bb]?'?[10]+'?( ( t val( R ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR! + s t DATEc s
d | S( Ns (\d{4}|\d{2})-\d{1,2}-\d{1,2}( ( R# ( R ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR! , s t TIMEc s
d | S( Ns" (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2}( ( R# ( R ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR! - s t TIMESTAMPt DATETIMEc s d | j S( NsR ((\d{4}|\d{2})-\d{1,2}-\d{1,2}( (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2})?|NULL|NOW\(\))( t upper( R# ( R ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR! . s t numerics ' t
AUTOINCREMENTt AUTO_INCREMENTt i i s+ Default value %s is not supported. Removed!s NOW()s CURRENT TIMESTAMPt CURRENT_TIMESTAMPi i sJ Default value %s is not supported for a MySQL column of type "%s".Removed!( s TINYINTs SMALLINTs INTEGERs BIGINT( s TIMESTAMPs DATETIME( s NOW()s CURRENT TIMESTAMPs CURRENT_TIMESTAMPs TIMESTAMP( i i i ( t ownert intt floatR t
simpleTypeR t groupt userTypet
actualTypet stripR( t flagst appendt Exceptiont addMigrationLogEntryR t majorNumbert minorNumbert
releaseNumber( t selft statet
default_valuet
source_columnt
target_columnt target_catalogt target_default_valuet value_validatorst source_datatypeR2 t value_validatort target_datatype( ( R s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt migrateColumnDefaultValue sP ' $
' c
C s | j } t d | j D } | j } | r | j r | j j } | r | j j j d r | d | _ | j j d | _ t S| j
j | j j
n | rY| j j
} d } | d k r;d | j k o d k n r d } qd | j k o d k n r2| j j d
k r)d } q8d } qd } n| d
k rh| j d k r_d
} qd } n| d k r}d } no| d k rd } nZ| d= k r| } d | _ n<| d> k rd } n'| d k rd } d | _ d | _ n | d k rd } d | _ d | _ n| d k r(d } n| d k r=d } n| d k rzd | j k ocd! k n rqd } qd" } nr| d# k rd" } n]| d? k rd } nH| d' k r1d | j k od( k n rd) } qd( | j k od* k n r d+ } qd* | j k od, k n r(d- } qd" } n | d. k rFd" } n | d/ k r[d0 } n | d1 k rpd1 } n| | d2 k rd2 } ng | d3 k rd2 } | j d | | d4 n< | d5 k rd } d6 | _ n | j d7 rd } n | } | j | r | | | _ nJ t j d8 d9 | | f | j d: | | d; | j | j j | f 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 .0t datatype( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pys <genexpr>^ s s enum(t ENUMi R, R i i i i t
MEDIUMTEXTt LONGTEXTR t BITR R t INTR R iR R t
SMALLMONEYi
t MONEYi R R s DOUBLE PRECISIONR R" i i@ t LONGBLOBs LONG VARBITR R t NTEXTR i t TINYBLOBi t BLOBi t
MEDIUMBLOBs LONG BINARYR& R' R$ R% t DATETIMEOFFSETs6 Source column type DATETIMEOFFSET was migrated to TIMEt UNIQUEIDENTIFIERSTRi$ t ST_s& SQLAnywhere migrateTableColumnsToMySQLs# Can't find datatype %s for type %s
i s< Could not migrate column "%s" in "%s": Unknown datatype "%s"s2 Could not migrate type of column "%s" in "%s" (%s)( s SMALLINTs INTs BIGINT( s DECIMALs NUMERIC( s XMLs TEXTs NTEXT( t
targetCatalogt dictt simpleDatatypesR1 R3 R4 t
sqlDefinitiont
startswitht datatypeExplicitParamsR R6 t extendR R( t lengthR R: t precisiont scaleR9 t has_keyt grtt log_warningR. t Falset formattedRawType( R= R> R@ RA RZ t mysql_simpleTypest source_typeRE RG ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt migrateDatatypeForColumn[ s
c C s | S( s]
Create datatype cast expression for target column based on source datatype.
( ( R= R> RB ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt migrateUpdateForChanges s c C s t t | j | | | } | rxyt | j | j D]_\ } } | j | j k sj | j | j k r| j d | | d | j j
| j
| j j
| j
| j | j | j f | j | j k r d | j j
| j j d | j
<n | j | _ | j | _ n | j
r: | j d k rRd | _ | j d | | d | j j
| j
f n | j d k rd | _ | j d | | d | j j
| j
f qq: q: Wn | S( Ni sa The column %s.%s references %s.%s but its data type is %s instead of %s. Data type changed to %s.s
?::%s as ?s columnTypeCastExpression:%ss SET NULLs NO ACTIONss Cannot have a SET NULL update rule: referencing column %s.%s does not allow nulls. Update rule changed to NO ACTIONss Cannot have a SET NULL delete rule: referencing column %s.%s does not allow nulls. Delete rule changed to NO ACTION( t superR t migrateTableForeignKeyToMySQLt zipt columnst referencedColumnsR1 Ra R9 R. R t
formattedTypet
customDatat isNotNullt
updateRulet
deleteRule( R= R> t source_fkt targetTablet target_fkt columnt referenced_column( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyRn s2 "$$ $( t __name__t
__module__RH Rk Rl Rn ( ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s = x c C s d S( Nt SQLAnywhere( ( ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instancet migrateIdentifier( R t log( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | S( N( R t migrateCatalog( R> t source_catalog( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | | S( N( R t
migrateSchema( R> t sourceSchemaRZ ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | | S( N( R t migrateTableToMySQL( R> t sourceTablet
target_schema( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | | S( N( R t migrateTableToMySQL2ndPass( R> R Rx ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | | S( N( R Rn ( R> Rw Rx ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyRn s c C s t j | | | S( N( R t migrateTriggerToMySQL( R> t source_triggert target_table( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR s c C s t j | | | S( N( R t migrateViewToMySQL( R> t source_viewR ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR " s c C s t j | | | S( N( R t migrateRoutineToMySQL( R> t source_routineR ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyR ' s c C s t j | | S( N( R Rl ( R> RB ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyRl , s c C sY t j t j t j j j } t j j } d | _ d | _ d | _ | j | | S( Ns& sqlanywhere:migrateTimestampAsDatetimese Migrate TIMESTAMP values as DATETIME by default. TIMESTAMP values in MySQL have a limited time range.t boolean(
Re t Listt OBJECTt classest db_migration_MigrationParametert __grtclassname__R t captiont paramTypeR7 ( R> t listt param( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt getMigrationOptions1 s
(( R t wbR Re t db_generic_migration_grtR t
ModuleInfoR R t exportt STRINGR R t GrtLogObjectR t
db_Catalogt db_migration_MigrationR t db_SchemaR t db_TableR RO R t db_mysql_ForeignKeyt
db_ForeignKeyRn t db_mysql_Triggert
db_TriggerR t
db_mysql_Viewt db_ViewR t db_mysql_Routinet
db_RoutineR Rl t LISTR R ( ( ( s[ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlanywhere_migration_grt.pyt <module> s$ *099699990