TTC
Theo's Typesafe Cult•3mo ago
Gary, el Pingüino Artefacto

Applying drizzle migrations with Hono

Hi, I'm trying to apply that migrations on the directory like this: 
await migrate(drizzleDb, {
  migrationsFolder: "./src/databases/tenants/migrations",
})
await migrate(drizzleDb, {
  migrationsFolder: "./src/databases/tenants/migrations",
})
I'm using Nextjs, deployed on Vercel with a hono api. The path is /api/hono/tenants/create. But every time I get this error: Error: Can't find meta/_journal.json file at /var/task/.next/server/app/api/hono/[[...route]]/route.js:2467:42887 at qp (/var/task/.next/server/app/api/hono/[[...route]]/route.js:2467:43323) at /var/task/.next/server/app/api/hono/[[...route]]/route.js:2467:44022 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async o (/var/task/.next/server/chunks/636.js:67:10412) at async Function.P [as begin] (/var/task/.next/server/chunks/636.js:67:9981) at async qf (/var/task/.next/server/app/api/hono/[[...route]]/route.js:2467:43460) I have tried absolute urls, relative, using path.join, etc. Thanks for the help 😄
1 Reply
Gary, el Pingüino Artefacto
Gary, el Pingüino ArtefactoOP•3mo ago
After some hours, I managed to solve it. For anyone with the same issue, use the path module. 
    const folder = path.join(process.cwd(), "src", "databases", "tenants", "migrations")
    const folder = path.join(process.cwd(), "src", "databases", "tenants", "migrations")
I also added this on the next.conf, Idk if it is necesary but xd 
experimental: {
  outputFileTracingIncludes: {
    "/api/hono/[[...routes]]": ["./src/databases/tenants/migrations/**/*"],
    "/api/hono/tenants/create": ["./src/databases/tenants/migrations/**/*"],
  },
},
experimental: {
  outputFileTracingIncludes: {
    "/api/hono/[[...routes]]": ["./src/databases/tenants/migrations/**/*"],
    "/api/hono/tenants/create": ["./src/databases/tenants/migrations/**/*"],
  },
},
and 
webpack: (config, { isServer }) => {
  if (isServer) {
    if (process.env.VERCEL_ENV === "production") {
      execSync(`curl -X GET ${process.env.VERCEL_URL}/api/hono/tenants/create`)
    }
  }
  return config
},
webpack: (config, { isServer }) => {
  if (isServer) {
    if (process.env.VERCEL_ENV === "production") {
      execSync(`curl -X GET ${process.env.VERCEL_URL}/api/hono/tenants/create`)
    }
  }
  return config
},

Did you find this page helpful?