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 test_query_one(self): conn = mysql.connector.connect(host=os.getenv("DB_HOST"), database=os.getenv("DB_NAME"), user=os.getenv("DB_USER"), password=os.getenv("DB_PASS")) client = QueryData() cursor = conn.cursor() cursor.execute("SELECT * FROM posts LIMIT 1") row = cursor.fetchone() #row = row.items() row = client.parse_item(row) assert row['id'] == 1 assert row['title'] == "DrupalCamp Western Mass" assert row['active'] == 1 assert row['created_at'] == "2013-01-14"
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))
from query_data import QueryData if __name__ == "__main__": query = QueryData() query.handle()
def test_get_tags(self): client = QueryData() tags = client.get_tags(267) assert tags == "windows, linux, wsl, php"
def test_query_all(self): client = QueryData() results = client.all() assert results is not None
def test_connect(self): """ query all """ client = QueryData() assert isinstance(client.conn, mysql.connector.connection.MySQLConnection)
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)