From 8d9b2e3df24078cc6ff2eef1a71f1096de22e6a3 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Fri, 8 Sep 2023 16:46:50 -0500 Subject: [PATCH] Add set-password build target --- make_files/make_db.mk | 17 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-) diff --git a/make_files/make_db.mk b/make_files/make_db.mk index f577833..565780c 100644 --- a/make_files/make_db.mk +++ b/make_files/make_db.mk @@ -445,10 +445,12 @@ $(DB_TARGETS): %.sql: %.m4 $(DB_DEPENDS) ## to be the ADMINUSER role, the role used to make database objects. ## TARGET_USER ## The user to be created or otherwise modified. +## NEW_PASSWORD +## The password to assign. ## NEW_DB ## The database to be created. ## NEW_DESCRIPTION -## The description of the new object (database) +## The description of the new object (database). ## ## Usage: ## The expectation is that first an administrative user will be created, then @@ -476,6 +478,7 @@ SET_DATESTYLE := ALTER DATABASE $(NEW_DB) \ SET DATESTYLE = 'ISO,MDY'; CREATE_ADMINUSER := CREATE ROLE $(TARGET_USER) LOGIN SUPERUSER CREATEROLE \ PASSWORD '$(NEW_PASSWORD)'; +SET_PASSWORD := ALTER ROLE $(TARGET_USER) PASSWORD '$(NEW_PASSWORD)' ## The available targets for make (make TARGET) are: ## @@ -523,6 +526,18 @@ init-database: ## Lesser used targets: ## +## set-password Set the password of TARGET_USER to NEW_PASSWORD +.PHONY: set-password +set-password: + [ -n "$(NEW_PASSWORD)" ] \ + || { printf 'The NEW_PASSWORD variable must be set\n' >&2 ; \ + exit 1 ; } + ( $(PSQL_SETUP) \ + printf "$(SET_PASSWORD)\n" ; \ + ) \ + | psql $(PSQL_ARGS) $(PSQL_SINGLE_TRANS) --set=ON_ERROR_STOP=y + + ## set-search_path Set the default search_path the database named ## by the TARGET_DB variable. .PHONY: set-search_path -- 2.34.1