Merge branch 'spicedb-postgresql' into 'main'

Load SpiceDB schema into postgresql

See merge request gitlab-org/software-supply-chain-security/authorization/sparkled!22

1 files changed, 8 insertions, 1 deletions

diff --git a/Makefile b/Makefile
index f50bc8d..4425037 100644
--- a/Makefile
+++ b/Makefile
@@ -3,6 +3,7 @@ GIT_BRANCH := $(shell git rev-parse --abbrev-ref HEAD | sed 's/\//_/g')
 IMAGE_TAG := $(PROJECT_NAME):$(GIT_BRANCH)
 AUTHZD_BIN := bin/authzd
 SPARKLED_BIN := bin/sparkled
+SPICEDB := bin/spicedb
 TOOL := bin/tool
 ZED := bin/zed
 
@@ -90,4 +91,10 @@ db-init:
 db-create: db-init
 	@mise exec postgres -- createdb -h /tmp sparkle_development || true
 
-db-setup: db-schema-load db-seed
+db-migrate:
+	@$(TOOL) godotenv -f .env.local,.env -- sh -c '$(SPICEDB) datastore migrate head --datastore-engine postgres --datastore-conn-uri "$$DATABASE_URL" --log-level trace' --skip-release-check
+
+db-console:
+	@mise exec postgres -- psql -h /tmp sparkle_development
+
+db-setup: db-create db-schema-load db-seed