Python-Flask - How to access sqlite database.db on pythonanywhere.com without specifying its directory?

Question

I am using flask and sqlite3 on https://www.pythonanywhere.com. In my own machine, when I test the application, I do not need to specify the directory of the database for example db = sqlite3.connect("database.db") and it works perfectly. While on pythonanywhere, I would need to change it to db = sqlite3.connect("/path/to/database.db") because when I do not change I will get this error:

Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

In /var/log/<application>.pythonanywhere.com.error.log, I get:

OperationalError: no such table: <table-name>

And I found an empty database.db in my home folder at pythonanywhere (which means the application created it, right?) and the database.db I created is in the projects folder

Is there any way to specify the directory in order for it to work perfectly both in my machine and on pythonanywhere without changing the path?

lord63. j · Accepted Answer · 2015-12-29 14:14:52Z

8

In your db file, try this way:

from os import path

ROOT = path.dirname(path.realpath(__file__))

...
db = sqlite3.connect(path.join(ROOT, "database.db"))
...

Instead of directly pointing out the path, the ROOT always point to the directory of your file that contains the db, then you should get the right location for your database.

answered Dec 29, 2015 at 14:14

lord63. j

4,6702 gold badges24 silver badges31 bronze badges

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

1 Comment

Austin Imperial Over a year ago

Thanks! It worked perfectly now for both my machine and in pythonanywhere!

Collectives™ on Stack Overflow

Python-Flask - How to access sqlite database.db on pythonanywhere.com without specifying its directory?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related