| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ s� d d l m Z d d l Z d d l Z d d l m Z m 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 d% e j f d& � � YZ e j e j e j j e j j � d' � � Z e j e j e j j e j e j � d( � � Z! d S() i����( t DefineModuleN( t log_warningt log_error( 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 TreeViewt __init__t TreeAltRowColorst TreeShowColumnLinest TreeShowRowLinest
add_columnt StringColumnTypet end_columns( t self( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR* ' s& ( R t cleart Nonet add_node( R R% ( ( R* sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt display_data& s
( t __name__t
__module__R R. ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 st 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 scrollt set_instancet offsetR, t sizet Falset verticalt node_spacingt econtextt drag_offset( R t contextR5 ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR D s
c C s� | d k r | | f | _ n | | j d 8} | | j d 8} | j j j | | | � | j j r� | d k r� | j j | | � n | j j � d S( Ni i ( R= R7 R< t _canvast
mouse_downt
overview_modet
close_tooltip( R t bt xt y( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR@ T s c C sW | d k r d | _ n | | j d 8} | | j d 8} | j j j | | | � d S( Ni i ( R, R= R7 R< R? t mouse_up( R RC RD RE ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRF _ s
c C sh | | j d 8} | | j d 8} | j j j | | � | j j rd | j j | | � | j � n d S( Ni i ( R7 R< R? t
mouse_moveRA t mouse_movedt set_needs_repaint( R RD RE ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRG f s c C s | j j j � d S( N( R< R? t mouse_leave( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRJ q 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( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt relayoutt 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 | � Wn1 t k
r d d l
} t d | j � � n Xd S( Ni i� g �o@i� i i i����s' Exception rendering explain output: %s
(
R t set_source_rgbR< R8 RL RM R7 t
set_offsett repaintt Exceptiont tracebackR t
format_exc( R t crRD RE RO RP t ct dwt dht xxt yyRV ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRT z s
( R/ R0 R R@ RF RG RJ RQ RT ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR1 C s c G s t j | � } | j � | S( N( R t ToolBarItemR3 ( t argst item( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 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 sS e Z d Z e Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z RS( i c C s+ t j j | t � | j � | j � | | _ t j j � j } t j
t j � | _ | j j
d � t t j � | _ | j j | j � t t j � } | j j | � t t j � } | j d � | j j | � t t j � } | j d d g � | j | j � | j j | � | } | t d d � k }
|
sJ| j t � n t t j � } | j j | � t t j � } | j | d � � | j | j � | j d � | j j | � t t j � } | j j | � t t j � } | j d � | j j | � t t j � } | j | d
� � | j | j � | j d � | j j | � t t j � } | j j | � t t j � } | j d � | j j | � t t j � } | j | d
� � | 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" | j& t# t# � | j | � t j, � | _- | j- j. | � | j- j/ t j0 � | j- j1 t j2 t# � | j" | j- t# t# � | j- j3 t � d S( Ns #ffffffs
Display Info:s Read + Eval costs Data Read per Joini i s tiny_saveas.pngs Save image to an external file.s Overview:s% qe_sql-editor-explain-tb-overview.pngs Zoom out the diagram.s View Source:s' qe_sql-editor-tb-icon_word-wrap-off.pngs& qe_sql-editor-tb-icon_word-wrap-on.pngs View the raw JSON explain data.(4 R t BoxR R9 R3 R4 t _contextt Appt gett get_resource_patht
newToolBart SecondaryToolBart toolbart set_back_colorRa t SelectorItemt
switcher_itemt add_itemt
SeparatorItemt LabelItemt set_textt set_selector_itemst add_activated_callbackt display_costR t set_enabledt
ActionItemt set_icont savet set_tooltipt overviewt
ToggleItemt set_alt_icont
switch_to_rawt addt Truet newScrollPanelt ScrollPanelNoFlagsR5 t set_visible_scrollersR1 t drawboxR; R: t
CodeEditort _raw_explaint set_valuet set_languaget LanguagePythont set_featurest FeatureReadOnlyt show( R t ownert json_textR> t server_versionRo t st lR` t cost_type_itemt
has_cost_infot btn( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR � s�
c C s� | j � } | r� | j � j � d } | d k rG | j j d � n3 | d k rf | j j d � n t j d d | � | j j � n d S( Ni t readt read_eval_costR% t data_read_per_joint vexplains Unknown cost info type: %s
( t get_textt lowert splitRl t show_cost_info_typet grtR R� RI ( R R` t textt cost( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR| s c C s3 | j j d | j � j � k � | j j � d S( Nt
aggregated( Rl t show_aggregated_cost_infoR� R� R� RI ( R R` ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt toggle_aggregated& s "c C s1 | j � } | j j | � | j j | � d S( N( t get_checkedR� R� R5 ( R R` t flag( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� + s c C s� t j t j � } t j j j j j d d � } | rF | j | � n | j d d � | j
d � | j d � | j � r� | j
j | j � � | j � t j j j j d <n d S( Ns) wb.VisualExplain:LastFileChooserDirectoryt s PNG image (*.png)|*.pngt pngs
Save Image Ass explain.png( R t FileChoosert SaveFileR� t roott wbt optionsRn t
set_directoryt set_extensionst set_titlet set_patht run_modalRl t
export_to_pngt get_patht
get_directory( R R` R( t directory( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� 1 s
c C s | j j � d S( N( R� RI ( R RD RE RO RP ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRI > s c C s | j j � | j j � d S( N( Rl t enter_overview_modeR� RI ( R R` ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� B s
( R/ R0 R; R� R: R R| R� R� R� RI R� ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyRj � s q
t TabularExplainTabc B s& e Z d Z e Z d � Z d � Z RS( i c C s� t j j | t � | j � | j � t j t j � | _ | j j d � t
t j � | _ | j j
| j � | j | j t t � t 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� t! | j � D]� \ } } | rc| t | � k rc| | n t" j | j# d � } | j# d k r�| } | j j$ t j% | j# | � q5| j j$ t j& | j# | � q5W| j j' � | j( � r{x� t) rw| j j* � }
xd t+ | � D]V } | j, | � } | | k rP|
j- | | rFt. | � n d � q
|
j/ | | � q
W| j0 � s�Pq�q�Wn | j1 � | j | j t) t) � d S( Ns #ffffffs) wb.query.analysis:ExplainTreeColumnWidthst ,id Rh i (2 R Rk R R9 R3 R4 Rp Rq Rr Rs Ra Rt Ru Rv R� t newTreeViewt TreeFlatListR R R t explain_treet add_column_resized_callbackt column_resizedt lent columnsR, R� R� R� t stateRn R� t intR t EXPLAIN_COLUMN_WIDTHSR R t LongIntegerColumnTypeR R t goToFirstRowR� R- t ranget stringFieldValuet set_longt longR t nextRowt reset_references( R R� t explainR� RY t rows_columnt saved_widthsR) t columnt widthR# R' ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR L sD
*+ 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! R� R� R� R� ( R R� t sizesR) ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� { s ( R/ R0 R; R� R: R R� ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� H s /t
ExplainTabc B sV e Z d Z d Z d Z d � Z e Z d � Z d � Z
d � Z d � Z d � Z
RS( c
C sf t j j | t d t � | j � | j � | j | j � t j j � j
| j � | _ | r� | r� t j
d � } | j t j � | j t j � | j | t t � d S| | _ t j t j � | _ | j j | j � | j d � t j j j j d d � } d } | r}y t! | � } Wq}t" k
ry} d d l# } t$ d | j% � � t j& j' d d | d
d d � q}Xn | r�y� t( | | � | _) t* | | | j) | � | _+ | j) j, | j+ j- | j+ j. | j+ j/ � | j+ j- j0 � | j j1 | j+ d � | j+ j2 j3 d
� | j+ j2 j4 d d g � | j+ j2 j5 | j6 � Wq�t" k
r�} d d l# } t$ d | j% � � t j& j' d d | d
d d � q�Xn
t$ d � | r0t7 | | | � | _8 | j j1 | j8 d � | j8 j2 j3 d � | j8 j2 j4 d d g � | j8 j2 j9 d � | j8 j2 j5 | j6 � n | j | j t t � | j) rb| j j: | � n d S( Nt QueryExplains( Explain data not available for statements #ffffffs" wb.query.analysis:ActiveExplainTabi i����s Error creating query plan: %s
s Query Plan Generation Errors� An unexpected error occurred parsing JSON query explain data.
Please file a bug report at http://bugs.mysql.com along with the query and the Raw Explain Data.
Exception: %st OKR� s Visual Explaint visual_explain_switchers Tabular Explains� An unexpected error occurred during creation of the graphical query plan.
Please file a bug report at http://bugs.mysql.com along with the query and the Raw Explain Data.
Exception: %ss No JSON data for explain
t tabular_explain_switcher(; R t AppViewR R9 R3 R4 t on_closet on_tab_closet Formt main_formt add_deactivated_callbackt form_deactivatedt _form_deactivated_connt newLabelt set_stylet BigBoldStylet set_text_alignt MiddleCenterR� R� t _queryt
newTabViewt TabViewTablesst tabviewt add_tab_changed_callbackt tab_changedRs R� R� R� R� Rn R, R RU RV R RW t Utilitiest
show_errorR t _explain_contextRj t _query_plant init_canvasR� R5 RI RQ t add_pageRu t set_nameRz R{ t switch_viewR� t _tabular_explainRy t set_active_tab(
R R� t queryR� R� t labelt default_tabt json_datat eRV ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR � sj
(
c C s� | j r
d St | _ | j � } | d k rA | j j d � n/ | d k r` | j j d � n t d | � � | j � } | d k r� | j d � n | d k r� | j d � n t | _ d S( Ns Visual Explaini s Tabular Explaini s Unknown R� R� ( t
_switchingR� R� R� R� RU t get_nameRy R9 ( R R` t new_viewt source( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� � s c C sz | j rv | j rv | j j � d k r: | j j j � n | j j 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
deactivateRB R� R� R� R� ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� � s
c C s+ t j t j t j Bt j Bt j B� } | S( N( R R� R� R R R ( R t jsont tree( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt fill_costs_tree� s 'c C s& | j r" | j r" | j j � n d S( N( R� R� RB ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� � s c C s0 | j � | j r, | j j � d | _ n t S( N( R� R� t
disconnectR, R� ( R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� � s
N( R/ R0 R, R� t _costs_treeR� R R9 R R� R� R R� R� ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyR� � s H
c
C sM t j | j j � } | j } | rIy | j j d | d � } Wn- t k
rp } t d | | f � d } n Xd } | r� | 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 � | j d � | j | d
d � | j | � n d S( Ns
EXPLAIN %si s! Could not execute EXPLAIN %s: %s
i i s EXPLAIN FORMAT=JSON %si t execution_plans Execution
Plans output_type-executionplan.png( R t fromgrtR� t
serverVersiont currentStatementt executeQueryRU R R, t# is_supported_mysql_version_at_leastR� R� R� R� R t dockingPointt set_identifierR� t dock_viewt select_view(
t editort result_panelR
t statementR� R R t rsett viewt dock( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt
visualExplain� s*
!
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 � } | j 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 %sR ( R R R� R t executeManagementQueryR� t DBErrorR_ R R� t show_messageR� RU R R� R� R� R, R� R t resultDockingPointR R R� (
R t conn_idt the_queryR
R� R R R R R ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt visualExplainForConnection s>
!
(" R� R R� R t
workbench.logR R t workbench.utilsR t workbench.graphics.cairo_utilsR t explain_rendererR R t
ModuleInfoR R R2 R1 Ra R� Rk Rj R� R� R� t exportt INTt classest db_query_QueryEditort db_query_ResultPanelR t STRINGR% ( ( ( sN C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_query_analysis_grt.pyt <module> s4 $M
�:}-