def sql_explain(self): stmt, params = self.validate() engine_id = self.request.params['engine_id'] if not engine_id: raise HTTPBadRequest('No valid database engine') engines = self.request.registry.parent_registry.pdtb_sqla_engines engine = engines[int(engine_id)]() params = json.loads(params) if engine.name.startswith('sqlite'): query = 'EXPLAIN QUERY PLAN %s' % stmt else: query = 'EXPLAIN %s' % stmt result = engine.execute(query, params) return { 'result': result.fetchall(), 'headers': result.keys(), 'sql': format_sql(stmt), 'str': str, 'duration': float(self.request.params['duration']), }
def sql_explain(self): stmt, params = self.validate() engine_id = self.request.params['engine_id'] if not engine_id: raise HTTPBadRequest('No valid database engine') engine = getattr(self.request.registry, 'pdtb_sqla_engines')\ [int(engine_id)]() params = json.loads(params) if engine.name.startswith('sqlite'): query = 'EXPLAIN QUERY PLAN %s' % stmt else: query = 'EXPLAIN %s' % stmt result = engine.execute(query, params) return { 'result': result.fetchall(), 'headers': result.keys(), 'sql': format_sql(stmt), 'str': str, 'duration': float(self.request.params['duration']), }
def sql_select(self): stmt, params = self.validate() engine_id = self.request.params["engine_id"] # Make sure it is a select statement if not stmt.lower().strip().startswith("select"): raise HTTPBadRequest("Not a SELECT SQL statement") if not engine_id: raise HTTPBadRequest("No valid database engine") engine = getattr(self.request.registry, "pdtb_sqla_engines")[int(engine_id)]() params = [json.loads(params)] result = engine.execute(stmt, params) return { "result": result.fetchall(), "headers": result.keys(), "sql": format_sql(stmt), "duration": float(self.request.params["duration"]), }
def sql_select(self): stmt, params = self.validate() engine_id = self.request.params['engine_id'] # Make sure it is a select statement if not stmt.lower().strip().startswith('select'): raise HTTPBadRequest('Not a SELECT SQL statement') if not engine_id: raise HTTPBadRequest('No valid database engine') engines = self.request.registry.parent_registry.pdtb_sqla_engines engine = engines[int(engine_id)]() params = [json.loads(params)] result = engine.execute(stmt, params) return { 'result': result.fetchall(), 'headers': result.keys(), 'sql': format_sql(stmt), 'duration': float(self.request.params['duration']), }
def sql_select(self): stmt, params = self.validate() engine_id = self.request.params['engine_id'] # Make sure it is a select statement if not stmt.lower().strip().startswith('select'): raise HTTPBadRequest('Not a SELECT SQL statement') if not engine_id: raise HTTPBadRequest('No valid database engine') engine = getattr(self.request.registry, 'pdtb_sqla_engines')\ [int(engine_id)]() params = [json.loads(params)] result = engine.execute(stmt, params) return { 'result': result.fetchall(), 'headers': result.keys(), 'sql': format_sql(stmt), 'duration': float(self.request.params['duration']), }
def sql_explain(self): stmt, params = self.validate() engine_id = self.request.params["engine_id"] if not engine_id: raise HTTPBadRequest("No valid database engine") engine = getattr(self.request.registry, "pdtb_sqla_engines")[int(engine_id)]() params = json.loads(params) if engine.name.startswith("sqlite"): query = "EXPLAIN QUERY PLAN %s" % stmt else: query = "EXPLAIN %s" % stmt result = engine.execute(query, params) return { "result": result.fetchall(), "headers": result.keys(), "sql": format_sql(stmt), "str": str, "duration": float(self.request.params["duration"]), }