Error while locating templates files in a monorepo structure

[synicko]

Describe the bug

Structure of my projet

/monorepo
  node_modules
  packages
    server
      migrations
      node_modules

The server package contains the script to create migrations.
When I run node-pg-migrate create -j ts, the binary tries to load the templates files from the server node_modules folder and throws an error because the monorepo node_modules folder contains the package
I found a workaround by adding the option --templateFileName ../../node_modules/node-pg-migrate/templates/migration-template.ts to the command line but didn't have the problem in previous versions of node-pg-migrate

Steps to reproduce

cd [path_to_monorepo]/packages/server
node-pg-migrate create -j ts [migration_name]

Logs

[Error: ENOENT: no such file or directory, open '[...]/monorepo/packages/server/node_modules/node-pg-migrate/templates/migration-template.ts'] {
  errno: -2,
  code: 'ENOENT',
  syscall: 'open',
  path: '[...]/monorepo/packages/server/node_modules/node-pg-migrate/templates/migration-template.ts'
}

System Info

MacOS Somona 14.5
Node 20.15.1
node-pg-migrate 7.5.2

Used Module System

esm

[Shinigami92]

I knew this will bite me 😣
This is coming from #1208

• fix(esm): dont depend on __dirname #1208

/ping @aprendendofelipe

Potentially you need to live with the workaround for now and wait until node-pg-migrate is esm only

[MrPiao]

Can confirm this repros @ 7.7.0, and that the workaround still works

[guivictorr]

Just for the sake of documentation, I'm experiencing this issue using 7.9.0 with turborepo, everything works fine on 7.6.0

[Shinigami92]

Just for the sake of documentation, I'm experiencing this issue using 7.9.0 with turborepo, everything works fine on 7.6.0

#1263 (comment)

[Shinigami92]

@MrPiao @guivictorr @synicko @endor could you all tryout https://www.npmjs.com/package/node-pg-migrate/v/8.0.0-experimental-1328-1 and report any bugs to #1328?

• chore!: drop cjs support #1328

[guivictorr]

@Shinigami92 I will comment about monorepo in this issue to keep things organized 😅, I've created this repo to reproduce my problem and I wrote some instructions on the readme.

https://github.com/guivictorr/node-pg-migrate-demo

[Shinigami92]

@guivictorr perfect, thx
Will hopefully checkout tomorrow 🌃