Function resetTestDatabaseClient

src/database/testing.ts:37–59

(client: TestDatabaseClient)

}

export async function resetTestDatabaseClient(client: TestDatabaseClient): Promise<void> {
  const schemaObjects = await client.execute(`
    SELECT type, name
    FROM sqlite_master
    WHERE name NOT LIKE 'sqlite_%'
      AND type IN ('table', 'view', 'trigger')
    ORDER BY CASE type WHEN 'trigger' THEN 0 WHEN 'view' THEN 1 ELSE 2 END
  `);

  await client.execute('PRAGMA foreign_keys = OFF');
  try {
    for (const row of schemaObjects.rows) {
      const type = String(row.type).toUpperCase();
      if (type !== 'TABLE' && type !== 'VIEW' && type !== 'TRIGGER') {
        continue;
      }
      const name = String(row.name).replace(/"/g, '""');
      await client.execute(`DROP ${type} IF EXISTS "${name}"`);
    }
  } finally {
    await client.execute('PRAGMA foreign_keys = ON');
  }
}

export async function closeTestDatabaseClient(client: TestDatabaseClient): Promise<void> {
  await enqueueTestDatabaseOperation(async () => {