how to specify the location of Sqlite DB on Ubuntu

Question

My sqlite DB is on Ubuntu at

(venv)jisoo@jisoo:~totalAirQREST/totalAirRunDB$

How can I specify the location of the DB in sqlalchemy?

My app.py located in totalAirQREST has the following.

app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL','sqlite:///airQuality.db')

I know I have to change from the sqlite:///airQuality.db, to sqlite:////totalAirRunDB/airQuality.db. But it turns out it is not working. Please help me how to get the app know the location of the sqlite DB.

Jekis · Accepted Answer · 2018-01-15 03:29:32Z

2

Try full path

app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL','sqlite:////home/jisoo/totalAirQREST/totalAirRunDB/airQuality.db

answered Jan 15, 2018 at 3:29

Jekis

4,7662 gold badges40 silver badges44 bronze badges

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

2 Comments

Jekis Over a year ago

You are welcome! Please select it as a correct answer.

passion Over a year ago

I am sorry. Pls. show me how to select it as a correct answer. Do I just press the upward arrow on the left of the answer? Even though I pressed it, nothing changed.

Collectives™ on Stack Overflow

how to specify the location of Sqlite DB on Ubuntu

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related