def delete_data(self, table_name, filter_list, connect_word):
if not filter_list:
self.clean_table(table_name)
return
filter_query = Utils.parse_filter_query(filter_list, connect_word)
self.db_cursor.execute('DELETE FROM {} Where {}'.format(
table_name, filter_query))
self.db_file.commit()
def get_count(self,
source_table,
count_target='*',
filter_list=None,
connect_word=''):
if filter_list is None:
self.db_cursor.execute("SELECT count({}) FROM {}".format(
count_target, source_table))
else:
filter_query = Utils.parse_filter_query(filter_list, connect_word)
self.db_cursor.execute("SELECT count({}) FROM {} WHERE {}".format(
count_target, source_table, filter_query))
row = next(self.db_cursor)
return row[0]
