def query_c():
tmp_result = select(SUPPLY, "pid", "=", "p15")
tmp_result = join(tmp_result, "sid", SUPPLIERS, "sid")
query_result = project(tmp_result, ["address"])
removeTable("Supply_tmp")
removeTable(tmp_result)
return query_result
def query_e():
tmp_result = select(SUPPLY, "cost", ">=", 47.00)
tmp_res1 = join(tmp_result, "pid", PRODUCTS, "pid")
tmp_res2 = join(tmp_res1, "sid", SUPPLIERS, "sid")
query_result = project(tmp_res2, ["sname", "pname", "cost"])
removeTable("Supply_tmp")
removeTable(tmp_res1)
removeTable(tmp_res2)
return query_result
def query_d():
tmp_res1 = select(SUPPLIERS, "sname", "=", "Kiddie")
tmp_res2 = select(SUPPLY, "pid", "=", "p20")
tmp_result = join(tmp_res1, "sid", tmp_res2, "sid")
query_result = project(tmp_result, ["cost"])
removeTable("Suppliers_tmp")
removeTable("Supply_tmp")
removeTable(tmp_result)
return query_result
def query_b():
tmp_result = select(SUPPLIERS, "sid", "=", "s23")
query_result = project(tmp_result, ["sname"])
removeTable("Suppliers_tmp")
return query_result
removeTable(tmp_res1)
removeTable(tmp_res2)
return query_result
if __name__ == "__main__":
# res = query_x()
with open(os.path.join(OUTPUT_PATH, QUERY_RESULT), "a+") as qr:
qr.write(
"Find the name for the supplier ‘s23’ when a B+_tree exists on Suppliers.sid.\r\n\r\n"
)
res = query_a()
display_schema(res, QUERY_RESULT)
displayTable(res, QUERY_RESULT)
removeTable(res)
removeTree(SUPPLIERS, "sid")
with open(os.path.join(OUTPUT_PATH, QUERY_RESULT), "a+") as qr:
qr.write(
"Remove the B+_tree from Suppliers.sid, and repeat Question a.\r\n\r\n"
)
res = query_b()
display_schema(res, QUERY_RESULT)
displayTable(res, QUERY_RESULT)
removeTable(res)
with open(os.path.join(OUTPUT_PATH, QUERY_RESULT), "a+") as qr:
qr.write(
"Find the address of the suppliers who supplied ‘p15’.\r\n\r\n")