ThimoDEV · November 6, 2023 09:59 · Nov 6, 2023
diff --git a/clear-planetscale-db-drizzle.ts b/clear-planetscale-db-drizzle.ts
@@ -0,0 +1,35 @@
+// db.ts
+import * as schema from "./schema"
+export const db = drizzle(connection, { schema })
+
+
+//reset.ts
+async function reset() {
+  const tableSchema = db._.schema
+  if (!tableSchema) {
+    throw new Error("No table schema found")
+  }
+
+  console.log("🗑️  Emptying the entire database")
+  const queries = Object.values(tableSchema).map((table) => {
+    console.log(`🧨 Preparing delete query for table: ${table.dbName}`)
+    return sql.raw(`TRUNCATE TABLE ${table.dbName};`)
+  })
+
+  console.log("📨 Sending delete queries...")
+
+  await db.transaction(async (tx) => {
+    await Promise.all(
+      queries.map(async (query) => {
+        if (query) await tx.execute(query)
+      })
+    )
+  })
+
+  console.log("✅ Database emptied")
+}
+
+reset().catch((e) => {
+
+  console.error(e)
+})