| 141 | |
| 142 | |
| 143 | def update_record( |
| 144 | table_name: str, pk: int, data: dict[str, Any] |
| 145 | ) -> tuple[str, tuple[Any, ...]]: |
| 146 | check_identifier(table_name) |
| 147 | con = get_connection() |
| 148 | names = ', '.join(data.keys()) |
| 149 | placeholders = ', '.join(['?'] * len(data)) |
| 150 | values = tuple(data.values()) + (pk,) |
| 151 | sql = f'UPDATE {table_name} SET ({names}) = ({placeholders}) WHERE pk = ?' |
| 152 | con.execute(sql, values) |
| 153 | con.commit() |
| 154 | return sql, values |
| 155 | |
| 156 | |
| 157 | def delete_record(table_name: str, pk: int) -> sqlite3.Cursor: |