| 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 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( i����N( 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 r�y |
d% | � Wn1 t
k
r�d# } | j d% | | d& | � q�X| j r�| j j p�d# } | d. k r�| j
� d/ k r�| j j | j j | j j f d0 k r}| d k rTd) } q�d# } | j d% | | d, | | f � q�d) } q�q�q�Wn | 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( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 _( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyt <lambda>* s t VARBITs LONG VARBITc s
� d | � S( Ns [Bb]?'?[10]+'?( ( t val( R ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 } q�d | j k o d k n r2| j j d
k r)d } q8d } q�d } n�| d
k rh| j d k r_d
} q�d } n�| d k r}d } no| d k r�d } nZ| d= k r�| } d | _ n<| d> k r�d } n'| d k r�d } 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 } q�d" } nr| d# k r�d" } n]| d? k r�d } nH| d' k r1d | j k o�d( k n r�d) } q�d( | j k o�d* k n r d+ } q�d* | j k od, k n r(d- } q�d" } n� | d. k rFd" } n� | d/ k r[d0 } n� | d1 k rpd1 } n| | d2 k r�d2 } ng | d3 k r�d2 } | j d | | d4 � n< | d5 k r�d } d6 | _ n | j d7 � r�d } 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( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 i����R 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 ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyt migrateUpdateForChanges� s c
C s� t t | � j | | | � } | r�xyt | 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 r�d | _ | j d | | d | j j
| j
f � q�q: 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( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyRn � s2 "$$ $( t __name__t
__module__RH Rk Rl Rn ( ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR s = x c C s d S( Nt SQLAnywhere( ( ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyt getTargetDBMSName� s c C s t j | | � S( N( t instancet migrateIdentifier( R t log( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� � s c C s t j | | � S( N( R� t migrateCatalog( R> t source_catalog( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� s c C s t j | | | � S( N( R� t
migrateSchema( R> t sourceSchemaRZ ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� s c C s t j | | | � S( N( R� t migrateTableToMySQL( R> t sourceTablet
target_schema( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� s c C s t j | | | � S( N( R� t migrateTableToMySQL2ndPass( R> R� Rx ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� s c C s t j | | | � S( N( R� Rn ( R> Rw Rx ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyRn s c C s t j | | | � S( N( R� t migrateTriggerToMySQL( R> t source_triggert target_table( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� s c C s t j | | | � S( N( R� t migrateViewToMySQL( R> t source_viewR� ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� " s c C s t j | | | � S( N( R� t migrateRoutineToMySQL( R> t source_routineR� ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyR� ' s c C s t j | | � S( N( R� Rl ( R> RB ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 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� ( ( ( sU C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_migration_grt.pyt <module> s$ � *099699990