Computer scienceProgramming languagesPythonPython librariesSQL Alchemy

SQL Alchemy updating and deleting data

Delete them all

Report a typo

Imagine you are working for a company, and this company uses an SQL Alchemy library.
Your boss gives you a crucial task — you have to delete all rows from the table that are older than 5 years.
"Easy task", you think, and end up with the following code:

query = session.query(SomeTable)

query.filter(SomeTable.creation_date <= 5).delete()

You hit the run button. What is going to happen?

Select one option from the list

All data from the table will be deleted

You will be FIRED!

Lucky for you, you forgot to commit the changes, so they won't happen

The code has errors and will not be executed

___

Create a free account to access the full topic