| 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 Z d d l Z d d l Z d d l m Z d d l m Z d d l m Z d d l m
Z
d Z d Z d a d Z d Z d
Z d Z d Z d
Z d Z d Z d d d YZ d Z d Z d Z i Z d Z d d d YZ d S( iN( t escape_sql_identifier( t" insert_item_to_plugin_context_menu( t TableTemplateManager( t show_schema_managerc C s$ t j d | s d t | S| S( Ns ^([a-z][A-Z][0-9]_)*$s `%s`( t ret matchR ( t s( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt esc_ident s c C s | S( N( ( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt _$ s c C s
t a d S( N( R t template_manager( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt init( s c s t j | d } | d d } t } d } t } d } t } t d k r i d d 6d d 6d d
6d d 6d
d 6d d 6d d 6d d 6}
n> i d d 6d d 6d d
6d d 6d d 6d d 6d d 6d d 6}
t } d x D]} | j | k r | d k r| j } q t } n | j d k rO| j } t } | j | j q | j de k r| j } t } | j d k rd q| j d k rd
q| j d k rd q| j d! k rd qq | j df k r&| j } | j t } | d 7} | j d k r| j | j qq | j dg k rG| j } t } q | j d" k r| j } | j
r| j | j
j | j
j d# | j } n t } q d$ G| j GHq W| rd } n | j d% }
|
r| j |
d } n d } t } t r| r| d k rt j
t d& }
|
j d' | j | d |
| d 7} t j
t d( }
|
j d) | j | d |
| d 7} t j
t d* }
|
j d+ | j | d |
| d 7} n | s| rKt d, d- d g t d k t f t d. d- d d d d! d d/ d0 d
d d g
t d k t f t d1 d2 d d d d! d d/ d0 d
d d g
t d k t f t d3 d4 d d
g t d k t f t d3 d4 d g t d k o d j d k t f t d5 d6 d/ d0 g t | d k t f t d7 d8 d d g t d k t f t d7 d9 d/ g t d k t f t d: d; d d g t d k t f t d: d< d/ g t d k t f t d= d> d g t d k t f t d? d@ d d d
d d g t d k t f t dA dB d g t d k t f t dC dD d g t d k t f d d d g d t f t dE dF d g t dG k t f t dH dI d g t d k t f t dJ dK d g t d k t f g } t j
dL } | j dM | j | | | d 7} t j
dN } | j dO | j | | | d 7} t t } t t } x | D] \ } } } } } | r| rqn | r| | k rqn | d k r| j | j q| j | t | | | }
|
j | | j | t | | | }
|
j | qWt } n t } | dh k r t d k r | r| j | t j
dP t j | d 7} t } n t j
dQ |
j }
|
j f dR | j | |
| d 7} | di k r t j
dS }
| j | |
| d 7} x: t j D]/ } |
j | j | d j f dT q; W|
j |
j dU t j q n | d k r
| r | j | t j
dP t j | d 7} t } n t j
dV }
|
j f dW | j | |
| d 7} n | r
| rU
| j | t j
dP t j | d 7} t } n | d k r
t j
dX |
j | | }
n% t j
dY | |
j | | f }
|
j f dZ | j | |
| d 7} t } n | d k r; | r; t j
d[ }
|
j f d\ | j | |
| d 7} n | r | ry | j | t j
dP t j | d 7} t } n | d k r t j
d] |
j | | }
n% t j
d^ | |
j | | f }
|
j f d_ | j | |
| d 7} n | d k rs | rs t j
d` | d k r/ d n da | }
|
j f db | j | |
| d 7} n | dj k r t j
dc }
|
j f dd t | |
n d S(k Nt menut selectioni i t Schemas db.Schemat Tables db.Tablet Views db.Viewt Functions db.Functions Stored Procedures db.StoredProceduret Indexs db.Indext Triggers
db.Triggers Foreign Keys
db.ForeignKeyt Schemast Tablest Viewst Functionss Stored Procedurest Indexest Triggerss Foreign Keyst columnst tablest viewst functionst storedProceduress db.Columnt :s Unhandled typet builtins_separators Export Data to CSV File...t export_table_csvs Import Data from CSV File...t import_table_csvs Dump Data to SQL File...t
dump_tablet Namet
name_shorts Name (short)s db.Table:db.Columns db.View:db.Columns Name (long)t name_longs Select All Statementt select_all_statements Select Columns Statementt select_columns_statements Insert Statementt insert_all_statementt insert_columns_statements Update Statementt update_all_statementt update_columns_statements Delete Statementt delete_statements Create Statementt create_statements Procedure Callt call_procedures
Function Callt
call_functions Join Selected Tablest build_joined_selecti s Delete with Referencest build_cascaded_deletes Select Row Referencest build_cascaded_selects Copy to Clipboardt copy_to_clipboards Send to SQL Editort send_to_editort s Create %s...c s t d j S( Ni ( t do_create_objectt
schemaName( ( R t sendert selection_db_type( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt <lambda> s s Create Table Like...c s t j | | S( N( R t create_table_like_template( t templt schema( R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s Edit Templates...s Create Schema...c s t d d S( Ns db.Schema( R6 t None( ( R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s Alter %s...s Alter %i %s...c s
t S( N( t do_alter_object( ( R R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s Table Maintenance...c s, t t g D] } | j ^ q t S( N( R t setR7 t True( t obj( R R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s
Drop %s...s
Drop %i %s...c s
t S( N( t do_drop_object( ( R R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s Truncate %s...s %i Tablesc s
t S( N( t do_truncate_table( ( R R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s s Search Table Data...c s
t S( N( t open_search( ( R8 ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: s ( s tabless viewss functionss storedProcedures( s db.Schemas db.Tables db.Views db.Functions db.StoredProcedure( s db.Indexs
db.Trigger( s tabless viewss functionss storedProceduress db.Schemas db.Tables db.Views db.Functions db.StoredProcedure( s db.Tables tables( s db.Tables db.Schemas tables( t mformst fromgrtR> t Falset lenR@ t typeRA t addt namet ownert find_itemt get_item_indext newMenuItemR t set_namet insert_itemt
CodeGeneratort
add_separatort add_item_with_titlet getattrt set_enabledt SeparatorMenuItemt gett add_clicked_callbackR t templatesR7 t edit_templatesR ( RL R8 t argsR t node_typet mixedt selection_typet object_selectedt object_selected_countt column_selectedt object_type_captiont
unique_tablesR t itemt indext needs_separatort
code_itemst copy_submenut send_submenut gencopyt gensendt captiont typest enabledt allow_mixedR< ( ( R R8 R9 sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt handleLiveTreeContextMenu. s
'BB*:**'*''3''''-
-
"%
"%
)
c C s t j j j | d S( N( t grtt modulest MySQLDBSearchModulet showSearchPanel( t editor( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRE s c C s" | d k r t j j } d | _ | j | _ | j j t j j j j
d j t j j } d | _ | j | _ | j j t j j j j
d j t j j } d | _ d | _ | | _ | j
j | | j | | n7t j j } d | _ | j | _ | j j t j j j j
d j t j j } | | _ | j | _ | | _ | j
j | t j j } d | _ | j | _ | j j t j j j j
d j t j j } | | _ | j | _ | | _ | j
j | | d k r/t j j } | | _ d | _ | j j | n | d k rxt j j } d | _ | | _ d
| _ | j j | n | d k rt j j } d | _ | | _ d
| _ | j j | nM | d k rt j j } | | _ d | _ | j j | n
d G| GHd S| j | | d S( Ns db.Schemat defaulti t
new_schemaR5 s db.Tablet new_tables db.StoredProceduret proceduret
new_procedures db.Functiont functiont new_functions db.Viewt new_views Unsupported objtype( Rs t classest db_mysql_CatalogRL t oldNamet simpleDatatypest extendt roott wbt rdbmsMgmtt rdbmst db_mysql_SchemaRM t schematat appendt editLiveObjectt db_mysql_TableR t db_mysql_Routinet routineTypet routinest
db_mysql_ViewR ( Rw t schema_namet db_typet ocatalogt catalogR= t oschemat newobj( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR6 st # # # # c C s1 x* | D]" } | j | j | j | j q Wd S( N( t alterLiveObjectRJ R7 RL ( Rw R RB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR? e s
c C ss t j t j j t j } | j d t j t } | j d | j | | j d | j
t j d t t t j
} | j
| t t | j t j | j | | j t j t t j } | j d t j } | j d t j t } | j d | j | t t | j | t t | j | t t | j d d | j | | S( Ns Review SQL Code to Executei i s# Review the SQL code to be executed.t Executet Canceli ih ( RF t Formt main_formt
FormNormalt set_titlet newBoxRH t set_paddingt set_contentt set_spacingRK t newLabelRA t
CodeEditort set_languaget
LanguageMySQLt set_textt set_featurest FeatureReadOnlyt newButtont add_endt set_sizet run_modal( t codet formt boxRw t okt cancelt bbox( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt review_sql_codek s.
c
C s! g } xI | D]A } | j d k r
| j d t | j t | j f q
q
Wt | d k r t j j d d | d d d d } nA t | d k r t j j d
d t | d d d } n d S| t j k r d S| t j
k r#t d j g | D] } d
| ^ q s#d Sn d } x | D] } y( d | } | j
| d | d 7} Wq0t k
r} | t | d k rt j j d t | d | d d d t j k rPqqt j j d t | d | d d d t j k rPqq0Xq0Wt j j j d | d S( Ns db.Tables %s.%si s Truncate Tables> Please confirm permanent deletion of all rows from table `%s`.i s
Review SQLR t Truncates Truncate TablessF Please confirm permanent deletion of all rows from %s selected tables.s
s TRUNCATE %s;s TRUNCATE %ss Could not Truncate Tables0
Click Cancel to stop truncating other tables.
t OKR5 s
s %i tables truncated( RJ R R R7 RL RI RF t Utilitiest show_messaget ResultCancelt ResultOkR t joint executeManagementCommandt Exceptiont
show_errort strt AppRY t set_status_text(
Rw R R RB t rest tt countt tablet stmtt exc( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRD s:
0,
55 c C s g } g } t } x| D]} | j d k rT d t | j } | j d n| j d k r | j d t | j t | j f | j d q nc| j d k r d t | j t | j f } | j d n"| j d
k r!d t | j t | j f } | j d n | j d
k rbd t | j t | j f } | j d n | j d k rd t | j t | j f } | j d n_ | j d k rd t | j t | j j t | j j f } | j d n d G| j GH| j d | f q W| rdd d j | } t | t | } | j t | | f n t | } | szd St | d k rt
j j d d d d d d Sd } d | k r.| d k rt
j j d d | d j d! d" d# } qot
j j d$ t | d% d j | d! d" d# } nAd | k r| d k rrt
j j d& d' | d j d! d" d# } qot
j j d( | d) d j g | D] } | j ^ q d! d" d# } n | d k rt
j j d* t | d d+ t | d j | d j f d! d" d# } nY t
j j d d, | d j t | d j g | D] } | j ^ qG f d! d" d# } | d k s| t
j k rd S| t
j k rt d- j g | D] \ }
} | d. ^ q sd Sn d } x t | D] \ } \ }
} y! | j | d d | |
7} Wqt k
r}
| t | d k rt
j j d/ t |
d0 | d d" d t
j k rPqqt
j j d/ t |
d1 | d d d t
j k rPqqXqWt
j j j d2 | d S(3 Ns db.Schemas DROP DATABASE %sR
s db.Tables %s.%sR s
db.Triggers DROP TRIGGER %s.%sR s db.StoredProcedures DROP PROCEDURE %s.%ss Stored Procedures db.Functions DROP FUNCTION %s.%sR s db.Views DROP VIEW %s.%sR s db.Indexs DROP INDEX %s ON %s.%sR s Unsupported type for dropi s
DROP TABLE %ss , s Drop Objectsso Multiple objects of different types are selected. To avoid accidents, please drop one type of object at a time.R R5 s
Drop Tables= Please confirm permanent deletion of table `%s` and its data.i s
Review SQLR s Drop Nows Drop %i Tabless> Please confirm permanent deletion of tables %s and their data.s Drop SchemasB Please confirm permanent deletion of schema `%s` and all its data.s Drop %i SchemassC Please confirm permanent deletion of schemas %s and all their data.s Drop %ss- Please confirm permanent deletion of %s `%s`.s6 Please confirm permanent deletion of %s %s objects: %ss
t ;s Could not Drop Objects/
Click Cancel to stop dropping other objects.
s
s %i objects dropped( R@ RJ R RL RK R R7 RM R RI RF R R R> t listt lowerR R R t enumeratet executeCommandR R R R RY R ( Rw R t
statementst table_namest object_typesRB R R R R t ct
drop_countt iR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRC s
)
""""4 & $J2 55 t DependencyAnalyzerc B sY e Z d Z d Z d Z d Z d Z d Z d Z d Z d Z
RS( c C s( | | _ | | _ i | _ i | _ d S( N( R R t tables_by_namet referencing_foreign_keys( t selfR R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt __init__ s c C s t j j } t j d d t j j d | j d t \ } } | sJ d S| j
| | t j d d | j i t d 6t d 6t d 6t d 6} | j
| d
| j g | | _ | j | t j d d | j | j S( Nt
sqlide_grts
Connecting...s Connect to MySQLR s! Reverse engineering schema %s...
t reverseEngineerTablest reverseEngineerTriggerst reverseEngineerViewst reverseEngineerRoutinesR5 s$ Reverse engineer schema %s finished
( Rs Rt t DbMySQLREt log_infoRF R t find_or_ask_for_passwordt hostIdentifierRH R> t connectR RA t reverseEngineerR t
disconnect( R t
connectiont mR t passwordt options( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt load_data s $
!
c C s x | j j D]s } xj | j D]_ } | | j | j <xF | j D]; } | j j | j g } | j | | | j | j <q= Wq Wq
Wd S( N(
R R R R RL t foreignKeysR RY t referencedTableR ( R R R t ft refs( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt scan_tables- s
c C s& | | j k r" | j j | d Sd S( N( R R RY R> ( R R= RL ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt table_with_name9 s c C s | j j | g S( N( R RY ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_foreign_keys_to_table? s c C s g | j D] } | j ^ q
S( N( R R ( R R t fk( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_referenced_tablesC s c C sR x$ | j D] } | j | k r
| Sq
Wx$ | j D] } | j | k r1 | Sq1 Wd S( N( R R R> ( R t table1t table2R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_foreign_key_betweenG s c C s+ x$ | j D] } | j | k r
| Sq
Wd S( N( R R R> ( R R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_foreign_key_fromQ s c s i i x+ | j j D] } d | <d | <q Wd | < f d } f d } | j j } x= | r | | } x$ | j | D] } | | | q Wqw Wg } | }
x7 |
r |
} | j | j | |
| }
q W| S( Nii c s; | | d k r7 | d | <| | <n d S( Ni ( ( t ut v( t predecessort distance( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt relaxe s c s) t f d | } | j | | S( Nc s | | k r | S| S( N( ( t at b( R ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR: k s ( t reducet remove( t remainingR ( R ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_cheapestj s
( R t valuesR> R R R ( R t
from_tablet to_tableR R R R R R t foreign_keysR t pred( ( R R sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt find_foreign_key_path_betweenX s(
( t __name__t
__module__R R R R R R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR s
c C s | j j d | d } | s t j j j d | t d | } | j | j } | sz t j j j d d St j j j d | | | j d | <n) t j j j d | t | | } | S( Ns sqlide_grt:Catalog:%ss$ Reverse engineering schema for %s...s
Cancelled.s %s reverse engineereds+ Reusing reverse engineered schema for %s...( t
customDataRY R> RF R R R R R ( Rw R= R t info( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt dependencyInfoForSchemaInEditor s c C s g } xr t t | j D][ } | j d t | j j t | j | j t | j j t | j | j f q Wd j | S( Ns
%s.%s = %s.%ss AND (
t rangeRI t referencedColumnsR R R RL RM R R ( R t joinsR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt format_fk_join s Yc
C s> t } x t | D] \ } } x | | d D] } | j | | } | r` | j | Pq1 | r | j | | p | j | | } | s d | j | j f GHd S| j | q1 d Sq1 Wq W| s d Sd d j t g | D] } t | j ^ q g | D] } t | j
j ^ q d j d | D f S( Ni s! Could not find path from %s to %ss! SELECT *
FROM %s
WHERE %ss , s AND c s s | ] } t | Vq d S( N( R ( t .0R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr> s ( R@ R R RK R RL R> t updateR R RM (
R
R t auto_add_missingR R t t1t t2R t fksR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt join_tables s"
$ c C s d } d } g } x t d t | D] } | | d k rK | d 7} n | | d k rh | d 8} n | d k r | r | j | n | S| d k r | | d k r | j | d } q( | | | 7} q( Wd S( Ni R5 t (t )i t ,( R RI R R> ( t textR t tokent tokensR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt tokenize_argument_list s"
RS c B s e 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
d Z d
Z d Z d Z d Z d Z d Z d Z RS( c C s | | _ | | _ | | _ d S( N( Rw R t to_editor( R Rw R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR s c
C s d | j j | | f } t j | r0 t | S| j j d t | t | f d } | r g } | j } x_ | r | j d } | j d d k } | j d } | j | | | f | j } qv W| t | <| GH| Sd Sd S( Ns %s:%s.%ss SHOW COLUMNS FROM %s.%si t Fieldt Keyt PRIt Default( Rw t __id__t table_column_cachet has_keyt executeManagementQueryR t goToFirstRowt stringFieldValueByNameR t nextRowR> (
R R= R t info_keyt rsR R RL t is_keyRx ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt get_table_columns s" +
c C s t j j | d S( N( RF R t set_clipboard_text( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR3 s c C s> | j j } | s$ | j j } n | r: | j | n d S( N( Rw t activeQueryEditort addQueryEditort replaceSelection( R R t ed( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR4 s
c C s* | j r | j | n
| j | d S( N( R R4 R3 ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt send s c C sN g } x+ | j D] } | j d t | j q W| j d j | d S( Ns %ss , ( R R R RL R3 R ( R t partsRB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR$ s c C sx g } xU | j D]J } | j d | j r: t | j j n t | j t | j f q W| j d j | d S( Ns %s.%ss , ( R R RM R RL R7 R3 R ( R R4 RB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR% s Hc s g } x | j D]x j d k r1 j n | j d d j f d | j j j D t j t j f q W| j d j | d S( NR s SELECT %s
FROM %s.%s;
s ,
c 3 s2 | ]( } d t j t | d f Vq d S( s %s.%si N( R RL ( R R ( RB ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr> s s
(
R RJ RM R R R- R7 RL R R3 ( R R4 ( ( RB sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR& s [c C s g } d } xH | j D]= } | j d k r | j | j | j rS | j } qS q q W| r | j d d j d | D t | j t | j f n d S( Ns db.Columns SELECT %s FROM %s.%s;
s , c s s | ] } d t | Vq d S( s %sN( R ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr> s (
R> R RJ R RL RM R3 R R R7 ( R R R RB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR' s c C s g } x | j D] } | j d k r1 | j } n | j | j | j } | j d t | j t | j d j d | D d j d | D f q W| j d j | d S( NR s$ INSERT INTO %s.%s
(%s)
VALUES
(%s);
s ,
c s s# | ] } d t | d Vq d S( s %si N( R ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr># s c s s' | ] } d | d | d f Vq d S( s
<{%s: %s}>i i N( ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr>$ s s
(
R RJ RM R- R7 RL R R R R3 ( R R4 RB R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR( s !"c C so | j d j } | j d t | j t | j d j d | j D d j d | j D f d S( Ni s$ INSERT INTO %s.%s
(%s)
VALUES
(%s);
s ,
c s s" | ] } d t | j Vq d S( s %sN( R RL ( R RB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr>+ s c s s | ] } d | j Vq d S( s <{%s}>N( RL ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr>, s ( R RM R3 R R7 RL R ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR) ' s !c
C s g } x | j D] } | j d k r1 | j } n | j | j | j } | j d t | j t | j d j d | D d j g | D]$ } | d r d t | d ^ q f q W| j d j | d S(
NR s UPDATE %s.%s
SET
%s
WHERE %s;
s ,
c s s4 | ]* } d t | d | d | d f Vq d S( s %s = <{%s: %s}>i i N( R ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr>6 s s AND i s
%s = <{expr}>i s
(
R RJ RM R- R7 RL R R R R3 ( R R4 RB R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR* . s !Cc C sV | j d j } | j d t | j t | j d j d | j D f d S( Ni s0 UPDATE %s.%s
SET
%s
WHERE <{where_expression}>;
s ,
c s s+ | ]! } d t | j | j f Vq d S( s %s = <{%s}>N( R RL ( R RB ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pys <genexpr>> s ( R RM R3 R R7 RL R ( R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR+ : s !c C s] g } x: | j D]/ } | j d t | j t | j f q W| j d j | d S( Ns. DELETE FROM %s.%s
WHERE <{where_expression}>;
s
( R R R R7 RL R3 R ( R R4 R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR, @ s -c C s^ g } x;| j D]0} d } | j d k rV | j j d t | j d } d } n| j d k r | j j d t | j t | j f d } d } nE| j d k r | j j d
t | j t | j f d } d } d } n | j d
k r=| j j d t | j t | j f d } d } d } n | j d k r| j j d t | j t | j f d } d } d } nX | j d k r| j j d t | j t | j f d } d } n d G| j GHq | r4| j r4| j | } | s d | | j f GHq@| j | | q d | j GHq W| j
d j | d S( Ns %s;
s db.Schemas SHOW CREATE SCHEMA %si s Create Databases db.Tables SHOW CREATE TABLE %s.%ss Create Tables
db.Triggers SHOW CREATE TRIGGER %s.%st Statements DELIMITER $$
%s$$
DELIMITER ;
s db.StoredProcedures SHOW CREATE PROCEDURE %s.%ss Create Procedures db.Functions SHOW CREATE FUNCTION %s.%ss Create Functions db.Views SHOW CREATE VIEW %s.%ss Create Views Unsupported types No field %s for %ss! Couldn't fetch create code for %ss
( R RJ Rw R& R RL R7 R' R( R R3 R ( R R4 RB t wrapperR+ t
field_namet sql( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR- F sB " 1 1 1 1 1 c C s# g } x | j D] } | j j d t | j t | j f d } | r | j r | j d } | rt j d | } | rt
| t | j d d } | j
d t | j t | j d j g | D] } d | j ^ q f qqq q W| j d j | d S(
Ns SHOW CREATE PROCEDURE %s.%si s Create Procedures (CREATE .* PROCEDURE [^(]*\()i s CALL %s.%s(%s);
s , s <{%s}>R5 ( R Rw R& R R7 RL R' R( R R R RI t groupsR R t stripR3 ( R R4 RB R+ R8 R R] R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR. n s 1$!>c C s# g } x | j D] } | j j d t | j t | j f d } | r | j r | j d } | rt j d | } | rt
| t | j d d } | j
d t | j t | j d j g | D] } d | j ^ q f qqq q W| j d j | d S(
Ns SHOW CREATE FUNCTION %s.%si s Create Functions (CREATE .* FUNCTION [^(]*\()i s %s.%s(%s)s , s <{%s}>s
( R Rw R& R R7 RL R' R( R R R RI R9 R R R: R3 ( R R4 RB R+ R8 R R] R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR/ | s 1$!>c C s} | j } | j } t | | d j } | s2 d S| j g } x< | D]4 } | j | j | j } | rI | j | qI qI Wt | t | k r t j
j d d d d d d St | | t
} | r | j | nv t j
j d d d d d t j k rSt | | t } | r0| j | qWt j
j d d d d d d Sn d S| j syt j j j d
n d S( Ni s Join Selected Tabless3 Could reverse engineer some of the selected tables.R R5 sj Some of the tables could not be joined together.
Should missing intermediate tables be searched and added?s Add MissingR s Could not join selected tables.s= Select statement for joined selection was copied to clipboard( Rw R R R7 R R RL R RI RF R R R RH R3 R RA R R RY R ( R Rw R R
R t objectR t query( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR0 s4
' c s | j } | j d } t | | j } | s2 d S| j | j | j | j s t j j d d | j d d d d S j
s t j j d d | j d d d d Sg x= j
j D]/ } j d j | j
j | j
j f q Wd j f d g } | | g t g } x+ j
j D] } | j d
| j
j qMWd j | d d j | } | j | | j st j j j d j n d S(
Ni s Select Row Referencess$ Could not find reverse engineered %sR R5 sN Unable to find referencing tables for %s because the table has no primary key.s %s.%s = @%s_to_selects AND c s | | k r d S| j | d } x7 | j | D]& } | j | | | | g | q6 Wd | j } | d d j | g | D] } | j j ^ q j 7} | r | d d j g | D] } t | ^ q 7} | d 7} n | d 7} | j | d S( Nc S s | | k r | | g S| S( N( ( R Rf ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt add_to_list s s SELECT %s.*
s FROM %s
s , s
WHERE %s
s
AND s AND %s;s
WHERE %s;( RK R RM RL R R R ( R R
t selectst reference_chaint visitedR= R R< ( t the_tablet pkt
create_select( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRC s
$
<0s SET @%s_to_select = <{row_id}>;s
s; Select statements for %s references was copied to clipboard( Rw R R R7 R R RL RF R R t
primaryKeyR R t referencedColumnR R@ R3 R R RY R ( R Rw R; R
R R> t varsetupR< ( ( RA RC RB sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR2 s8
#
-
c s | j } | j d } t | | j } | s2 d S| j | j | j | j s t j j d d | j d d d d S j
s t j j d d | j d d d d Sg x= j
j D]/ } j d j | j
j | j
j f q Wd j f d
g } | | g t g } x+ j
j D] } | j d | j
j qMWd d
j | d
j | f } | j | | j st j j j d j n d S( s]
To delete a row from a table all references to that row from other tables must be deleted first,
otherwise the FK constraint won't let it be done.
So this function will build the DELETE statements needed to do that, by deleting
references to the given row all the way up to the wanted table.
i Ns Cascading DELETEs$ Could not find reverse engineered %sR R5 sP Unable to create a DELETE statement for %s because the table has no primary key.s %s.%s = @%s_to_deletes AND c s | | k r d S| j | d } x7 | j | D]& } | j | | | | g | q6 Wd | j } | d d j | g | D] } | j j ^ q j 7} | r | d d j g | D] } t | ^ q 7} | d 7} n | d 7} | j | d S( Nc S s | | k r | | g S| S( N( ( R Rf ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR= s s DELETE FROM %s
s
USING %s
s , s
WHERE %s
s
AND s AND %s;s
WHERE %s;( RK R RM RL R R R ( R R
t deletesR? R@ R= R R< ( t
create_deleteRA RB ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRH s
$
<0s SET @%s_to_delete = <{row_id}>;s
-- All objects that reference that row (directly or indirectly) will be deleted when this snippet is executed.
-- To preview the rows to be deleted, use Select Row Dependencies
START TRANSACTION;
-- Provide the values of the primary key of the row to delete.
%s
%s
COMMIT;
s
s/ DELETE statement for %s was copied to clipboard( Rw R R R7 R R RL RF R R RD R R RE R R@ R3 R R RY R ( R Rw R; R
R RG RF R< ( ( RA RB RH sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyR1 s8
#
-
"
( R R R R- R3 R4 R3 R$ R% R& R' R( R) R* R+ R, R- R. R/ R0 R2 R1 ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyRS s( ( $ <( ( ( R Rs RF t workbench.db_utilsR t workbench.pluginsR t table_templatesR t sqlide_catalogman_extR R R R> R R
Rr RE R6 R? R RD RC R R R R R$ R RS ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_schematree_ext.pyt <module> s0 F $ ar