| 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 @ s
d d l Z d d l Z d d l m Z m Z d d l m Z m Z m Z m Z m Z d d l
m Z d d l m
Z
d d l m Z m Z e d Z d Z d e j f d
YZ d Z d e j f d
YZ d e f d YZ d e j f d YZ d e j f d YZ d e f d YZ d e f d YZ d e f d YZ d e f d YZ d e f d YZ! d e f d YZ" d e f d! YZ# d" e f d# YZ$ d$ e j f d% YZ% d& e j& f d' YZ' d S(( iN( t log_errort log_warning( t IconStringColumnTypet StringColumnTypet LongIntegerColumnTypet IntegerColumnTypet NumberWithUnitColumnType( t NotificationCenter( t make_panel_header( t
human_sizet Versionc C s y | j d d Wn= t j k
rS } t j j d d d d d t d t SXxo | D]g } t | | } t j | j
} | j | d d | j | | j
| | r[ | j q[ q[ Wd S( Ns select 1i s Schema InspectorsF Can not launch the Schema Inspector because the server is unreacheble.t OKt sG Can not launch the Schema Inspector because the server is unreacheble.
( t executeManagementQueryt grtt DBErrort mformst Utilitiest
show_errorR t Falset
SchemaManagert fromgrtt dockingPointt dock_viewt select_viewt set_titlet show_table_maintenance( t editort selectiont table_maintenancet et schema_namet smant dpoint( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt show_schema_manager s
c s t j | d } | d } g x4 | D], } | j d k rR j | j q* d Sq* W r t j d } | j f d | j d | n d S( Nt menuR s db.Schemas Schema Inspectorc s
t S( N( R" ( ( t schemas_selectedt sender( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt <lambda>? s i ( R R t typet appendt namet newMenuItemt add_clicked_callbackt insert_item( R) R% t argsR# R t st item( ( R$ R% sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt handleLiveTreeContextMenu/ s
t MaintenanceResultFormc B s& e Z e d Z d Z d Z RS( c C s7 t j j | t j j t j t j t | _ | j j d | j j d | j
| j t j t j t j
Bt j B | _ | j j t j | j j | j t t | j j t j d d t | r | j j t j d d t n8 | j j t j d d t | j j t j d d
t | j j | | _ t j j } i | j d d 6| j d
d 6d d 6| j d d 6| j d d 6} | j } x | ry| j j } | j d | j d | sQ| j d | j d | j d | j | j d d | j d | j d | j! | j d n | j d | j d | j" } qWt j t } | j j | t t t j# } | j$ | j% | j& d | j | t t t j# | _' | j' j& d | j' j$ | j( | j) | j' t t | j* d d
d S( Ni i t Tablei t Checksumid t OperationiP t Messagei s mini_ok.pngt statuss mini_error.pngt errorR t infos mini_notice.pngt notes mini_warning.pngt warningi i i i s Copy to ClipboardR i (+ R t Formt __init__t main_formt
FormNormalt newBoxR t boxt set_paddingt set_spacingt set_contentt newTreeViewt TreeFlatListt TreeAltRowColorst TreeShowColumnLinest treet set_selection_modet TreeSelectMultiplet addt Truet
add_columnR R t end_columnst _checksumt Appt gett get_resource_patht goToFirstRowt add_nodet
set_stringt stringFieldValuet
set_icon_patht set_tagt nextRowt newButtonR+ t copy_to_clipboardt set_textt okt closet add_endt set_size( t selft resultst checksumt appt icon_pathR] t nodet bboxt copy( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< C sX "#
%
c C s g } x | j j pI g t | j j D] } | j j | ^ q. D]o } | j d | j d g } | j s | j | j | j | j d n | j d j | qJ Wt
j j d j | d S( Ni i i s s
(
RH t
get_selectiont ranget countt node_at_rowt
get_stringRO R( t get_tagt joinR R t set_clipboard_text( Ra t rowst iRf t row( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR[ ~ s J c C s | j | j d d S( N( t run_modalR] t None( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt run s ( t __name__t
__module__R R< R[ Rv ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR1 B s ;
c C sb | d j | } | j | d } t | | j d } | j | d j | j d S( Ns , i t CHECKSUMR ( Ro R
R1 t
startswithR t stripRv ( R t actionR t queryt resultt form( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt do_table_maintenance s
t
ObjectManagerc B s e Z d Z d Z d Z d Z g Z d Z d Z d Z
d Z d Z d Z
d Z d Z d Z d
Z RS( s task_error.pngc
C s/ t j j | t | j | j | | _ | | _ t j | j
| _ t j t | _
| j | j
t t t j d | _ | j j t j t j d | _ t j t | _ | j j d | j j d | j j | j t t | j j | j t t | j | j t t | j j t | j
j d | j
j d t j t j t j Bt j B | _ | j j t j t | d rt! t" | d r| j# n xa | j$ D]V \ } } } } } | r| j j% t j& | rqn | j j' | | | t qW| j j( | j j) t | j
j | j t t t j* | _+ | j+ j, | j- | j j. | j/ | j j0 | j+ t j1 j2 j3 | j4 d | _5 t j1 j2 j3 | j6 | _6 t j d | _7 | j7 j8 d t j9 | _: | j: j8 d | j: j; | j< t j t | _= | j= j d | j
j | j= t t | j= j | j7 t t | j= j> | j: t t x | j? D]| \ } } | s| j= j t j d t t qn t j9 } | j8 | | j; t" | | | j= j | t t qWd S( NR i t preload_columnss
.16x16.pngt Refresht (@ R t BoxR< R t set_managedt set_release_on_addt schemaR R
R t
serverVersiont target_versionR? t mainRK RL t newLabelt
error_headingt set_stylet BoldStylet
error_bodyt error_boxRB RA t showRD RE RF RG RH RI RJ t hasattrt callablet getattrR t columnst# is_supported_mysql_version_at_leastt fromstrRM RN t set_allow_sortingt newContextMenuR# t add_will_show_callbackt menu_will_showt add_activated_callbackt on_activatet set_context_menuRP RQ RR t klassRe t
bad_icon_patht row_countR\ RZ t refresh_btnR+ t refreshRg R_ t actions(
Ra R R t fieldR' t captiont widtht min_versiont
callback_namet btn( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< sn
#$
"
"
c C sD | j j t | j j t | j j | | j j | d S( N( R R R R RL R R\ R ( Ra t titlet msg( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C s! | j j d | j j d S( Ns Count: %d( R R\ RH Rk ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt refresh_row_count s c C s d d l m } | d k r | j d k r_ | | j | j | j | j j d f g q | j d k r t | d r | | j | j | j | j
j d f g d q n d S( Ni( t show_table_inspectors db.Tablet utf8s db.Indext parent_name_columnt indexes( t sqlide_tableman_extR Ru R R R Rm t name_columnt encodeR R ( Ra Rf t colR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s 4 c C sk | d k rg| j j | d k rgi } t j } d } x| j j D] } | j | j } t j j
} | | _ | j | _
| j | _ t | d r3t | d r | j } n | j | j } | j | r | | | _ q3t j j
} | | _ d | _ | | _ | j | _
| | | <n | j | qM W| r| j rt j j
} | j | _
| j | _ | j | t j j
} | j | _
| j | _ d | _ | | _ n t j d t j }
|
j d | j j |
| j j d | j d t j } | | d <t j | j d
| d <t | d <t! j" d
| j# | qgn d S( NR t tables db.Tables db.SchemaR t bottom_plugins_separatorR R R t ContextMenuR# t schema_inspectort GRNLiveDBObjectMenuWillShow($ Ru R# t
remove_allR t ListRH Ri Rm R t classest db_query_LiveDBObjectR) R t
schemaNameR R' R R R t has_keyt ownerR( t node_nameR R* t SeparatorMenuItemt set_namet add_itemt add_item_with_titleR t Dictt togrtRL R t sendR ( Ra R/ t parent_nodesR t pobjRf R) t objt parent_namet sobjt separatorR- ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR sX
c C s g } x| | j D]q \ } } } } } | rM | j j t j | rM q n y | j d | d Wq | j d | q Xq W| j i | j d 6d j | d 6S( Ns `%s`R R s , R ( R R R R
R R( t
show_queryR Ro ( Ra t colst field_objt ctypeR R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt get_query0 s "c C sf y | j j | d } Wn t j k
r } | j d d k sT | j d d k r t j j d d | | j d f d d d n- t j j d d
| | j d f d d d d SX| j } x| ra| j s | j | rR| j
j } | j | r-| j
d Gd GH| j | j | j n( | j d k rU| j | j | j n d } x| j D]\ } } } }
} | r| j j t j | rqen d } d }
y | d
} | d }
Wn
| }
n X| t j k r;t |
t k r| j | | j |
pd qA| j | | j |
p4d n| t j k rt |
t k r| j | t | j! |
pzd qA| j | t | j
|
pd n t |
t k r| j" | | d k r| j! |
pd n | | j! |
n@ | j" | | d k r+| j
|
p=d n | | j
|
| d 7} qeWn | j# } q Wd S( Ni i i iv s Access ErrorsC The current user does not have enough privileges to execute %s.
%sR R s MySQL ErrorsN An error occurred retrieving information about the schema.
Query: %s
Error: %st Names IS CORRUPTEDt format_funcR ($ R R
R R R- R R R RS t filterRH RT t is_row_corruptedt stringFieldValueByNameRW t icon_columnR Ru Re R R R R
R R R' t intt set_intt
intFieldValuet intFieldValueByNameR t set_longt longRV RU RY ( Ra R} t rsetR R] Rf Rr R R R R R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt preload_data; sP &0- "
""((C@c C s. | j j | j | j | j d S( N( RH t clearR R R ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR j s
c C s, | j j } | r( | j | d n d S( Ni ( RH t get_selected_nodeR ( Ra Rf ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt
inspect_tablep s c C s t S( N( R ( Ra R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR u s N( Rw Rx Ru R R R R R R< R R R R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s I : / t TableManagerc B s e Z d Z d Z d Z d Z d1 Z d Z d Z d e
d d d1 f d e d d d1 f d e d d
d1 f d e d d
d1 f d e d d d1 f d e d d
d1 f i d d 6d d 6e
d d
d1 f i d d 6d d 6e
d d
d1 f i d d 6d d 6e
d d
d1 f i d d 6d d 6e
d d d1 f d e d! d d1 f d" e d# d$ d1 f d% e d& d$ d1 f d' e d( d$ d1 f d) e d) d
d1 f d* e d* d d1 f d+ e d+ d, d1 f g Z d- Z d. Z d/ Z d0 Z RS(2 t Tabless db.Tablet tablesi s; show table status from `%(schema)s` where Comment <> 'VIEW'R i t Enginei< R
i2 t
Row_formats
Row Formatid t RowsiP t Avg_row_lengths Avg Row Lengtht Data_lengthR c C s | r t t | Sd S( NR ( R R ( t x( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR& s R s Data Lengtht Max_data_lengthc C s | r t t | Sd S( NR ( R R ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR& s s Max Data Lengtht Index_lengthc C s | r t t | Sd S( NR ( R R ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR& s s Index Lengtht Data_freec C s | r t t | Sd S( NR ( R R ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR& s s Data Freet Auto_increments Auto Incrementt Create_times Create Timei t Update_times Update Timet
Check_times
Check Timet CollationR3 t Commenti c C s | j d S( NR ( R ( Ra R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C s g | _ t j | d S( N( t table_namesR R ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C s | j j | j d t S( NR ( R R( R RL ( Ra R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C sm g } x` | j j D]O } t j j } | j | j | _ | j | _ | j
| _ | j | q W| S( N(
RH Ri R R R Rm R R) R R R R' R( ( Ra R Rf R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyRi s N( Rw Rx R R R R Ru R R R R R R R R R R R Ri ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR y s8 #### t TableMaintenancePanelc B sG e Z d Z d Z d Z d Z d Z d Z d Z RS( c s t j j t j j | _ j d j d t j d } | j
t j j | t t
t j d } j | t t
t j d _ j j t
t
t j t _ j j d j j d j j j g _ d d f d } t j _ j j d | j d d d
j g | j j d k s| j j d k r| j j d k rt j t
} | j d
t j _ j j d j j j | j j t t
t j d } | j d d | j | t t
| j t j d t t
t j _ j j d d j j! t | j j t t
| j" d d } | r| j# r j j$ | j% d qn d } d _ t j _& j& j d | j' d' d d j& g | t j( _) j) j* d d d d d g t j _+ j+ j d t j _, j, j d j) j+ j, g } | j- d( d! d" | t j _. j. j d# j. g } | j/ d) d% d& | d S(* Ni i s Table Maintenance Operationss Select tables and click the operation you want to perform.
NOTE: Some commands may require locking tables until completion,
which may take a long time for large tables.i c
sm t j | } | j t j j j | t t t j | } j j | t t | ry j j | t t n t j t } | j d t j
} | j t j j
j d | j | | j | t t x! | D] } | j | t t q Wt j } | j | | j | j | j | t t j j | j j | t t d S( Ni s mini_notice.png( R R R R t contentRK R RL R? RB t newImageBoxt set_imageRP RQ RR t set_tooltipRZ R+ R\ R{ R_ t _buttonsR( (
R R t desct tooltipt optionst
extra_optionst lt hbt oR ( Ra ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt make_command_box s*
s Don't write to BINLOG (local)s
Analyze Tables Analyzes and stores the key distribution for a table.
During the analysis, the table is locked with a read lock for InnoDB and MyISAM.s With InnoDB tables, when you enable the innodb_stats_persistent option, you must run ANALYZE TABLE after loading substantial data into an InnoDB table, or creating a new index for one.
MySQL uses the stored key distribution to decide the order in which tables should be joined when you perform a join on something other than a constant. In addition, key distributions can be used when deciding which indexes to use for a specific table within a query.i i i s Optimize FULLTEXT onlyR i is$ Number of words to optimize per run:i2 s1 SHOW VARIABLES LIKE 'innodb_ft_num_word_optimize'i s
s Optimize Tables Reorganizes the physical storage of table data and associated index data,
to reduce storage space and improve I/O efficiency when accessing the table.s The exact changes made to each table depend on the storage engine used by that table.
Use OPTIMIZE TABLE in these cases, depending on the type of table:
* After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file. The table and indexes are reorganized, and disk space can be reclaimed for use by the operating system.
* After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. Set the configuration option innodb_optimize_fulltext_only=1 first. To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run Optimize Table until the search index is fully updated.t Quickt Mediumt Extendeds For Upgradet Fastt Changeds Check Tablesl CHECK TABLE checks a table or tables for errors.
For MyISAM tables, the key statistics are updated as well.s The FOR UPGRADE option checks whether the named tables are compatible with the current version of MySQL. With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created.
Check Options:
- QUICK Do not scan the rows to check for incorrect links. Applies to InnoDB and MyISAM tables and views.
- FAST Check only tables that have not been closed properly. Applies only to MyISAM tables and views; ignored for InnoDB.
- CHANGED Check only tables that have been changed since the last check or that have not been closed properly. Applies only to MyISAM tables and views; ignored for InnoDB.
- MEDIUM Scan rows to verify that deleted links are valid. This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys. Applies only to MyISAM tables and views; ignored for InnoDB.
- EXTENDED Do a full key lookup for all keys for each row. This ensures that the table is 100% consistent, but takes a long time. Applies only to MyISAM tables and views; ignored for InnoDB.s Quick (if supported)s Checksum Tables> CHECKSUM TABLE reports a checksum for the contents of a table.s You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state.s
Optimize Tables
Check Tables
Checksum Table(0 R R R< R R R R RB RA R R t BigStyleRK RL t newScrollPanelt scrollR? R R Ru t newCheckBoxt
analyze_localR\ t
analyze_tableR t majorNumbert minorNumbert optimize_ft_onlyR+ t optimize_ft_only_toggledR` t newTextEntryt optimize_ft_numwordst set_enabledR
RS t set_valueRV t optimize_localt optimize_tablet newSelectort check_scan_optt add_itemst check_fast_optt check_changed_optt check_tablet checksum_quickt checksum_table( Ra R t headingt helpR R R R~ R ( ( Ra sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< s
6
c C s | j j | j j d S( N( R R R t
get_active( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR D s c C s9 | j j r d n d } t | j d | | j d S( Ns NO_WRITE_TO_BINLOGR s ANALYZE%s TABLE %%s( R R' R R t
table_list( Ra t local( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR H s c C s | j r d } | j j d d } | rN | j rN | j d d k } n d | j j rf d n d | j j f } | j j | d n | j
j r d n d } t | j d
| | j | j r | d k r d | } | j j | d n d S( Ns& SELECT @@innodb_optimize_fulltext_onlyi t OFFsK SET GLOBAL innodb_optimize_fulltext_only=%s, innodb_ft_num_word_optimize=%st 1t 0i s NO_WRITE_TO_BINLOGR s OPTIMIZE%s TABLE %%ss+ SET GLOBAL innodb_optimize_fulltext_only=%s(
R Ru R R
RS RV R' R t get_string_valuet executeManagementCommandR R R( ( Ra t old_valuet rest commandR) ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR L s .
c C sk | j j } | | j j r' d n d 7} | | j j rF d n d 7} t | j d | | j d S( Ns FASTR s CHANGEDs CHECK TABLE %%s %s( R R- R R' R! R R R( ( Ra t option( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR" ] s c C s9 | j j r d n d } t | j d | | j d S( Ns QUICKR s CHECKSUM TABLE %%s%s( R# R' R R R( ( Ra R2 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR$ c s c C s` g | D] \ } } d | | f ^ q | _ x- | j D]" } | j t | j d k q6 Wd S( Ns `%s`.`%s`i ( R( R R t len( Ra R R R t enginet b( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt show_tablesh s ,( Rw Rx R< R R R R" R$ R6 ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s t TableManagerParentc B sM e Z d Z e d Z d Z d Z d Z d Z d Z RS( c C s t j j | t t | j | j | | _ | | _ t | | | _
| j | j
d t | j
j | _ | j
j
| _
| j
j j | j t j | _ | j j d | j j | j | j
j j | j t t | j j t t j | _ | j j d | j j | j
j | j
j j | j t t t j | _ | j j d | j j | j | j
j j | j t t d | _ d S( Nid s < Summary Lists
Inspect Tables
Maintenance >( R t SplitterR< RL R R R R R R t summary_viewRK R R RH t add_changed_callbackt table_selection_changedRZ t
goback_btnR\ R+ t switch_backRg R t inspect_btnR R_ t maintenance_btnt switch_maintenanceRu t
right_view( Ra R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< o s0
c C s
| j j S( N( R9 R ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C s | j j d S( N( R9 R ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s c C sl | j r% | j | j d | _ n | j j j t | j j t | j j t | j
j t d S( N( RA t removeRu R9 R R RL R? R< R R> ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR= s c C s t | j | _ | j | j | j | j j | j d | j j | j | j | j j
j t | j
j t | j j t | j j t d S( Ni ( R R RA RK t relayoutt set_divider_positionR6 R t selected_tablesR9 R R R R? R< RL R> ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR@ s
c C sL g } x? | j j j D]+ } | j | j d | j d f q W| S( Ni i ( R9 RH Ri R( Rm ( Ra R Rf ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyRE s )c C s, | j r( | j j | j | j n d S( N( RA R6 R RE ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR; s (
Rw Rx R< t propertyR R R= R@ RE R; ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR7 n s ! t
ColumnManagerc B s e Z d Z d 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 g
Z
RS(! t Columnss db.ColumnR sJ select * from information_schema.columns where table_schema = '%(schema)s'i i t
TABLE_NAMER2 i t COLUMN_NAMEt Columnt COLUMN_TYPEt Typeix t COLUMN_DEFAULTs
Default Valuet IS_NULLABLEt Nullablei2 t CHARACTER_SET_NAMEs
Character SetiP t COLLATION_NAMER id t
PRIVILEGESt
Privilegesi t EXTRAt Extrat COLUMN_COMMENTt CommentsN( Rw Rx R R R Ru R R R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyRG s$ t IndexManagerc B sT e Z d Z d 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 i d
d 6d d
6e 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 d# Z d$ Z RS(& t Indexess db.IndexR s- show index from `%(table)s` from `%(schema)s`i i R2 i t Key_nameR t
Non_uniqueR c C s | d k r d Sd S( NR+ t Yest No( ( t val( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR& s R t Uniquei2 t
Index_types
Index Typet
Index_comments
Index Comments 5.5t Column_nameRK id t Seq_in_indexs Seq in Indext PackedR t Cardinalityt Sub_parts Sub partt Nullt NULLR c C s, t j | | | | | _ | j | _ d S( N( R R< R t
tab_tablest
table_manager( Ra R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< s c C s | j j d S( N( R t show_index_manager( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt manage s c C s | j j x| j j p g D]u} yI | j j | j i | j d d d 6| j j d d d 6d } Wn7 t j
k
r } t d | j | | d f q n X| j } x| r| j
s | j
| r| j j } | j d | j d } x| j D]u\ } } } }
} | rF| j j t j | rFq n d } d }
y | d } | d }
Wn
| }
n X| t j k rt |
t k r| j | | j |
pd qt| j | | j |
pd n t |
t k r4| j | | d k r| j |
p-d n | | j |
n@ | j | | d k r^| j |
ppd n | | j |
| d
7} q Wn | j! } q Wq W| j" d S( Nt `s ``R R i s( Error querying index info for %s.%s: %s
R R R i (# RH R Rk R R R
R t replaceR R R R RS R RT RW Re R R R R
R Ru R R R' R R R R RU RV R RY R ( Ra R R t errR] Rf Rr R R R R R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR sB
I "
""C@N( Rw Rx R R R Ru R R R R R R R R R R< Rm R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyRY s0 # t
GrantsManagerc B s e Z d Z d Z d Z d Z d e d d d0 f d e d d d0 f d e d d d0 f d e d
d d0 f d e d
d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d d d0 f d e d! d d0 f d" e d# d d0 f d$ e d% d d0 f d& e d' d d0 f d( e d) d d0 f d* e d+ d d0 f d, e d- d d0 f g Z d. Z
d/ Z RS(1 t Grantss db.Grantst table_privilegesi t Hostid t Usert Dbt Scopet Select_privt Selecti2 t Insert_privt Insertt Update_privt Updatet Delete_privt Deletet Create_privt Createt Drop_privt Dropt
Grant_privt Grantt References_privt
Referencest
Index_privt Indext
Alter_privt Altert Create_tmp_table_privs Create tmp tablet Lock_tables_privs Lock Tablest Create_view_privs Create Viewt Create_routine_privs Create Routinet Alter_routine_privs
Alter Routinet Execute_privt Executet
Event_privt Eventt Trigger_privt Triggerc
C sT t | j d k r g Sg } g } g } x | j D] \ } } } } } | rr | j j t j | rr q5 n d } y | d } Wn
| } n X| d k r q5 n | d k r | j | n | d k r5 | j d | j d d q5 q5 W| j d
i d j | d 6d
j | d 6 | j d i d j | d 6| j
d 6 | S( Ni R t scopeRv Ru Rt s %s = 'Y'R t _sM SELECT '<global>' as Db,%(sel_fields)s FROM mysql.user WHERE %(where_fields)st ,t
sel_fieldss OR t where_fieldssA SELECT Db,%(sel_fields)s FROM mysql.db WHERE '%(schema)s' like dbR ( s Db( Ru Rt s Db( R3 R R R R
R Ru R( Ro Ro R (
Ra t outputt fieldst fields_whereR R R R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR : s, "
$1+c C s? | j j x! | j D] } | j | q W| j d S( N( RH R R R R ( Ra R} ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR X s
N( Rw Rx R R R R R Ru R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyRq s6 t ViewManagerc B sJ e Z d Z d Z d Z d Z d Z d Z d Z d e
d d d f g Z RS( t Viewss db.Viewt viewss: show table status from `%(schema)s` where Comment = 'VIEW'i R i N( Rw Rx R R R Ru R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR _ s t TriggerManagerc 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 d e
d d d f d e
d d d f d e
d d d f g
Z RS( t Triggerss
db.Triggert triggerss show triggers from `%(schema)s`i R R i R id R2 t Timingt Createdt sql_modes SQL Modet Definert character_set_clients Client Character Sett collation_connections Connection Collations Database CollationN( Rw Rx R R R R R R R Ru R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR j s t ProcedureManagerc 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 d e
d d d f d e
d d d f d e
d d d f g
Z RS( s Stored Proceduress db.StoredProceduret storedProceduress- show procedure status where Db = '%(schema)s'i R i RM id R t ModifiedR t
Security_types
Security TypeR s Client Character SetR s Connection Collations Database CollationR i N( Rw Rx R R R R R R R Ru R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR ~ s t FunctionManagerc B s5 e Z d Z d Z d Z d Z d Z d Z e j Z RS( t Functionss db.Functiont functionss, show function status where Db = '%(schema)s'i (
Rw Rx R R R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s t EventManagerc 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 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 RS( t Eventst GrtObjectt eventss show events from `%(schema)s`i R i R s
Row Formatid s Time zones Time ZoneRM s
Execute ats Interval values Interval fieldt Startst Endst Statust
OriginatorR s Client Character SetR s Connection Collations Database CollationN( Rw Rx R R R R R R R Ru R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s( t SchemaInfoPanelc B s& e Z d Z d Z d Z d Z RS( t Infot informationsc C sf t j j | t | j | j | | _ | | _ t j | _ | j j
d | j j d | j j d | j j
d d } t j t | _ | j j d | j j t d | j j j d | t t | j | j t t | j j | 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 t j t } | j d | j d | j | j t t | j | t t d S( Ni i i c S s# t j | } | j t j | S( N( R R R R ( t tR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt
make_title s i
s db.Schema.32x32.pngs %ss Schema Detailsi i s Default collation:i i R s Default characterset:i s Table count:i s Database size (rough estimate):i ( R R R< R R R R t _schemat newTableR t
set_row_countt set_column_countt set_row_spacingt set_column_spacingR? RL t panel_header_boxRA RK R t
connectionR) t HFillFlagR t col_default_collation_nameR R t HExpandFlagt col_default_character_set_namet table_countt
database_sizeRB ( Ra R R R t tbox( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< sJ
/(+,+,+,+,
c C s y | j j d | j d } Wn3 t j k
rU } t d | j | f d } n X| r | j } | r xn | j D]` } t | d | j
j rx t | d | j
j
d d j j | j | j
qx qx Wq n y | j j d | j d } Wn3 t j k
r7} t d | j | f d } n X| r| j } | r| j j t | j d | j j | j d
qn d S( NsB select * from information_schema.schemata WHERE schema_name = '%s'i sH select * from information_schema.schemata WHERE schema_name = '%s' : %s
s col_%sR R s select sum(data_length) + sum(index_length) database_size,count(*) table_count from information_schema.tables WHERE table_schema = '%s's select sum(data_length) + sum(index_length) database_size,count(*) table_count from information_schema.tables WHERE table_schema = '%s' : %s
R R ( R R
R R R R Ru RS R R R) t lowerR Ro R\ R R R t floatFieldValueByNameR ( Ra R R R] R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s*
H
( Rw Rx R R R< R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s 6R c B s# e Z d Z d Z d Z RS( c C s t j j | t d t | | _ t j | _ | j | j t t g | _ t
t t t
t t t t t g } | j j j d k s | j j j d k r | j j j d k r | j t n x | D] } yq | t
k r | | | | } n | | | } t | d | j | | j j | | j j | | j Wq t k
rzd d l } t d | j | j f q Xq W| j d S( NR i i t tab_is Error initializing tab %s: %s
(! R t AppViewR< R R t
newTabViewt tabviewRK RL t pagesR R7 RG RY R R R R Rq R R R R( R t setattrR t add_pageR t Exceptiont tracebackR t
format_excR ( Ra R R t tabst Tabt tabR ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR< s( !?
%c C s | j j d S( N( Rj R@ ( Ra ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR % s c C s" x | j D] } | j q
Wd S( N( R R ( Ra R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR ) s ( Rw Rx R< R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyR s (( R R t
workbench.logR R R R R R R t workbench.notificationsR t wb_admin_utilsR t workbench.utilsR R
R R" R0 R; R1 R R R R R R8 R7 RG RY Rq R R R R R R R R ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.pyt <module> s0 ( J 6OKA
T