def db_command(self):
return argo_db.execute_sql(
'SELECT * FROM nobench_main WHERE str1 = "{}";'.format(self.arguments[0]))
def db_command(self):
# return argo_db.execute_sql("SELECT * FROM nobench_main WHERE num BETWEEN 30000 AND 30100;")
return argo_db.execute_sql("SELECT * FROM nobench_main WHERE num >= {} AND num < {};".format(self.arguments[0],
self.arguments[1]))
def db_command(self):
return argo_db.execute_sql("SELECT nested_obj.str1, nested_obj.num FROM nobench_main;")
def db_command(self):
return argo_db.execute_sql("SELECT sparse_110, sparse_220 FROM nobench_main;")
def db_command(self):
return argo_db.execute_sql("DELETE FROM nobench_main")
def db_command(self):
return argo_db.execute_sql("SELECT str1, num FROM nobench_main;")
def db_command(self):
return argo_db.execute_sql("""SELECT deep_nested_obj.level_2.level_3.level_4.level_5.level_6.level_7.level_8.deep_str_agg
FROM nobench_main
WHERE deep_nested_obj.level_2.level_3.level_4.level_5.level_6.level_7.level_8.deep_str_agg = "{}";""".format(self.arguments[0]))
def db_command(self):
return argo_db.execute_sql('SELECT * FROM nobench_main WHERE deep_nested_obj.level_2.level_3.level_4.level_5.level_6.level_7.level_8.deep_str_single = "{}"'.format(self.arguments[0]))
def db_command(self):
return argo_db.execute_sql("""SELECT * FROM nobench_main AS left INNER JOIN
nobench_main AS right ON (left.nested_obj.str =
right.str1) WHERE left.num BETWEEN XXXXX AND YYYYY;""")
def prepare(self):
results = argo_db.execute_sql("SELECT sparse_500 FROM nobench_main")
for index, result in enumerate(results):
if index == 5:
self.arguments.append(result['sparse_500'])
def db_command(self):
return argo_db.execute_sql("SELECT * FROM nobench_main WHERE dyn1 >= {} AND dyn1 < {};".format(self.arguments[0],
self.arguments[1]))
