search

ACTtaiwan / CongressionalGuide

Web based look up for U.S. Congress members and candidates to see if they support certain legislation or issues.
MIT License
8 stars 5 forks source link

adding candidate url column support #63

Closed balamark closed 8 years ago

balamark commented 8 years ago

I see some column now has constraint 'unique' and that cause the script to fail if there are more than one candidates without the website value. Because it's a Null value for those candidates without website url and it seems like it's enforcing uniqueness on Null.

Also, don't forget to update the script if the schema changes. (insert_query and insert_value) or create an item and let me know.

balamark commented 8 years ago

wait, don't merge the db

balamark commented 8 years ago

ok. only change the import script. Now, fb,twitter,candidate url should works fine.

soarhevn commented 8 years ago

Actually on SQLite at least, unique does not count NULL, so it should not throw an error. Not sure why it would be doing so for you. I'll try the new import script and see if I get an error.