| 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 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 d l m
Z
m Z m Z d d l
m Z d d l m Z m Z d
„ Z e d „ Z d „ Z d
e j f d „ ƒ YZ d e j f d „ ƒ YZ d e j f d „ ƒ YZ d e j f d „ ƒ YZ d f d „ ƒ YZ d e e f d „ ƒ YZ d e e f d „ ƒ YZ d e e f d „ ƒ YZ d e e f d „ ƒ YZ d e e f d „ ƒ YZ! d! e e f d" „ ƒ YZ" d# e e j f d$ „ ƒ YZ# d% e j$ f d& „ ƒ YZ% d S(' iÿÿÿÿN( t log_error( t MaintenanceResultForm( t
ObjectManager( t TriggerManager( t
ColumnManager( t IconStringColumnTypet StringColumnTypet IntegerColumnType( t make_panel_header( t
human_sizet Versionc C s# t j | ƒ } | j t j ƒ | S( N( t mformst newLabelt set_stylet BoldStyle( t tt l( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt
make_title s c C sœ x• | D] \ } } t | ƒ } | j | | ƒ t j | j ƒ } | j | d d ƒ | j | ƒ | j d | | f ƒ | d k r | j | ƒ q q Wd S( Nt i s %s.%s(
t TableInspectort
show_tableR t fromgrtt dockingPointt dock_viewt select_viewt set_titlet Nonet switch_to_page( t editort selectiont paget schemat tablet tinspectt dpoint( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt show_table_inspector% s
c sG t j | d ƒ } | d } | j d t ƒ } g } t ‰ xq | D]i } | j d k rs | j | j | j f ƒ qB | j d k r§ t ‰ | j | j | j j f ƒ qB d SqB W| rCt j
ˆ rÇ d n d ƒ } | j | | ‡ f d † ƒ | r$| j d | ƒ | j d
t j
d t j
ƒ ƒ qC| j ˆ r6d n d
| ƒ n d S( Nt menuR t schema_inspectors db.Tables db.Indexs Create Indexs Table Inspectorc s t | | ˆ r d n d ƒ S( Nt indexes( R# R ( t sendert tables_selected( t show_index_page( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt <lambda>B s i i R ( R R t gett Falset typet appendt
schemaNamet namet Truet ownert newMenuItemt add_clicked_callbackt insert_itemt SeparatorMenuItem( R0 R' t argsR$ R t from_schema_inspectorR( t st item( ( R) sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt handleLiveTreeContextMenu0 s&
"t TableInfoPanelc B sJ e Z d Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( t Infot informationsc C s t j j | t ƒ | j ƒ | j ƒ | | _ t j ƒ | _ | j ƒ rQ d n d } | j j
d | ƒ | j j d ƒ | j j d ƒ | j j
d ƒ t j t ƒ | _ | j j d ƒ d | _ | j | j t t ƒ | j j t d ƒ d d d d t j ƒ | j j t j d ƒ d d d d
t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d d
t j t j Bƒ | j j t j d ƒ d d d
d
t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d
d
t j t j Bƒ | j j t j d ƒ d d d
d t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d
d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _ | j j t j ƒ | j j | j d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _! | j! j t j ƒ | j j | j! d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _" | j" j t j ƒ | j j | j" d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _# | j# j t j ƒ | j j | j# d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _$ | j$ j t j ƒ | j j | j$ d d d d t j t j Bƒ | j ƒ rã| j j t j d ƒ d d d d t j ƒ t j d ƒ | _% | j% j t j ƒ | j j | j% d d d d t j t j Bƒ | j j t j d ƒ d d d d t j ƒ t j d ƒ | _& | j& j t j ƒ | j j | j& d d d d t j t j Bƒ n | j j t j d ƒ d d d | d | t j ƒ t j d ƒ | _' | j' j t j ƒ | j j | j' d d d | d | t j t j Bƒ | j j t j d! ƒ d d d | d | t j ƒ t j d ƒ | _( | j( j t j ƒ | j j | j( d d d | d | t j t j Bƒ | j j t j d" ƒ d d d | d# | t j ƒ t j d ƒ | _) | j) j t j ƒ | j j | j) d d d | d# | t j t j Bƒ | j j t j d$ ƒ d d d# | d% | t j ƒ t j d ƒ | _* | j* j t j ƒ | j j | j* d d d# | d% | t j t j Bƒ | j j t j d& ƒ d d d% | d' | t j ƒ t j d ƒ | _+ | j+ j t j ƒ | j j | j+ d d d% | d' | t j t j Bƒ | j j t j d( ƒ d d d' | d | t j ƒ t j d ƒ | _, | j, j t j ƒ | j, j- t ƒ t. j/ j0 ƒ d) k r2
| j, j1 d d* ƒ n | j j | j, d d d' | d | t j t j Bƒ t j2 ƒ } | j3 t t ƒ | j4 t ƒ t j t ƒ } | j5 d ƒ | j d ƒ | j | j t t ƒ | j | ƒ | j | t t ƒ t j t ƒ } | j5 d ƒ | j d ƒ t j ƒ } | j
d ƒ | j d ƒ t j6 ƒ | _7 | j7 j8 d+ ƒ | j7 j9 | j: ƒ | j7 j; t ƒ | j t j d, ƒ d d d d t j ƒ | j | j7 d d d d t j ƒ | j t j d- ƒ d d d d t j ƒ | j | t t ƒ | j | t t ƒ d S(. Ni i i i i
s
Table Detailsi s Engine:i i R s Row format:i s
Column count:i s Table rows:i s AVG row length:s Data length:i s
Index length:s Max data length:i s
Data free:i s Table size (estimate):i
s File format:i s
Data path:i s Update time:s Create time:s Auto increment:i s Table collation:i s Create options:i s Comment:t win32iÿÿÿÿs
Analyze Tables0 Information on this page may be outdated. Click s to update it.(< R t Boxt __init__R, t set_managedt set_release_on_addR t newTableR t i_s_innodb_availablet
set_row_countt set_column_countt set_row_spacingt set_column_spacingt newBoxR1 t panel_header_boxt set_paddingR t
_table_enginet addR t HFillFlagR t engineR
R t HExpandFlagt
row_formatt column_countt
table_rowst avg_row_lengtht data_lengtht index_lengtht max_data_lengtht data_freet
table_sizet file_formatt data_patht update_timet create_timet auto_incrementt table_collationt create_optionst
table_commentt
set_wrap_textt syst platformt lowert set_sizet ScrollPanelt set_visible_scrollerst set_autohide_scrollerst set_spacingt newButtont analyze_btnt set_textR4 t
analyze_tablet enable_internal_padding( t selfR t offsett scrollt tboxt bboxR ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA M sæ
(+,+,+,+,+,+,+,+,+,+, +,+/343434343434
("(c C s | j S( N( RM ( Rq ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt get_table_engineå s c C sY | j j d | j | j f d ƒ } t | t ƒ } | j d ƒ | j ƒ | j ƒ d S( Ns ANALYZE TABLE `%s`.`%s`i s
ANALYZE TABLE( R t executeManagementQueryt _schemat _tableR R, R t runt refresh( Rq t resultt form( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRo è s
%
c C s( | j j j d k o' | j j j d k S( Ni i ( R t
serverVersiont majorNumbert minorNumber( Rq ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRE ï s c C sû y) | j j d | j | j f d ƒ } Wn9 t j k
rd } t d | j | j | f ƒ d } n X| rW| j ƒ } g } i } x< | j D]1 } t
| | j j ƒ ƒ r | j
| j ƒ q q Wxª | rnx‘ | D]‰ } | j d d ƒ j ƒ d k r| j | ƒ j ƒ | _ n t | | j d d ƒ j ƒ ƒ j | j | ƒ ƒ | j | ƒ | | j ƒ <qÒ W| j ƒ } qÅ Wy² | j j t t | d ƒ t | d ƒ ƒ ƒ | j j t t | d ƒ ƒ ƒ | j j t t | d ƒ ƒ ƒ | j j t t | d ƒ ƒ ƒ | j j t t | d
ƒ ƒ ƒ WqWt k
rS} t d | j | j | f ƒ qWXn y) | j j d | j | j f d ƒ } Wn9 t j k
r»} t d
| j | j | f ƒ d } n X| ró| j ƒ } | ró| j j | j d ƒ ƒ qón | j ƒ r÷y) | j j d | j | j f d ƒ } Wn9 t j k
rc} t d | j | j | f ƒ d } n X| r÷| j ƒ } | rô| j j | j d ƒ ƒ | j d ƒ } | d d k rÞ| j j d | j d ƒ | d f ƒ qñ| j j | ƒ qôq÷n d S( NsW select * from information_schema.tables WHERE table_schema = '%s' AND table_name = '%s'i s\ select * from information_schema.tables WHERE table_schema = '%s' AND table_name = '%s': %s
t t _RP RV RW RY RX s* Error displaying table info for %s.%s: %s
sl select count(*) column_count from information_schema.columns WHERE table_schema = '%s' and table_name = '%s'sq select count(*) column_count from information_schema.columns WHERE table_schema = '%s' and table_name = '%s': %s
RS s± SELECT @@datadir datadir,st.FILE_FORMAT,sd.path FROM information_schema.INNODB_SYS_TABLES st JOIN information_schema.innodb_sys_datafiles sd USING(space) WHERE st.name = '%s/%s's· SELECT @@datadir datadir,st.FILE_FORMAT,sd.path FROM information_schema.INNODB_SYS_TABLES st JOIN information_schema.innodb_sys_datafiles sd USING(space) WHERE st.name = '%s/%s'': %s
t FILE_FORMATt pathi t .s %s%st datadiri ( R Rw Rx Ry t grtt DBErrorR R t goToFirstRowt columnst hasattrR0 Rf R. t replacet stringFieldValueByNameRM t getattrRn t nextRowRZ R t intRV RW RY RX t ExceptionRS RE R[ R\ ( Rq t rsett et okRŠ t
column_valuest colR\ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ ò sd )
1 . $$)
)
*c C sU | | _ | | _ | j j t d | j j j d | | f ƒ t t ƒ | j
ƒ d S( Ns db.Table.32x32.pngs %s.%s( Rx Ry RK RN R R t
connectionR0 R, R1 R{ ( Rq R R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR 0 s 5(
t __name__t
__module__t captiont node_nameRA Rv Ro RE R{ R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR< J s ˜ >t TableDDLc B s/ e Z d Z d Z d „ Z d „ Z d „ Z RS( t DDLt structurec C sè t j j | t ƒ | j ƒ | j ƒ | | _ | j d ƒ | j d ƒ t j t ƒ | _
| j
j d ƒ | j | j
t t ƒ t j
ƒ | _ | j j t j ƒ | j j ƒ | j j t ƒ | j j ƒ | j | j t t ƒ d S( Ni i ( R R@ RA R, RB RC R Rk RL RJ t title_boxRN R1 t
CodeEditort code_editort set_languaget
LanguageMySQLt
set_read_only( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA ; s
c C sÀ y) | j j d | j | j f d ƒ } Wn9 t j k
rd } t d | j | j | f ƒ d } n X| r¼ | j ƒ } | r¼ | j j
t ƒ | j j | j
d ƒ ƒ | j j
t ƒ q¼ n d S( Ns show create table `%s`.`%s`i s! show create table `%s`.`%s` : %s
i ( R Rw Rx Ry R‡ Rˆ R R R‰ R¡ R¤ R, t set_valuet stringFieldValueR1 ( Rq R’ R“ R” ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ O s )
c C sL | | _ | | _ | j j t d | j | j f ƒ t t ƒ | j ƒ d S( Ns
DDL for %s.%s( Rx Ry RŸ RN R R, R1 R{ ( Rq R R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR ] s ,( R˜ R™ Rš R› RA R{ R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRœ 8 s
t CreateIndexFormc B s, e Z d „ Z d „ Z d „ Z d „ Z RS( c
C s t j j | t j j ƒ t j ƒ | | _ | | _ | | _ | | _ | | _ | | _
t j | j
ƒ | _ | j d | | f ƒ t j t ƒ } | j | ƒ | j d ƒ | j d ƒ t j ƒ } | j d ƒ | j d ƒ | j d ƒ | j d ƒ | j | t t ƒ | j t j d t ƒ d d d d t j ƒ t j t ƒ } | j d ƒ t j ƒ | _ | j | j t t ƒ t j ƒ | _! | j! j" d
d d d
g ƒ | j | j! t t ƒ | j | d d d d t j# t j Bt j$ Bƒ | j
d2 k rk| j t j d t ƒ d d d d t j ƒ t j ƒ | _% | j% j" d d g ƒ | j | j% d d d d t j ƒ n t j d ƒ } | j& t j' ƒ | j | d d d d t j t j# Bƒ t j( t j) t j* Bt j+ Bƒ | _, | j, j- t j. d d t ƒ | j, j- t j. d d t ƒ | j, j/ ƒ | j, j0 d d ƒ t j ƒ }
|
j d ƒ |
j d ƒ |
j d ƒ |
j d ƒ |
j | j, d d d d t j t j# Bt j$ Bt j1 Bƒ t j2 ƒ | _3 | j3 j4 d ƒ | j3 j5 | j6 ƒ | j3 j7 t ƒ t j2 ƒ | _8 | j8 j4 d ƒ | j8 j5 | j9 ƒ | j8 j7 t ƒ |
j | j3 d d d d t j# t j Bƒ |
j | j8 d d d d t j# t j Bƒ |
j t j d ƒ d d d d t j# t j Bt j1 Bƒ | j |
d d d d t j# t j Bƒ t j d ƒ } | j& t j' ƒ | j | d d d d t j t j# Bƒ t j: d ƒ | _; | j; j0 d d ƒ | j j
j< d! k s| j j
j< d! k r€| j j
j= d! k r€n | j; j> t ƒ | j | j; d d d d t j t j# Bƒ | j j
j< d! k põ| j j
j< d! k oõ| j j
j= d" k } | rt j d# ƒ } n t j d$ ƒ } | j> t ƒ | j? t j@ ƒ | j | d d d d! t j ƒ | j t j d% t ƒ d d d! d" t j ƒ t j ƒ | _A | jA j" d& d' d( g ƒ | jA j> | ƒ | j | jA d d d! d" t j ƒ | j t j d) t ƒ d d d" d t j ƒ t j ƒ | _B | jB j" d* d+ d, d- g ƒ | jB j> | ƒ | j | jB d d d" d t j ƒ t j t ƒ } | j d ƒ t j2 ƒ | _C | jC j4 d. ƒ t j2 ƒ | _D | jD j4 d/ ƒ t jE jF | | jC | jD ƒ | jG | t t ƒ | j0 d0 d1 ƒ | jH ƒ d S(3 Ns Create Index for Table %s.%si i i i i s Index Name:i i s
Non-Uniquet Uniquet FullTextt Spatialt memoryt heapt ndbs Type:t BTREEt HASHs Columns:i t ColumniÈ t Lengthi< iÿÿÿÿiP i s â–²s â–¼R s Comments:i i s
Create/Online Optionss,
Create/Online Options (requires MySQL 5.6+)s
Algorithm:t Defaultt Copyt InPlaces Locking:s/ Default (allow as much concurrency as possible)s) Exclusive (totally block access to table)s" Shared (allow queries but not DML)s None (allow queries and DML)t Createt Canceli& i ( R« s heapR (I R t FormRA t main_formt
FormNormalt _ownert _editorRx Ry t _columnst _engineR
R R~ t target_versionR RJ R, t set_contentRL Rk RD RF RG RH RI RN R1 R RO t newTextEntryR0 t newSelectort kindt add_itemst VFillFlagRQ R- t set_text_alignt TopRightt newTreeViewt TreeFlatListt TreeAltRowColorst TreeShowColumnLinesRŠ t
add_columnR t end_columnsRg t VExpandFlagRl t move_upRn R4 t move_row_upRp t move_downt
move_row_downt
newTextBoxt commentsR R€ t set_enabledR
R t algorithmt lockR” t cancelt Utilitiest add_end_ok_cancel_buttonst add_endt center(
Rq R2 R R R RŠ RP t contentt hboxR t tblt
online_ddl_okRu ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA d s¾ "
+
-+%&#
7))6&&?)?
+"+ "
c C s² | j j ƒ } | r® | j j | ƒ } | d k r® | j d ƒ | j d ƒ } } | j j ƒ j | d ƒ } | j d | ƒ | j d | ƒ | j ƒ | j j | ƒ q® n d S( Ni i ( RŠ t get_selected_nodet row_for_nodet
get_stringt root_nodet insert_childt
set_stringt remove_from_parentt select_node( Rq t nodet rowR0 t lengtht new_node( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRÏ Ø s
c C s¿ | j j ƒ } | r» | j j | ƒ } | | j j ƒ d k r» | j d ƒ | j d ƒ } } | j ƒ | j j ƒ j | d ƒ } | j d | ƒ | j d | ƒ | j j | ƒ q» n d S( Ni i (
RŠ Rà Rá t countRâ Ræ Rã Rä Rå Rç ( Rq Rè Ré R0 Rê Rë ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRÑ ä s
c
C sã d | j d j | j ƒ f } | j j | ƒ x0 | j D]% } | j j ƒ } | j d | ƒ q9 W| j | j | j
ƒ rßg } xz t | j j ƒ ƒ D]c } | j j
| ƒ } | j d ƒ } | j d ƒ } | rì | j d | | f ƒ q– | j | ƒ q– W| j j ƒ j ƒ } | j j ƒ d k r0d } n
d | } d | | j j ƒ t | d ƒ rtd
| j j ƒ j ƒ n d | j | j d j | ƒ f } | j j j d k sÕ| j j j d k rû| j j j d k rû| d
| j j ƒ j d d ƒ 7} n | j j j d k s:| j j j d k r| j j j d k r| d | j j ƒ j ƒ 7} | d | j j ƒ j ƒ j ƒ d 7} n y | j j | d ƒ t! SWqßt" j# k
rÛ} t$ j% j& d d | j' d d d d ƒ qßXn t! S( Ns idx_%s_%sR‚ i i s %s(%s)R R s( CREATE%s INDEX `%s` %s ON `%s`.`%s` (%s)R- s USING %ss , i s
COMMENT '%s't 's ''i s
ALGORITHM %ss LOCK %ss Create Indexs Error creating index.
%st OK(( Ry t joinR¼ R0 R¥ RŠ t add_nodeRå t run_modalR” R× t rangeRì t node_at_rowRâ R. R t get_string_valuet uppert get_selected_indexR‹ R- Rx R» R~ R R€ RÓ RŒ RÕ RÖ t splitt executeManagementCommandR1 R‡ Rˆ R RØ t
show_errorR7 (
Rq R0 t cRè RŠ t iR RÂ t sqlR“ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRz ð s@
\?&? * ( R˜ R™ RA RÏ RÑ Rz ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR§ c s t t TableIndexInfoPanelc B sJ e Z d Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( t IndexesR& c C sÅ t j j | t ƒ | j ƒ | j ƒ | j d ƒ | j d ƒ | | _ t j
| j j ƒ | _ d | _ t j ƒ } | j d ƒ | j d ƒ | j d ƒ | j d ƒ | j | t t ƒ | j t d ƒ d d d d t j ƒ t j t j t j Bt j Bƒ | _ | j j t j d d
t ƒ | j j t j d d t ƒ | j j t j d
d t ƒ | j j t j d d t ƒ | j j ƒ | j j! | j" ƒ | j j# d d ƒ | j | j d d d d t j t j$ Bƒ t j% t ƒ } | j t d ƒ t t ƒ t j& ƒ | _' | j' j( d ƒ | j' j) t ƒ | j' j* | j+ ƒ | j, | j' t t ƒ | j | d d d d t j t j- Bt j$ Bƒ t j ƒ | _. | j | j. d d d d t j t j- Bt j$ Bƒ | j. j d ƒ | j. j d ƒ | j. j d ƒ | j. j d ƒ | j. j d ƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _0 | j0 j1 t j2 ƒ | j. j | j0 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _3 | j3 j1 t j2 ƒ | j. j | j3 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _4 | j4 j1 t j2 ƒ | j. j | j4 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _5 | j5 j1 t j2 ƒ | j. j | j5 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _6 | j6 j1 t j2 ƒ | j. j | j6 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _7 | j7 j1 t j2 ƒ | j. j | j7 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _8 | j8 j1 t j2 ƒ | j. j | j8 d d d d t j t j- Bƒ | j. j t j/ d ƒ d d d d t j ƒ t j/ d ƒ | _9 | j9 j1 t j2 ƒ | j. j | j9 d d d d t j t j- Bƒ t j ƒ } | j d ƒ | j d ƒ | j d ƒ | j d ƒ | j | t t ƒ | j t d! ƒ d d d d t j t j- Bƒ t j t j t j Bt j Bƒ | _: | j: j t j d" d# t ƒ | j: j t j d d# t ƒ | j: j t j d$ d% t ƒ | j: j t j d& d' t ƒ | j: j ƒ | j: j; t j< ƒ | j | j: d d d d t j t j- Bt j$ Bt j= Bƒ t j% t ƒ } t j& ƒ | _> | j> j( d( ƒ | j> j* | j? ƒ | j, | j> t t ƒ | j | t t ƒ d S() Ni i i i i s Indexes in Tablei i t KeyiŒ t TypeiP R¨ i( t ColumnsiÈ i iÿÿÿÿs
Index Detailss
Drop Indexi s Key Name:R s Index Type:s Packed:s Allows NULL:s Unique:s Cardinality:s Comment:i s
User Comment:i s Columns in tableR° i– t Nullablei2 Rþ i, s$ Create Index for Selected Columns...(@ R R@ RA R, RB RC RL Rk R R
R R~ R¾ R Rv RD RF RG RH RI RN R1 R RO RÇ RÈ RÉ RÊ t
index_listRË R R RÌ t add_changed_callbackt index_selectedRg RÄ RJ Rl t
drop_indexRn RÔ R4 t
do_drop_indexRÚ RQ t infoR t key_nameR
R t
index_typet packedt allows_nullt
unique_valuest cardinalityt commentt user_commentt column_listt set_selection_modet TreeSelectMultipleRÍ t create_indext do_create_index( Rq R R t dhboxRÝ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA s¸
%#
)-0+,+,+,+,+,+,+,+,
,#
7c C sÜ | j j ƒ } | rØ | j d ƒ } t j j d d | | j | j f d d d ƒ t j k rØ y4 | j j
d | | j | j f d ƒ | j ƒ WqÕ t j
k
rÑ } t j j d d | j d d
d d ƒ qÕ XqØ n d S( Ni s
Drop Indexs% Drop index `%s` from table `%s`.`%s`?t DropR¶ R s DROP INDEX `%s` ON `%s`.`%s`i s Error dropping index.
%sRî ( R Rà Râ R RØ t show_messageRx Ry t ResultOkR Rø R{ R‡ Rˆ Rù R7 ( Rq Rè t indexR“ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR s :&c C s± g } x- | j j ƒ D] } | j | j d ƒ ƒ q W| r‘ t | | j | j | j | | j rl | j ƒ n d ƒ } | j
ƒ r | j ƒ q n t j
j d d d d d ƒ d S( Ni s Create Indexs( You have to select at least one column.
Rî R ( R t
get_selectionR. Râ R§ R Rx Ry Rv R Rz R{ R RØ t show_warning( Rq t colsRè R} ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR œ s 9 c C sñ | j j ƒ } | r]| j | j j | ƒ } | \ } } | j j | d ƒ | j j | d d k rm d n d ƒ | d d k rº | j rº | j ƒ d k rº | j j d | d ƒ n | j j | d ƒ | j j | d
ƒ | j
j | d ƒ | j j | d ƒ | j j | d
ƒ | j
j d d ƒ rJ| j j | d ƒ n | j j t ƒ n | j j t ƒ | j j d ƒ | j j d ƒ | j j d ƒ | j j d ƒ | j
j d ƒ | j j d ƒ | j j d ƒ | j j d ƒ d S( Ni i t 1t NOt YESt PRIMARYt innodbs %s (clustered)i i i i i i R ( R Rà t
index_infoRá R Rn R
Rv R
R R R R R¾ t# is_supported_mysql_version_at_leastR R RÔ R1 R, ( Rq Rè t idxR RŠ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR § s2 &+c C s | j | j | j ƒ d S( N( R Rx Ry ( Rq ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ Æ s c C sÓ | | _ | | _ | j j ƒ g | _ | j j ƒ t j j ƒ j d ƒ } t j j ƒ j d ƒ } | r«y# | j
j d | | f d ƒ } Wn3 t j
k
rà } t d | | | f ƒ d } n X| j j t j d ƒ ƒ rî t d ƒ } n t d ƒ } d d
d d g } x | D] } | j | ƒ qWi }
| r‰| j ƒ } d } d }
d } g } x| rë| j d
ƒ } | | k rw| r| j j ƒ } | j d | ƒ | j d | ƒ | j d |
ƒ | j d
| d k rÞd n d ƒ | j d d j g | D] } | d ^ qûƒ ƒ n g } | j j g | D] } | j | ƒ ^ q.| f ƒ | } | j d ƒ }
| j d ƒ } n | j d
ƒ } | |
k r¢| g |
| <n |
| j | ƒ | j g | D] } | j | ƒ ^ qÀƒ | j ƒ } q]W| r‰| j j ƒ } | j d | ƒ | j d | ƒ | j d |
ƒ | j d
| d k rLd n d ƒ | j d d j g | D] } | d ^ qiƒ ƒ q‰n y# | j
j d | | f d ƒ } Wn3 t j
k
rá} t d | | | f ƒ d } n X| rÏ| j ƒ } x± | r¤| j j ƒ } | j d | ƒ | j d | j d ƒ ƒ | j d | j d ƒ ƒ | j d
| j d
ƒ ƒ | j d d j |
j | j d ƒ g ƒ ƒ ƒ | j ƒ } q÷WqÏn$ | j j ƒ | j j ƒ | j ƒ d S( Ns db.Column.16x16.pngs db.Index.16x16.pngs SHOW INDEX FROM `%s`.`%s`i s- Cannot execute SHOW INDEX FROM `%s`.`%s`: %s
s 5.6i
i i i i i i i R R R s , i
s SHOW COLUMNS FROM `%s`.`%s`s/ Cannot execute SHOW COLUMNS FROM `%s`.`%s`: %s
( Rx Ry R t clearR# R R t AppR+ t get_resource_pathR Rw R‡ Rˆ R R R¾ R$ R
t fromstrRò t removeR‰ R¦ Rð t
set_icon_pathRå Rï R. R R ( Rq R R t column_icont
index_iconR’ R“ t index_rs_columnst column_rs_columnsRû t column_to_indexR” t curnamet itypet
non_uniqueRŠ R0 Rè Rú t cname( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR Ê s
#
"32 )"6#
.
(
R˜ R™ Rš R› RA R R R R{ R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRý s v t TableManDefsc B s e Z d „ Z d „ Z RS( c C sÀ g } xˆ t | j ƒ D]w \ } \ } } } } } | rY | j j t j | ƒ ƒ rY q n y | j d | d ƒ Wq | j d | ƒ q Xq W| j i | j d 6| j d 6d j
| ƒ d 6S( Ns `%s`t fieldR R s , RŠ ( t enumerateRŠ R¾ R$ R
R) R. t
show_queryR R Rï ( Rq R Rû t field_objt ctypeRš t widtht min_version( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt get_query s +"c C s | | _ | | _ | j ƒ d S( N( R R R{ ( Rq R R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR & s ( R˜ R™ R= R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR5 s t TableTriggerManagerc
B sÅ e Z d Z d Z d e d d d f d e d d d f d e d d d f d e d d d f d e d
d d f d e d d d f d e d
d d f d e d d d f d e d d d f g Z d „ Z RS( i s0 show triggers from `%(schema)s` like '%(table)s't Triggert NameiÈ t Eventid t Timingt Createdt sql_modes SQL Modet Definert character_set_clients Client Character Sett collation_connections Connection Collations Database Collationc C s+ t j | | d ƒ | j ƒ | j ƒ d S( N( R RA R RB RC ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA 8 s
N( R˜ R™ t icon_columnR8 R R R RŠ RA ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR> + s t TableColumnManagerc
B sË e Z d Z d Z d Z d e d d d f d e d d d f d e d d d f d
e d d d f d
e d d d f d e d d d f d e d d d f d e d d d f d e d d d f g Z d „ Z RS( sq select %(columns)s from information_schema.columns where table_schema = '%(schema)s' and table_name = '%(table)s'i t COLUMN_NAMER° i– t COLUMN_TYPER ix t COLUMN_DEFAULTs
Default Valuet IS_NULLABLER i2 t CHARACTER_SET_NAMEs
Character SetiP t COLLATION_NAMEt Collationid t
PRIVILEGESt
PrivilegesiÈ t EXTRAt Extrat COLUMN_COMMENTt Commentsc C s+ t j | | d ƒ | j ƒ | j ƒ d S( N( R RA R RB RC ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA K s
N(
R˜ R™ R8 RH t name_columnR R R RŠ RA ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRI > s t ConstraintManagerc B s¹ e Z d Z d Z d Z d Z d Z d Z d e d d d f d e
d d
d f d e
d d
d f d
e
d d
d f d e
d d
d f d e
d d
d f d e
d d
d f g Z d „ Z RS( i s Foreign keyss db.Constraintst constraintssT select %(columns)s FROM information_schema.KEY_COLUMN_USAGE WHERE ((REFERENCED_TABLE_SCHEMA = '%(schema)s' AND referenced_table_name = '%(table)s') OR (TABLE_SCHEMA='%(schema)s' and table_name = '%(table)s')) AND REFERENCED_TABLE_NAME is not null ORDER BY TABLE_NAME, COLUMN_NAME;t constraint_nameR@ iÈ t constraint_schemat Schemaid t
table_namet Tablet column_nameR° t referenced_table_schemas Referenced Schemat referenced_table_names Referenced Tablet referenced_column_names Referenced Columnc C s+ t j | | d ƒ | j ƒ | j ƒ d S( N( R RA R RB RC ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA a s
N(
R˜ R™ RH Rš t klassR› R8 RW R R R RŠ RA ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRX P s t PartitionManagerc B sm e Z d Z d Z d Z d Z d Z d Z d e d d d+ f d e
d d
d+ f d e d d
d+ f d
e d d
d+ f d e
d d
d+ f d e
d d
d+ f d e
d d
d+ f d e
d d
d+ f d e
d d
d+ f d e d d
d+ f d e d d
d+ f d e d d
d+ f d e d d
d+ f d! e d" d
d+ f d# e
d$ d% d+ f d& e
d' d% d+ f d( e
d) d% d+ f g Z d* „ Z
RS(, t
Partitionss
db.Partitionst
partitionssÓ select %(columns)s FROM information_schema.partitions WHERE TABLE_SCHEMA = '%(schema)s' AND TABLE_NAME = '%(table)s' AND PARTITION_NAME IS NOT NULL ORDER BY PARTITION_NAMEi t partition_nameR@ iÈ t subpartition_names Subpartiton Nameid t partition_ordinal_positions Ordinal Post subpartition_ordinal_positions Subpartiton Ordinal Post partition_methods Partition Methodt subpartition_methods Subpartition Methodt partition_expressions Partition expressiont subpartition_expressions Subpartition expressiont partition_descriptions Partition descriptionRT s
Table rowsRU s AVG row lengthRV s Data lengthRX s max data lengthRW s Index lengthR^ s Create timei– R] s Update timet
check_times
Check timec C s+ t j | | d ƒ | j ƒ | j ƒ d S( N( R RA R RB RC ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA € s
N( R˜ R™ Rš Rc R› R8 RW RH R R R R RŠ RA ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRd f s0 t GrantsTableManagerc B sD e Z d Z d Z d Z d Z d „ Z d „ Z d „ Z d „ Z RS( s Table privilegess db.Grantst table_privilegesi c C sD g | _ t j | | d ƒ | j ƒ | j ƒ | j j t ƒ d S( N( RŠ R RA R RB RC t refresh_btnt showR, ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA ‹ s
c C s_ t | j ƒ d k r d Sd } y | j j | d ƒ } Wn‚ t j k
r¼ } | j d d k ss | j d d k r— | j d d | | j d f ƒ n! | j d d | | j d f ƒ d SXd
t d d d f d
t d d d f d t d d d f g | _ | j
ƒ } | r[xJ | j d ƒ d d j d ƒ D]% } | j j
| t | d d f ƒ q/Wn d S( Ni s9 show columns from `mysql`.`tables_priv` like 'table_priv'i i iv s Access ErrorsC The current user does not have enough privileges to execute %s.
%ss MySQL ErrorsN An error occurred retrieving information about the schema.
Query: %s
Error: %st usert Userid t hostt Hostt scopet ScopeR i iþÿÿÿs ','i2 ( t lenRŠ R Rw R‡ Rˆ R7 Rù R R R‰ R R÷ R. ( Rq t queryR’ R“ R” R– ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt preload_columns• s" &$! 'c C s1 t | j ƒ d k r g Sg } g } g } x¾ t | j ƒ D] \ } \ } } } } } d }
y | d }
Wn
| }
n X|
d k rΠq; n |
d k rÛ | j d |
j d d ƒ |
f ƒ | j d |
j d d ƒ ƒ q; | j |
ƒ q; W| j d
i d j | ƒ d 6d
j | ƒ d 6ƒ | j d i d j | ƒ d 6| j d 6ƒ g } g } x¡ t | j ƒ D] \ } \ } } } } } d }
y | d }
Wn
| }
n X|
d k rµqdn |
d k rç| j d |
j d d ƒ |
f ƒ qd| j |
ƒ qdW| j d i d j | ƒ d 6| j d 6| j d 6ƒ | S( Ni R6 Ry Ru Rw s %s_priv AS '%s'R R‚ s
%s_priv = 'Y'sP SELECT '<global>' as scope,%(sel_fields)s FROM mysql.user WHERE %(where_fields)st ,t
sel_fieldss OR t where_fieldssJ SELECT Db as scope,%(sel_fields)s FROM mysql.db WHERE '%(schema)s' like dbR s6 IF(FIND_IN_SET('%s',Table_priv) = 0, 'N', 'Y') AS '%s'sŠ SELECT CONCAT(Db,'.',Table_name) as scope,%(sel_fields)s FROM mysql.tables_priv WHERE '%(schema)s' LIKE Db AND '%(table)s' LIKE Table_nameR ( s users host( s users host( R{ RŠ R7 R R. RŒ Rï R R ( Rq t outputt fieldst fields_whereRû R9 R: Rš R; R< R6 ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR= sD +
# 1++
&5c C s? | j j ƒ x! | j ƒ D] } | j | ƒ q W| j ƒ d S( N( t treeR& R= t preload_datat refresh_row_count( Rq R| ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ Ú s
(
R˜ R™ Rš Rc R› RW RA R} R= R{ ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRq † s
-t GrantsColumnManagerc B sD e Z d Z d Z d Z d Z d „ Z d „ Z d „ Z d „ Z RS( s Column privilegess db.Grantst column_privilegesi c C sD g | _ t j | | d ƒ | j ƒ | j ƒ | j j t ƒ d S( N( RŠ R RA R RB RC Rs Rt R, ( Rq R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA å s
c C s_ t | j ƒ d k r d Sd } y | j j | d ƒ } Wn‚ t j k
r¼ } | j d d k ss | j d d k r— | j d d | | j d f ƒ n! | j d d | | j d f ƒ d SXd
t d d d f d
t d d d f d t d d d f g | _ | j
ƒ } | r[xJ | j d ƒ d d j d ƒ D]% } | j j
| t | d d f ƒ q/Wn d S( Ni s; show columns from `mysql`.`columns_priv` like 'Column_priv'i i iv s Access ErrorsC The current user does not have enough privileges to execute %s.
%ss MySQL ErrorsN An error occurred retrieving information about the schema.
Query: %s
Error: %sRu Rv id Rw Rx Ry Rz R i iþÿÿÿs ','i2 ( R{ RŠ R Rw R‡ Rˆ R7 Rù R R R‰ R R÷ R. ( Rq R| R’ R“ R” R– ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR} î s" &$! 'c
C s t | j ƒ d k r g Sg } g } x¡ t | j ƒ D] \ } \ } } } } } d } y | d } Wn
| } n X| d k r† q5 n | d k r¸ | j d | j d d ƒ | f ƒ q5 | j | ƒ q5 W| j d i d
j | ƒ d 6| j d 6| j d
6ƒ | S( Ni R6 Ry Ru Rw s7 IF(FIND_IN_SET('%s',Column_priv) = 0, 'N', 'Y') AS '%s'R R‚ s› SELECT CONCAT(Db,'.',Table_name,'.',Column_name) as scope,%(sel_fields)s FROM mysql.columns_priv WHERE Db LIKE '%(schema)s' AND Table_name LIKE '%(table)s'R~ R R R ( s users host( R{ RŠ R7 R R. RŒ Rï R R (
Rq R R‚ Rû R9 R: Rš R; R< R6 ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR= s" +
&5c C s? | j j ƒ x! | j ƒ D] } | j | ƒ q W| j ƒ d S( N( R„ R& R= R… R† ( Rq R| ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ s
(
R˜ R™ Rš Rc R› RW RA R} R= R{ ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR‡ à s t
GrantsManagerc B s2 e Z d Z d Z d Z d Z d „ Z d „ Z RS( t Grantss db.Grantst grantsi c C sÜ t j j | t ƒ | j ƒ | j ƒ | | _ | j d ƒ | j d ƒ t j t ƒ } | j d ƒ t
| j ƒ | _ | j t
| j j ƒ t t ƒ | j | j t t ƒ t j t t ƒ } | j | d ƒ t j t ƒ } | j d ƒ t | j ƒ | _ | j t
| j j ƒ t t ƒ | j | j t t ƒ | j | d ƒ | j | t t ƒ t j t ƒ | _ | j j d ƒ | j | j t t ƒ t j ƒ | _ | j j d ƒ | j j | j ƒ | j j | j t t ƒ d S( Ni i iÈ iÜ t Refresh( R R@ RA R, RB RC R RL Rk RJ Rq t grants_tableRN R Rš R1 t newSplitterR‡ t
grants_columnRu Rl Rs Rn R4 R{ RÚ ( Rq R t tbl_boxt splittert col_box( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA ' s6
c C s6 | j j | j | j ƒ | j j | j | j ƒ d S( N( R R R R R ( Rq ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR{ M s ( R˜ R™ Rš Rc R› RW RA R{ ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR‰ " s &R c B s# e Z d „ Z d „ Z d „ Z RS( c C sA i | _ g | _ t j j | t d t ƒ | j ƒ | j ƒ t j ƒ | _ | j
| j t t ƒ t t
t t t t t t g } d } x² | D]ª } yg | | ƒ } t | d | j | ƒ | | j | j <| j j | | j ƒ | j j | ƒ | d 7} Wq t k
r8d d l } t d | j | j ƒ f ƒ q Xq Wd S( NR i t tab_i iÿÿÿÿs Error initializing tab %s: %s
( t tab_listt pagesR t AppViewRA R, RB RC t
newTabViewt tabRN R1 R< RI Rý R> RX Rd R‰ Rœ t setattrR› t add_pageRš R. R‘ t tracebackR t
format_exc( Rq R t tabsRû t TabR˜ R› ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyRA S s(
c C sP x! | j D] } | j | | ƒ q
W| j | j d j | j | j d _ d S( NR> R& ( R• R R” Rv ( Rq R R R˜ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR o s c C s5 | j j | ƒ } | d k r1 | j j | ƒ n d S( N( R” R+ R R˜ t set_active_tab( Rq R R% ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR y s ( R˜ R™ RA R R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyR R s
(& R R‡ Rd t
workbench.logR t sqlide_catalogman_extR R R R R R R t wb_admin_utilsR t workbench.utilsR R
R R R# R; R@ R< Rœ R· R§ Rý R5 R> RI RX Rd Rq R‡ R‰ R– R ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.pyt <module> s6 î+´ÿ ZB 0