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

Figure out why votes are not being exported as test data #398

Open
waldoj opened this issue Jan 27, 2020 · 3 comments
Open

Figure out why votes are not being exported as test data #398

waldoj opened this issue Jan 27, 2020 · 3 comments
Labels

Comments

@waldoj
Copy link
Member

waldoj commented Jan 27, 2020

The MySQL export script includes the votes table, and yet no vote records are being included. The preamble from the export is there, but no actual records are surfaced. Figure out why.

@waldoj waldoj added the devops label Jan 27, 2020
@waldoj
Copy link
Member Author

waldoj commented Jan 27, 2020

Well, part of the problem is that representatives_votes isn't being exported at all. That's for the simple reason that bill_id is (quite reasonably) not included in that table — instead, the shared key is the vote_id column (not the same as the lis_vote_id column!), which adds a wrinkle that the simple export script isn't prepared to deal with.

@waldoj
Copy link
Member Author

waldoj commented Jan 27, 2020

Still, the data from votes should be exported. Yet it's not.

@waldoj
Copy link
Member Author

waldoj commented Jan 27, 2020

Looking at live data on the site, these queries do not, in fact, return results. There is no record with these bill IDs. And yet here's a vote on one of these bills. I don't know what's happening here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant