| 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 (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 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 DbSQLiteMigrationt authors Oracle Corp.t versions 1.0t SQLiteMigrationc 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 } n | S| r| j } d | k r@| d2 k r@| j d" | | d# | d$ d% Sd | k rv| d k rv| j d" | | d& | d% S| d k r| j r| j d" | | d' d% Sd" | _ d Sn | j r| j j
n | j j j
}
|
j d( k r| j
d) } n | } x| D]} | | d* k ry | d" | Wn1 t k
rbd% } | j d" | | d+ | q
X| j rx| j j p{d% } | d3 k r
| j d4 k r
| j j | j j | j j f d5 k r| d k rd. } qd% } | j d" | | d1 | | f q
d. } q
qqWn | S(6 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( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_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 _( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt <lambda>* s t VARBITs LONG VARBITc s
d | S( Ns [Bb]?'?[10]+'?( ( t val( R ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR! + s t DATEc s
d | S( Ns (\d{4}|\d{2})-\d{1,2}-\d{1,2}( ( R# ( R ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR! , s t TIMEc s
d | S( Ns" (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2}( ( R# ( R ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR! - s t TIMESTAMPt DATETIMEc s d | j S( NsM ((\d{4}|\d{2})-\d{1,2}-\d{1,2}( (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2})?|NOW\(\))( t upper( R# ( R ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR! . s t BLOBt NULLs X''i s] Default values are not allowed for BLOB columns in MySQL. The default value "%s" was removed.id t s[ Default values are not allowed for TEXT columns in MySQL. The default value %s was removed.s: NULL default value found for not nullable column. Removed!t numerics ' 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 NULLs X''( s TIMESTAMPs DATETIME( s NOW()s CURRENT TIMESTAMPs CURRENT_TIMESTAMPs TIMESTAMP( i i i ( t ownert intt floatR t
simpleTypeR R( t addMigrationLogEntryt isNotNullt defaultValueIsNullt groupt userTypet
actualTypet stript ExceptionR t majorNumbert minorNumbert
releaseNumber(
t selft statet
default_valuet
source_columnt
target_columnt target_catalogt target_default_valuet value_validatorst source_datatypet default_value_upperR5 t value_validatort target_datatype( ( R sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt migrateColumnDefaultValue sn ' $
' 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 | r| j j
} d } | d, k r;d | j k o d k n r d } qd | j k o d
k n r2| j j d k r)d } q8d } qd
} nN| d- k rh| j d k r_d } qd
} n!| d k r}d } n | d k rd } n | d. k r| } d | _ n | d/ k rd } n | d k rd } n | d k rd } n | d0 k rd
} n | d k rd } np | d! k r.d" } n[ | d# k rCd# } nF | d$ k rXd$ } n1 | d% k rd$ } | j d | | d& n | } | j | r| | | _ 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(1 Nc s s$ | ] } | j j | f Vq d S( N( R R( ( t .0t datatype( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pys <genexpr>r s s enum(t ENUMi R+ R R i i i i t
MEDIUMTEXTt LONGTEXTR R t BITR R t INTR R iR R R R s DOUBLE PRECISIONR t CLOBR R) t LONGBLOBR& R' R$ R% t DATETIMEOFFSETs6 Source column type DATETIMEOFFSET was migrated to TIMEs! SQLite 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 NVARCHAR( s CHARs NCHAR( s SMALLINTs INTs BIGINT( s DECIMALs NUMERIC( s CLOBs TEXT( t
targetCatalogt dictt simpleDatatypesR1 R6 R7 t
sqlDefinitiont
startswitht datatypeExplicitParamsR t flagst extendR R( t lengthR R: t precisionR2 t has_keyt grtt log_warningR. t Falset formattedRawType( R= R> R@ RA RT t mysql_simpleTypest source_typeRE RH ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt migrateDatatypeForColumno s
c C s | S( s]
Create datatype cast expression for target column based on source datatype.
( ( R= R> RB ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_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 zipt columnst referencedColumnsR1 R\ R2 R. R t
formattedTypet
customDataR3 t
updateRulet
deleteRule( R= R> t source_fkt targetTablet target_fkt columnt referenced_column( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyRh s2 "$$ $( t __name__t
__module__RI Re Rf Rh ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR s Q [ c C s d S( Nt SQLite( ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instancet migrateIdentifier( R t log( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyRz s c C s t j | | S( N( Ry t migrateCatalog( R> t source_catalog( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR| s c C s t j | | | S( N( Ry t
migrateSchema( R> t sourceSchemaRT ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR~ s c C s t j | | | S( N( Ry t migrateTableToMySQL( R> t sourceTablet
target_schema( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR s c C s t j | | | S( N( Ry t migrateTableToMySQL2ndPass( R> R Rq ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR
s c C s t j | | | S( N( Ry Rh ( R> Rp Rq ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyRh s c C s t j | | | S( N( Ry t migrateTriggerToMySQL( R> t source_triggert target_table( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR s c C s t j | | | S( N( Ry t migrateViewToMySQL( R> t source_viewR ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR s c C s t j | | | S( N( Ry t migrateRoutineToMySQL( R> t source_routineR ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyR s c C s t j | | S( N( Ry Rf ( R> RB ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyRf # s c C sY t j t j t j j j } t j j } d | _ d | _ d | _ | j | | S( Ns! sqlite:migrateTimestampAsDatetimese Migrate TIMESTAMP values as DATETIME by default. TIMESTAMP values in MySQL have a limited time range.t boolean(
R_ t Listt OBJECTt classest db_migration_MigrationParametert __grtclassname__R t captiont paramTypet append( R> t listt param( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt getMigrationOptions( s
(( R t wbR R_ t db_generic_migration_grtR t
ModuleInfoR Ry t exportt STRINGRx R t GrtLogObjectRz t
db_Catalogt db_migration_MigrationR| t db_SchemaR~ t db_TableR RP R t db_mysql_ForeignKeyt
db_ForeignKeyRh t db_mysql_Triggert
db_TriggerR t
db_mysql_Viewt db_ViewR t db_mysql_Routinet
db_RoutineR Rf t LISTR R ( ( ( sV C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_sqlite_migration_grt.pyt <module> s$ *099699990