e12c9dc9f0Co-authored-by: Cursor Agent <cursoragent@cursor.com> Co-authored-by: Marcelo Mendonça Soares <marcelomendoncasoares@users.noreply.github.com>
43 lines
1.2 KiB
Dart
43 lines
1.2 KiB
Dart
// Keeps CRDT space aligned with integration tests plus the benchmark table.
|
|
|
|
import 'package:serverpod_database/serverpod_database.dart';
|
|
import 'package:serverpod_offline_sync_test_client/serverpod_offline_sync_test_client.dart';
|
|
|
|
/// [Types] is benchmark-only; the rest mirrors `client_session.dart` sync space.
|
|
List<Table> get benchmarkSyncTables => [
|
|
Address.t,
|
|
City.t,
|
|
Company.t,
|
|
FkChainCascadeMiddle.t,
|
|
FkChainMiddleCascadeChild.t,
|
|
FkChainMiddleSetNullChild.t,
|
|
FkChainRestrictBlocker.t,
|
|
FkChainRoot.t,
|
|
FkChainSetNullCascadeChild.t,
|
|
FkChainSetNullMiddle.t,
|
|
FkChainSetNullRestrictChild.t,
|
|
FkChainSetNullSetNullChild.t,
|
|
Organization.t,
|
|
Person.t,
|
|
RestrictChild.t,
|
|
Town.t,
|
|
Types.t,
|
|
Unique.t,
|
|
UniqueComposite.t,
|
|
UniqueSetNullChild.t,
|
|
UniqueUuid.t,
|
|
];
|
|
|
|
Future<void> clearUserTables(DatabaseSession session) async {
|
|
await session.db.unsafeExecute('PRAGMA foreign_keys = OFF');
|
|
final result = await session.db.unsafeQuery('''
|
|
SELECT name
|
|
FROM sqlite_master
|
|
WHERE (type = 'table') AND (name NOT LIKE 'serverpod_%')
|
|
''');
|
|
for (final row in result) {
|
|
final tableName = row[0] as String;
|
|
await session.db.unsafeExecute('DELETE FROM "$tableName"');
|
|
}
|
|
await session.db.unsafeExecute('PRAGMA foreign_keys = ON');
|
|
}
|