Build exception with different env

[rdrigos]

Question

Good afternoon, I'm starting to use PRISMA ORM in my TypeScript code, and I have some questions...
After initializing a project with PRISMA using the command npx prisma init, it creates the following structure:

project
    |---- prisma
    |            |---- prisma.schema
    |
    |---- .env
    |---- src (my folder with API files, bots....)
    |---- package.json
    |---- package-lock.json

and I would like to move this .env file to the env folder, so it would look like this:

project
  |---- env
  |          |---- .env
  |
  |---- prisma
  |          |---- prisma.schema
  |
  |---- .env
  |---- src (my folder with API files, bots....)
  |---- package.json
  |---- package-lock.json

without causing an error in prisma.schema at the time of table creation and execution of the PRISMA code. I also would like to show a better structure, how the code will be executed on a local server:

project
  |---- env
  |          |---- env.development
  |          |---- env.production
  |
  |---- prisma
  |          |---- prisma.schema
  |
  |---- .env
  |---- src (my folder with API files, bots....)
  |---- package.json
  |---- package-lock.json

and in this way, when building:

project
  |---- dist
  |         |---- development
  |         |---- production
  |
  |---- env
  |          |---- env.development
  |          |---- env.production
  |
  |---- prisma
  |          |---- prisma.schema
  |
  |---- .env
  |---- src (my folder with API files, bots....)
  |---- package.json
  |---- package-lock.json

each of these environments knows which env file to use from the env folder and executes correctly.

How to reproduce (optional)

No response

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

No response

[janpio]

Prisma only looks for .env in the root folder. But you can use dotenv-cli or similar packages to load the .env file from any location you want.

[rdrigos]

Ok, could you explain this to me better? Or leave an article explaining how it works

[ludralph]

Hi @rdrigos, Can you take a look at this section of the documentation?