...
updateDBPasswords.groovy (download here)
changePasswords.csv (download here)
updateDBPasswords.groovy
...
Place the updatedDBPasswords.groovy in the <datical_install_dir>/repl/scripts folder.
Update the daticalBaseDir variable to point to the parent directory where all Datical DB projects are housed.
Populate the changePasswords.csv and place in the parent directory where all Datical DB projects are housed (the same value that was set as daticalBaseDir.)
From the same directory where you added the changePasswords.csv file, run the following command:
Code Block hammer groovy updateDBPasswords.groovy
The process performs the following :
Forfor each row in the changePasswords.csv file
, runs:
Runs a
git status
andgit pull
in the project’s directory.Base64 encodes the password value.
Checks the datical.project file in the project’s directory for the dbDef.
Replaces the old password string with the new base64 encoded password.
Runs a
git add datical.project
,git commit -m'<Message>'
, and agit push
.
...