def process_response(self, response):
data = []
for index, query in enumerate(self.queries):
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
need = self.token + stmt + params
hash = hashlib.sha1(bytes_(need)).hexdigest()
data.append({
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'hash': hash,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
'query_index': index,
})
self.data = {
'queries': data,
'text': text,
}
def process_response(self, response):
data = []
for query in self.queries:
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
need = self.token + stmt + params
hash = hashlib.sha1(bytes_(need)).hexdigest()
data.append({
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'hash': hash,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
})
self.data = {
'queries':data,
'text':text,
}
def process_response(self, response):
data = []
for index, query in enumerate(self.queries):
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
data.append({
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
'query_index': index,
})
self.data = {
'queries': data,
'text': text_,
'engines': self.engines,
}
def process_response(self, response):
data = []
for index, query in enumerate(self.queries):
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except ValueError:
pass # JSON parameters serialization can generate ValueError
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
data.append(
{
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
'query_index': index,
}
)
self.data = {
'queries': data,
'text': text_,
'engines': self.engines,
}
def validate(self):
stmt = self.request.params['sql']
params = self.request.params['params']
# Validate hash
need = self.token + stmt + url_quote(params)
hash = hashlib.sha1(bytes_(need)).hexdigest()
if hash != self.request.params['hash']:
raise HTTPBadRequest('Bad token in request')
return stmt, params
def validate(self):
stmt = self.request.params['sql']
params = self.request.params['params']
# Validate hash
need = self.request.exc_history.token + stmt + url_quote(params)
hash = hashlib.sha1(bytes_(need)).hexdigest()
if hash != self.request.params['hash']:
raise HTTPBadRequest('Bad token in request')
return stmt, params
def validate(self):
stmt = self.request.params["sql"]
params = self.request.params["params"]
# Validate hash
need = self.request.exc_history.token + stmt + url_quote(params)
hash = hashlib.sha1(bytes_(need)).hexdigest()
if hash != self.request.params["hash"]:
raise HTTPBadRequest("Bad token in request")
return stmt, params
def content(self):
if not self.queries:
return "No queries in executed in request."
data = []
for query in self.queries:
stmt = query["statement"]
is_select = stmt.strip().lower().startswith("select")
params = ""
try:
params = url_quote(json.dumps(query["parameters"]))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
need = self.request.exc_history.token + stmt + params
hash = hashlib.sha1(bytes_(need)).hexdigest()
data.append(
{
"engine_id": query["engine_id"],
"duration": query["duration"],
"sql": format_sql(stmt),
"raw_sql": stmt,
"hash": hash,
"parameters": query["parameters"],
"params": params,
"is_select": is_select,
"context": query["context"],
}
)
vars = {
"static_path": self.request.static_url(STATIC_PATH),
"root_path": self.request.route_url(ROOT_ROUTE_NAME),
"queries": data,
"text": text,
}
delattr(self.request, "pdtb_sqla_queries")
return self.render("pyramid_debugtoolbar.panels:templates/sqlalchemy.dbtmako", vars, self.request)
def content(self):
if not self.queries:
return 'No queries in executed in request.'
data = []
for query in self.queries:
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
need = self.request.exc_history.token + stmt + params
hash = hashlib.sha1(bytes_(need)).hexdigest()
data.append({
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'hash': hash,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
})
vars = {
'static_path': self.request.static_url(STATIC_PATH),
'root_path': self.request.route_url(ROOT_ROUTE_NAME),
'queries': data,
'text': text,
}
delattr(self.request, 'pdtb_sqla_queries')
return self.render(
'pyramid_debugtoolbar.panels:templates/sqlalchemy.dbtmako', vars,
self.request)
def content(self):
if not self.queries:
return 'No queries in executed in request.'
data = []
for query in self.queries:
stmt = query['statement']
is_select = stmt.strip().lower().startswith('select')
params = ''
try:
params = url_quote(json.dumps(query['parameters']))
except TypeError:
pass # object not JSON serializable
except UnicodeDecodeError:
pass # parameters contain non-utf8 (probably binary) data
need = self.request.exc_history.token + stmt + params
hash = hashlib.sha1(bytes_(need)).hexdigest()
data.append({
'engine_id': query['engine_id'],
'duration': query['duration'],
'sql': format_sql(stmt),
'raw_sql': stmt,
'hash': hash,
'parameters': query['parameters'],
'params': params,
'is_select': is_select,
'context': query['context'],
})
vars = {
'static_path': self.request.static_url(STATIC_PATH),
'root_path': self.request.route_url(ROOT_ROUTE_NAME),
'queries':data,
'text':text,
}
delattr(self.request, 'pdtb_sqla_queries')
return self.render(
'pyramid_debugtoolbar.panels:templates/sqlalchemy.dbtmako',
vars, self.request)
