| 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 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( iN( 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 ii 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 } qd | j
k o d k n r | j j d k r d
} q d } qd } n| d8 k r(| j
d k r d } qd } n| d9 k rFd } d | _
n| d: k rd| } d | _
nr| d k r| } d | _
d | j k r| j j d qn2| d k rd } 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 rd n d" } d | _
nD| d< k rd } | j j | _
| j j | _ n| d% k rd& } d | _
n | d= k r]d | j
k o d k n r,| d% k r#d) } qZ| } qd | j
k oFd k n rTd* } qd& } ny | d> k rrd+ } nd | d- k rd- } nO | d. k rd. } n: | d/ k rd } 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 UNITEXTit 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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< ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR s ( t __name__t
__module__Rq R! R# R= Rv R R$ R R ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR s s c C s d S( Nt Sybase( ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instanceR! ( R R ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR! s c C s t j | | S( N( R t migrateCatalog( R( t
sourceCatalog( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR s c C s t j | | | S( N( R t
migrateSchema( R( t sourceSchemaR4 ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR s c C s t j | | | S( N( R R# ( R( R) t
target_schema( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR# s c C s t j | | | S( N( R t migrateTableToMySQL2ndPass( R( R) R+ ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR " s c C s t j | | | S( N( R R ( R( R R+ ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR ' s c C s t j | | | S( N( R t migrateTriggerToMySQL( R( t source_triggert target_table( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR , s c C s t j | | | S( N( R t migrateViewToMySQL( R( t source_viewR ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR 1 s c C s t j | | | S( N( R t migrateRoutineToMySQL( R( t source_routineR ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyR 6 s c C s t j | | S( N( R R ( R( R~ ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sybase_migration_grt.pyt <module> s( *099699990