| 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 : C:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
ó
,¢2Sc @ s_ 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 „ 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! d S( iÿÿÿÿ( t DefineModuleN( t db_utils( t NotConnectedErrort 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( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyt generateSQLCreateStatementsE s
+$ $
c C s1 t j j ƒ } d | _ d | _ | j | _ | S( Nt Preambles SET FOREIGN_KEY_CHECKS = 0;( R* R4 t db_DatabaseDdlObjectR t
sqlDefinitionR ( R R9 R
( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyR6 b s
c C s1 t j j ƒ } d | _ d | _ | j | _ | S( Nt Postambles SET FOREIGN_KEY_CHECKS = 1;( R* R4 R? R R@ R ( R R9 R
( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyR7 j 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( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyt get_connectiont 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 restablishedt passwords Connecting to %s...t Connectedi (
RE t pingt ExceptionR* t send_infoRC t
disconnectt connectR R t MySQLConnectionRB R ( t
connectionRF t con( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyRL { s
c C s4 t j | j ƒ r0 t | j j ƒ t | j =n d S( Ni ( RB R R RK ( RN ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyRK s
c C s t j | j ƒ r d Sd S( Ni i ( RB R R ( RN ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( RE R* R- t MysqlSqlFacadet getSqlStatementRangest query_statust
UserInterruptRJ t
log_debug3t executeR t
QueryErrorR4 t GrtLogEntryt ownert strR t entryTypet entriest appendt send_warningt log_errorR RI t True( RN t scriptt logt rangest startt lengtht statementt exct entry( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( RE t executeQueryR* RS RT t nextRowR] t
stringByIndex( RN t namest result( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( RE Rj R* RS RT Rk R] Rl ( RN R Rm Rn ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ƒ 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 ƒ qPWxG | 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 ƒ qøWqèWqÅ W| j d }
|
rw|
j rw| 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( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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
-- ----------------------------------------------------------------------------
s , s migration:preambles ;
t Schemat Tables %s.%st Viewt Routinet Triggers migration:postamblei ( t timet opent writeR R R t oldNamet ctimeR R R R R R t close( t pathR R9 Rs Ry t filet sR; R R! R# R$ R" R< ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyt createScriptForCatalogObjectsâ s: ^
&&&&
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* R4 t GrtLogObjectt logObjectR] ( R
Rb ( t creationLog( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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_progressRC R Ri R R t begin_progress_stept lenR R t end_progress_stepR R R t sumR t floatRJ RT ( RN R R9 R… R† R; t iR R! t totalt tcountt vcountt rcountt trcountt oR# R$ R" R< ( ( R… sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( RE Rj Rk t ret matchRl t groupsR* R4 t
GrtVersiont intR0 R1 R2 t buildNumberR ( RN t connRn R• t pR t nt ver_parts( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyt getServerVersion€ s 0"
(" t wbR R* t workbenchR t workbench.exceptionsR t
ModuleInfoR% t exportt INTR4 R5 R˜ t DICTR= t STRINGR6 R7 RB RE t db_mgmt_ConnectionRL RK RP Ri t LISTRo Rp R+ R‚ Rƒ R” RŸ ( ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mysql_fe_grt.pyt <module> s& (3 ** *$$ *$*0?E_