| 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 d d l m Z e d d d d d d
� Z d 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����N( t DefineModule( t GenericMigration( t find_object_with_namet namet DbSybaseMigrationt authors Oracle Corp.t versions 1.0i t SybaseMigrationc B sS e Z e d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z
RS( c C s0 t j d t j � } | } | j d � r9 | j d � sW | j d � rg | j d � rg | d d !} n | j | � r� | r� t j j � } d | _ d | | _
| j j | � n t
| � d k r,t d 7a | d
t t � } | r,t j j � } d | _ d | | f | _
| j j | � q,n | S( Ns
^[^/\\.]+$t "t [t ]i i����i u9 Sybase migrateIdentifier: Could not migrate identifier %si@ i> u. Identifier `%s` is too long, truncated to `%s`( t ret compilet Ut
startswitht endswitht matcht grtt classest GrtLogEntryt entryTypeR t entriest appendt lent truncated_identifier_serialt str( t selft sybase_namet logt dots_allowedt mysql_valid_regext
mysql_namet entry( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt migrateIdentifier s&
c C sU t t | � j | | | � } | j | | j j | j j | | � \ | _ | _ | S( N( t superR t migrateTableToMySQLt migrateCharsetCollationt ownert defaultCharacterSetNamet defaultCollationName( R t statet sourceTablet targetSchemat targetTable( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR# 9 s 3c C s | } | j r� | j j } | d k r? | d k r� d } q� n_ | d k r� | j d k r� d } t | j j d � | _ | j d | | d | | f � q� n | r� | j d � r� | | k r� y t | � Wq� d } | j d
| | d | � q� Xq� n | S(
Nt TIMESTAMPs getdate()t CURRENT_TIMESTAMPt DATETIMEt
SMALLDATETIMEi s= Default value is %s, so type was changed from %s to TIMESTAMPt 't i s! Default value %s is not supported( s DATETIMEs
SMALLDATETIME( t
simpleTypeR t defaultValueR t
targetCatalogt simpleDatatypest addMigrationLogEntryR t float( R R( t
default_valuet
source_columnt
target_columnt target_default_valuet source_datatype( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt migrateColumnDefaultValue> s( "c C sz | j } t d � | j D� � } | j } | r` | j r` | j j } | j j | j j � n | rC| j j � } d } | d7 k r� d | j
k o� d k n r� d } q�d | j
k o� d k n r� | j j d k r� d
} q� d } q�d } n�| d8 k r(| j
d k r d } q�d } n�| d9 k rFd } d | _
n�| d: k rd| } d | _
nr| d k r�| } d | _
d | j k r�| j j d � q�n2| d k r�d } d | _
| j d | | d | | | j
f � n�| d k r,d } d | _
| j d | | d | | | j
f � n�| d; k rAd } n�| d k r_d } d | _
nw| d k r�| j
d! k r�d n d" } d | _
nD| d< k r�d } | j j | _
| j j | _ n| d% k r�d& } d | _
n� | d= k r]d | j
k o d k n r,| d% k r#d) } qZ| } q�d | j
k oFd k n rTd* } q�d& } ny | d> k rrd+ } nd | d- k r�d- } nO | d. k r�d. } n: | d/ k r�d } d0 | _
| j d | | d1 � n | } | j | � r�| | | _ nJ t j d2 d3 | | f � | j d4 | | d5 | j | j j | f � t St S| j d4 | | d6 | j | j j | j f � t St S(? Nc s s$ | ] } | j j � | f Vq d S( N( R t upper( t .0t datatype( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pys <genexpr>^ s R1 t VARCHARt NVARCHARt
UNIVARCHARi i i i t
MEDIUMTEXTt LONGTEXTt CHARt NCHARt UNICHARt TEXTt NTEXTt UNITEXTi����t BIGINTt INTt SMALLINTt TINYINTt UNSIGNEDt SYSNAMEi s, Source column type %s was migrated to %s(%s)t LONGSYSNAMEi� t DECIMALt NUMERICt REALt FLOATi t DOUBLEt MONEYt
SMALLMONEYt IMAGEt LONGBLOBt BINARYt VARBINARYt TINYBLOBt
MEDIUMBLOBR. R/ t DATEt TIMEt BITi s1 Source column type BIT was migrated to TINYINT(1)s! Sybase 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 VARCHARs NVARCHARRC ( s CHARs NCHARRH ( s TEXTs NTEXTRK ( s BIGINTs INTs SMALLINT( s DECIMALs NUMERIC( s MONEYs
SMALLMONEY( s BINARYs VARBINARY( s DATETIMEs
SMALLDATETIME( R4 t dictR5 R2 t userTypet
actualTypet flagst extendR R> t lengthR t majorNumbert precisionR R6 t numericPrecisiont numericScalet scalet has_keyR t log_warningR% t Falset Truet formattedRawType( R R( R9 R: R4 t mysql_simpleTypest source_typeR< t target_datatype( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt migrateDatatypeForColumn[ 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 | 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.
RQ s CONVERT(VARCHAR(30), ?)RR s CONVERT(VARCHAR(255), ?)s %s as ?s columnTypeCastExpression:%sN(
t schematat tablest columnst Nonet lookupSourceObjectR t getColumnDataTypeR% t
customDataR ( R R( t target_catalogR* R+ R: t type_cast_expressionR< R9 ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt migrateUpdateForChanges� s -c C s. | r$ | j d | | d | � d S| | f S( Ni s( Collation %s migrated to utf8_general_ciR1 t utf8_general_ci( R1 s utf8_general_ci( R6 ( R R( t charsett collationt
source_objectt
target_object( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR$ � s
c C sX t j | | | | � } | rT | j rT | j j } | d k rQ | j | _ qQ qT n | S( NRM RO RN RL ( s INTs TINYINTs SMALLINTs BIGINT( R t migrateTableColumnToMySQLR2 R t identityt
autoIncrement( R R( R9 R+ R: R< ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� � s c C s t j | | | | � } | S( N( R t migrateTableForeignKeyToMySQL( R R( t source_fkR+ t target_fk( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� s ( t __name__t
__module__Rq R! R# R= Rv R� R$ R� R� ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR s s c C s d S( Nt Sybase( ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt getTargetDBMSName s c C s t j | | � S( N( t instanceR! ( R R ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR! s c C s t j | | � S( N( R� t migrateCatalog( R( t
sourceCatalog( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� s c C s t j | | | � S( N( R� t
migrateSchema( R( t sourceSchemaR4 ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� s c C s t j | | | � S( N( R� R# ( R( R) t
target_schema( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR# s c C s t j | | | � S( N( R� t migrateTableToMySQL2ndPass( R( R) R+ ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� " s c C s t j | | | � S( N( R� R� ( R( R� R+ ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� ' s c C s t j | | | � S( N( R� t migrateTriggerToMySQL( R( t source_triggert target_table( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� , s c C s t j | | | � S( N( R� t migrateViewToMySQL( R( t source_viewR� ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� 1 s c C s t j | | | � S( N( R� t migrateRoutineToMySQL( R( t source_routineR� ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� 6 s c C s t j | | � S( N( R� R� ( R( R~ ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyR� ; 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( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt getMigrationOptions@ s (+ R t wbR R t db_generic_migration_grtR t workbench.utilsR t
ModuleInfoR R R� t exportt STRINGR� R t GrtLogObjectR! t
db_Catalogt db_migration_MigrationR� t db_SchemaR� t db_TableR# RM R� t db_mysql_ForeignKeyt
db_ForeignKeyR� t db_mysql_Triggert
db_TriggerR� t
db_mysql_Viewt db_ViewR� t db_mysql_Routinet
db_RoutineR� R� t LISTR� R� ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_migration_grt.pyt <module> s( � *099699990