Merge branch 'sparkle-visibility' into 'main'

Connect to postgresql

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

1 files changed, 19 insertions, 0 deletions

diff --git a/app/db/url.go b/app/db/url.go
new file mode 100644
index 0000000..b17c651
--- /dev/null
+++ b/app/db/url.go
@@ -0,0 +1,19 @@
+package db
+
+import (
+	"fmt"
+
+	"github.com/xlgmokha/x/pkg/env"
+)
+
+func URL() string {
+	if url := env.Fetch("DATABASE_URL", ""); url != "" {
+		return url
+	}
+
+	return fmt.Sprintf(
+		"postgresql://postgres:%s@localhost:5000/%s?sslmode=disable",
+		env.Fetch("RUNWAY_PG_USER_POSTGRES_PASSWORD_SPARKLE", ""),
+		env.Fetch("DATABASE_NAME", "sparkle"),
+	)
+}