Skip to content

Cache upserting sqlite version "syntax error" #51

@michaelwood

Description

@michaelwood

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions