NestJs migrations with TypeORM 0.3 (latest) - How to set it up from scratch using Datasource

[@irfandyjip3246]

Saved for myself 12:19 Start talking about Migration 19:09 Migrations script

[@amitavroydev]

Interesting

[@serbanzidaru943]

Thank you for this. I spent 3 hours on the official nestjs course and wasn't able to run the migrations. With your video literally 15 minutes and it works perfect. Life saver.

[@amitavroydev]

That's great to head. Thanks for the comment

[@mariemmatri8743]

Thank you so much! I also liked how you figured out the issues in the video without cutting the video

[@amitavroydev]

Thanks

[@CaminoConDiego]

Dude! Thanks a lot seriously! This video must be at Nestjs and Typeform docs!!! Can not believe that I almost lost the day trying to find a way to create my migration

[@amitavroydev]

Good to know it helped you

[@budgeter4807]

No amount of words can explain how thankful I am. Umetisha chief...

[@amitavroydev]

Thank you so much 🙏

[@debadipti]

You saved me from a lot of pain since ages!! Thank you !

[@amitavroydev]

Glad I could help!

[@MrDiGrayMan]

I've spent hours reading nest js and typeorm docs, and finaly found this video. Eveything works perfect, thank you!

[@amitavroydev]

Great to know it helped you

[@YonatanVigilioUsa]

No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command.

[@amitavroydev]

OK

[@rjaysharma3097]

I getting the same issue. Are you able to solve it?

[@EzequielBinker]

"No changes in database schema were found - cannot generate a migration" issue. Did anyone solve this ? I'm using typeorm 0.3. Thanks

[@amitavroydev]

This reply from Yaseen shaik might work 1. Stop all the executions. 2. delete the generated sql file. 3. do "npm run start:dev" or "yarn start:dev" 4. Open another terminal in the root directory 5. and enter the migration:generate command as shown in the video. Hope this solve your issue.

[@sarunmrzn]

Can you inject the config service to datasource for env vars? I can only get it working with dotenv package, it'd be nice if there was a workaround by using config service itself

[@amitavroydev]

Still couldn't make it happen

[@nucleus8706]

How did you do it with dotenv?

[@golu8045]

Hello sir, can you share a github repo link of this code? because I am getting an error "No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command" or please make a video how to solve this issue

[@amitavroydev]

I don't have a Github repo for just this video

[@davisperezguzman3384]

could you solve it? I sell the same

[@golu8045]

@@davisperezguzman3384 if you are using typeorm@0.3.12 then downgrade the version because it is a bug of typeorm for windows laptops.

[@joaovitor-mc5co]

Thanks for the explanation, this perfectly resolve my problem with migrations in the TypeORM.

[@amitavroydev]

Good to know

[@nealfarrand1246]

This was very helpful. Thanks for putting this together. It was very clear to understand.

[@amitavroydev]

Great to hear!

[@adesegunadebayo]

I have been pulling my hair with the breaking changes from typeorm >= 0.3 versions, I'll update this thread if it comes out successful!

[@amitavroydev]

I am trying to do the same. Some issue with typeorm and nestjs configuration

[@nucleus8706]

if you encounter cannot find ./app.controller - something is wrong in your dist file. I ran prebuilt command to generate dist folder and it worked.

[@amitavroydev]

Thanks for the help buddy

[@nucleus8706]

@@amitavroydev I must thank you. Your video made things more clear that I was struggling with. How do you load env credentials in datasource with config service?

[@amerhamed1729]

Hi sir I don't know why but when i try to run the second command of migration generate it give me to create an other tables not Alter

[@amitavroydev]

Look at the migration table. Do you already have entries

[@amerhamed1729]

@@amitavroydev yes share the code please

[@romanpredein]

I spent three days with the documentation to no avail. I should have gone here first. Thanks!!!

[@amitavroydev]

Thanks for the comment. Do subscribe if you’re not already a subscriber 🙏

[@sagargopale8718]

I do not get DataSourceOptions in typeorm module. What version are you using for @nestjs/typeorm and typeorm?

[@amitavroydev]

I am using 0.3

[@iamabhirupdatta]

Hey, i am having issues when doing this in a express-ts project without nextjs. I have a src folder which contains ts files and a dist folder which output js files in same name as ts except with .js extension. Everything is working except the migrations commands. "start": "cross-env NODE_ENV=dev node dist/server.js", "typeorm": "npm run start && ts-node ./node_modules/typeorm/cli", "typeorm:generate-migration:win": "npm run typeorm -- -d ./src/api/database/initialize.ts migration:generate ./dist/api/database/migrations/FirstMigration" The commands run but the migration file doesnot generate. Please help

[@amitavroydev]

Hmm, I haven't looked at the integration of TypeORM with Express yet. However, tell me one thing - does it work properly if sync is set to true?

[@MayabiLinux]

