diff options
| author | fulpm <8397318+fulpm@users.noreply.github.com> | 2020-10-20 17:54:50 -0400 |
|---|---|---|
| committer | Gord Thompson <gord@gordthompson.com> | 2020-10-21 17:47:33 -0600 |
| commit | 7937a409f9e685341b6a5b8385491befe0aaa4d4 (patch) | |
| tree | 32205383be2966d9bc59fb47306b65184204e5f2 /lib/sqlalchemy/dialects/sqlite | |
| parent | 91e14cc42c3c715f57db7d910761dfd5dd55e2b1 (diff) | |
| download | sqlalchemy-7937a409f9e685341b6a5b8385491befe0aaa4d4.tar.gz | |
Correct reflection for composite primary keys
Fixes: #5661
### Description
Fixes reflection of composite primary keys to maintain the correct column order in the MSSQL
and SQLite dialects.
Closes: #5662
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5662
Pull-request-sha: b568dec7070b4f3ee46a528bdf16fb237baade2a
Change-Id: I452b23cbf7f389c4a0a34cffce5c32498efe37d2
Diffstat (limited to 'lib/sqlalchemy/dialects/sqlite')
| -rw-r--r-- | lib/sqlalchemy/dialects/sqlite/base.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index 8ef35514a..8a4fbe8e5 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -1853,6 +1853,7 @@ class SQLiteDialect(default.DefaultDialect): constraint_name = result.group(1) if result else None cols = self.get_columns(connection, table_name, schema, **kw) + cols.sort(key=lambda col: col.get("primary_key")) pkeys = [] for col in cols: if col["primary_key"]: |