Lifecyle Job Example: How to seed a Postgres database with a simple SQL and Shell script

[rophilogene (Romaric Philogene)]

Hi everyone ,

Here is a quick example of how to seed a Postgres database with a simple SQL and Shell script using a Qovery Lifecycle Job.

lifecycle-job-examples/examples/seed-postgres-database-with-sql-script at main ·...

---

Extracted from the README. Here are the instructions:

Seed your Postgres database with a SQL script

This example shows you how to seed your Postgres database with a SQL script.

Important

• Our SQL Script downloads from a S3 bucket to avoid storing sensitive data in this repository. This is a good practice to follow.
• You can remove the S3 download part to put a SQL script in this repository. However, it’s not recommended to store sensitive data in a public
  repository.

How to use

1. Fork this repository
2. Create a Lifecycle Job
3. Select your forked repository with the appropriate branch (e.g. main)
4. Set the “Root application path” to the example you want to use (e.g. examples/seed-postgres-database-with-sql-script)
5. Set the “Dockerfile path” to the Dockerfile in the example you want to use (e.g. Dockerfile)
6. Select “Start” event and add the following CMD Arguments: ["-c", "seed.sh"] - which indicates to the Lifecycle Job to run the seed.sh script when the Lifecycle Job starts.
7. Create your Lifecycle Job but do not deploy it yet.
8. Go to your Lifecycle Job variables and create:
   1. DATABASE_URL environment variable alias to provide to seed.sh your database connection string where to restore your seed.
   2. SEED_URL environment variable alias to provide to seed.sh your seed SQL script URL. (can be a public S3 bucket URL or any other URL)
9. Deploy your Lifecycle Job.

Your database is now seeded with your SQL script.

I’ll complete this thread with a demo video in the coming days