How do I load the data source , and typeOrmModule.forRoot from same .env file ? anyone has any idea or can give me some hints please ? Thanks

[@amitavroydev]

Haven't tried that yet

[@vijayendralolla]

Your videos are Great. One request is to make another series for writing tests using jest (for this Quiz project)

[@amitavroydev]

will try

[@avivlevinson6245]

Thank you very much! In the newer versions of TypeORM, the @EntityRepository() decorator has been deprecated. any idea how to solve that ?

[@amitavroydev]

Normal queries I guess. Haven't checked in details yet

[@nicolagabriel8520]

How about if i want to use config service for env when creating a datasource?

[@amitavroydev]

Need to try that

[@khaledali777]

I have been struggling to make it happen. You made my day. 👍

[@amitavroydev]

Glad I could help

[@saif_haq_]

"No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command" Please tell how to solve this.......... the only difference in my code is that i'm using Postgres and i've used graphql instead of rest api

[@amitavroydev]

This solution by YaseenShaik might work 1. Stop all the executions. 2. delete the generated sql file. 3. do "npm run start:dev" or "yarn start:dev" 4. Open another terminal in the root directory 5. and enter the migration:generate command as shown in the video. Hope this solve your issue.

[@matheusrehbein4234]

nice thanks... please add in the playlist

[@amitavroydev]

Added

[@okekunleoluwatobiloba9184]

i'll be honest with you, ATM, you are my GOAT!!!!!!!!!

[@amitavroydev]

Thank you so much

[@orjiemmanuel1418]

Thank you so much for this video, mine was able to generate the migration file after a created a new entity that wasn't in the database but when I run migration:run command I get "No Migrations are pending"

[@orjiemmanuel1418]

I made some adjustment in my data-source file and it worked just fine!

[@amitavroydev]

Good to know it finally worked

[@shivam.gupta25]

@@orjiemmanuel1418 what adjustments did you made

[@shalandichannel]

do you why i might get this error: Error during migration generation: TypeError at Reflect.getMetadat sounds familiar ?

[@shalandichannel]

i am using version 0.3 of typeorm

[@amitavroydev]

Well I am not getting that error Could be some configuration issue

[@amitavroydev]

What node version are you on

[@victorm9131]

Extremely helpful video. Thanks a lot!

[@amitavroydev]

You are welcome my friend

[@ebukaokoye5286]

Thanks a lot, i have been running around looking for a solution to my migration bugs and you helped me fix them, i appreciate.

[@amitavroydev]

Glad I could help

[@ongo9977]

how to read database config from env file

[@amitavroydev]

There is already a video in this series where I have done that. You can check that.

[@ongo9977]

@@amitavroydev tks you

[@JoeJoseph79]

How do I implement seeding here

[@amitavroydev]

Any problem with the original video that I have created on Seeder?

[@rudeadyet1992]

Thanks very useful. Also, what about Seeding? Is it the same as of you old tutorial.

[@amitavroydev]

Yes, it is

[@sriharsha186]

Everyone who gets this warning:'No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command' - This is either because you did not have Entity() decorator or because the table already exists in the DB. Remember, in the video, the table was first deleted before the command to run migrations was run

[@amitavroydev]

Thanks 👍

[@ArkojeetMukherjee]

I dropped all my tables, still I have this message.

[@ArkojeetMukherjee]

I have the @Entity() decorator, but still nothing.

[@ArkojeetMukherjee]

Never mind, I solved it thanks I missed one part of it

[@CaminoConDiego]

this happened to me, take a look on your entities: ['dist/**/*.entity.js'], migrations: ['dist/db/migrations/*.js'], keys at dataSourceOptions object. it must look like the example

[@zayyanabdillah7031]

is it mandatory to create datasource in root level?

[@amitavroydev]

Not necessary.

[@Айдер-т5з]

This is a great guide. I spent a lot of time setting up migrations. like, share, subscribe

[@amitavroydev]

Thanks my friend

[@vladislavderkach2647]

Thank you, bro. It was very helpful!

[@amitavroydev]

Glad it helped!

[@djaos-8326]

This work for postgresql?

[@amitavroydev]

haven't tried. but typeorm does work with pgsql, so I am assuming it should

[@sargonfromazupiranu6544]

Grate video! But how to insert default data?

[@amitavroydev]

You need to use seeders

[@goikarBaab]

​ @Amitav Roy I am getting an error, when i run the migrations. It says there are no migrations to run, even though there are pending scripts in the DB. Can you please share the repo link for this codebase

[@amitavroydev]

Hi ivo costa, I don't have a repo just for this video because I started from the installation. Let me see, if I can work on a series and create a Repo like I have done for the older NestJs project.

[@somebody-17546]

Where i can get code ?

[@amitavroydev]

This is an isolated video. You can follow the video to get the code. However, the entire series code can be found here: my-lnk.com/2188012324

[@olgabaeva727]

