| 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 m Z d d l 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_error( t IconStringColumnTypet StringColumnTypet LongIntegerColumnTypet IntegerColumnType( t NotificationCenter( t make_panel_header( t
human_sizet Versionc C sv xo | D]g } t | | } t j | j } | j | d d | j | | j | | r | j q q Wd S( Nt i ( t
SchemaManagert mformst fromgrtt dockingPointt dock_viewt select_viewt set_titlet show_table_maintenance( t editort selectiont table_maintenancet schema_namet smant dpoint( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt <lambda>8 s i ( R R t typet appendt namet newMenuItemt add_clicked_callbackt insert_item( R R t argsR R t st item( ( R R sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 Clipboardt OKi (+ R t Formt __init__t main_formt
FormNormalt newBoxt Falset boxt set_paddingt set_spacingt set_contentt newTreeNodeViewt 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_pathRU t nodet bboxt copy( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 < 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
(
R@ t
get_selectiont ranget countt node_at_rowt
get_stringRG R t get_tagt joinR t Utilitiest set_clipboard_text( RY t rowst iR^ t row( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRS w s J c C s | j | j d d S( N( t run_modalRU t None( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt run s ( t __name__t
__module__R7 R3 RS Ro ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR' ; s ;
c C sb | d j | } | j | d } t | | j d } | j | d j | j d S( Ns , i t CHECKSUMR ( Rg t executeManagementQueryR' t
startswithR t stripRo ( R t actionR t queryt resultt form( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt do_table_maintenance s
t
ObjectManagerc B sq e 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 RS(
c
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 j d | _6 | j6 j7 d t j8 | _9 | j9 j7 d | j9 j: | j; t j8 | _< | j< j7 d | j< j: | j= t j t | _> | j> j d | j
j | j> t t | j> j | j6 t t | j> j? | j9 t t | j> j? | j< t t x | j@ D]| \ } } | s| j> j t j d t t qn t j8 } | j7 | | j: t" | | | j> j | t t qWd S( NR i t preload_columnss
.16x16.pngt Refreshs
Inspect Tablet (A R t BoxR3 R7 t set_managedt set_release_on_addt schemaR R R t
serverVersiont target_versionR6 t mainRC RD t newLabelt
error_headingt set_stylet BoldStylet
error_bodyt error_boxR: R9 t showR< R= R> R? R@ RA RB t hasattrt callablet getattrR| t columnst# is_supported_mysql_version_at_leastt fromstrRE RF t set_allow_sortingt newContextMenuR t add_will_show_callbackt menu_will_showt add_activated_callbackt on_activatet set_context_menuRH RI RJ t klassR] t row_countRT RR t refresh_btnR! t refresht inspect_btnt
inspect_tableR_ RW t actions(
RY R R t fieldR t captiont widtht min_versiont
callback_namet btn( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 st
#$
"
"
c C sD | j j t | j j t | j j | | j j | d S( N( R R R7 R RD R RT R ( RY t titlet msg( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt
show_error s c C s! | j j d | j j d S( Ns Count: %d( R RT R@ Rc ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 Rn R R R Re t name_columnt encodeR R ( RY R^ t colR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s 4 c C sL | d k rH| j j | d k rHi } t j } d } x | j j D] } | j | j } t j j
} | | _ | j | _
| j | _ t | d r| j | j } | j | r | | _ qt 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" | qHn d S(
NR s db.Tables db.SchemaR t bottom_plugins_separatorR} R R t ContextMenuR t schema_inspectort GRNLiveDBObjectMenuWillShow(# Rn R t
remove_allt grtt ListR@ Ra Re R t classest db_query_LiveDBObjectR R t
schemaNameR R R R t has_keyt ownerR t node_nameR R t SeparatorMenuItemt set_namet add_itemt add_item_with_titleR t Dictt togrtRD R t sendR ( RY R% t parent_nodesR t pobjR^ R t objt parent_namet sobjt separatorR# ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR sT
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 Rg ( RY t colst field_objt ctypeR R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt get_query( s "c C s, 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 } xc| r'| j s | j | r| j
j } | j d k r| j | j | j n d } x| j D]\ } } } }
} | rh| j j t j | rhq+n d } d }
y | d } | d }
Wn
| }
n X| t j k rt |
t k r| j | | j |
pd q| j | | j |
pd n| t j k rrt |
t k rJ| j | t | j |
p@d q| j | t | j |
phd n t |
t k r| j | | d k r| j |
pd n | | j |
n@ | j | | d k r| j |
pd n | | j |
| d 7} q+Wn | j! } q Wd S(
Ni i i iv s Access ErrorsC The current user does not have enough privileges to execute %s.
%sR1 R s MySQL ErrorsN An error occurred retrieving information about the schema.
Query: %s
Error: %st format_funcR (" R Rs R t DBErrorR# R Rh R RK t filterR@ RL t icon_columnRn RO R] R R R R R R R t intt set_intt
intFieldValuet intFieldValueByNameR t set_longt longRN t stringFieldValueByNameRM RQ ( RY Rw t rsett eRU R^ Rk R R R R R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt preload_data3 sJ &0- "
""((C@c C s. | j j | j | j | j d S( N( R@ t clearR R R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR ` s
c C s, | j j } | r( | j | d n d S( Ni ( R@ t get_selected_nodeR ( RY R^ ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR f s N( Rp Rq Rn R R R R R3 R R R R R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR{ s M 6 - t TableManagerc B s e 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 i d d 6d d 6e d d
d- f i d d 6d d 6e d d
d- f i d d 6d d 6e 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 g Z
d* Z d+ Z d, Z RS(. t Tabless db.Tablet tablesi s< show table status from `%(schema)s` where Engine is not NULLt Namei t EngineiP R id t
Row_formats
Row Formatt Rowst Avg_row_lengths Avg Row Lengtht Data_lengthR c C s t t | S( N( R R ( t x( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR | s R s Data Lengtht Max_data_lengthc C s t t | S( N( R R ( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR } s s Max Data Lengtht Index_lengthc C s t t | S( N( R R ( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR ~ s s Index Lengtht Data_freec C s t t | S( N( R R ( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s s Data Freet Auto_increments Auto Incrementt Create_times Create Timet Update_times Update Timet
Check_times
Check Timet CollationR) t Commenti c C s g | _ t j | d S( N( t table_namesR{ R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s c C s | j j | j d t S( NR ( R R R RD ( RY R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(
R@ Ra R R R Re R R R R R R R ( RY R R^ R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRa s N( Rp Rq R R R R Rn R R R R R R R R R Ra ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR l s6 #### 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 contentRC R7 RD R6 R: t newImageBoxt set_imageRH RI RJ t set_tooltipRR R! RT Ru RW t _buttonsR (
R R t desct tooltipt optionst
extra_optionst lt hbt oR ( RY ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 R3 R7 R R R R: R9 R R t BigStyleRC RD t newScrollPanelt scrollR6 R R Rn t newCheckBoxt
analyze_localRT t
analyze_tableR t majorNumbert minorNumbert optimize_ft_onlyR! t optimize_ft_only_toggledRX t newTextEntryt optimize_ft_numwordst set_enabledRs RK t set_valueRN t optimize_localt optimize_tablet newSelectort check_scan_optt add_itemst check_fast_optt check_changed_optt check_tablet checksum_quickt checksum_table( RY R t headingt helpR R R Rx R ( ( RY sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 s
6
c C s | j j | j j d S( N( R R R t
get_active( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR 3 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# Rz R t
table_list( RY t local( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR 7 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 Rn R Rs RK RN R# R t get_string_valuet executeManagementCommandR Rz R$ ( RY t old_valuet rest commandR% ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR ; 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 Rz R R$ ( RY t option( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR L 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# Rz R R$ ( RY R. ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR R 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( RY R R t tablet enginet b( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt show_tablesW s ,( Rp Rq R3 R R R R R R3 ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 sQ 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 t t d | _ d S( Nid s < Summary Lists
Maintenance >( R t SplitterR3 RD R7 R R R R R t summary_viewRC R R R@ t add_changed_callbackt table_selection_changedRR t
goback_btnRT R! t switch_backR_ R t maintenance_btnt switch_maintenanceRW Rn t
right_view( RY R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 ^ s(
c C s
| j j S( N( R6 R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR { s c C s | j j d S( N( R6 R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s c C so | j r% | j | j d | _ n | j j j t | j j t | j j t | j j
j t d S( N( R= t removeRn R6 R R RD R; R9 R7 R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR: s c C s t | j | _ | j | j | j d | j j | j j | j | j | j j
j t | j
j t | j j t | j j j t d S( Ni ( R R R= RC t set_positiont relayoutR3 R t selected_tablesR6 R R R7 R; R9 RD R ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( R6 R@ Ra R Re ( RY R R^ ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRA s )c C s, | j r( | j j | j | j n d S( N( R= R3 R RA ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR8 s (
Rp Rq R3 t propertyR R R: R< RA R8 ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR4 ] s t
ColumnManagerc B s e 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 t
TABLE_NAMER( 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(
Rp Rq R R R Rn R R R R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRC 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 R( i t Key_nameR t
Non_uniqueR c C s | d k r d Sd S( NR' t Yest No( ( t val( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s R t Uniquei2 t
Index_types
Index Typet
Index_comments
Index Comments 5.5t Column_nameRG 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{ R3 R t
tab_tablest
table_manager( RY R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 s c C s | j j d S( N( R t show_index_manager( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt manage s c
C si | j j xK| j j p g D]7} | j j | j i | j d d d 6| j j d d d 6d } | j } x| rV| j
s | j
| rG| j j } | j d | j
d } x| j D]u\ } } } } }
|
r| j j t j |
rq n d } d } y | d } | d } Wn
| } n X| t j k rt | t k r| j | | j | pxd q6| j | | j | pd n t | t k r| j | | d k r| j | pd n | | j | n@ | j | | d k r | j | p2d n | | j | | d 7} q Wn | j } qz Wq W| j d S(
Nt `s ``R0 R i R R R i ( R@ R Rg R R Rs R t replaceR RK R RL RO R] R R R R R Rn R R R R R R R RM RN R RQ R (
RY R0 R RU R^ Rk R R R R R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s:
E "
""C@N( Rp Rq R R R Rn R R R R R R R R R R3 Ri R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRU 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 scopeRq Rp Ro 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( Rp Ro s Db( R/ R R R R R Rn R Rk Rg R (
RY t outputt fieldst fields_whereR R R R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s, "
$1+c C s? | j j x! | j D] } | j | q W| j d S( N( R@ R R R R ( RY Rw ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR = s
N( Rp Rq R R R R R Rn R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyRl 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 viewss8 show table status from `%(schema)s` where Engine is NULLi R i N( Rp Rq R R R Rn R R R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR D 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 R( t Timingt Createdt sql_modes SQL Modet Definert character_set_clients Client Character Sett collation_connections Connection Collations Database CollationN( Rp Rq R R R R R R R Rn R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR O 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 RI id R t ModifiedR t
Security_types
Security TypeR s Client Character SetR s Connection Collations Database CollationR i N( Rp Rq R R R R R R R Rn R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR c 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 (
Rp Rq R R R R R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR w 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 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 ZoneRI s
Execute ats Interval values Interval fieldt Startst Endst Statust
OriginatorR s Client Character SetR s Connection Collations Database CollationR i N( Rp Rq R R R R R R R Rn R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 R3 R7 R R R t _schemat newTableR0 t
set_row_countt set_column_countt set_row_spacingt set_column_spacingR6 RD t panel_header_boxR9 RC R t
connectionR t HFillFlagR t col_default_collation_nameR R t HExpandFlagt col_default_character_set_namet table_countt
database_sizeR: ( RY R R R t tbox( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 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 Rs R R R R Rn RK R R R t lowerR Rk RT R R R R R ( RY R R RU R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s*
H
( Rp Rq R R R3 R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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 AppViewR3 R7 R t
newTabViewt tabviewRC RD t pagesR R4 RC RU R R R R Rl R R R R R t setattrR t add_pageR t Exceptiont tracebackR t
format_excR ( RY R R t tabst Tabt tabR ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR3 s( !?
%c C s | j j d S( N( Rf R< ( RY ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR
s c C s" x | j D] } | j q
Wd S( N( R R ( RY R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR s ( Rp Rq R3 R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyR
s (& R R t
workbench.logR R R R R t workbench.notificationsR t wb_admin_utilsR t workbench.utilsR R R7 R R& R2 R' Rz R R{ R R R5 R4 RC RU Rl R R R R R R R R
( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\sqlide_catalogman_ext.pyt <module> s0 " J 2JGA
V