Commit graph

8 commits

Author SHA1 Message Date
Viktor Tigerström
75f6137d80
multi: rename sql kvstores session_id to group_id
Rename the session_id to group_id in kvstores table in the SQL store, to
better represent how the field is actually used.

Note that this is a breaking change, and would normally require a new
migration. But as the SQL store is not used in production, and only
enabled under the dev build flag, we can rename it without a new
migration, as there's no users of the SQL store in production.
2025-07-21 14:45:45 +02:00
Elle Mouton
65e4309f9c
db: add actions schemas and queries
In this commit we define the schema for the `actions` table along with
various queries we will need for interacting with the table. NOTE: we
will also add some of our own queries manually in commits to follow.
2025-05-29 07:04:40 +02:00
Elle Mouton
a54accbf78
db/sqlc: priv map schemas and crud
Define the privacy mapper schemas and queries.
2025-04-22 06:10:48 +02:00
Elle Mouton
e8d72f7276
db/sqlc: kvstores schemas & queries
In this commit, we define the schemas and queries that are needed to
implement the firewalldb's KVStores in SQL.
2025-04-10 13:03:20 +02:00
Elle
64ab73a763
Merge pull request #994 from ellemouton/sql21Sessions13
[sql-21] sessions: SQL schemas & queries
2025-03-11 12:14:30 -05:00
Elle Mouton
20167666ad
db/sqlc: add session schemas and queries
This commit adds all the schema definitions we require for the sessions
store.
2025-03-11 11:37:41 -05:00
Elle Mouton
a8d3c1ac7e
db/sqlc: only use named UNIQUE indices
Replace any named UNIQUE indices in the accounts tables and replace with
named ones. This is for a future where we want to be able to edit these
indices without having to drop the table.
It is fine for us to just edit these tables since these are not
available in "prod" yet.
2025-03-10 13:54:11 -05:00
Elle Mouton
caec0742db
db/sqlc: add account related tables and queries
This commit also contains the sqlc.yaml file, the `make sqlc` command
and the script for generating sqlc code. This must be done in this
commit as the script only works if there are queries to generate from.
2025-01-29 16:37:20 +02:00