updateDocument method
Updates a document in the specified collection
Implementation
@override
Future<void> updateDocument(
String collection,
String id,
Map<String, dynamic> data,
) async {
final connection = _requireConnection();
await _ensureCollection(collection);
final payload = _sanitizePayload(data);
final sql = Sql('UPDATE ${_tableName(collection)} SET data = \$1 WHERE id = \$2');
await connection.execute(
sql,
parameters: [
TypedValue(Type.jsonb, payload),
id,
],
);
}