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]