î à^Q\ ã@s²ddlmZmZddlmZddlmZddlmZddl m Z ddl m Z ee dd„ƒƒZ ee d d „ƒƒZee d d „ƒƒZd S)é)Úabsolute_importÚunicode_literals)ÚHttpResponseBadRequest)ÚSimpleTemplateResponse)Ú csrf_exempt)Úrequire_show_toolbar)Ú SQLSelectFormcCsÔt|jpdƒ}|jƒrÊ|jd}|jd}|j}|j||ƒdd„|jDƒ}|jƒ}|jƒi|d6|j ƒd6|jdd6|d 6|jd d 6}t d |ƒSt d ƒS) z.Returns the output of the SQL SELECT statementNÚraw_sqlÚparamscSsg|]}|d‘qS)r©)Ú.0Údr r úR/var/www/dbchiro/venv/build/django-debug-toolbar/debug_toolbar/panels/sql/views.pyú s zsql_select..ÚresultÚsqlÚdurationÚheadersÚaliasz$debug_toolbar/panels/sql_select.htmlz Form errors) rÚPOSTÚis_validÚ cleaned_dataÚcursorÚexecuteÚ descriptionÚfetchallÚcloseÚ reformat_sqlrr)ÚrequestÚformrr rrrÚcontextr r rÚ sql_select s"        r!c Cs3t|jpdƒ}|jƒr)|jd}|jd}|jj}|j}|dkrv|jd|f|ƒn=|dkrœ|jd|f|ƒn|jd|f|ƒd d „|jDƒ}|j ƒ}|j ƒi|d 6|j ƒd 6|jd d 6|d6|jdd6}t d|ƒSt dƒS)z8Returns the output of the SQL EXPLAIN on the given queryNr r ZsqlitezEXPLAIN QUERY PLAN %sZ postgresqlzEXPLAIN ANALYZE %sz EXPLAIN %scSsg|]}|d‘qS)rr )r r r r rr;s zsql_explain..rrrrrz%debug_toolbar/panels/sql_explain.htmlz Form errors)rrrrÚ connectionÚvendorrrrrrrrr) rrrr r#rrrr r r rÚ sql_explain%s,           r$c Cs3t|jpdƒ}|jƒr)|jd}|jd}|j}d}d}d}y]|jdƒ|j||ƒ|jdƒ|jdƒdd„|jDƒ}|jƒ}Wntk rÍd }YnX|j ƒi|d 6|d 6|j ƒd 6|jd d 6|d6|jdd6}t d|ƒSt dƒS)zJReturns the output of running the SQL and getting the profiling statisticsNr r zSET PROFILING=1zSET PROFILING=0zÓ SELECT * FROM information_schema.profiling WHERE query_id = ( SELECT query_id FROM information_schema.profiling ORDER BY query_id DESC LIMIT 1 ) cSsg|]}|d‘qS)rr )r r r r rrgs zsql_profile..zDProfiling is either not available or not supported by your database.rÚ result_errorrrrrz%debug_toolbar/panels/sql_profile.htmlz Form errors) rrrrrrrrÚ Exceptionrrrr) rrrr rrrr%r r r rÚ sql_profileJs8            r'N)Ú __future__rrZ django.httprZdjango.template.responserZdjango.views.decorators.csrfrZdebug_toolbar.decoratorsrZdebug_toolbar.panels.sql.formsrr!r$r'r r r rÚs$