| 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 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 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 find_object_with_name( t Sql92Migration( t GenericMigrationt namet DbPostgresqlMigrationt authors Oracle Corp.t versions 1.0t PostgresqlMigrationc B s, e Z d � Z d � Z d � Z d � Z RS( c
s� | j } | j } | j j j } | } d � � d d d g t f d d d d d g t f 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 g � f d � f d g � f d � f g } t j d � }
d } | j r3| j j } | r3|
j | � } | r| j r| j j j d k rt
| j | j d � � }
|
r| j r�t
d � | j j D� � n t
� } | j | k r�y t |
j � } Wn t k
r�n X| d k r�|
j | j _ n d | _ n d! Sn | j j j d k r0| j d" � } q0q3n | r�d# | k r^| j d# d � d$ } n | } xP| D]E} | | d$ k rky | d | � Wn1 t k
r�d! } | j d | | d% | � q�X| j r�| j j p�d! } | d k r'| j � } | d& k rd' } q�| d( k r�d) } q�q�| d k r�| j � d* k r�| j j | j j | j j f d/ k r�| d k r�d- } q�d! } | j d | | d. | � q�d- } q�qkqkWn | S(0 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( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt raise_on_no_match' s t SMALLINTt INTt BIGINTt NUMERICt DECIMALt FLOATt REALs DOUBLE PRECISIONt CHARt VARCHARt NCHARt NVARCHARt BLOBt CLOBt XMLc S s t S( N( R
( t _( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt <lambda>/ s t BITs BIT VARYINGc s
� d | � S( Ns [Bb]?'?[10]+'?( ( t val( R ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR 0 s t DATEc s
� d | � S( Ns (\d{4}|\d{2})-\d{1,2}-\d{1,2}( ( R" ( R ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR 1 s t TIMEc s
� d | � S( Ns" (\d{1,2} )?\d{1,2}:\d{0,2}:\d{0,2}( ( R" ( R ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR 2 s t TIMESTAMPc 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 ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR 3 s t BOOLEANc s � d | j � � S( Ns (TRUE|FALSE|NULL)( R& ( R" ( R ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR 5 s s nextval[(]'(.*?)'::regclass[)]t numerici c s s | ] } | j j Vq d S( N( t referencedColumnR ( t .0t column( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pys <genexpr>B s t s ' s ::i s+ Default value %s is not supported. Removed!t TRUEt 1t FALSEt 0s NOW()i i t CURRENT_TIMESTAMPsM Default value now() is not supported for a MySQL column of type "%s".Removed!( i i i ( t ownert intt floatR t compileR t
simpleTypeR R
t groupR t sequencest
primaryKeyt sett columnst
startValueR t nextAutoInct
autoIncrementt stript splitt Exceptiont addMigrationLogEntryR& R t majorNumbert minorNumbert
releaseNumber( t selft statet
default_valuet
source_columnt
target_columnt source_tablet
source_schemat target_catalogt target_default_valuet value_validatorst seq_regext source_datatypeR
t seqt pk_colst startt value_validatort target_datatypeR" ( ( R sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt migrateColumnDefaultValue s| ! $.
' c C sY | 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 } nz| d
k rh| j d k r_d
} q�d } nM| dE k r�| } d | _ n/| d k r�d } d | _ n| d k r�d } d | _ n�| d k r�d } d | _ n�| dF k r�d } n�| d k r d } d | _ d | _ n�| d k r1d } n�| d k rFd } no| d k r[d! } nZ| d" k rpd } nE| d# k r�d$ } n0| d% k r�d% } n| d& k r�d& } n| d' k r�d& } | j d | | d( � n� | dG k r�d) } n� | d+ k r
d, } d | _ n� | d- k r+d } d. | _ n� | d/ k rId } d. | _ nl | d0 k rgd } d1 | _ nN | d2 k r�d } d3 | _ n0 | dH k r�d } n | dI k r�d } n | } | j | � r�| | | _ nJ t j dA dB | | f � | j d | | dC | j | j j | f � t St S| j d | | dD | j | j j | j f � t St S(J Nc s s$ | ] } | j j � | f Vq d S( N( R R& ( R* t datatype( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pys <genexpr>z s s enum(t ENUMi R, R i i i i t
MEDIUMTEXTt LONGTEXTR R R R i����t SMALLSERIALi t SERIALt INTEGERt BIGSERIALR R t MONEYi i R R s DOUBLE PRECISIONt DOUBLEt BYTEAt LONGBLOBt TEXTR% t DATETIMER# R$ t INTERVALs0 Source column type INTERVAL was migrated to TIMER! s BIT VARYINGR' t TINYINTt CIDRi+ t INETt MACADDRi t UUIDi$ R t JSONt TSVECTORt TSQUERYt ARRAYt POINTt LINEt LSEGt BOXt PATHt POLYGONt CIRCLEt
TXID_SNAPSHOTs% PostgreSQL migrateTableColumnsToMySQLs# Can't find datatype %s for type %s
s< Could not migrate column "%s" in "%s": Unknown datatype "%s"s2 Could not migrate type of column "%s" in "%s" (%s)( s SMALLINTs INTs BIGINT( s DECIMALs NUMERIC( s BITs BIT VARYING( s XMLRl Rm Rn Ro ( Rp Rq Rr Rs s PATHs POLYGONRv Rw ( t
targetCatalogt dictt simpleDatatypesR6 t userTypet
actualTypet
sqlDefinitiont
startswitht datatypeExplicitParamsR
t flagst extendR R& t lengthR RC t precisionR> t scaleRB t has_keyt grtt log_warningR2 t Falset formattedRawType( RF RG RI RJ Rx t mysql_simpleTypest source_typeRQ RV ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt migrateDatatypeForColumnw 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 | 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.
R' s CASE WHEN ? THEN 1 ELSE 0 ENDs %s as ?s columnTypeCastExpression:%sN(
t schematat tablesR; R t lookupSourceObjectR t getColumnDataTypeR2 t
customDataR ( RF RG RM t targetSchemat targetTableRJ t type_cast_expressionRQ RI ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_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 zipR; t referencedColumnsR6 R� RB R2 R t
formattedTypeR� t isNotNullt
updateRulet
deleteRule( RF RG t source_fkR� t target_fkR+ t referenced_column( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� s2 "$$ $( t __name__t
__module__RW R� R� R� ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR s W z c C s d S( Nt
Postgresql( ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt getTargetDBMSName* s c C s t j | | � S( N( t instancet migrateIdentifier( R t log( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� . s c C s t j | | � S( N( R� t migrateCatalog( RG t source_catalog( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� 3 s c C s t j | | | � S( N( R� t
migrateSchema( RG t sourceSchemaRx ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� 8 s c C s t j | | | � S( N( R� t migrateTableToMySQL( RG t sourceTablet
target_schema( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� = s c C s t j | | | � S( N( R� t migrateTableToMySQL2ndPass( RG R� R� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� B s c C s t j | | | � S( N( R� R� ( RG R� R� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� G s c C s t j | | | � S( N( R� t migrateTriggerToMySQL( RG t source_triggert target_table( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� L s c C s t j | | | � S( N( R� t migrateViewToMySQL( RG t source_viewR� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� Q s c C s t j | | | � S( N( R� t migrateRoutineToMySQL( RG t source_routineR� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� V s c C s t j | | � S( N( R� R� ( RG RM ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyR� [ s c C sY t j t j t j j j � } t j j � } d | _ d | _ d | _ | j | � | S( Ns% postgresql: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( RG t listt param( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt getMigrationOptions` s
(, R t wbR t workbench.utilsR R� t db_sql92_migration_grtR 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� R 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� ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_postgresql_migration_grt.pyt <module> s* �
*099699990