Switch $HOME/.octosql to XDG Spec

[tony-sol]

Change default configs/plugins/repos/logs location according to XDG Specification.

App will look for:

• the config file in $XDG_CONFIG_HOME/octosql/octosql.yml with fallback to current $HOME/.octosql/octosql.yml
• the logs file in $XDG_CACHE_HOME/octosql/logs.txt with fallback to current $HOME/.octosql/logs.txt
• the plugins tmp dir in $XDG_CACHE_HOME/octosql/tmp/plugins/ with fallback to current $HOME/.octosql/tmp/plugins/
• the extension_handlers file in $XDG_CONFIG_HOME/octosql/file_extension_handlers.json with fallback to current $HOME/.octosql/file_extension_handlers.json
• the plugins dir in $XDG_DATA_HOME/octosql/plugins with fallback to current $HOME/.octosql/plugins
• the repositories dir in $XDG_DATA_HOME/octosql/repositories with fallback to current $HOME/.octosql/repositories

[tony-sol]

Awesome! Thanks so much!

Should i do anything else to make new release available?

[cube2222]

@Tony-Sol snapshot tests started failing, so will need to debug that before making a release.

[cube2222]

Yeah, trying out locally, it looks like it's not capable of creating the logs file if the ~/.octosql home directory doesn't exist (it should create it).

couldn't create logs file: open /Users/jakub/.octosql/logs.txt: no such file or directory

[tony-sol]

I'm going to debug this now, fix will be soon

[cube2222]

@Tony-Sol I think it's the change in InitializeFileLogger

[cube2222]

used to have MkdirAll, now it doesn't

[cube2222]

Pushed a fix https://github.com/cube2222/octosql/commit/b158983ae886ce316636f3f9cdb1a68756dca127

[tony-sol]

@cube2222 made a new PR with fix - https://github.com/cube2222/octosql/pull/315