ThreeSixtyGiving / datagetter

Scripts to download data from http://registry.threesixtygiving.org
MIT License
1 stars 1 forks source link

Cache upserting sqlite version "syntax error" #51

Open michaelwood opened 1 year ago

michaelwood commented 1 year ago

We make use of multiple ON CONFLICT in our cache update mechanism https://github.com/ThreeSixtyGiving/datagetter/blob/master/getter/cache.py#L87

The syntax was generalized to permit multiple ON CONFLICT clauses and to allow DO UPDATE resolution without a conflict target in SQLite version 3.35.0 (2021-03-12). https://www2.sqlite.org/matrix/lang_upsert.html

The datastore has version 3.31.1

I'm not sure how easily upgrade able this is since sqlite3 is part of python's core though it's a sql statement not any api or bindings issue.