Execute PostgreSQL statements upon deployment to Elastic Beanstalk

Question

I am working on an application that has source code stored in GitHub, build and test is done by CodeShip, and hosting is done in Amazon Elastic Beanstalk.

I'm at a point where seed data is needed on the development database (PostgreSQL in Amazon RDS) and it is changing regularly in development.

I'd like to execute several SQL statements that are stored in GitHub when a deployment takes place. I haven't found a way to do this with the tools we're using, so I'm wondering if there are some alternatives.

what language do you use? there are specific tools that can be used per language — Tal, Dec 31 '15 at 10:00
The project is JavaScript, but I'm open to anything that gets the job done. — 80bower, Jan 04 '16 at 15:47

score 0 · Answer 1 · answered Jan 06 '16 at 08:19

0

If these are the same SQL statements, then you can simply create an .ebextension (see documentation) that will execute them after each deploy.
If the SQLs are dynamic per deploy, then I'd recommend a database migrations management tool. I'm familiar with rails that has that by default abut there's also a standalone migrations tool for non-rails projects. Google can suggest many other options.

answered Jan 06 '16 at 08:19

Tal

7,827
6
38
61

Yeah, these are the same statements and are written to handle any existing data. – 80bower Jan 06 '16 at 14:18
in that case, the solution is as written to use .ebextensions – Tal Jan 06 '16 at 20:35

Execute PostgreSQL statements upon deployment to Elastic Beanstalk

1 Answers1