Function cleanupDb

tests/db-utils.ts:141–177

()

}

export async function cleanupDb() {
	const db = new Database(process.env.DATABASE_URL!.replace('file:', ''))

	try {
		// Disable FK constraints to avoid relation conflicts during deletion
		db.exec('PRAGMA foreign_keys = OFF')

		// Get all table names
		const tables = db
			.prepare(
				`
			SELECT name FROM sqlite_master 
			WHERE type='table' AND name NOT LIKE 'sqlite_%' AND name NOT LIKE '_prisma_migrations'
		`,
			)
			.all() as { name: string }[]

		// Delete tables except the ones that are excluded above
		for (const { name } of tables) {
			db.exec(`DROP TABLE IF EXISTS "${name}"`)
		}

		// Get migration SQLs and run each migration
		const migrationSqls = await getMigrationSqls()
		for (const statements of migrationSqls) {
			// Run each sql statement in the migration
			db.transaction(() => {
				for (const statement of statements) {
					db.exec(statement)
				}
			})()
		}
	} finally {
		db.exec('PRAGMA foreign_keys = ON')
		db.close()
	}
}