diff options
| author | RamonWill <ramonwilliams@hotmail.co.uk> | 2020-09-14 18:22:34 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2020-11-08 13:34:24 -0500 |
| commit | 89ddd0b8976ed695d239898a2a8e4ebf531537f2 (patch) | |
| tree | 31728325dbdea93b96fb80af4895d29d6e7c57b9 /lib/sqlalchemy/sql | |
| parent | 75fb71d25e988bcc13629469cb6739ad7eb539e9 (diff) | |
| download | sqlalchemy-89ddd0b8976ed695d239898a2a8e4ebf531537f2.tar.gz | |
Implement upsert for SQLite
Implemented INSERT... ON CONFLICT clause for SQLite. Pull request courtesy
Ramon Williams.
Fixes: #4010
Closes: #5580
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5580
Pull-request-sha: fb422e0749fac442a455cbce539ef662d9512bc0
Change-Id: Ibeea44f4c2cee8dab5dc22b7ec3ae1ab95c12b65
Diffstat (limited to 'lib/sqlalchemy/sql')
| -rw-r--r-- | lib/sqlalchemy/sql/dml.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/lib/sqlalchemy/sql/dml.py b/lib/sqlalchemy/sql/dml.py index dc2aacbea..9b9a6153b 100644 --- a/lib/sqlalchemy/sql/dml.py +++ b/lib/sqlalchemy/sql/dml.py @@ -863,11 +863,12 @@ class Insert(ValuesBase): backends that support "returning", this turns off the "implicit returning" feature for the statement. - If both `values` and compile-time bind parameters are present, the - compile-time bind parameters override the information specified - within `values` on a per-key basis. + If both :paramref:`_expression.Insert.values` and compile-time bind + parameters are present, the compile-time bind parameters override the + information specified within :paramref:`_expression.Insert.values` on a + per-key basis. - The keys within `values` can be either + The keys within :paramref:`_expression.Insert.values` can be either :class:`~sqlalchemy.schema.Column` objects or their string identifiers. Each key may reference one of: |