def query_tables_task(q):
with orcl_engine.connect().execution_options(
autocommit=True) as connection:
raw = stamp_queries["QUERIES"][q]
responses = []
errors = []
for stmt in sqlparse.split(raw):
try:
proxy = connection.execute(stmt.replace(";", ""))
responses += [dict(row) for row in proxy]
except Exception as e:
if not str(e) in config["ERR_EXCPTS"]:
errors.append(str(e))
return {"query": raw, "responses": responses, "errors": errors}
def populate_task():
with orcl_engine.connect().execution_options(
autocommit=True) as connection:
errors = []
for stmt in sqlparse.split(stamp_queries["POPULATE"]):
try:
proxy = connection.execute(stmt.replace(";", ""))
except Exception as e:
if not str(e) in config["ERR_EXCPTS"]:
errors.append(str(e))
return {
"query": stamp_queries["POPULATE"],
"responses": "Task successful",
"errors": errors
}
def get_table_task(tbl):
with orcl_engine.connect().execution_options(
autocommit=True) as connection:
raw = f"SELECT * FROM {tbl};"
try:
proxy = connection.execute(raw.replace(";", ""))
return {
"query": raw,
"responses": [dict(row) for row in proxy],
"errors": []
}
except Exception as e:
return {
"query": raw,
"responses": "Task successful",
"errors": [str(e)]
}
def ping_orcl_task():
with orcl_engine.connect().execution_options(
autocommit=True) as connection:
errors = []
raw = "SELECT 1 FROM DUAL;"
try:
proxy = connection.execute(raw.replace(";", ""))
return {
"query": raw,
"responses": [dict(row) for row in proxy],
"errors": errors
}
except Exception as e:
return {
"query": raw,
"responses": "Task successful",
"errors": errors
}
def raw_query_task(q):
with orcl_engine.connect().execution_options(
autocommit=True) as connection:
responses = []
errors = []
for stmt in sqlparse.split(q):
try:
proxy = connection.execute(stmt.replace(";", ""))
responses += [dict(row) for row in proxy]
except Exception as e:
if not str(e) in config["ERR_EXCPTS"]:
errors.append(str(e))
if not responses:
return {
"query": q,
"responses": "Task successful",
"errors": errors
}
return {"query": q, "responses": responses, "errors": errors}