TTC
Theo's Typesafe Cult•17mo ago
Dale

How do you run `primsa` commands in a `create-t3-turbo` monorepo?

I can run pnpm db-push but I would like to run other commands, like prisma migrate. I can't figure out how to do this
5 Replies
Dale
Dale•17mo ago
Ahh never mind, you just need to cd to the prisma folder to run commands like npx prisma studio, etc Wait, that causes errors though because of the environment variables? e.g. 
> npx prisma migrate dev
Prisma schema loaded from schema.prisma
Error: Prisma schema validation - (get-config wasm)
Error code: P1012
error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:10
   | 
 9 |     provider = "postgresql"
10 |     url      = env("DATABASE_URL")
   | 

Validation Error Count: 1
> npx prisma migrate dev
Prisma schema loaded from schema.prisma
Error: Prisma schema validation - (get-config wasm)
Error code: P1012
error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:10
   | 
 9 |     provider = "postgresql"
10 |     url      = env("DATABASE_URL")
   | 

Validation Error Count: 1
Unknown User
Unknown User•17mo ago
Message Not Public
Sign In & Join Server To View
Dale
Dale•17mo ago
I have a different DATABASE_URL that is connected to a postegres database on supabase.. is that wrong?
Unknown User
Unknown User•17mo ago
Message Not Public
Sign In & Join Server To View
Dale
Dale•17mo ago
No I am still confused. My .env file already has a DATABASE_URL connection to a supabase hosted postgres database e.g. 
DATABASE_URL='postgres://postgres:{password}@db.{string}.supabase.co:6543/postgres'
DATABASE_URL='postgres://postgres:{password}@db.{string}.supabase.co:6543/postgres'
Wouldn't adding a local host overwrite that? Also, how would this allow me to run a npx prisma studio command from the root dir? Ahh it seems like it might be as simple as adding a 
"prisma": {
    "schema": "./packages/db/prisma/schema.prisma"
  },
"prisma": {
    "schema": "./packages/db/prisma/schema.prisma"
  },
to the package.json I will test more That does seem to be the answer ^^
Want results from more Discord servers?
Add your server
More Posts
Ternary statements with possible null/undefinedI am working with an object with the following shape: ```ts { image: string, previewImg: number } `Random webdev questionIs there a css property to update the arrow colour on a select component?When will the react Component remount?I hear React itself use Object.is to decide whether to reRender a component or not How about remounti require assistance from the typesafe cult (solved)type the keys on a `const` object while preserving their assigned values. ```ts const FileNamesMap:Help! using listbox headless uii code like this and it show me this error, anyidea how?How to use the accessToken to call a route that is protected by nextauth from server ?Does any one have examples where you use accessTokens to autenticate API call instead of cookies andBest way to AB Test on T3 Stack?What's the best way you've found to run A/B tests? Assuming you're deploying on vercel?Override ENV variables inside Docker ComposeHey, I have those ENV variables for my docker compose config. There's one problem, inside docker I hNew NodeError (looping error)I sometimes get this error over and over again in a loop, and can't figure out what's causing it. Antrpc query only once parameter is not nullNew in T3 stack so forgive me if this is a noob question: I am trying to run a trpc query only if