| 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 Z d d l Z d d l Z d d l m Z d e f d � � YZ d e f d � � YZ d e f d � � YZ
d e f d
� � YZ d S( i����N( t log_debugt NotSupportedErrorc B s e Z RS( ( t __name__t
__module__( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR s t MigrationTargetc B s� e Z d � Z d � Z d � Z e e e � Z d � Z d � Z e e e � Z d � Z
e e
� Z d � Z d � Z
d � Z d � Z d
� Z d � Z d � Z d
� Z d � Z d � Z RS( c C s, | | _ d | _ d | _ | j | � d S( N( t statet Nonet _rdbmst passwordt _set_connection( t selfR t
connection( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt __init__ s c C s | j S( N( R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt
_get_rdbms& s c C s2 | j d k r% t d | j � � n | | _ d S( Nt Mysqls Unsupported target RDBMS "%s"( t namet
ValueErrorR ( R
t rdbms( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt
_set_rdbms( s c C s
| j j S( N( R t
targetCatalog( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _get_catalog/ s c C s | | j _ d S( N( R R ( R
t catalog( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _set_catalog1 s c C s
| j j S( N( R t targetConnection( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _get_connection6 s c C sE | j s | j j r& t d � � n | | j _ | j j | _ d S( Ns Invalid connection object( t drivert ownerR R R R ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR ; s c C s& | j � j | j | j p d � t S( Nt ( t module_fet connectR R t True( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt checkConnectionA s "c C s� | j � j | j � | j _ t j j � | j _ | j j j | j j _ | j j j
| j j _
| j j j | j j _ | j j j | j j _ d S( N(
R t getServerVersionR R t targetDBVersiont grtt classest
GrtVersiont
targetVersionR t majorNumbert minorNumbert
releaseNumber( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt checkVersionE s c C sF | j j j d k r$ t d � � n t j j j | j | j pB d � S( Nt MysqlNativeSSHsh MySQL connections through SSH are not supported in this version of the MySQL Workbench Migration Wizard.R ( R R R R R" t modulest DbMySQLFER R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR N s c C s t j j j | j � S( N( R" R+ R, t
disconnectR ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR- T s c C s
t j j S( N( R" R+ R, ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR W s c C s
t j j S( N( R" R+ t DbMySQLRE( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt module_reZ s c C s
t j j S( N( R" R+ t DbMySQLMigration( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt module_migration] s c C s
t j j S( N( R" R+ t DbMySQL( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt module_db` s c C s6 | j � r2 | j � j | j � } | j � | Sd S( N( R R t getOSR R- R ( R
t os_name( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt get_osc s
( R R R R
R t propertyR R R R R R R R R) R R- R R/ R1 R3 R6 ( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR s& t MigrationSourcec B s� e Z d � Z d � Z d � Z e e e � Z d � Z e e � Z d � Z d � Z
e e e
� Z d � Z d � Z
e e e
� Z d � Z d � Z e e e � Z d
� Z d � Z e e e � Z d � Z d
� Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e d � � Z d � Z g d � Z e d � � Z! d � Z" d � Z# d � Z$ d � Z% d � Z& d � Z' d � Z( d � Z) d! � Z* d" � Z+ d# � Z, d$ � Z- RS(% c C sY | | _ d | _ d | _ d | _ d | _ d | _ d | _ d | _ | j | � d S( N(
R R R t _rev_eng_modulet _migration_modulet
_db_modulet
_catalog_nameR t migrationR ( R
R R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR n s c C s | j S( N( R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR
{ s c C sF | | _ d | _ d | _ d | _ x� t t j � D]� } t t j | � } t | d � s4 | j
� | j k rw q4 n | j } | j
d � r� t | d � r� | | _ n | j
d � r� t | d � r� | | _ n | j
d � r4 t | d � r4 | | _ q4 q4 W| j s | j s | j r6t d | j � � n | j | _ d S( Nt getTargetDBMSNamet Dbt reverseEngineert migrateCatalogt fullyQualifiedObjectNames Source RDBMS "%s" not supported( R R R9 R; R: t dirR" R+ t getattrt hasattrR> R R t
startswithR R= ( R
R t mnamet modR ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR } s$ % c C s
| j j S( N( R t
sourceCatalog( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � s c C s
| j j S( N( R t sourceConnection( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � s c C sI | j s | j j r& t d � � n | | j _ | j | j j � d S( Ns Invalid connection object( R R R R RJ R ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � s c C s
| j j S( N( R t selectedSchemataNames( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _get_selected_schemata� s c C s8 | j j j � x! | D] } | j j j | � q Wd S( N( R RK t
remove_allt append( R
t namesR ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _set_selected_schemata� s
c C s
| | _ d S( N( R< ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _set_selected_catalog� s c C s | j S( N( R< ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _get_selected_catalog� s c C s
| j j S( N( R t
ignoreList( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _get_ignore_list� s c C s | | j _ d S( N( R RS ( R
t ilist( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt _set_ignore_list� s c C s_ | j j j j d k r< | j j j d k r< t d � � n | j j | j | j pW d � t S( NR R* sh MySQL connections through SSH are not supported in this version of the MySQL Workbench Migration Wizard.R ( R R R R R R9 R R R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � s - c C s | j j | j � S( N( R9 R- R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR- � s c C s" | j � j | j � | j _ d S( N( R/ R R R t sourceDBVersion( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR) � s c C s | j j | j � S( N( R9 t getCatalogNamesR ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyRX � s c C s | j j | j | p d � S( NR ( R9 t getSchemaNamesR ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyRY � s c C s | j j | j | p d | � S( NR ( R9 t
getTableNamesR ( R
R t schema( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyRZ � s c C s | j S( N( R9 ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR/ � s c C s | j S( N( R: ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR1 � s c C s | j S( N( R; ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR3 � s c C s
| j j S( N( R t sourceSchemataNames( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt schemaNames� s c C s) t | j d � r% | j j | j � Sd S( Nt getDriverDBMSNameR ( RE R9 R^ R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR^ � s c
C s t j d d � | j � | j j d k r�t j d d � | j j j � | j � } | r� t | � j
| � } | r� t j d d j t
| � � � n t
t | � j
| � � p� | j � } n | | _ t j d d � d } d t | � d
} x�| D]� } | sq n t j | d | � | j | � } xO | D]G } | sNq<n | j j j d | j j | � | j j | � f � q<W| d
| 7} q WnV| j j d k r�t j d d � | j d � } | r>t | � j
| � } | rt j d d j t
| � � � n t
t | � j
| � � p8| j d � } n g | _ | j j j � x� | D]; } | j j j d | j j d � | j j | � f � q^WnR g | _ | j j j � x6 | j d � D]% } | j j j | j j | � � q�Wt j d d � d S( sm Fetch list of schema names in catalog.schema format and stores them in the migration.sourceSchemataNames nodeg s Checking connection...i g�������?s Fetching catalog names...s' The following catalogs were not found: s , s Fetching schema names...g �?g�����|�=s Fetching schema names from %s...s %s.%sg�������?R s' The following schemas where not found: t deft FinishedN( R" t
send_progressR R t doesSupportCatalogsR R\ RM RX t sett
differencet send_warningt joint listt _catalog_namest lenRY RN R; t quoteIdentifier(
R
t only_these_catalogst
catalog_namest inexistent_catalogst accumulated_progresst step_progress_shareR t schema_namesR[ t inexistent_schemata( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt doFetchSchemaNames� sT
#*
9#-
< #c C s� t | j d � r* t | j j � � } n d d d d d d d g } | d } xn | d D]b } | d } xO | j j D]A } t | | t � } | rw t | � d k rw | j | � Pqw qw WqZ W| S( Nt getSupportedObjectTypest tabless db.Tablet Tablest viewss db.Viewt Viewst routiness
db.Routinet Routinest
routineGroupss db.RoutineGroups Routine Groupst synonymss
db.Synonymt Synonymst structuredTypess db.StructuredTypes Structured Typest sequencess db.Sequencet Sequencesi i ( Rt s db.TableRu ( Rv s db.ViewRw ( Rx s
db.RoutineRy ( Rz s db.RoutineGroups Routine Groups( R{ s
db.SynonymR| ( R} s db.StructuredTypes Structured Types( R~ s db.SequenceR (
RE R9 Rg Rs R t schemataRD t FalseRi RN ( R
t allTypest supportedt itemt tR[ t objects( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt supportedObjectTypes" s$
c C s[ g } xN | j j D]@ } t | | � } x( | D] } | j d | j | j � q/ Wq W| S( Ns %s.%s( R R� RD RN R ( R
t otypet lR[ R� t obj( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt allObjectsOfType9 s
"c C sR g } xE | j D]: } | j d � \ } } } | | k r | j | � q q W| S( Nt :( RS t splitRN ( R
R� R� t ignore_specR� t sepR� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt availableObjectsOfTypeA s c C s� g } x| | j j D]n } t | | � } xV | D]N } d | | j | j f } | | j k r/ | j d | j | j f � q/ q/ Wq W| S( Ns %s:%s.%ss %s.%s( R R� RD R RS RN ( R
R� R� R[ R� R� R� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt selectedObjectsOfTypeI s
(c C s| xJ t t t | j � � � D]- } | j | j | d � r | j | =q q Wx( | D] } | j j d | | f � qT Wd S( NR� s %s:%s( t reversedt rangeRi RS RF RN ( R
R� t iglistt iR� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt setIgnoredObjectsOfTypeT s
"
c C sn xJ t t t | j � � � D]- } | j | j | d � r | j | =q q W| rj | j j d | � n d S( NR� s %s:*( R� R� Ri RS RF RN ( R
R� t flagR� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt setIgnoreObjectType\ s
"c C s d | | j k S( Ns %s:*( RS ( R
R� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt isObjectTypeIgnoredd s c C s@ d | | j k s8 d | | j j | j f | j k r< t St S( Ns %s:*s %s:%s.%s( RS R R R R� ( R
R� R� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt isObjectIgnoredg s 8c C sd | j � t j d d j | j � | j f � | j j | j | j | j | j j
� | j _ d S( sU Perform reverse engineering of selected schemas into the migration.sourceCatalog nodes Reverse engineering %s from %ss , N( R R" t send_infoRf RK t selectedCatalogNameR9 R@ R R t applicationDataRI ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR@ l s
&c C s, t | j d � r( | j j | j � n d S( Nt resetProgressFlags( RE R9 R� R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR� s s c C s& t | j d � r" | j j � n d S( Nt cleanup( RE R9 R� ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR� w s c C s3 t | j � d � r+ | j � j | j � Sd Sd S( NR4 ( RE R/ R4 R R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR6 { s c C s | j � j | j � S( N( R/ t getSourceInstanceR ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt get_source_instance� s (. R R R R
R R7 R R R R R R RL RP RK RQ RR R� RT RV RS R R- R) RX RY RZ R/ R1 R3 R] R^ Rr R� R� R� R� R� R� R� R� R@ R� R� R6 R� ( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR8 m sV
0 t
MigrationPlanc B s� e Z d � Z d � Z e d � � Z e d � � Z e d � � Z d � Z d � Z e
d � � Z e
d � � Z d � Z
d
� Z d � Z d � Z d
� Z RS( c C s� t j j j � t j j j | _ | j st j j � | _ t j j | j _
| j t j j _ t j j
� j � } | d } t j j | � r� | j j j t j | � � qt j j
� j d � } | d 7} t j j | � r| j j j t j | � � qn d | _ d | _ t j d k rFt j j
� j d � | _ n� t j d k rst j j
� j d � | _ n� t j j
� j d � | _ t j j | j � s�t j j t j j t j j j j � d � | _ n t j j | j � s�d | _ n d t j k r�t j j
� j d � | _! t j j | j! � sit j j t j j t j j j j � d � | _! n t j j | j! � s�d | _! q�n | j | _! t" | j � t# k r�| j j$ d
� | _ n t" | j! � t# k r�| j! j$ d
� | _! n d S( Ns /migration_generic_typemap.xmlR s+ /modules/data/migration_generic_typemap.xmlt win32s wbcopytables.exet darwint wbcopytabless wbcopytables-bint linuxs UTF-8(% R" R+ t Workbencht initializeOtherRDBMSt roott wbR= R R# t db_migration_MigrationR t mformst Appt gett get_user_data_foldert ost patht existst genericDatatypeMappingst extendt unserializet get_resource_pathR t migrationSourcet migrationTargett syst platformt get_executable_patht wbcopytables_path_binRf t dirnamet registryt appExecutablePatht wbcopytables_patht typet unicodet encode( R
t datadirR� t global_path( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � sH
" 3 3 c C sS | j r | j j � n d | j _ d t j j _ d | _ d | _ d | _ d S( N(
R� R� R R R R" R� R� R= R� ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt close� s c C sW d } d } d } x� t t j � D]� } t t j | � } t | d � s" | j � | j k re q" n | j } | j d � r� t | d � r� | } n | j d � r� t | d � r� | } n | j d � r" t | d � r" | } q" q" W| st j
d d | j � n | s't j
d d | j � n | sGt j
d d | j � n | oV| oV| S(
NR> R? R@ RA RB t MigrationsG RDBMS %s cannot be a migration source because it's missing a RE module
sN RDBMS %s cannot be a migration source because it's missing a Migration module
sS RDBMS %s cannot be a migration source because it's missing a Db information module
( R RC R" R+ RD RE R> R R RF t
log_debug2( R t rev_eng_modulet migration_modulet db_moduleRG RH R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt is_rdbms_migratable� s* %
c C sF g } x9 t j j j j D]% } t j | � r | j | � q q W| S( N( R" R� R� t rdbmsMgmtR R� R� RN ( t sourcesR ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt supportedSources� s
c C s t j j j j d S( Ni ( R" R� R� R� R ( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt supportedTargets� s c C s1 | j r | | j _ n t | j | � | _ d S( N( R� R R8 R ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt setSourceConnection� s c C s+ t | j | � | _ | j j | j _ d S( N( R R R� R R R ( R
R ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt setTargetConnection� s c C s
| j j S( N( R R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR � s c C s
| j j S( N( R RI ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyRI � s c C sA | j j j � | j j j | j | j j � | j _ i } | S( N( R t migrationLogRM R� R= RA R R� ( R
t report( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt migrate� s 'c C s< t j j j | j j | j j | j j � i d d 6} | S( Ni R� ( R" R+ R, t generateSQLCreateStatementsR� R R R% t objectCreationParams( R
R� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt generateSQL s +
c C s) t j j j | | j j | j j � d S( N( R" R+ R, t createScriptForCatalogObjectsR� R R R� ( R
R� ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt createTargetScript s c C sD | j j j � t j j j | j j | j j | j j
| j j � S( N( R t creationLogRM R" R+ R, t createCatalogObjectsR� R R R� ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt createTarget s c C sZ t | j j d � r? | j j j | j | j j � | j _ n t d | j j j � d S( Nt migrateUpdateForChangess> migrateUpdateForChanges method call was skipped for module %s
( RE R� R= R� R R� R R R ( R
( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt migrationUpdate s *( R R R R� t staticmethodR� R� R� R� R� R7 R RI R� R� R� R� R� ( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyR� � s /
( R� R� R" R� t
workbench.logR t ExceptionR t objectR R8 R� ( ( ( sB C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.pyt <module> s O