Handling Exceptions In Flask-SQLAlchemy

This video demonstrates how to handle common exceptions when working with Flask-SQLAlchemy, using an IntegrityError as an example.
WORK WITH ME👇🏼
✅ Implement features and fix bugs in your app: Live, one-on-one screenshare
prettyprinted....
Join my free course on the basics of Flask-SQLAlchemy: prettyprinted....

[@prettyprinted]

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

[@avisekssarma5592]

Thank you for making these sort of short and clear videos in problems that can happen in code. You are like stackoverflow in youtube.

[@stillinmusic]

All your videos are so helpful.

[@prettyprinted]

Thanks for watching!

[@sajedkhoshkar]

Thanks for making these sort of videos. Very useful

[@kiranbakale8207]

I got a Type error
It says view function did not return a valid response . The function either returned none or ended without a return statement
Please reply

[@triple5beats506]

What about the "on_conflict_do_nothing()" method? Would this be useful in this situation?

[@prateeksarangi9187]

Thanks Anthony !! As always great

[@nayan1917]

Hi Anthony, Please make a video on how to handle Sqlalchemy timeout error for maximum queue pool size reached. It would be very helpful!

[@Biongar]

How to detect which field raise IntegrityError when we have 2+ unique fields? Example: User should have unique username and unique email, we send both of them when create user

[@desmondade]

Great video Anthony

[@prettyprinted]

Thanks for watching!

[@arunaacharya5473]

can you do a video on how to solve sqlite thread error

[@fabricio_patrocinio]

This video is power, thanks brow!!

[@shadedeveloping4705]

Great video! Thanks

[@prettyprinted]

Glad you liked it!

[@akhileshverma4812]

Giving an error module flask_sqlalchemy not found
I have run the command also

[@quechon1]

Anthony my man very good video

[@prettyprinted]

Thanks!

[@cedricbenonga7778]

How do I still successfully add the same value twice in the flask-sqlalchimy database while handling the integrity error?

[@prettyprinted]

Just make sure the field you want to add the value in is set to unique=False

[@satheesh22g]

but ,i got sqlalchemy.exc.ProgrammingError
ProgrammingError: (sqlite3.ProgrammingError) SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 140258910824192 and this is thread id 140258902431488.how can i solve this

[@prettyprinted]

It depends on your code. Are you doing anything special in your route with Flask-SQLAlchemy?

[@prettyprinted]

Thanks for watching everyone! Check out prettyprinted.com for Flask courses.

[@charlesjoseph809]

am i need to close the session once request over?

[@prettyprinted]

Flask-SQLAlchemy should take care of closing the session for you after the request ends.

[@charlesjoseph809]

close need when flask-sqlalchemy used with flask-socketio?

[@prettyprinted]

In that case, you may have to. I haven't thought about that one yet.

[@Conekingu]

Really helpful!!! Thanks

[@prettyprinted]

Thanks for watching!

[@falseee4445]

Hello, it tells me that IntegrityError is not defined :(

[@prettyprinted]

You can import it from sqlalchemy.

[@falseee4445]

@@prettyprinted ok thanks

[@antoniochacon4017]

great new video

[@prettyprinted]

Thanks for watching.

[@fakenameforgoogle9168]

Thanks

[@AKSHITGAURRA]

thanks buddy, you saved my ass

[@NikosKeyZ]

Start the video at 4.50. You can thank me later!

[@prettyprinted]

Some people like to hear me talk even when I'm not writing code!

[@NikosKeyZ]

Pretty Printed of course but people in hurry like me, don't want to hear over and over again same things.

[@ranjanthapa3964]

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: movie__details.genre
i searched everywhere in google but i didn't get the solution of this error. anyone to help me out