| 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/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
ó
2z”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_'