def get_table(date, table_name):
table = find_table(table_name, request.args.get("compartmentId",
default=""))
# The idea here is to maybe create a object will all this properties
return Response(
status=202,
content_type="application/json",
response=json.dumps({
"compartmentId": table["compartmentId"],
"ddlStatement": table["ddlStatement"],
"id": table["id"],
"isAutoReclaimable": None,
"lifecycleDetails": None,
"lifecycleState": None,
"name": table["name"],
"schema": None,
"tableLimits": table["tableLimits"],
"timeCreated": None,
"timeOfExpiration": None,
"timeUpdated": None,
}),
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)
def delete_row(date, table_name):
table = find_table(table_name, request.args.get("compartmentId",
default=""))
keys = request.args.getlist("key")
k = {}
for key in keys:
i = key.split(":")
k[i[0]] = i[1]
for row in table["_rows"]:
found = True
for key in k:
if str(row[key]) != k[key]:
found = False
if found:
table["_rows"].remove(row)
break
return Response(
status=200,
content_type="application/json",
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)
def delete_table(date, table_name):
table = find_table(table_name, request.args["compartmentId"])
remove_table(table)
return Response(
status=202,
content_type="application/json",
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)
def put_row(date, table_name):
data = json.loads(request.data)
table = find_table(table_name, data.get("compartmentId", ""))
table["_rows"].append(data["value"])
return Response(
status=200,
content_type="application/json",
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)
def get_row(date, table_name):
table = find_table(table_name, request.args.get("compartmentId",
default=""))
rows = table["_rows"]
keys = request.args.getlist("key")
k = {}
for key in keys:
i = key.split(":")
k[i[0]] = i[1]
row = find_row(rows, k)
return Response(
status=200,
content_type="application/json",
response=json.dumps({"value": row}),
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)
def query(date):
data = json.loads(request.data)
stmt = data["statement"].split(" ")
table_name = ""
for i in range(len(stmt)):
if stmt[i] == "FROM":
table_name = stmt[i + 1]
break
table = find_table(table_name, data["compartmentId"])
rows = table["_rows"]
return Response(
status=200,
content_type="application/json",
response=json.dumps({"items": rows}),
headers={
"opc-request-id":
request.headers["Opc-Request-Id"]
if "Opc-Request-Id" in request.headers else ""
},
)