bitovi/Apply SQL files to Postgres Database
Iterate through a folder containing SQL files and apply them to a Postgres Database
View on GitHubTrust Signals
- Scorecard Score
- not yet scored
- Maintenance Recency
- Maintainedlast commit Feb 18, 2025
- License
- MIT
Pinned Snippet
uses: bitovi/github-actions-apply-sql-files-to-postgres@ead46324710045051a47e531b98e24ce07fe5283 # v0.0.2tags can be moved; commit SHAs can't. why a SHA?
Inputs
| name | description | required | default |
|---|---|---|---|
| checkout | Specifies if this action should checkout the code | no | true |
| aws_access_key_id | AWS access key ID | yes | — |
| aws_secret_access_key | AWS secret access key | yes | — |
| aws_default_region | AWS default region | no | us-east-1 |
| aws_role_to_assume | AWS Role to assume. | no | — |
| aws_secret_name | Name of the AWS Secret containing the DB credentials. | no | — |
| db_host | Defines the db_host to use in the connection string. | no | — |
| db_port | Defines the db_port to use in the connection string. | no | — |
| db_name | Defines the db_name to use in the connection string. | no | — |
| db_username | Defines the db_username to use in the connection string. | no | — |
| db_password | Defines the db_password to use in the connection string. | no | — |
| sql_connection_string | Allows 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_run | Echo the commands to be executed (without passowrd). Will run a list command to test connection. | — | true |
| sql_scripts_path | Path containing the sql files. If none defined, will look for files in the root folder. | no | — |
Outputs
no outputs