Left Outer Join in Flask-SQLAlchemy

[@prettyprinted]

Join my free course on the basics of Flask-SQLAlchemy: prettyprinted.com/flasksql

[@ngozimayo1889]

Finally, a decent explanation how to do joins with Flask-SQLAlchemy! Thank you so much Anthony, very helpful.

[@0KiraDark]

man you saved me, I spent a lot of time trying to understand where I'm committing a mistake in my code but when I saw your video I could solve my problem, thank you.

[@51_amanverma24]

Amazing video, it helped me in one of my project. Thank you sir 👍👍

[@cest102]

Exactly what I was looking for. You're the man.

[@prettyprinted]

I'm glad the video helped. Thanks for watching!

[@RamiroJativa]

Excellent Anthony. Thank you. I share a code example where I apply the use of outerjoin in the way you showed it. BTW: My next challenge is to build an outerjoin with three tables. # outerjoin with paginate. # The id is selected in the # query so that the html page # can display the record # corresponding to the id. # The id is important for the # edition of the record and # also to delete the record. # The other columns are displayed # on the screen. records = db.session.query( Record.id, Testlab.testdescription, Record.time, Record.name, Record.organization, Record.date, Record.place, Record.city).outerjoin( Testlab,Record.test == Testlab.code).paginate( per_page = records_per_page, page = page_num, error_out = False) return render_template('web/records.html', records=records)

[@TheShash1001]

Thanks for your dedication

[@prettyprinted]

And thank you for watching.

[@pathak_amit]

Great explanation. Would appreciate if you could explain how to put a where condition in this? For example, picking records which have made a purchase of greater than 15. Thanks!

[@sohaibbenbouzid9802]

thank you very much this helped me alot.

[@carlsagan3295]

Very useful, thank you!

[@prettyprinted]

Thanks for watching!

[@VelascoPale]

grateful, but how i can serialize to json those result to use in one function in Ajax like response :((

[@adnankayace]

Thank you Anthony!

[@prettyprinted]

You're welcome! Thanks for watching.

[@ayowandeoluwatosin9365]

Awesome tutorial. I would like to self join. That is join a table to itself...I would also like to query a database= result one, iterate through the result one using a for loop to query again another table= result 2 , then add result 2 as a value to a key in result one.. how do I go about either... Thank you

[@rohit-ld6fc]

How to have multiple ON clause using AND/OR eq.... .....ON atc2.type_id = annotation_type.id AND atc2.customer_id = 12

[@ZOOSnippets]

Hey Anthony, a suggestion for a topic for a video, could you maybe tell more about subqueries in SQLAlchemy?

[@prettyprinted]

I'll see what I can do. Thanks for the idea.

[@prettyprinted]

I'll think about creating a video for subqueries. Thanks for the idea.

[@ZOOSnippets]

That would be great. I currently have a problem to limit data in a relationship between to tables. I have one database with a list of sensors, and linked a table with reading values. I want to make a query in SQLAlchemy to limit the last 10 values from every sensor, but there i get stuck. Your video's helped me a lot with overcome other isues already! Keep up the good work!!

[@jasjyotsingh2007]

Cant we do this using the same method shown in One -Many relationship using db.relationships and referencing the object direct. No reference in the other table will simply return a null for the Object column

[@hossamashraf4885]

Thanks really helpful :D

[@prettyprinted]

You're welcome!

[@dirkb806]

Awesome tut! Any way you can make a part 2 to this video and add an UI? Would love to see a whole example where one can set up an app + db + html and render a db output in html via sqlalchemy (A cherry on the cake would be to bring in a library like chart.js also). Thanks in advance!

[@prettyprinted]

I'll consider that. Thanks for the idea.

[@Thesrik23]

Hey Anthony How to use multivalueField in Django and please provide some resource to learn it Thanks in advance

[@prettyprinted]

I'll cover that eventually.

[@vaneakatok]

i am looking for an inner join. there is none, is there any?

[@СлавегггНосков]

Thx, Anthony, you're doing a great job. In your video about many-to-many relationship the conjunction table was 'db.Table', not 'Model'. So, here is the question how can I join two tables where one is 'Model' and another is 'Table'. Or maybe conjuction table simply can be db.Model too ? thx, again :)

[@prettyprinted]

Yeah, the conjunction table can be db.Model. db.Table was just used because I wouldn't need to use it like a normal model.

[@vaneakatok]

my two models are connected by an association object (many-to-many) I want to filter through this ass_obj there are M students and N classes any 1 student can take up to N classes. and any 1 class can have up to M students How do I query the students from a particular class or the classes that any given student is enrolled in?

[@SourabhDevlal]

Bro tell me how to put COUNT on the child columns

[@ReillyChase]

Very helpful, thanks!

[@prettyprinted]

Thanks for watching!