| 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/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
2zXc @ 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 DbMsAccessMigrationt authors Oracle Corp.t versions 1.0t MSAccessMigrationc B s, e Z d Z d Z d Z d Z RS( c sb | 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^| } x| D]}
| |
d! k rQy |
d" | Wn1 t
k
rd# } | j d" | | d$ | qWX| j r| j j pd# } | d+ k rW| j d, k rW| j
j | j
j | j
j f d- k rK| d k r"d' } qQd# } | j d" | | d* | | f qTd' } qWqQqQWn | 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( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_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 _( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt <lambda>* s t VARBITs LONG VARBITc s
d | S( Ns [Bb]?'?[10]+'?( ( t val( R ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR! + s t DATEc s
d | S( Ns (\d{4}|\d{2})-\d{1,2}-\d{1,2}( ( R# ( R ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR! , s t TIMEc s
d | S( Ns" (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2}( ( R# ( R ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_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 ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR! . s t numerics ' i i t 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 TIMESTAMPs DATETIME( s NOW()s CURRENT TIMESTAMPs CURRENT_TIMESTAMPs TIMESTAMP( i i i ( t ownert intt floatR t
simpleTypeR t groupt userTypet
actualTypet stript Exceptiont addMigrationLogEntryR( R t majorNumbert minorNumbert
releaseNumber( t selft statet
default_valuet
source_columnt
target_columnt target_catalogt target_default_valuet value_validatorst source_datatypeR0 t value_validatort target_datatype( ( R sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt migrateColumnDefaultValue sJ ' $
' c C s | j } t d | j D } | j } | r| j j } d } | d k rg d } | j | _ n| d k s | d k r d } n| d k r d } n| d k r`d } t } x7 | j j D]) }
|
| k r t
} Pq |
j r Pq q W| rTt } xA | j j D]3 } x* | j D] }
|
j
| k rt
} PqqWqW| r]d | _ d | _ q]qTn | d k rud
} n | d k rd
} | j j d n | d
k rd } n | d k s| d k rd } n | d k s| d k rd } nc | d k rd } nN | d k rd } n9 | d k r0d } n$ | d k rNd } d | _ n | } | j | rs| | | _ nJ t j d d | | 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( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pys <genexpr>Y s R* R R t INTR t COUNTERi t BITR t BYTEt UNSIGNEDt SINGLER R R t CURRENCYR R t BLOBt
LONGBINARYt LONGBLOBt LONGCHARt LONGTEXTR' is# MSAccess 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)( t
targetCatalogt dictt simpleDatatypesR/ R R( t lengtht FalseR, t columnsR t
autoIncrementt indicest referencedColumnt isNotNullt flagst appendt precisiont has_keyt grtt log_warningR5 t formattedRawType( R9 R: R< R= RS t mysql_simpleTypest source_typeRA RC t flagt colt
is_indexedt idxt c( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt migrateDatatypeForColumnV s c C s | S( s]
Create datatype cast expression for target column based on source datatype.
( ( R9 R: R> ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_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 zipRX t referencedColumnsR/ RV R5 R, R t
formattedTypet
customDataR\ t
updateRulet
deleteRule( R9 R: t source_fkt targetTablet target_fkt columnt referenced_column( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyRn s2 "$$ $( t __name__t
__module__RD Rk Rl Rn ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s 8 Q c C s d S( Nt MsAccess( ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instancet migrateIdentifier( R t log( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | S( N( R~ t migrateCatalog( R: t source_catalog( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ t
migrateSchema( R: t sourceSchemaRS ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ t migrateTableToMySQL( R: t sourceTablet
target_schema( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ t migrateTableToMySQL2ndPass( R: R Rv ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ Rn ( R: Ru Rv ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyRn s c C s t j | | | S( N( R~ t migrateTriggerToMySQL( R: t source_triggert target_table( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ t migrateViewToMySQL( R: t source_viewR ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | | S( N( R~ t migrateRoutineToMySQL( R: t source_routineR ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyR s c C s t j | | S( N( R~ Rl ( R: R> ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyRl s c C s" t j t j t j j j } | S( N( Ra t Listt OBJECTt classest db_migration_MigrationParametert __grtclassname__( R: t list( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt getMigrationOptions s (( R t wbR Ra 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 RG 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 ( ( ( sR C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_migration_grt.pyt <module> s$ *099699990