django.git/django/db/backends/sqlite3/introspection.py, branch stable/5.2.x

[5.2.x] Applied Black's 2026 stable style.

2026-03-30T19:55:07Z

https://github.com/psf/black/releases/tag/26.1.0 Backport of 6cff02078799b7c683a0d39630d49ab4fe532e7c from main.

[5.2.x] Fixed #36358 -- Corrected introspection of composite primary keys on SQLite.

2025-04-30T13:54:17Z

Previously, any first field of a composite primary key with type `INTEGER` was incorrectly introspected as an `AutoField` due to SQLite treating `INTEGER PRIMARY KEY` as an alias for the `ROWID`. This change ensures that integer fields in composite PKs are not mistaken for auto-incrementing fields. Thanks Jacob Walls and Sarah Boyce for the reviews. Backport of 07100db6f46255ec6ef70b860495f977473684d6 from main.

Fixed #35762 -- Avoided unneeded quote_name() calls in SQLite introspection.

2024-09-17T06:56:44Z

Double-quoting string literals is deprecated in recent SQLite versions. Co-authored-by: Mariusz Felisiak

Fixed #31300 -- Added GeneratedField model field.

2023-09-07T04:19:08Z

Thanks Adam Johnson and Paolo Melchiorre for reviews. Co-Authored-By: Lily Foote Co-Authored-By: Mariusz Felisiak

Made inspectdb used Cursor.description.display_size for CharFields' max_length.

2022-12-08T08:00:35Z

internal_size is size for fixed-size types not for char types.

Fixed #32234 -- Made inspectdb inform about composite primary keys.

2022-06-01T06:40:44Z

Refs #33476 -- Refactored code to strictly match 88 characters line length.

2022-02-07T19:37:05Z

Refs #33476 -- Reformatted code with Black.

2022-02-07T19:37:05Z

Refs #33288 -- Removed SQLite's DatabaseIntrospection._get_foreign_key_constraints().

2021-11-15T07:20:30Z

The get_relations() method returns the exact same data in a more generic format.

Fixed #33288 -- Made SQLite introspection use information schema for relations.

2021-11-15T07:07:07Z

Previous solution was using brittle and complex parsing rules to extract them from the SQL used to define the tables. Removed a now unnecessary unit test that ensured the removed parsing logic accounted for optional spacing.