| 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 : |
2zXc @ s1 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 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 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 CreateIndexForm( 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( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt esc_ident s c C s | S( N( ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt _% s c C s
t a d S( N( R t template_manager( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt init) s c sS
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 dg 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 dh k r&| j } | j t } | d 7} | j d k r| j | j qq | j di 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| rWt 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 t | | j | t | | | }
|
j t | qWt } n t } | dj 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} | dk k r t j
dS }
| j | |
| d 7} x: t j D]/ } |
j | j | d j f dT qG 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
| ra
| 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 rG | rG t j
d[ }
|
j f d\ | j | |
| d 7} n | r | r | 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 r | r t j
d` | d k r; d n da | }
|
j f db | j | |
| d 7} n | dl k r t j
dc }
|
j f dd t | |
n | d/ k rO
| rO
| r
| j | t j
dP t j | d 7} t } n t j
de }
|
j f df | j | |
| d 7} n d S(m 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 selection_db_typet sender( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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( R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Edit Templates...s Create Schema...c s t d d S( Ns db.Schema( R7 t None( ( R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Alter %s...s Alter %i %s...c s
t S( N( t do_alter_object( ( R
R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Table Maintenance...c s, t t g D] } | j ^ q t S( N( R t setR8 t True( t obj( R
R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s
Drop %s...s
Drop %i %s...c s
t S( N( t do_drop_object( ( R
R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Truncate %s...s %i Tablesc s
t S( N( t do_truncate_table( ( R
R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Search Table Data...c s
t S( N( t open_search( ( R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; s s Create Index...c s
t S( N( t do_create_index( ( R
R: ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 lenRA t typeRB 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 boolt SeparatorMenuItemt gett add_clicked_callbackR
t templatesR8 t edit_templatesR ( RN R: 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
R9 R: sN C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyRF & s c C s9 | d k r" | j | d d n | j | | d d S( Ns db.SchemaR6 ( t alterLiveObject( Rz t schema_namet db_type( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR7 * s c C s1 x* | D]" } | j | j | j | j q Wd S( N( R{ RL R8 RN ( Rz R
RC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR@ 0 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 ( RH t Formt main_formt
FormNormalt set_titlet newBoxRJ t set_paddingt set_contentt set_spacingRM t newLabelRB t
CodeEditort set_languaget
LanguageMySQLt set_textt set_featurest FeatureReadOnlyt newButtont add_endt set_sizet run_modal( t codet formt boxRz t okt cancelt bbox( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt review_sql_code6 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 OKR6 s
s %i tables truncated( RL t appendR R8 RN RK RH t Utilitiest show_messaget ResultCancelt ResultOkR t joint executeManagementCommandt Exceptiont
show_errort strt AppR\ t set_status_text(
Rz R
R RC t rest tt countt tablet stmtt exc( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyRE V s:
0,
55 c C s g } d } d } x | D] } | rT | | j k rT t j j d d d d d d S| r | j sv | | j j k r t j j d d d d d d S| j } | j j } | j | j q W| r t t j j
| | | | d } | j r q n d S( Ns Create Indexs6 Please select one or more columns from the same table.R R6 ( R? R8 RH R R RO RN R R R R t run( Rz R
t colsR> R t nodeR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyRG z s"
" $ 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 R6 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( RA RL R RN RM R R8 RO R RK RH R R R? t listt lowerR R R t enumeratet executeCommandR R R R R\ R ( Rz R
t
statementst table_namest object_typesRC R R R R t ct
drop_countt iR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyRD 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| t catalogt tables_by_namet referencing_foreign_keys( t selfR R| ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 MySQLt roots! Reverse engineering schema %s...
t reverseEngineerTablest reverseEngineerTriggerst reverseEngineerViewst reverseEngineerRoutinesR6 s$ Reverse engineer schema %s finished
( Rv Rw t DbMySQLREt log_infoRH R t find_or_ask_for_passwordt hostIdentifierRJ R? t connectR| RB t reverseEngineerR t
disconnect( R t
connectiont mR t passwordt options( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 t schemataR R RN t foreignKeysR R\ t referencedTableR ( R R R t ft refs( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt scan_tables
s
c C s& | | j k r" | j j | d Sd S( N( R| R R\ R? ( R R> RN ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt table_with_name s c C s | j j | g S( N( R R\ ( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt get_referenced_tables# 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt get_foreign_key_between' s c C s+ x$ | j D] } | j | k r
| Sq
Wd S( N( R R R? ( R R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt get_foreign_key_from1 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 sW | k s | k r d S | | d k rS | d | <| | <n d S( Ni ( ( t ut v( t distancet predecessor( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR; M s ( t reducet remove( t remainingR ( R ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt get_cheapestL 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 sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt find_foreign_key_path_between8 s(
( t __name__t
__module__R R R R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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
customDataR\ R? RH R R R R R ( Rz R> R t info( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt dependencyInfoForSchemaInEditord 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 rangeRK t referencedColumnsR R R RN RO R R ( R t joinsR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt format_fk_joinx 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s ( RA R R RM R RN R? t updateR R RO (
R R t auto_add_missingR R t t1t t2R t fksR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 R6 t (t )i t ,( R RK R R? ( t textR t tokent tokensR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt tokenize_argument_list s"
RU 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( Rz R
t to_editor( R Rz R
R
( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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( Rz t __id__t table_column_cachet has_keyt executeManagementQueryR t goToFirstRowt stringFieldValueByNameR t nextRowR? (
R R> R t info_keyt rsR R RN t is_keyt default( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt get_table_columns s" +
c C s t j j | d S( N( RH R t set_clipboard_text( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR4 s c C s> | j j } | s$ | j j } n | r: | j | n d S( N( Rz t activeQueryEditort addQueryEditort replaceSelection( R R t ed( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR5 s
c C s* | j r | j | n
| j | d S( N( R
R5 R4 ( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 RN R R ( R t partsRC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 RO R RN R8 R R ( R R! RC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 RN ( R R ( RC ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s s
(
R
RL RO R R R R8 RN R R ( R R! ( ( RC sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s (
R? R
RL R RN RO R R R R8 ( R R R RC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s s
(
R
RL RO R R8 RN R R R R ( R R! RC R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 RN ( R RC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr>
s c s s | ] } d | j Vq d S( s <{%s}>N( RN ( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s ( R
RO R R R8 RN R ( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s s AND i s
%s = <{expr}>i s
(
R
RL RO R R8 RN R R R R ( R R! RC R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 RN ( R RC ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pys <genexpr> s ( R
RO R R R8 RN R ( R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 R8 RN R R ( R R! R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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
RL Rz R R RN R8 R R R R R ( R R! RC t wrapperR t
field_namet sql( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR. ( 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}>R6 ( R
Rz R R R8 RN R R R R R RK t groupsR R t stripR ( R R! RC R R% R R` R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR/ P 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
Rz R R R8 RN R R R R R RK R& R R R' R ( R R! RC R R% R R` R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR0 ^ 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 R6 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( Rz R
R R8 R R RN R RK RH R R R RJ R R RB R
R R\ R ( R Rz R
R R t objectR t query( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR1 m 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 R6 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 Ri ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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;( RM R RO RN R R R ( R R t selectst reference_chaint visitedR* R R) ( t
create_selectt pkt the_table( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR. s
$
<0s SET @%s_to_select = <{row_id}>;s
s; Select statements for %s references was copied to clipboard( Rz R
R R8 R R RN RH R R t
primaryKeyR R t referencedColumnR RA R R
R R\ R ( R Rz R( R R R+ t varsetupR) ( ( R. R/ R0 sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR3 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 R6 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 Ri ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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;( RM R RO RN R R R ( R R t deletesR, R- R* R R) ( t
create_deleteR/ R0 ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR5 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( Rz R
R R8 R R RN RH R R R1 R R R2 R RA R R
R R\ R ( R Rz R( R R R4 R3 R) ( ( R5 R/ R0 sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyR2 s8
#
-
"
( R R R R R4 R5 R R% R& R' R( R) R* R+ R, R- R. R/ R0 R1 R3 R2 ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyRU s( ( $ <( ( (! R Rv RH t workbench.db_utilsR t workbench.pluginsR t table_templatesR t sqlide_tableman_extR t sqlide_catalogman_extR R R R? R
R Ru RF R7 R@ R RE RG RD R R R R R R RU ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_schematree_ext.pyt <module> s4 $ at