data4democracy / metadata-for-democracy Goto Github PK

Update the database docker file so that it starts up and runs any scripts found in /db/migrations. To get any environmental variables needed for running the database in the container, expect there to be a script in the root of the project called secrets.sh that sets the variables you need with the prefix MD4D_DB_ (ie, if you're passing in POSTGRES_PASSWORD, expect that the host will have an environmental variable called MD4D_DB_POSTGRES_PASSWORD that you can use.)

Create a file structure to isolate the api, github listener, and snapshot code.

Create docker files and a docker-compose to run the api, github listener and database.

For this iteration, assume PostgreSQL and Python 2.

Write a function that, given the name of an organization on github, returns a list of its public repos.

This function should be in ./snapshot/take.py.

Write code in the web hook to recognize when a payload contains information about a new task in github.

In order to avoid conflicts in development, configure PostgreSQL to run on a port other than the default.

Add a section of basic coding standards to the readme for this repo.

Update the docker files in the api and webhook directories so that they execute the code found in their home directories.

Documentation for the flask containers we're using can be found here.

Write a script or set of scripts that can be called on a Debian-branch (read Ubuntu) box or a Macintosh to start the services from a fresh github pull.

Write the initial scripts for creating a database to hold the information required by version 1. This includes the following tables: organization, repository, issue.

SQL scripts should go in the ./db/migrations directory (which doesn't exist yet.)

Documentation for the Postgres image can be found here.