]j ddlmZmZddlmZddlmZddlmZm Z ddl m Z eee dZ eee dZ eee dZy ) )HttpResponseBadRequest JsonResponse)render_to_string) csrf_exempt)require_show_toolbarsigned_data_view) SQLSelectFormct|}|jr|jd}|jd}|j5}|j |||j Dcgc]}|d }}|j }ddd|j|jd|jdd} td| } td | iStd Scc}w#1swYbxYw) z.Returns the output of the SQL SELECT statementraw_sqlparamsrNdurationaliasresultsqlr headersrz$debug_toolbar/panels/sql_select.htmlcontent Form errors) r is_valid cleaned_datacursorexecute descriptionfetchall reformat_sqlrrr) request verified_dataformrr rdrrcontextrs H/root/env/lib/python3.12/site-packages/debug_toolbar/panels/sql/views.py sql_selectr" s  'D }} *""8, [[ 'F NN3 '%+%7%78qt8G8__&F ' $$&))*5&&w/  ##I7SY011 !- 009 ' 's!C&' C!3C&!C&&C/ct|}|jr-|jd}|jd}|jj}|j 5}|dk(r"|j dj||nH|dk(r"|j dj||n!|j dj|||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 queryr r sqlitezEXPLAIN QUERY PLAN {} postgresqlzEXPLAIN ANALYZE {}z EXPLAIN {}rNr rrz%debug_toolbar/panels/sql_explain.htmlrr)r rr connectionvendorrrformatrrrrrr) rrrrr r'rrrrr rs r! sql_explainr)$sR  'D }} *""8,'' [[ 'F!6==cBFK<'3::3?H|2237@%+%7%78qt8G8__&F '$$&))*5&&w/  ##JGTY011 !- 009 ' 'sA>E E'EEE#c|t|}|jr|jd}|jd}d}d}d}|j5} |j d|j |||j d|j d|j D 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 statisticsr r NzSET 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.r r)r result_errorrr rrz%debug_toolbar/panels/sql_profile.htmlrr) r rrrrrr Exceptionrrrr) rrrrr rrr+rrr rs r! sql_profiler-HsQ  'D }} *""8, [[ F 01sF+01  *0););r5s<34K8 1 10 1 1B /1 /1r4