bitovi/Apply SQL files to Postgres Database

Iterate through a folder containing SQL files and apply them to a Postgres Database

View on GitHub

Trust Signals

Scorecard Score
not yet scored
Maintenance Recency
Maintainedlast commit Feb 18, 2025
License
MIT

Pinned Snippet

workflow.ymlSHA-pinned
uses: bitovi/github-actions-apply-sql-files-to-postgres@ead46324710045051a47e531b98e24ce07fe5283 # v0.0.2

tags can be moved; commit SHAs can't. why a SHA?

namedescriptionrequireddefault
checkoutSpecifies if this action should checkout the codenotrue
aws_access_key_idAWS access key IDyes
aws_secret_access_keyAWS secret access keyyes
aws_default_regionAWS default regionnous-east-1
aws_role_to_assumeAWS Role to assume.no
aws_secret_nameName of the AWS Secret containing the DB credentials.no
db_hostDefines the db_host to use in the connection string.no
db_portDefines the db_port to use in the connection string.no
db_nameDefines the db_name to use in the connection string.no
db_usernameDefines the db_username to use in the connection string.no
db_passwordDefines the db_password to use in the connection string.no
sql_connection_stringAllows overriding default set up connection string to anything else.no"PGPASSWORD=${DB_PASSWORD} /usr/bin/psql -h ${DB_HOST} -p ${DB_PORT} -U ${DB_USER} -d ${DB_NAME}"
dry_runEcho the commands to be executed (without passowrd). Will run a list command to test connection.true
sql_scripts_pathPath containing the sql files. If none defined, will look for files in the root folder.no

no outputs