CodeForPhilly / CodeForPhilly/CHIME-2

Windows on flask db migrate: (sqlite3.OperationalError) unable to open database file

Aperta
#20 0 commenti 1 reazione 1 assegnatario Rivendicata da @BrianThomasRoss Vedi su GitHub
flask
Lingua principale
Python
Stelle
2
Fork
4
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

### Problem

Trying to build the app on Windows 10.

After creating a `.env` file from `.env.example`, I tried to initialize the project from the command line like so:

```
pip install -r requirements/dev.txt
npm install
for /f "tokens=*" %i in (.env) do set %i
flask db init
flask db migrate -m "initial"
```

At the `migrate` line, there is a long stack trace, and then this error (even when running the prompt as Administrator):

```
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: http://sqlalche.me/e/13/e3q8)
```

### Proposed Solution

Changing the value of `DATABASE_URL` in `.env` from the example default `sqlite:////tmp/dev.db` to a path I knew I had write access to (in my case, the project directory itself: `sqlite:///C:\\Users\\\\chime2\\dev.db`) fixed the issue.

Because the example path assumes a Linux filesystem, can a note be made, maybe in the README, that the value would need to be changed prior to building?

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.