Error: Can't find meta/_journal.json file when trying to apply migrations in a lambda

Amur · 2023-08-10T13:47:02.488Z

I'm trying to apply migration in a lambda locally with running sls invoke local -f db_run_migrations I use serverless framework with the serverless-esbuild plugin to package my lambdas I execute the lambda using the `sls invoke local -f db_run_migrations`command This is my folder structure and lambda handler

P

pandareaper•8/10/23, 10:30 PM

I'm doing the same thing in my project without issue, play around with

fs.existsSync()

fs.existsSync()

fs.existsSync()

fs.existsSync() to make sure the path you are setting is correct, it likely isn't

This is what we set as the path to our migrations folders

path.join(__dirname, 'drizzle')

path.join(__dirname, 'drizzle')

path.join(__dirname, 'drizzle')

path.join(__dirname, 'drizzle')

We copy the migration folder into our lambda bundle as part of our build

"postbuild": "cp -r ../../packages/database/drizzle dist",

"postbuild": "cp -r ../../packages/database/drizzle dist",

"postbuild": "cp -r ../../packages/database/drizzle dist",

"postbuild": "cp -r ../../packages/database/drizzle dist",

Ppandareaper I'm doing the same thing in my project without issue, play around with `fs.exist...

A

AmurOP•8/11/23, 5:46 PM

and what's executin the 'postbuild' script? are you also using the serverless-esbuild plugin? or i assume you are using sst because i'm using serverless framewrok

A

AmurOP•8/11/23, 6:17 PM

the migrations are definitely not getting included now, so i just have to find out how to include them

A

AmurOP•8/12/23, 6:11 PM

@pandareaper is the migration folder part of all your lambda's bundle? or just the one that's doing the migration?

P

pandareaper•8/12/23, 10:11 PM

Just the one thats doing the migration, after the build my

dist

dist

dist

dist directory looks like this.

main.js

main.js

main.js

main.js is my javascript bundle, using webpack.

drizzle

drizzle

drizzle

drizzle is my migration files etc. which are copied into the folder

postbuild

postbuild

postbuild

postbuild which yarn runs automatically when I run

yarn build

yarn build

yarn build

yarn build

P

pandareaper•8/12/23, 10:12 PM

I use the CDK and bundle everything in the

dist

dist

dist

dist folder as a ZIP

Locally I use

serverless-offline

serverless-offline

serverless-offline

serverless-offline and just point to the

dist/main.js

dist/main.js

dist/main.js

dist/main.js as my handler, so it can work with serverless as well

A

AmurOP•8/13/23, 9:15 AM

you bundle everything in the

dist

dist

dist

dist folder so you don't package them individually
so your

main.js

main.js

main.js

main.jsfile will have all the code for all your lambdas if i understand correctly
this is how my

.build

.build

.build

.build dir look like when i esbuild bundles everything

A

AmurOP•8/13/23, 9:16 AM

so then serverless-framework packages them individually

A

AmurOP•8/13/23, 9:49 AM

ah i think i got it working, i just had to set it up in serverless framework

added the

inlclude

inlclude

inlclude

inlclude option to my function

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

P

pandareaper•8/14/23, 6:56 AM

Nice, thats effectively equivalent to my postbuild step where I copy over the migration files

Error: Can't find meta/_journal.json file when trying to apply migrations in a lambda

Similar Threads

Similar Threads

Similar Threads