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)