def test_insert_row_dict_numeric(cursor): value = 101 values = { 'id': random_utilities.random_string(), 'numeric_col': value } assert postgres.insert_row_as_dict(cursor, test_table_name, values) is True postgres.remove_row(cursor, test_table_name, 'numeric_col', value)
def test_remove_row(cursor): column = 'id' columns = f'({column})' value = random_utilities.random_letters() values = f"('{value}')" postgres.insert_row(cursor, test_table_name, columns, values) assert postgres.remove_row(cursor, test_table_name, column, value) is True
def delete_row(self, column, value): return postgres.remove_row(self.cursor, self.name, column, value)
def test_remove_row_invalid(cursor): assert postgres.remove_row(cursor, test_table_name, None, None) is False
def test_insert_row_dict_apostrophe(cursor): value = "test'apo" values = {'id': value} assert postgres.insert_row_as_dict(cursor, test_table_name, values) is True postgres.remove_row(cursor, test_table_name, 'id', value)