CRUD Operations on Multiple Tables - TypeORM

How to do CRUD Operations in TypeORM on multiple tables.

----

----

----

----
Follow Me Online Here:

#benawad
​
----
#benawad

[thomasjohnson]

This is a good piece, I have been dealing with exactly this albeit in a different language. It can get extremely complicated fast. If you think about real world use cases in web and mobile development as opposed just data mining, joins are often conditional like you have, but often time it needs to be ordered (descending, ascending) or have a method implemented.(like trim where you're searching tags for example) What I would recommend for complex use case is to grab a set of mock SQL data and plan your joins and operations with a UI client like Azure Data studio or SQL server management studio(I run a WIndows VM dedicated to the latter) there are even add ons that will create graph of your joins. That way you can run queries and get a feel for it. These examples are always helpful. I think seeing the data rendered in a browser or in a React Native app, just simple raw data is always helpful, personally I need to think about things like this from the user end.

[ronifintech]

Loved it!
More of these joins and complex queries would be very useful!

Some example:
A FB page wants to do some query of all users that liked the page and then users can like many pages.

[g-luu]

More examples would be super. For example a booking system db design. Not too complex but i think that would be an insightful tutorial.

[craigjohnson]

Great video Ben! Please do more videos with CRUD Operations and GraphQL.

[josephizang]

This comment is very very late but please more...of this. Gorgeous work!

[reevebarreto]

Thank you soo much Ben!
I was really struggling to find out how to work with multiple tables using typeorm

[CodingPuff]

Great video, it would be nice if you talk about creating and using transactions, the official docs really don't say much on this topic.

[aram]

I really liked this video. Please, more on relations if you only have time. I started to dig into TypeORM only recently - would like to have a clear line drawn between ActiveRecord pattern vs repository pattern, and their pros/cons, and also how you are supposed to test the ORM layer.

[mritunjayupadhyay]

Thank you so much for this tutorial. It was really compact, nice and informative.

[JohnDoe-jizv]

Thanks for tutorial Ben, could you make some videos on CQRS, and ACL, RBAC permissions in future 🙏🏻

[mmb]

isn't the last query not doing what you expect? since it will also grab the notes that weren't shared at all but created by joe?

[mohamedsami]

Great video bro! Please which is better find operation vs createQueryBuilder ?

[ypd]

4:08 notesYouShared: Note[]; > notesYouShared: SharedNote[]; i think class type have to change like this .. but is there some reason ?

[parimal]

How i can change @PrimaryColumn()
senderId: number; to be nullable into SharedNote table

[seanhuggins]

Ben... I've been looking all over the internet, stack overflow, TypeORM docs, even my old Databases textbook, heck I even asked my mom for an answer to this problem... Nothing

I should have known that this whole time, you had the answer - in a 14-minute long video - I'm sorry... I let you down and I'll never do it again.

[Bargainsxx]

man! i for some reason, i am not aware of, like to write raw sql queries

[sharukhshanu]

excellent can i know how to deploy my node express typeorm project in digital ocean

[CastleMatch]

Thanks Ben, could you do a tutorial on transactions in TypeORM? Like a user to user money transfer to avoid race conditions?

[DrPanesar]

Hi Ben, Is typeorm particularly tricky with these queries or are all ORMS a bit tricky do you think? I like query builder though. A lot better in the long run i think. BW

[vigneshs]

How do you stop the user from sharing the note with himself?