SQLALCHEMY delete all rows in existing database in python

Question

I have created a sqlite database in python according to a tutorial:

from sqlalchemy import create_engine
engine = create_engine('sqlite:///DB.db')

And next time I run the python script, it has old data in there.

How can I delete all rows, reinitialise or even delete the database (where is it located?)?

You can simply delete the Db.db file. It will be recreated the next time. — Barmar
– Barmar, Commented Feb 17, 2022 at 21:34

MarcinJ · Accepted Answer · 2022-02-17 21:38:45Z

5

If you don't need the data to persist, you can use an in-memory sqlite database, using

engine = create_engine('sqlite://')

If you still want the data to be accessible after you run your script, but each execution should just start anew, simply delete the DB.db file wherever the working directory is, at the start of your script:

import os
if os.path.exists('DB.db'):
   os.remove('DB.db')

answered Feb 17, 2022 at 21:38

MarcinJ

3,6592 gold badges16 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nolimits Over a year ago

Such simple command, I could find nowhere across the globe. Thanks!

Machkour Oke · Accepted Answer · 2023-03-09 12:08:19Z

0

You can use the following code:

file_location = engine.url.database
# To stop using the file
engine.dispose()

# Drop file
os.remove(file_location)

answered Mar 9, 2023 at 12:08

Machkour Oke

831 silver badge7 bronze badges

Collectives™ on Stack Overflow

SQLALCHEMY delete all rows in existing database in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related