Running SQL statement manually for in-memory database

import { readdir } from "node:fs/promises"
import path from "path"
import { createClient } from "@libsql/client/node"
import { drizzle } from "drizzle-orm/libsql"

const client = createClient({
  url: ":memory:",
})

export const db = drizzle(client, { logger: true })

migrate()

export async function migrate() {
  const migrations = path.resolve(__dirname, "migrations")

  const files = await readdir(migrations)

  for (const file of files) {
    if (file.endsWith(".sql")) {
      const read = Bun.file(path.resolve(migrations, file))

      const sql = await read.text()

      const result = await db.run(sql)

      console.log("result", result)
    }
  }
}