| 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 m Z d d l Z d d l m Z d d l m Z d d l m Z e d d d d d
d � Z d � Z
e j e j e j
j e j
j e j � d
� � Z e j e j e j
j e j � d � � Z e j e j e j
j e j � d � � Z i Z d � Z e j e j e j
j e j � d � � Z e j e j e j
j � d � � Z e j e j e j
j � d � � Z d � Z e j e j e j
j � d � � Z e j e j e j
j e j � d � � Z e j e j e j e j
j e j � d � � Z e j e j e j
j e j
j e j e j e j
j! f � d � � Z" e j e j
j e j
j � d � � Z# e j e j e j
j � d � � Z$ d S( i����( t DefineModuleN( t db_utils( t NotConnectedError( t Versiont namet DbMySQLFEt authors Oracle Corp.t versions 1.0c
sb d � � d d � f d � } x=| j D]2} | | | j | j d � | j | j d � � x| | j D]q } | | | j | j d � � xL | j D]A } | j | j d � } | r� d | } n | | | d d �q� Wqf Wx- | j D]" } | | | j | j d � � q� WxL | j D]A } | j | j d � } | rCd | } n | | | d d �qWq( Wd S( Nc S s, | j r( d d j | j d � � } n | S( Ns -- s
-- s
( t commentedOutt joint split( t objt sql( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt comment_out s t ;c s� | r | | d | } n | j j d t � rn | r� � | | � | j d <| � | | � k | j d <q� nZ | j j d � r� | j d =| j d =n | d k r� � | | � | _ n d | j | _ d S( Ns
s migration:lock_temp_sqls migration:new_temp_sqls migration:temp_sql_changeds! -- no script was generated for %s( t
customDatat gett Falset has_keyt Nonet temp_sqlR ( R R t drop_sqlt delim( R
( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt apply_script$ s "
s
DELIMITER $$
R s $$( R t schemataR t __id__t tablest triggerst viewst routines(
t catalogt create_scriptst drop_scriptsR t schemat tablet triggerR t viewt routine( ( R
sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt apply_scripts_to_catalog s$ .
c C s
t j � } | j | � d | d <d | d <| r^ t j j j | j | j | j � | d <n t j j j t j
j � | | � } | j d t
� r� i } n$ t j j j | t j
j � | � } t | | | � t | | � } | | j d <t | | � } | | j d <d S( Ni t GenerateWarningst UseOIDAsResultDictKeyt
DBSettingst KeepSchematas migration:preambles migration:postamblei ( t grtt Dictt updatet modulest DbMySQLt getTraitsForServerVersiont majorNumbert minorNumbert
releaseNumbert generateSQLForDifferencest classest db_mysql_CatalogR R R& t getSchemaCreatePreambleR t getSchemaCreatePostamble( R t
targetVersiont objectCreationParamst optionsR R t preamblet postamble( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt generateSQLCreateStatementsF s
+$ $
c C s1 t j j � } d | _ d | _ | j | _ | S( Nt Preambles SET FOREIGN_KEY_CHECKS = 0;( R+ R5 t db_DatabaseDdlObjectR t
sqlDefinitionR ( R R: R ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyR7 c s
c C s1 t j j � } d | _ d | _ | j | _ | S( Nt Postambles SET FOREIGN_KEY_CHECKS = 1;( R+ R5 R@ R RA R ( R R: R ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyR8 k s
c C s4 t j | j � r t | j St d | j � � d S( Ns No open connection to %s( t _connectionsR R R t hostIdentifier( t connection_object( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt get_connectionu s c C s� yg t | � } y | j � WnF t k
re t j d | j � | j � | j � t j d � n XWn^ t k
r� t j
| d | �} t j d | j � | j � t j d � | t | j <n Xd S( Ns Reconnecting to %s...s Connection reestablishedt passwords Connecting to %s...t Connectedi (
RF t pingt ExceptionR+ t send_infoRD t
disconnectt connectR R t MySQLConnectionRC R ( t
connectionRG t con( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyRM | s
c C s4 t j | j � r0 t | j j � t | j =n d S( Ni ( RC R R RL ( RO ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyRL � s
c C s t j | j � r d Sd S( Ni i ( RC R R ( RO ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt isConnected� s c C s� t | � } t j j j | � } x�| D]�\ } } t j � rO t j � � n | | | | !} y5 t j d | � t j d d | � | j | � Wq( t
j k
r"} | r� t j j
� } | | _ t | � | _ d | _ | j j | � n t j d | � t j d d | | f � t St k
r�} | r~t j j
� } | | _ d t | � | _ d | _ | j j | � n t j d | � t j d d | | f � t SXq( W| r�t j j
� } | | _ d | _ | j j | � n t S(
Ns Execute statementR s Execute %s
i s %ss Exception executing '%s': %s
s Exception: s Exception caught: %si ( RF R+ R. t MysqlSqlFacadet getSqlStatementRangest query_statust
UserInterruptRK t
log_debug3t executeR t
QueryErrorR5 t GrtLogEntryt ownert strR t entryTypet entriest appendt send_warningt log_errorR RJ t True( RO t scriptt logt rangest startt lengtht statementt exct entry( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt execute_script� sH c C si g } t | � j d � } t j � r6 t j � � n x, | rd | j � rd | j | j d � � q9 W| S( s: Returns a list of schemas for the given connection object.s SHOW DATABASESi ( RF t executeQueryR+ RT RU t nextRowR^ t
stringByIndex( RO t namest result( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt getSchemaNames� s c C sm g } t | � j d | � } t j � r: t j � � n x, | rh | j � rh | j | j d � � q= W| S( sQ Returns a list of the tables in the given schema for the given connection object.s SHOW TABLES FROM `%s`i ( RF Rk R+ RT RU Rl R^ Rm ( RO R! Rn Ro ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt
getTableNames� s c C s� d � } d d l } t | d � } | j d d j g | j D] } | j ^ q= � d j g | j D] } | j ^ qb � | j � t j t
j j j
j � f � | j d } | r� | j r� | j | j d � n x�| j D]{} | j | d | j � � | j | j d
� xK | j D]@ } | j | d d | j | j f � � | j | j d
� qWxK | j D]@ }
| j | d
d | j |
j f � � | j |
j d
� qhWxG | j D]< } | j | d d | j | j f � � | j | j � q�Wx_ | j D]T } xK | j D]@ } | j | d d | j | j f � � | j | j d
� qWq Wq� W| j d }
|
r�|
j r�| j |
j d � n | j � d S( s� Create a CREATE script with the catalog objects. The catalog must have been previously processed
with generateSQLCreateStatements(), so that the objects have their temp_sql attributes set with
their respective SQL CREATE statements.
c S s d | | f } | S( Ns�
-- ----------------------------------------------------------------------------
-- %s %s
-- ----------------------------------------------------------------------------
( ( t typeR t text( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt object_heading� s i����Ns w+s -- ----------------------------------------------------------------------------
-- MySQL Workbench Migration
-- Migrated Schemata: %s
-- Source Schemata: %s
-- Created: %s
-- Workbench Version: %s
-- ----------------------------------------------------------------------------
s , s migration:preambles
t Schemas ;
t Tables %s.%st Viewt Routinet Triggers migration:postamblei ( t timet opent writeR R R t oldNamet ctimeR t fromgrtR+ t roott wbt infoR R R R R R R t close( t pathR R: Rt Rz t filet sR< R! R" R$ R% R# R= ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt createScriptForCatalogObjects� s: v
&&&&
c s� � f d � } y�t j d d | j � | j d } t j d d � t | | j | | � � d } x#| j D]} t j | | d t | j � � | d t | j � 7} | j r� t j d d | j
� t j � qo n t | j � t | j
� t | j � t g | j D] } t | j � ^ q� } t j d d | j
� t | | j | | � � d }
d } d } d }
d } x� | j D]� } | j r�t j t | � | d
| j
| j
f � n* t j t | � | d | j
| j
f � | d 7} | j r�t | | j | | � � r�|
d 7}
q�q�Wx� | j
D]� } | j rst j t | � | d
| j
| j
f � n* t j t | � | d | j
| j
f � | d 7} | j r7t | | j | | � � r7| d 7} q7q7Wx� | j D]� } | j r#t j t | � | d | j
| j
f � n* t j t | � | d | j
| j
f � | d 7} | j r�t | | j | | � � r�| d 7} q�q�Wx� | j D]� } x� | j D]� } | j r�t j t | � | d | j
| j
| j
f � n0 t j t | � | d | j
| j
| j
f � | d 7} | j r�t | | j | | � � r�|
d 7}
q�q�Wq�Wt j d |
| | | j
f � t j � qo W| j d } t j d d � t | | j | | � � t j d d � Wn$ t j k
r�t j d � � n Xd S( s Create catalog objects in the server for the specified connection. The catalog must have been
previously processed with generateSQLCreateStatements(), so that the objects have their temp_sql
attributes set with their respective SQL CREATE statements.
c s= � d k r5 t j j � } | | _ � j | � | Sd Sd S( N( R R+ R5 t GrtLogObjectt logObjectR^ ( R Rc ( t creationLog( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt
makeLogObject* s
g s/ Creating schema in target MySQL server at %s...s migration:preambles Executing preamble script...g �?s Skipping schema %s... s Creating schema %s...i s Skipping table %s.%ss Creating table %s.%si s Skipping view %s.%ss Creating view %s.%ss Skipping routine %s.%ss Creating routine %s.%ss Skipping trigger %s.%s.%ss Creating trigger %s.%s.%ssK Scripts for %i tables, %i views and %i routines were executed for schema %ss migration:postambles Executing postamble script...s Schema createds< Cancellation request detected, interrupting schema creation.( R+ t
send_progressRD R Rj R R t begin_progress_stept lenR R t end_progress_stepR R R t sumR t floatRK RU ( RO R R: R� R� R< t iR! R" t totalt tcountt vcountt rcountt trcountt oR$ R% R# R= ( ( R� sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt createCatalogObjects# sz
!
R -*
% -*
% -*
% 30
%
c C s� t | � } | r� | j d � } | r� | j � r� d d l } | j d | j d � � } | r� | j � r� t j j � } g | j � D] } t
| � ^ q� d g d } | d \ | _ | _ | _
| _ | Sq� n d S( sN Returns a GrtVersion instance containing information about the server version.s SHOW VARIABLES LIKE 'version'i����Ns ([0-9]*)\.([0-9]*)\.([0-9]*)i i i ( RF Rk Rl t ret matchRm t groupsR+ R5 t
GrtVersiont intR1 R2 R3 t buildNumberR ( RO t connRo R� t pR t nt ver_parts( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt getServerVersion� s 0"
c C s� t | � } | r~ | j d � } | r~ | j � r~ | j d � j � } d | k rX d Sd | k rh d Sd | k r{ d Sq~ n d S( Ns SELECT @@version_compile_osi t linuxt wint windowst osxt darwin( RF Rk Rl Rm t lowerR ( RO R� Ro t
compile_os( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt getOS� s
(% R� R R+ t workbenchR t workbench.exceptionsR t workbench.utilsR t
ModuleInfoR& t exportt INTR5 R6 R� t DICTR> t STRINGR7 R8 RC RF t db_mgmt_ConnectionRM RL RQ Rj t LISTRp Rq R, R� R� R� R� R� ( ( ( sH C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mysql_fe_grt.pyt <module> s* (3 ** *$$ *$*0@E_'