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