o Mf @sddlmZmZddlmZddlmZddlmZm Z ddl m Z eee ddZ eee dd Z eee d d Zd S) )HttpResponseBadRequest JsonResponse)render_to_string) csrf_exempt)require_show_toolbarsigned_data_view) SQLSelectFormc Cst|}|rR|jd}|jd}|j}|||dd|jD}|}Wdn1s2wY|||jd||jdd}td |} t d | iSt d S) z.Returns the output of the SQL SELECT statementraw_sqlparamscSg|]}|dqSr.0dr r `/var/www/html/analyze/labelStudio/lib/python3.10/site-packages/debug_toolbar/panels/sql/views.py zsql_select..Ndurationaliasresultsqlrheadersrz$debug_toolbar/panels/sql_select.htmlcontent Form errors) ris_valid cleaned_datacursorexecute descriptionfetchall reformat_sqlrrr) request verified_dataformrr rrrcontextrr r r sql_select s$      r'c Cst|}|ru|jd}|jd}|jj}|j9}|dkr(|d||n|dkr6|d||n |d||dd |jD}| }Wd n1sUwY|| |jd ||jd d } t d| } t d| iSt dS)z8Returns the output of the SQL EXPLAIN on the given queryr r sqlitezEXPLAIN QUERY PLAN {} postgresqlzEXPLAIN ANALYZE {}z EXPLAIN {}cSr r r rr r rr9rzsql_explain..Nrrrz%debug_toolbar/panels/sql_explain.htmlrr)rrr connectionvendorrrformatr r!r"rrr) r#r$r%rr r+rrrr&rr r r sql_explain$s.     r-c Cst|}|rv|jd}|jd}d}d}d}|j7}z#|d||||d|ddd|jD}|}Wn tyJd }YnwWdn1sUwY||||jd ||jd d } t d | } t d| iSt dS)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 ) cSr r r rr r rrhrzsql_profile..zDProfiling is either not available or not supported by your database.rr)r result_errorrrrrz%debug_toolbar/panels/sql_profile.htmlrr) rrrrrr r! Exceptionr"rrr) r#r$r%rr rrr.rr&rr r r sql_profileHsB         r0N) django.httprrdjango.template.loaderrdjango.views.decorators.csrfrdebug_toolbar.decoratorsrrdebug_toolbar.panels.sql.formsrr'r-r0r r r rs"   !