| 57 | } |
| 58 | |
| 59 | async function hasDrizzleMigrationHistory(path: string): Promise<boolean> { |
| 60 | if (!existsSync(path)) return true; |
| 61 | |
| 62 | const db = await PGlite.create(path); |
| 63 | const result = await db.query<{ exists: boolean }>(` |
| 64 | SELECT EXISTS ( |
| 65 | SELECT 1 |
| 66 | FROM information_schema.tables |
| 67 | WHERE table_schema = 'drizzle' |
| 68 | AND table_name = '__drizzle_migrations' |
| 69 | ) AS "exists" |
| 70 | `); |
| 71 | await db.close(); |
| 72 | return result.rows[0]?.exists === true; |
| 73 | } |
| 74 | |
| 75 | if (!(await hasDrizzleMigrationHistory(DB_PATH))) { |
| 76 | console.log("[dev-db] Resetting dev database without Drizzle migration history"); |