Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How do you import people data into postgresql? #752

Open
arheinjohnson opened this issue Jul 27, 2022 · 1 comment
Open

How do you import people data into postgresql? #752

arheinjohnson opened this issue Jul 27, 2022 · 1 comment
Labels
type:bug missing or incorrect data or functionality

Comments

@arheinjohnson
Copy link

It's unclear to me how to get people / legislators data into a postgresql db?

I've successfully ran init-db.sh and have a container of your pg db, and I was mostly successful running scrape-ca but came across errors seemingly related to missing people data. I'm hoping this can be resolved by hydrating the pg db with your people data, but I'm not finding a command in the documentation to do so?

@arheinjohnson arheinjohnson added the type:bug missing or incorrect data or functionality label Jul 27, 2022
@arheinjohnson
Copy link
Author

The reason I ask is, when running docker-compose run --rm ca-scrape ca bills --fast, I hit a long list of exceptions that for example are similar to this:

ERROR openstates: no people returned for (AND: (OR: ('name__iexact', 'McKinnor'), ('other_names__name__iexact', 'McKinnor'), ('family_name__iexact', 'McKinnor')), ('memberships__organization__jurisdiction_id', 'ocd-jurisdiction/country:us/state:ca/government'), ('memberships__organization__classification__in', ('upper', 'lower', 'legislature')), (OR: ('memberships__end_date', ''), ('memberships__end_date__gt', '2020-12-07')), (OR: ('memberships__start_date', ''), ('memberships__start_date__lt', '2021-12-31')))

I basically assume this is because my db is missing people data?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type:bug missing or incorrect data or functionality
Projects
None yet
Development

No branches or pull requests

1 participant