Makefile

add_topics : topics_added.csv
	cat $< | psql $$DATABASE_URL -c "`cat scripts/update_topics.sql`"

.INTERMEDIATE: topics_added.csv
topics_added.csv: needs_topics.csv
	cat $< | python scripts/topics.py > $@

.INTERMEDIATE : needs_topics.csv
needs_topics.csv :
	psql $$DATABASE_URL -f scripts/needs_topics.sql > $@

data_issues.xlsx : missing_organization_on_actions.csv missing_bill_text_pdfs.csv bad_introductions.csv dupe_actions.csv bad_action_date.csv bad_agenda_action.csv
	python scripts/to_excel.py $^ $@

missing_organization_on_actions.csv :
	psql $$DATABASE_URL -f scripts/missing_organizations.sql > $@

missing_bill_text_pdfs.csv :
	psql $$DATABASE_URL -f scripts/missing_version.sql > $@

bad_introductions.csv :
	psql $$DATABASE_URL -f scripts/bad_introductions.sql > $@

dupe_actions.csv :
	psql $$DATABASE_URL -f scripts/dupe_actions.sql > $@

bad_action_date.csv :
	psql $$DATABASE_URL -f scripts/bad_action_date.sql > $@

bad_agenda_action.csv :
	psql $$DATABASE_URL -f scripts/bad_agenda_action.sql > $@