agola/internal/sqlg/lock
Simone Gotti 8423c7082e *: new db schema
* Remove query tables. Use a standard sql approach storing all possible
  fields as columns.
  * Some fields that are complex (like runtasks) are saved as json.
  * For postgres use native sequences. For sqlite3 emulate them with a
    sequence table.
* Add sqlg package that provides code generators, db, lock and a db
  manager for setup/migration.
* Future migrations could be done with the new migration logic and won't
  require a conversion from an export but will be done directly on the
  database.

* Added migration command to migrate from an export of the db schema
  available in master (at commit 248a9e0ad) in addition to the one
  already available to migrate from v0.7.x.
  To define if the source export is the one at v0.7.x or at commit
  248a9e0ad the migrate command provides a "--source-version" option.

* Run test for both sqlite3 and postgres databases
  * Currently integration tests are run only for sqlite3
2023-04-13 11:04:52 +02:00
..
local.go *: new db schema 2023-04-13 11:04:52 +02:00
lock.go *: new db schema 2023-04-13 11:04:52 +02:00
postgres.go *: new db schema 2023-04-13 11:04:52 +02:00