Ubuntu snap env unable to open database file

[Tdarnell]

After pulling the latest 43 commits on Ubuntu and running pipeline I am getting an sqlalchemy error on the latest version of the main branch that I have not been getting previously.

airsenal==1.14.1

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

I have found that deleting the AIRSENAL_DB_FILE out of /home/user/snap/code/208/.local/share/airsenal/ was needed to resolve this. Somehow it seems the snap folder path had moved for my AIrsenal install. Likely to just be a one off issue with my particular environment, but sharing in-case others experience the same. I added a print statement for my AIRSENAL_HOME and checked the contents of that folder to work out what was causing my DB file path to now point to an invalid folder.

[jack89roberts]

Hmm, weird. This is the path automatically set by AIrsenal or had you set your own path? If it's the automatically generated one we use from platformdirs import user_data_dir to determine it, so you could see what that returns for a few different versions of platformdirs if you fancy debugging it. Or I don't know whether Ubuntu itself has changed something recently in user paths.

It was definitely pointing to an invalid directory? The other thing that could cause dB errors is we've made some updates to add some new table columns, which means it needs to be deleted and re-generated anyway (there's a --clean argument in the pipeline script to do that). Then the error message should say something about missing columns/an invalid schema or something, though.

[jack89roberts]

Looking at docs I think the only reason the auto-generated path could be wrong is if the path to your home directory changed, or the value of $XDG_DATA_HOME has changed.