code4sac/councilmatic-stack

Stack for running the Councilmatic stack

councilmatic-stack

The goal of this project is to get the imago project, scraper-us-municipal project, and councilmatic-starter-template all working together.

Requirements

1. Install docker an docker-compose if you do not have them installed
2. Clone this scrapers project into the the folder scrapers in this project: https://github.com/feydan/scrapers-us-municipal.
3. Clone this sacramento-councilmatic project into the folder sacramento-councilmatic into this project: https://github.com/code4sac/sacramento-councilmatic and switch to the councilmatic-stack branch
4. Clone this api project intot he folder api in this this project: https://github.com/datamade/api.opencivicdata.org

Setup

1. In the sacramento-councilmatic/councilmatic folder, copy settings_deployment.py.example to settings_deployment.py, and when developing locally change the DEBUG = False line to DEBUG = True

Initializing

1. Run docker-compose up to start the database and scrapers containers. Keep this terminal window running.
2. Run the initial migration for scrapers docker-compose exec scrapers pupa dbinit us
3. Run the initial migration for councilmatic docker-compose exec councilmatic python manage.py migrate
4. Run the initial cache table creation docker-compose exec councilmatic python manage.py createcachetable
5. Run the initial migration for api docker-compose exec api python manage.py migrate

Running the scrapers

1. Ensure the containers are running. If they are still running from the Initializing step above continue to step 2. Otherwise start the containers: docker-compose up.
2. docker-compose exec scrapers /bin/bash (ssh's into the scrapers project)
3. pupa update sacramento (runs the update script)
4. exit exit scrapers

Importing data into Councilmatic

1. Ensure the containers are running. If they are still running from the Initializing step above continue to step 2. Otherwise start the containers: docker-compose up
2. docker-compose exec scrapers /bin/bash (ssh's into the councilmatic project)
3. python manage.py import_data
4. exit exit the scrapers

Accessing the web application

The web application is accessible at http://localhost:8001/ in your browser.

Accessing the database

docker-compose exec postgresql psql opencivicdata pupa

Todo

1. Fix bootstrapping so that you do not need to run the init scripts and have the update script automatically run on a cron job

Resources

Docker stuff: https://docs.docker.com/compose/django/#create-a-django-project

Open civic data api:

• https://github.com/datamade/imago
• https://github.com/datamade/api.opencivicdata.org

Scrapers US Municipal: opencivicdata/scrapers-us-municipal#243

Councilmatic: https://github.com/datamade/councilmatic-starter-template,