| 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
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 DbSQLiteMigrationt authors Oracle Corp.t versions 1.0t SQLiteMigrationc B s5 e Z d � 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 r�d. } 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( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 _( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyt <lambda>* s t VARBITs LONG VARBITc s
� d | � S( Ns [Bb]?'?[10]+'?( ( t val( R ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 } q�d | j k o d
k n r2| j j d k r)d } q8d } q�d
} nN| d- k rh| j d k r_d } q�d
} n!| d k r}d } n | d k r�d } n� | d. k r�| } d | _ n� | d/ k r�d } n� | d k r�d } n� | d k r�d } n� | d0 k rd
} n� | d k rd } np | d! k r.d" } n[ | d# k rCd# } nF | d$ k rXd$ } n1 | d% k r�d$ } | 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( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 i����R 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 ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyt migrateUpdateForChanges� s c
C s� t t | � j | | | � } | r�xyt | 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 r�d | _ | j d | | d | j j
| j
f � q�q: 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( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyRh � s2 "$$ $c C s� t j | | | | � } | j r� x` | j j D]O } | j j s. d | j _ d | j _ d | j _ | j d | | d � q. q. Wn | S( Ni i R+ su Source table has a PRIMARY KEY allowing NULL values, which is not supported by MySQL. Column was changed to NOT NULL.( R t migrateTablePrimaryKeyToMySQLt
primaryKeyRj t referencedColumnR3 R4 t defaultValueR2 ( R= R> t sourceTableRq t rest icolumn( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyRu � s ( t __name__t
__module__RI Re Rf Rh Ru ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR s
Q [ c C s d S( Nt SQLite( ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyt getTargetDBMSName s c C s t j | | � S( N( t instancet migrateIdentifier( R t log( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR� s c C s t j | | � S( N( R� t migrateCatalog( R> t source_catalog( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR� s c C s t j | | | � S( N( R� t
migrateSchema( R> t sourceSchemaRT ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR� s c C s t j | | | � S( N( R� t migrateTableToMySQL( R> Ry t
target_schema( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR� s c C s t j | | | � S( N( R� t migrateTableToMySQL2ndPass( R> Ry Rq ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyR� s c C s t j | | | � S( N( R� Rh ( R> Rp Rq ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyRh " 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_sqlite_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_sqlite_migration_grt.pyR� , 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_sqlite_migration_grt.pyR� 1 s c C s t j | | � S( N( R� Rf ( R> RB ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyRf 6 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( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyt getMigrationOptions; s
(( R t wbR R_ 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� 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� ( ( ( sP C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_migration_grt.pyt <module> s$ � *099699990