| 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 (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc @ s d d l m Z m Z d d l Z d d l Z d d l m Z d d l m Z d d l m
Z
m Z e d d d d d
d Z d e j
f d
YZ d e j f d YZ d Z i
d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6Z d e j f d! YZ d" e j f d# YZ e j d$ d% d& d' e j g e j e j e j j d( Z e j e j e j j e j e j d) Z d S(* i( t DefineModulet wbinputsN( t Version( t Context( t ExplainContextt decode_jsont namet SQLIDEQueryAnalysist authors Oracle Corp.t versions 1.0t JSONTreeViewerc B s e Z d Z d Z RS( c C s^ t j j | t j t j Bt j B | j t j d d | j t j d d | j d S( Nt Keyi t Valuei, ( t mformst TreeNodeViewt __init__t TreeAltRowColorst TreeShowColumnLinest TreeShowRowLinest
add_columnt StringColumnTypet end_columns( t self( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR s $c s< f d t | } | j d | j | d S( Nc sQ t | t k rw | r+ | j d d n x | j D]8 \ } } | } | j d | | | j | q8 Wn t | t k r | r | j d d n x t | D]> \ } } | } | j d t | | | j | q WnY | s| } n t | t k r7| j d | r-d n d n | j d t | d S( Ni s <dict>i s <list>t truet false( t typet dictt
set_stringt itemst add_childt listt enumeratet strt bool( t nodet create_nodet datat keyt valuet cht i( t add_nodes( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR) & s& ( R t cleart Nonet add_node( R R$ ( ( R) sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt display_data% s
( t __name__t
__module__R R- ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR
s t RenderBoxc B sG e Z d Z d Z d Z d Z d Z d Z d Z RS( c C sk t j j | | j | j | j | d | _ d | _ t | _
d | _ | | _ d | _
d S( Ni i ( i i ( R
t PyDrawBoxR t set_managedt set_release_on_addt set_instancet offsetR+ t sizet Falset verticalt node_spacingt econtextt drag_offset( R t context( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR C s
c C s] | d k r | | f | _ n | | j d 8} | | j d 8} | j j j | | | d S( Ni i ( R; R5 R: t _canvast
mouse_down( R t bt xt y( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR> Q s
c C sW | d k r d | _ n | | j d 8} | | j d 8} | j j j | | | d S( Ni i ( R+ R; R5 R: R= t mouse_up( R R? R@ RA ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRB X s
c C sU | j r | j j n | | j d 8} | | j d 8} | j j j | | d S( Ni i ( R; t scrollt set_viewport_offsetR5 R: R= t
mouse_move( R R@ RA ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRE _ s
c C s | j j j d S( N( R: R= t mouse_leave( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRF f s c C sP | j j \ } } | j | k s9 | j | k rL | j | | n d S( N( R: t layoutt get_widtht
get_heightt set_size( R t wt h( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt relayouti s $c C s t | } | j d d d d d y | j j \ } } d } d }
| | j k rq | j | d } n | | j k r | j | d }
n | |
f | _ | j j | |
| j j | Wn7 t k
rd d l
} t j d d | j
n Xd S(
Ni i g o@i i i it vexplains' Exception rendering explain output: %s
( R t set_source_rgbR: R6 RH RI R5 t
set_offsett repaintt Exceptiont tracebackt grtt log_errort
format_exc( R t crR@ RA RK RL t ct dwt dht xxt yyRS ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRQ o s
( R. R/ R R> RB RE RF RM RQ ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR0 B s c G s t j | } | j | S( N( R
t ToolBarItemR2 ( t argst item( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt newToolBarItem s
i( t idix t select_typeid t tablei2 R i t
possible_keysR% t key_lent reft rowst Extrat QueryPlanTabc B sA e Z d Z e Z d Z d Z d Z d Z d Z RS( i c
C s2 t j j | t | j | j | | _ t j j j } t j
t j | _ | j j
d t t j } | j d | j j | t t j } | j d d d d g | j | j | j j | | } | t d d k } | s | j t n t t j } | j j | t t j } | j | d | j | j | j d
| j j | | j | j t t t j t j | _! | j! j
d | j! j" t t t# | j | _$ | j! j | j$ | j% | j$ _% | j& | j$ _& | j | j! t t | j | d S( Ns #ffffffs Display Cost Info:s Prefix Cost (read + eval)s Read Costs Eval Costs Data Read per Joini i s tiny_saveas.pngs Save image to an external file.(' R
t BoxR R7 R2 R3 t _contextt Appt gett get_resource_patht
newToolBart SecondaryToolBart toolbart set_back_colorR` t LabelItemt set_textt add_itemt SelectorItemt set_selector_itemst add_activated_callbackt display_costR t set_enabledt
SeparatorItemt
ActionItemt set_icont savet set_tooltipt addt Truet newScrollPanelt ScrollPanelNoFlagsRC t set_visible_scrollersR0 t drawboxR9 R8 (
R R< t server_versionRn t lR_ t cost_type_itemt
has_cost_infot st btn( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR sF
c C s | j } | r | j j d } | d k rG | j j d nq | d k rf | j j d nR | d k r | j j d n3 | d k r | j j d n t j d
d | | j j n d S( Ni t evalt eval_costt prefixt prefix_costt readt read_costR$ t data_read_per_joinRN s Unknown cost info type: %s
( t get_textt lowert splitRk t show_cost_info_typeRT RU R t set_needs_repaint( R R_ t textt cost( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRy s c C s3 | j j d | j j k | j j d S( Nt
aggregated( Rk t show_aggregated_cost_infoR R R R ( R R_ ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt toggle_aggregated s "c C se t j t j } | j d d | j d | j d | j ra | j j | j n d S( Ns PNG image (*.png)|*.pngt pngs
Save Image Ass explain.png(
R
t FileChoosert SaveFilet set_extensionst set_titlet set_patht run_modalRk t
export_to_pngt get_path( R R_ R' ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR~ s
c C s | j j d S( N( R R ( R R@ RA RK RL ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR s (
R. R/ R9 R R8 R Ry R R~ R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyRi s F t
ExplainTabc B s, e Z d Z d Z d Z d Z RS( c C s t j j | t d t | j | j | | _ t j d | _ | j j | j
| j d t j
j j j d d } | r_t | } t | | _ t | j | | _ | j j | j j | j j | j j j | j j | j d t j | _ | j j | | j j t j | j j t j! d | j j | j d n d | _ d | _# d | _ | rt j$ t j% t j& Bt j' Bt j( B | _) | j) j* | j+ t, | j- } d } t j
j j j d d } | r g | j. d D] }
t/ |
^ q} n x t0 | j- D] \ }
} | r\|
t, | k r\| |
n t1 j | j2 d
} | j2 d k r|
} | j) j3 t j4 | j2 | q.| j) j3 t j5 | j2 | q.W| j) j6 | j7 rtx t8 rp| j) j9 }
xd t: | D]V }
| j; |
} |
| k rI|
j< |
| r?t= | n d q|
j> |
| qW| j? sPqqWn | j j | j) d | j@ n | jA | j t8 t8 | j r| j jB | n d S(
Nt QueryExplaini s #ffffffs" wb.query.analysis:ActiveExplainTabs
Query Plani s Raw Explain Datas) wb.query.analysis:ExplainTreeColumnWidthst ,id Rg t Explain(C R
t AppViewR R7 R2 R3 t _queryt
newTabViewt tabviewt add_tab_changed_callbackt tab_changedRr RT t roott wbt stateRm R R t _explain_contextRi t _query_plant init_canvasR R RM t add_paget
CodeEditort _raw_explainRt t set_languaget LanguagePythont set_featurest FeatureReadOnlyR+ t _costs_treet newTreeNodeViewt TreeFlatListR R R t explain_treet add_column_resized_callbackt column_resizedt lent columnsR t intR t EXPLAIN_COLUMN_WIDTHSR R t LongIntegerColumnTypeR R t goToFirstRowR R, t ranget stringFieldValuet set_longt longR t nextRowt reset_referencesR t set_active_tab( R R t queryt json_textt explaint default_tabt jsonRX t rows_columnt saved_widthsR( t columnt widthR" R& ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR sj
*+ 7
%
c C sx g } x6 t | j j D] } | j | j j | q Wd j g | D] } t | ^ qL t j j j
d <d S( NR s) wb.query.analysis:ExplainTreeColumnWidths( R R t get_column_countt appendt get_column_widtht joinR RT R R R ( R R t sizesR( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR S s c C sm | j ri | j ri | j j d k r: | j j j n | j j j | j j t j j j
d <n d S( Ni s" wb.query.analysis:ActiveExplainTab( R R R t get_active_tabR= t activatet
deactivateRT R R R ( R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR Z s
c C s+ t j t j t j Bt j Bt j B } | S( N( R
R R R R R ( R R t tree( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt fill_costs_treec s '( R. R/ R R R R ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyR s L s wb.sqlide.visual_explaint captions Visual Explaint inputc C sj t j | j j } | j } | rfy | j j d | d } Wn4 t k
rw } t j j d d | d d d d SX| s t j j d d d d d d Sd } | j d d
r | j j d | d } | r | j r | j
d } | j q n t | | | | r| n d } t j | j } | j | d d | j | | j | d n d S(
Ns
EXPLAIN %si s Explain for Connections Error executing explain
%st OKt i s Error executing explain.i i s EXPLAIN FORMAT=JSON %sR ( R t fromgrtt ownert
serverVersiont currentStatementt executeQueryRR R
t Utilitiest
show_errorR+ t# is_supported_mysql_version_at_leastR R R R t resultDockingPointt dock_viewt select_viewt set_view_title( t editorR t statementR t eR t rsett viewt dock( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt
visualExplainj s2 !
c
C s t j | j j } y | j j d | d } Wn t j k
r } | j d d k r} t j j
d d | d d d n& t j j d d | | f d d d d St k
r } t j j d d | | f d d d d SX| s t j j d d | d d d d S| j
d
d rm| j j d | d } | rd| j rd| j d } | j qmd } n t | | | | r| n d } t j | j } | j | d d | j | | j | d d S(
Ns EXPLAIN FOR CONNECTION %si i s Explain for Connections6 Explain for connection %s did not generate any output.R R s, Error executing explain for connection %s
%ss) Error executing explain for connection %si i s% EXPLAIN FORMAT=JSON FOR CONNECTION %s( R R R R t executeManagementQueryRT t DBErrorR^ R
R t show_messageR RR R R R R R+ R R R R R (
R t conn_idt the_queryR R R R R R R ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt visualExplainForConnection s<
!
( R R R RT R
t workbench.utilsR t workbench.graphics.cairo_utilsR t explain_rendererR R t
ModuleInfoR R
R1 R0 R` R Rj Ri R R t plugint currentQueryEditort exportt INTt classest db_query_QueryEditorR t STRINGR ( ( ( sT C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_query_analysis_grt.pyt <module> s2 $C
md!'"