hari_narayan

PostsComments

PPrisma

•Created by hari_narayan on 2/21/2025 in #help-and-questions

Migration issue in UAT

i am just using command like "npx prisma migrate deploy" to deploy migration files... i have 34 migration done.... but now what i have done is like take a copy of databse ... and restored it locally.... now my UAT databse is in my local postgresDB...named as "UAT_DB_IN_LOCAL" (database having same data in ALL table as UAT) ------- i have added in schema file model stu { id int? name string? } now i am using command like .... npx prisma migrate dev --create-only its now coming to 28th migration correctly and for 29th migration its saying like below The migration 20241021113752_dcs_mangement was modified after it was applied. ? We need to reset the "public" schema at "localhost:5432" Do you want to continue? All data will be lost. » (y/N) i know that i have added all migration in UAT database sucessfully...... also there are 34 files presenr and 34 rows in prisma_migration table ..... then why i am getting error..... if i make different db name as "UAT_LOCAL_DB_TEST" (no data is restored empty db) and apply there its making migration.sql file correctly.... and if i use on "UAT_DB_IN_LOCAL" "npx prisma migrate deploy" then tables are created goodly...... -------------------------------------------------------------------------------- why i cant "npx prisma migrate dev --create-only" use it "UAT_DB_IN_LOCAL" ...........and create migration file?????

19 replies

PPrisma

•Created by hari_narayan on 2/1/2025 in #help-and-questions

Prisma+nestjs

Respected sir, I have issues in supabase free tier as my db...added globle prisma module added every thing onModuleleInit and onModuleDestroy and disconnect.... But still facing idleconnction error.. prisma not killing idle connection.....i need to go to db and kill idle onne tions how to make prisma safe and scalable... Thanks 🥺 ,🥺🥺

5 replies

PPrisma

•Created by hari_narayan on 1/29/2025 in #help-and-questions

Schema migration automation

Public schema is attached to my node.js app...i want to migrate schema of for y name schema to database.... I have prisma/public/public.schema folder structure and prisma/shema.prisma for schema db structure...so on api request i want to do migration how??? I have used excutesafe but its failed due to multiple commands.... Sql inside of it....

8 replies

PPrisma

•Created by hari_narayan on 1/25/2025 in #help-and-questions

Initialisation of prisma req based nestjs

Respected sir, My passport google strategy requires authservice in and that requires prisma request based service due to this my passport js is not initializing at start of app.... For that ai suggested moduleref of prismaReqBased service anything best service to inject in authservice.... Anything i am doing wrong .. 🙏 So prismaBaseservice will be injected everywhere in applications.... Prisma baservive is moduleref and request passes to request based tanant servive and then it is working.....

12 replies

PPrisma

•Created by hari_narayan on 1/23/2025 in #help-and-questions

Gi,Migration 2 shemafiles...schma1.prisma

Respected sir, shema1.prisma and shema2.prisma Fules how to generate migration files for both in seperate folders....what cli command i can use #migrations Prisma folder in that this two files exists.... Thanks

15 replies

PPrisma

•Created by hari_narayan on 1/7/2025 in #help-and-questions

PrismaModule as globle in neatjs with prisma service and dburl

How to #parametrize db url if i want to always pass this url from my request. I want like db per tanant model...

3 replies