No video
NestJS, MySQL, TypeORM Crash Course
Covering the basics from creating, reading, updating, and deleting data from our MySQL database, all the way to one-to-one relationships and one-to-many and many-to-one. By the end of this video, you will become more comfortable with working with TypeORM entities and repositories to build persistent applications!
Code: github.com/stu...
Support the Channel:
Become a Member: www.youtube.co...
Become a Patreon: / stuyy
Buy me a Coffee: ko-fi.com/anson
Donate on Streamlabs: streamlabs.com...
Donate on PayPal: paypal.me/anso...
Connect with me:
Twitter: / ansonthedev
Discord: / discord
GitHub: github.com/stuyy
Twitch: / stuy
Пікірлер: 96
Should I do a course with MongoDB & Mongoose?
@houssincarnelian9562
Жыл бұрын
can you make a 2fa with nestjs how to send email verification after user register
@adityafitriansyah97
Жыл бұрын
Letsgo
@szymon2806
Жыл бұрын
Yes!
@SystemDV
Жыл бұрын
Yea!
@TruongNguyen-ix1mr
Жыл бұрын
yes
30 minutes of this tutorial and I was able to finally implement the typeorm in my nestjs backend. The explanation is very simple to understand. Thank you, very much!
@ansonthedev thanks for this tutorial, I 've been a laravel developer for 6 years and going through your Nes'tJS tutorials have been a breeze, Thank you again!!!
Thank you so much for learning all over again, even though I'm still unemployed.
I was so lucky i got these lectures .It is really really good . 😍😇
Hey Anson, I'm really enjoying your NestJS tutorials, I can't find many videos with similar quality. So far you've been able to explain how to best use Nest in many contexts, I've already watched how you implemented it with Mongoose and MongoDB, and after this I'll watch how to implement GraphQL. You are great, thank you for your work and your content. 💯
WIthout a doubt the best guide videos on KZread. I have watched many other content creators and tried to follow along, none offer explanations like this guy. If i ever get good enough to earn a living doing this, it would be, to a large extent, due to these videos.
Your teaching is amazing! You know what you are talking about and u are very aware of all the elements involved
@ansonthedev
8 ай бұрын
Thank you very much!
The best CRUD example in nestJS using database
Just amazing…. Thank you so much 💯
@ansonthedev
6 ай бұрын
Thank you and you're welcome! :)
Thank you! Great course! I can always learn from the little details like PUT vs PATCH
Whats your thoughts on Prisma?
Thanks sir, because of this tutorial I can now create my own api, great job for this wonderful tutorial.
Anson, your way of teaching and explaining core concepts is amazing. if youtube has million thumbs up option then Definitly i will give you millions of thumbs up. Just keep it up. Also did subscribe your channel
Thank you so much for teaching me about nest js, it really helped me alot!
Thank you very much for this tutorial! I had a lot of fun watching this video and the crash course and sure will be pretty helpful on my job
Thanks, i just finish this course!
hey loved the tutorial but one question why didn't you add manytomany relationship example??
Thank you for this amazing tutorial
@ansonthedev
3 ай бұрын
You are welcome!
Nice course, Good job and thank you ❤👏
The crash course is "to the point". I like it. Picassoooo~
what about ManyToMany TypeORM Relations?
Thanks Anson! your videos are amazing!!
completed twice to understand better. it's great xD
thank you so much anson, best wishes to you
Amazing, all clear. God bless.
Thanks for sharing, I have one question. How can I call stored procedures instead of using entities. I have developed the database and its procedures first. Now I want to call those stored procedures using nestjs. any help please. Thanks and regards.
This is a lifesaver. Thanks.
Great course! Could you share the extensions you use for NestJS or your course? Thanks
lot of thanks @Anson💟 after watched your video now i have confident in nestJS
Thank you so much broooooo
Awesome course ever I watched
DO you have the same thing on Many to Many?
You are super dooper amazing dude !
hi, can we achieve one-to-many/many-to-one relation using TypeORM: select table1.*, table2.* from table1 left join table2 on table1.pk_id=table2.fk_id and table1.status=1 , here main concern is to join table with multiple condition , thanks
Thank you my friend
Great!!
I want to know your snippet extension, i have tried some but it didn't do as yours in video :((
@linhohoang8023
2 ай бұрын
anyway, thank you so much for a very very useful video
when i restart the app after creating the entity , i did not get any table in mysql .
@ansonthedev
5 ай бұрын
You need to have synchronize: true in the TypeormModule config options.
thanks man best tutorial
Great video!
Can you share a link to the resource for using typeorm please?
Can you make a video of creating a testing database Mysql for E2E testing?
Video on query builder in NestJS?
Thanks, man, really appreciate your explaining .
thanks!!! i love your video
Great Content !!!
amazing class..thanks..
Great content but how would we add relations in find one by and then pass the id so that we could get a specific user ? :)
@nikoladzoni6432
Жыл бұрын
fetchUserById(id: number) { return this.userRepository.find({ where: { id }, relations: { profile: true, }, }); }
Thank you
@ansonthedev
7 ай бұрын
You're welcome
Can't the TypeORM CLI create the database? Sorta like sequelize migrate db:drop?
@ansonthedev
Жыл бұрын
I’m sure it can
Dude how can I make my own validation for the entity ?
what are your themes and extension for vs code?
please add time stamps, i use your video as a reference and it is always difficult to look for what i want, please add time stamps, thanks for your amazing work👊💪
Great video 😉
Great!
how open mysql in command prompt
thanks men
Followed it 1:1 and when trying to use postman I get MySQL DB error "QueryFailedError: Field 'username' doesn't have a default value". I send both username and password and Postman returns 201 but nothings get written into db. Can't run POST in Postman again due to "Error: socket hang up" and have to restart the whole nest so its hard to debug. Any ideas whats wrong? Im sending username/password in Postman properly but it tries to save DEFAULT values into the db. [SOLVED] Data type in Postman was set to "raw" but dropdown next to it was set to "text" instead of "JSON" :) So basically POSTMAN was sending data in a wrong format. All good, thank you for a great tutorial.
@PedroHMelo
10 ай бұрын
goat
Please give custom repository example
Can you push code to github please? Thanks
@ansonthedev
2 жыл бұрын
github.com/stuyy/nestjs-typeorm-mysql-course-repository
Amazing 🎉
Thank you !!!!!!
I am pretty sure, it's bad sql practice (according to conventions) to use pluralized names for tables, but it won't make your application crash, so seems good 👌😂
done!
Please make tutorial using sequelize
GREAT contents!!!! Thank you so much!! I have a question. How can I create save a POST array of images upload to amazon S3 into MYSQL images table? How would the Repository file look like? I had something going on, but my issue is, whenever I upload like 2 images it saves the first image twice in my DB. I'm tried images.forEach() and images.map(). still the same issue. Your example on here talked about "post" and that's a POST object, but my case is POST array.
Hi Brother , your video is very great and is easy to understand. But I encountered a huge issue when running POST request. It was the very first request at 30:54 of video . Please help me provoiding any suggestion to fix error below as I could not find solution at all. /Users/aashishsapkota/Desktop/nestjs-mysql/src/driver/mysql/MysqlQueryRunner.ts:222 new QueryFailedError(query, parameters, err), ^ QueryFailedError: Field 'username' doesn't have a default value I even tried setting default value to null in our entities but that would only push null username and password. Even if I provided new one. I also tried disabling safe mode but that did not worked at all . I know you might be busy but I could really appreciate your help on this if possible.
@PedroHMelo
10 ай бұрын
i am in the same error...
after finishing this crash course I literally want to marry you
I need sequelize and MySQL
@ansonthedev
10 күн бұрын
@@user-jt2zf1lc3v Ok..?
Дякую
olo
thank you sir
repository. create doesnt create entity in sql u should use save
@Column({ default:()=> 'CURRENT_TIMESTAMP', }) createdAt: Date;
Really enjoying this whole NestJS playlist, thank you for making it! I've found in the docs that for the "createdAt" we can use @CreateDateColumn() createdAt: Date;