You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When a bill is being inserted, and the legislator doesn't exist in the database, the method of handling it is really poor. It's just a SQL error. Make these improvements, in this priority order:
Have the logged error message indicate that this is likely the problem.
Create a function to retrieve barebones information about the legislator from the legislature's website, and insert a stub record about that legislator, prior to inserting the bill record. Basic house member data can be easily screen-scraped from the members list (they even generate CSV by screen-scraping their own site).
Ensure that a high-level alert is generated about the stub record, so that I know to build it out (instead of letting a terrible legislator record languish on the site).
Rebuild the site menu
The text was updated successfully, but these errors were encountered:
When a bill is being inserted, and the legislator doesn't exist in the database, the method of handling it is really poor. It's just a SQL error. Make these improvements, in this priority order:
The text was updated successfully, but these errors were encountered: