How to Delete and Truncate Everything on Drizzle (PostgreSQL)

[psygo]

This question was originally asked on Stack Overflow.

I'm a bit surprised this isn't present in the Drizzle docs or, better yet, isn't a function out of the box with it, but how exactly do you delete and truncate everything?

I've tried many variations of what's on this Answer Overflow post but it doesn't seem to truncate things actually:

async function deleteEverything() {
  try {
    await db.delete(posts)
    await db.delete(users)

    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(/* sql */ `TRUNCATE TABLE ${table.dbName} CASCADE;`)
      },
    )

    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")
  } catch (e) {
    console.error(e)
  }
}