a Ig@sddlmZmZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddZee ed d Zee ed d Zee ed dZdS))HttpResponseBadRequest JsonResponse)render_to_string) csrf_exempt)render_with_toolbar_languagerequire_show_toolbar)SignedDataForm) SQLSelectFormcCs2|jdkr|jn|j}t|}|r.|SdS)z2Unpack a signed data form, if invalid returns NoneGETN)methodr POSTris_valid verified_data)requestdataZ signed_formrZ/var/www/html/django/DPS/env/lib/python3.9/site-packages/debug_toolbar/panels/sql/views.pyget_signed_data s rc Cst|}|stdSt|}|r|jd}|jd}|j4}|||dd|jD}|}Wdn1sx0Y|| |jd||jdd }t d |} t d | iStd S) z.Returns the output of the SQL SELECT statementInvalid signatureraw_sqlparamscSsg|] }|dqSrr.0drrr "zsql_select..Ndurationaliasresultsqlrheadersrz$debug_toolbar/panels/sql_select.htmlcontent Form errors) rrr r cleaned_datacursorexecute descriptionfetchall reformat_sqlrr) rrformr!rr&r"r contextr#rrr sql_selects(   &  r-c Cst|}|stdSt|}|r|jd}|jd}|jj}|jr}|dkrd|d||n.|dkr|d||n|d||d d |j D}| }Wd n1s0Y|| |jd ||jd d} t d| } t d| iStdS)z8Returns the output of the SQL EXPLAIN on the given queryrrrZsqlitezEXPLAIN QUERY PLAN postgresqlzEXPLAIN ANALYZE zEXPLAIN cSsg|] }|dqSrrrrrrrIrzsql_explain..Nrrrz%debug_toolbar/panels/sql_explain.htmlr#r$)rrr r r% connectionvendorr&r'r(r)r*rr) rrr+r!rr0r&r"r r,r#rrr sql_explain1s2  &  r1c Cs t|}|stdSt|}|r|jd}|jd}d}d}d}|jn}zF|d||||d|ddd |jD}|}Wnt yd }Yn0Wdn1s0Y||| |jd ||jd d } t d| } t d| iStdS)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 ) cSsg|] }|dqSrrrrrrr{rzsql_profile..zDProfiling is either not available or not supported by your database.rr)r result_errorr!rr"rz%debug_toolbar/panels/sql_profile.htmlr#r$) rrr r r%r&r'r(r) Exceptionr*rr) rrr+r!rr r"r2r&r,r#rrr sql_profileXsB         &  r4N)Z django.httprrZdjango.template.loaderrZdjango.views.decorators.csrfrZdebug_toolbar.decoratorsrrZdebug_toolbar.formsrZdebug_toolbar.panels.sql.formsr rr-r1r4rrrrs$     $