Add snapcraft yaml

[popey]

This adds the ability to build a snap of sequeler. It's unsurprisingly based off the yaml for akira :).

I haven't fully tested it as I don't have many databases kicking around here. I tried connecting to a SQL lite database but it said "No provider 'SQLite' installed". What's missing?

[Alecaddd]

I had a similar problem when trying to build a snap the first time. I investigated a bit but never got to the end of it, but it seems as the SQL provider doesn't get installed by libgda-5.0-dev libmysqlclient-dev libpq-dev libgda-5.0-mysql libgda-5.0-postgres

Users with similar problems on #115 and #111 fixed by manually installing missing deps. On flatpak was solved by installing libmysql on post install: https://github.com/flathub/com.github.alecaddd.sequeler/blob/master/com.github.alecaddd.sequeler.json#L138

[taozuhong]

Maybe the script should add part: libgda-providers as follow:

  libgda-providers:
    plugin: nil
    override-pull: |
      apt -y update
      apt -y upgrade
      apt -y install libpq5
      apt -y install libmariadb3
      apt -y install libgda-5.0-mysql
      apt -y install libgda-5.0-postgres
  sequeler:
    after: [libgda-providers]

[Alecaddd]

Maybe the script should add part: libgda-providers as follow:

  libgda-providers:
    plugin: nil
    override-pull: |
      apt -y update
      apt -y upgrade
      apt -y install libpq5
      apt -y install libmariadb3
      apt -y install libgda-5.0-mysql
      apt -y install libgda-5.0-postgres
  sequeler:
    after: [libgda-providers]

Could that be it? @popey

[Alecaddd]

Closing this as Popey doesn't work for Ubuntu anymore and it doesn't seem to be any Snapcraft maintainer willing to take over this.