_template-service/devuitls.sh
adam 063a8fd945
Some checks failed
gitea.arg.rip/_template-service/pipeline/head There was a failure building this commit
that's what I get for using a narrow window
2024-12-13 16:21:36 -05:00

32 lines
1.0 KiB
Bash
Executable File

#!/bin/bash
servicename="$REPO_NAME"
pw_developmentdatabase="wnmhOttjA0wCiR9hVoG7jjrf90SxWvAV"
connnectionstr="Host=localhost;Database=$${servicename}_dev;Username=$${servicename};Password=$${pw_developmentdatabase};IncludeErrorDetail=true;"
case "$$1" in
"initial")
sudo -u postgres psql -c "create database $${servicename}_dev;"
sudo -u postgres psql -c "create user $$servicename with encrypted password '$$pw_developmentdatabase';"
sudo -u postgres psql -c "grant all privileges on database $${servicename}_dev to $$servicename;"
sudo -u postgres psql -d "$${servicename}_dev" -c "GRANT ALL ON SCHEMA public TO $$servicename"
cp appsettings.sample.json appsettings.json
dotnet ef database update --connection "$$connnectionstr"
;;
"add-migration")
dotnet ef migrations add "$$2"
dotnet ef database update --connection "$$connnectionstr"
;;
"dbupdate")
dotnet ef database update --connection "$$connnectionstr"
;;
*)
echo "Unknown command '$$1', try 'initial'"
;;
esac