python - How do I make pyinstaller include my database?

Question

I've got a PyQt4 application which makes use of sqlite3. I have two seperate files currently: a .py file and a .db file. Originally I took the .py file and tried to create an executable just using that thinking maybe it would link somehow but when I run the .exe it breaks when it gets to database related code. How do I get pyinstaller to include the database as well?

Answer 1

You need to use a specfile. Have a look at the documentation.

pyinstaller creates those file automatically. You just need to edit it. Have a look at the example from the docs. To add a README file you just need to add a tuple (source, destination) to 'datas':

a = Analysis(...
 datas=[ ('src/README.txt', '.') ],
 ...
 )