def test_query_5(self):
with open('../queries/1.json') as json_data:
query = json.loads(json_data.read())
query_data = QueryData()
query_data_obj = query_data.create_query_data(query)
table_selector = TableSelector()
print "5 " + str(table_selector.eval_query(query_data_obj))
def plan_query(self, query_file_path, indexing, stats, optimization, print_json):
start = timer()
with open(query_file_path) as json_data:
query = json.loads(json_data.read())
query_data = QueryData()
query_data_obj = query_data.create_query_data(query, indexing, stats, optimization)
query_planner = QueryPlanner()
query_plan = query_planner.eval_query(query_data_obj)
print "\nPlan : " + str(query_plan)
end = timer()
print("\n\nPlan run time : " + str(end - start))
def run_query(self, query_file_path, indexing, stats, optimization, print_json):
start = timer()
with open(query_file_path) as json_data:
query = json.loads(json_data.read())
query_data = QueryData()
query_data_obj = query_data.create_query_data(query, indexing, stats, optimization)
if print_json:
print "\nQuery : " + str(query_data_obj)
query_planner = QueryPlanner()
query_plan = query_planner.eval_query(query_data_obj)
if print_json:
print "\nPlan : " + str(query_plan)
query_executor = QueryExecutor()
query_result = query_executor.execute_query(query_data_obj, query_plan, indexing)
if print_json:
print "\nResult : \n" + str(query_result)
end = timer()
print("\n\nQuery run time : " + str(end - start))
def test_query_data_1(self):
with open('../queries/1.json') as json_data:
query = json.loads(json_data.read())
query_data = QueryData()
query_data_obj = query_data.create_query_data(query)