7 fddlmZmZddlmZddlmZddlmZm Z ddl m Z ddl m Z dZee edZee ed Zee ed Zy ) )HttpResponseBadRequest JsonResponse)render_to_string) csrf_exempt)render_with_toolbar_languagerequire_show_toolbar)SignedDataForm) SQLSelectFormc|jdk(r |jn |j}t|}|j r|j Sy)z2Unpack a signed data form, if invalid returns NoneGETN)methodr POSTr is_valid verified_data)requestdata signed_forms T/var/www/equiseq/venv/lib/python3.11/site-packages/debug_toolbar/panels/sql/views.pyget_signed_datar sD!..E17;;w||D &K((** ct|}|s tdSt|}|jr|jd}|jd}|j 5}|j |||jDcgc]}|d }}|j}ddd|j|jd|jdd} td | } td | iStd Scc}w#1swYbxYw) z.Returns the output of the SQL SELECT statementInvalid signatureraw_sqlparamsrNdurationaliasresultsqlrheadersrz$debug_toolbar/panels/sql_select.htmlcontent Form errors) rrr r cleaned_datacursorexecute descriptionfetchall reformat_sqlrr) rrformrrr$dr rcontextr!s r sql_selectr,s  $G,M %&9::  'D }} *""8, [[ 'F NN3 '%+%7%78qt8G8__&F ' $$&))*5&&w/  ##I7SY011 !- 009 ' 's!C>? C9 C>9C>>Dct|}|s tdSt|}|jr |jd}|jd}|j j }|j5}|dk(r|jd||n0|dk(r|jd||n|jd|||jDcgc]}|d  }}|j} d d d  |j|jd |jd d } td| } td| iStdScc}w#1swYbxYw)z8Returns the output of the SQL EXPLAIN on the given queryrrrsqlitezEXPLAIN QUERY PLAN postgresqlzEXPLAIN ANALYZE zEXPLAIN rNrrrz%debug_toolbar/panels/sql_explain.htmlr!r")rrr rr# connectionvendorr$r%r&r'r(rr) rrr)rrr1r$r*r rr+r!s r sql_explainr21s_ $G,M %&9::  'D }} *""8,'' [[ 'F!!4SE:FC<'!1#7@#/8%+%7%78qt8G8__&F '$$&))*5&&w/  ##JGTY011 !- 009 ' 's5AE E E EEct|}|s tdSt|}|jr|jd}|jd}d}d}d}|j 5} |j d|j |||j d|j d|jD cgc]} | d }} |j}ddd|||j|jd ||jd d } td | } td| iStdScc} w#t$rd }YowxYw#1swYtxYw)zJReturns the output of running the SQL and getting the profiling statisticsrrrNzSET PROFILING=1zSET PROFILING=0aV SELECT * FROM information_schema.profiling WHERE query_id = ( SELECT query_id FROM information_schema.profiling ORDER BY query_id DESC LIMIT 1 ) rzDProfiling is either not available or not supported by your database.rr)r result_errorrrr rz%debug_toolbar/panels/sql_profile.htmlr!r") rrr rr#r$r%r&r' Exceptionr(rr) rrr)rrrr r4r$r*r+r!s r sql_profiler6Xsj $G,M %&9::  'D }} *""8, [[ F 01sF+01  *0););r>s<34W.8 1 16 !1 !1H 21 21r