| 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
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 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 _( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyt <lambda>/ s t BITs BIT VARYINGc s
� d | � S( Ns [Bb]?'?[10]+'?( ( t val( R ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR) 3 s t BOOLEANc s
� d | � S( Ns (TRUE|FALSE)( ( R+ ( R ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 r�d } n�| d k rd | j
k o�d6 k n r�d } n d | j
k o�d7 k n r�d } qXd | j
k o�d8 k n r d } qXd } nF| d k r�d | j
k o8d9 k n rFd } n d | j
k o`d: k n rnd! } qXd | j
k o�d; k n r�d } qXd
} n� | d" k r�d" } n� | d# k r�d# } n� | d$ k r�d$ } nz | d< k r�d% } 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pys <genexpr>M s R0 R" R$ i i i i t
MEDIUMTEXTt LONGTEXTR! R# R R R i����R 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR � s
( t __name__t
__module__R R? R] Rf R ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR s
& e c C s d S( Nt Sql92( ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyt getTargetDBMSName� s c C s t j | | � S( N( t instancet migrateIdentifier( R t log( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyRq � s c C s t j | | � S( N( Rp t migrateCatalog( R t source_catalog( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyRs � s c C s t j | | | � S( N( Rp t
migrateSchema( R t sourceSchemaRK ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyRu � s c C s t j | | | � S( N( Rp R ( R R t
target_schema( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR � s c C s t j | | | � S( N( Rp t migrateTableToMySQL2ndPass( R R R ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyRx � s c C s t j | | | � S( N( Rp t migrateTableForeignKeyToMySQL( R t source_fkR ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyRy � s c C s t j | | | � S( N( Rp t migrateTriggerToMySQL( R t source_triggert target_table( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR{ � s c C s t j | | | � S( N( Rp t migrateViewToMySQL( R t source_viewRw ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR~ � s c C s t j | | | � S( N( Rp t migrateRoutineToMySQL( R t source_routineRw ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyR� � s c C s t j | | � S( N( Rp Rf ( R Rd ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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� ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sql92_migration_grt.pyt <module> s& � *099699990