| 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 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( iN( 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 rt
d | j j D n t
} | j | k ry t |
j } Wn t k
rn X| d k r|
j | j _ n d | _ n d! Sn | j j j d k r0| j d" } q0q3n | rd# | k r^| j d# d d$ } n | } xP| D]E} | | d$ k rky | d | Wn1 t k
rd! } | j d | | d% | qX| j r| j j pd! } | d k r'| j } | d& k rd' } q| d( k rd) } qq| d k r| j d* k r| j j | j j | j j f d/ k r| d k rd- } qd! } | j d | | d. | qd- } qqkqkWn | 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( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 _( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyt <lambda>/ s t BITs BIT VARYINGc s
d | S( Ns [Bb]?'?[10]+'?( ( t val( R ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR 3 s t BOOLEANc s d | j S( Ns (TRUE|FALSE|NULL)( R& ( R" ( R ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 } qd | j k o d k n r2| j j d
k r)d } q8d } qd } nz| d
k rh| j d k r_d
} qd } nM| dE k r| } d | _ n/| d k rd } d | _ n| d k rd } d | _ n| d k rd } d | _ n| dF k rd } 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 rd$ } n0| d% k rd% } n| d& k rd& } n| d' k rd& } | j d | | d( n | dG k rd) } 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 rd } d3 | _ n0 | dH k rd } n | dI k rd } 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( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 it 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 ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_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 zipR; t referencedColumnsR6 R RB R2 R t
formattedTypeR t isNotNullt
updateRulet
deleteRule( RF RG t source_fkR t target_fkR+ t referenced_column( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR s2 "$$ $( t __name__t
__module__RW R R R ( ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR s W z c C s d S( Nt
Postgresql( ( ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyt getTargetDBMSName* s c C s t j | | S( N( t instancet migrateIdentifier( R t log( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR . s c C s t j | | S( N( R t migrateCatalog( RG t source_catalog( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR 3 s c C s t j | | | S( N( R t
migrateSchema( RG t sourceSchemaRx ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR 8 s c C s t j | | | S( N( R t migrateTableToMySQL( RG t sourceTablet
target_schema( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR = s c C s t j | | | S( N( R t migrateTableToMySQL2ndPass( RG R R ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR B s c C s t j | | | S( N( R R ( RG R R ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR L s c C s t j | | | S( N( R t migrateViewToMySQL( RG t source_viewR ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR Q s c C s t j | | | S( N( R t migrateRoutineToMySQL( RG t source_routineR ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyR V s c C s t j | | S( N( R R ( RG RM ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( ( ( sZ C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_postgresql_migration_grt.pyt <module> s*
*099699990