+1 for the "No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command" error ((

[@yaseenshaik103]

1. Stop all the executions. 2. delete the generated sql file. 3. do "npm run start:dev" or "yarn start:dev" 4. Open another terminal in the root directory 5. and enter the migration:generate command as shown in the video. Hope this solve your issue.

[@amitavroydev]

Hope the solution worked

[@amitavroydev]

Thanks for the help

[@jesuscordoba1117]

Thank you very much, very useful and worked perfectly.

[@amitavroydev]

Glad it helped

[@Nageswararao93]

Thank you so much for the great video. Can you please do a video on how to run migrations(refersh database) for e2e testing?

[@amitavroydev]

Will try to first learn myself :)

[@jaganath15]

Thanks❤, it's working like a charm

[@amitavroydev]

Welcome 😊

[@orkhanmammadli1]

thanks a lot for your effort 👍

[@amitavroydev]

You are welcome

[@spoodermen2530]

thanks! worked well for me.

[@amitavroydev]

Glad it helped

[@Fill-c6j]

Thank you! solve my problem

[@amitavroydev]

Glad that it worked

[@liammax7289]

Can you givr us a tutorial for the new seeding please ?

[@amitavroydev]

Oh, I haven’t played with nestjs recently. Have been completely busy with the amazing stuff that has come up in the laravel ecosystem. Will check and try to do one video

[@Katie-hb8iq]

Why on earth would they change this and not update their documentation? They just say, "Make sure to create a database config file and give it the path" and that's gotta be as vague as humanly possible.

[@amitavroydev]

IDK

[@eunjikim2u]

You saved me too!!! Thank you so much! You are genius!!! LOL

[@amitavroydev]

Glad I could help!

[@killxflip8547]

Everyone who gets this warning:'No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command', add the @Entity() docorator to your entity class

[@amitavroydev]

Thanks 🙏

[@rafaeldossantostiburcio509]

Great video, congratulations

[@amitavroydev]

Thank you!

[@aurelinemotouom620]

you saved me , A video of seeders please

[@amitavroydev]

Yes, that's in the pipeline. Have been working on the Electron series so got delayed. Will try to come up with that soon

[@malamhari_]

Thanks, it helps me a lot

[@amitavroydev]

Glad to hear that!

[@_vlmdr]

Help me a lot! Thanks man

[@amitavroydev]

Happy to help!

[@sadamhussain5009]

Great Video We are facing No changes in database schema were found - cannot generate a migration. To create a new empty migration use "typeorm migration:create" command

[@amitavroydev]

What the scenario? Ideally it would detect change by default if actually there is a change

[@eduardokiriakos6255]

I got the same! Did you fix it?

[@nicolassavenay4602]

​@@eduardokiriakos6255 You can try to import migrations files as module (import { migrationName} from './path/to/migrationName';) and use it in the migrations array of dataSourceOptions: migrations: [migrationName]

[@eduardokiriakos6255]

@@nicolassavenay4602 I did it that way and it works! Thanks! But I would like to find a better way to do it :(

[@yaseenshaik103]

1. Stop all the executions. 2. delete the generated sql file. 3. do "npm run start:dev" or "yarn start:dev" 4. Open another terminal in the root directory 5. and enter the migration:generate command as shown in the video. Hope this solve your issue.

[@TheTomislavb]

Great video, thank you

[@amitavroydev]

You are welcome!

[@yuliakhitrukhina]

Nice, thanks!

[@amitavroydev]

Welcome

[@yaumiadz]

thx, it's useful af. like it

[@amitavroydev]

Glad it helped

[@islamicworld5086]

God bless u sir

[@amitavroydev]

Thank you 🙏

[@ManojRai-k2x]

Very Helpful. What is the exact version of typeorm you are using in this video?

[@amitavroydev]

0.3

[@code-island]

Very Good Content

[@amitavroydev]

Thank you 🙏

[@islamicworld5086]

Excellent work

[@amitavroydev]

Many thanks

[@cesarkohl]

TYVM!

[@amitavroydev]

YAW

[@the0FFH]

Thanks!!

[@amitavroydev]

Welcome

[@defaultName-gw1vg]

thank you

[@amitavroydev]

You're welcome

[@ICOReviewtoken]

please give me source github bro

[@amitavroydev]

I don’t have code for just this video. You can refer to the main series. You will find the github code

[@alphaprimeacademy474]

very helpful video

[@amitavroydev]

Glad it was helpful!

[@islamicworld5086]

Thanks

[@amitavroydev]

Welcome

[@crescini.adrian]

Crack +10

[@amitavroydev]

Thanks

[@javierrenteria3195]

can you share us the repo? thanks

[@amitavroydev]

The main series n Nest has a repo. For this particular video, I have not created a separate repo

[@javierrenteria3195]

@@amitavroydev aha! Good to know it. Thanks!

[@souleymanetoure670]

You are amazing !

[@amitavroydev]

Thank you