How much do your public officials make?

• 🐳 Docker

Perform the following steps from your terminal.

Clone this repository and cd into your local copy.

git clone https://github.com/datamade/bga-payroll.git cd bga-payroll

Next, copy bga_database/local_settings.py.example from bga_database/local-settings.py.

cp bga_database/local-settings.example.py bga_database/local-settings.py

Finally, build and run the applicaton.

docker-compose up -d --build

Once the command exits, you can visit the app in your browser at http://localhost:8000.

To view logs for app, worker, or any of the other services defined in docker-compose.yml, run docker-compose logs -f <SERVICE_NAME>, e.g., docker-compose logs -f app.

The application will work without data, but if you'd like to add some, you have two options: Restore from a database dump, or create and upload a data file.

DataMaders can make or request a dump of the staging database in the #bga-payroll Slack channel.

To create a dump, you must have SSH access to the staging server. Provided that's true, run the following command in your terminal, swapping in the correct value for ${STAGING_URL}:

ssh ubuntu@${STAGING_URL} pg_dump -U postgres -Fc -O -d bga_payroll -h ${RDS_URL} > bga_payroll.dump

When restoring a database, it's important that your local database is empty. So, remove your data volumes prior to restoring.

docker-compose down --volumes

Then, bring your database service up. This will create the bga_payroll database.

docker-compose up postgres

When your database is ready, you'll see output like this:

bga-payroll-postgres | PostgreSQL init process complete; ready for start up. bga-payroll-postgres | bga-payroll-postgres | 2021-08-18 16:31:36.869 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 bga-payroll-postgres | 2021-08-18 16:31:36.869 UTC [1] LOG: listening on IPv6 address "::", port 5432 bga-payroll-postgres | 2021-08-18 16:31:36.873 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" bga-payroll-postgres | 2021-08-18 16:31:36.890 UTC [75] LOG: database system was shut down at 2021-08-18 16:31:36 UTC bga-payroll-postgres | 2021-08-18 16:31:36.895 UTC [1] LOG: database system is ready to accept connections

In a separate terminal window, run pg_restore to load your dump into your containerized database.

docker exec -i bga-payroll-postgres pg_restore -U postgres -Fc -O -v -d bga_payroll < bga_payroll.dump 

Finally, start the app:

docker-compose up

N.b., if you need search for development, you also need to build the search index. This command will add employers from 2018 to the index. Add people to the entity types argument, if you need to.

docker-compose exec app python manage.py build_solr_index --reporting_year 2018 --entity-types units,departments --chunksize=25

First, make a formatted data file in the data/raw folder.

• The file should have a name like payroll-actual-*.csv
• The data should have these columns in this order: employer,last_name,first_name,title,department,base_salary,extra_pay,date_started,id,year

data/raw/payroll-actual-2017-pt-1.csv

docker-compose exec app make import/payroll-actual-2017-pt-1.csv

This will process and import the file data/raw/payroll-actual-2017-pt-1.csv. So to add data, first put the new data in that directory with that naming convention.