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")