inspectdb fails to inspect sqlite3 tables with foreign keys that have spaces

[samuller]

Running python manage.py inspectdb on an sqlite3 database with the following schema:

CREATE TABLE table_1 (
    id INTEGER PRIMARY KEY AUTOINCREMENT
);

CREATE TABLE table_2 (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    foreign_key_col INTEGER,
    FOREIGN KEY (foreign_key_col) REFERENCES table_1(id)
);

results in output missing tables with foreign keys:

class Table1(models.Model):
    id = models.IntegerField(primary_key=True, blank=True, null=True)  # AutoField?

    class Meta:
        managed = False
        db_table = 'table_1'
# Unable to inspect table 'table_2'
# The error was: 'NoneType' object has no attribute 'groups'

It turns out the regular expression (in django/db/backends/sqlite3/introspection.py) is not matching the string "FOREIGN KEY (foreign_key_col) REFERENCES table_1(id)" due to the single space character between KEY and the bracket. Depending on the schema input used to create the table there could be any amount of whitespace there.

[Tim Graham]

​PR (currently missing a test)

[Saulius Žemaitaitis]

​PR with tests based on the patch by samuller.

[Michael Manfre]

Patch now has a test and looks good.

[Tim Graham <timograham@…>]

In f28d29e8:

Fixed #27372 -- Fixed introspection of SQLite foreign keys with spaces in DDL.

Thanks samuller for the report and initial patch.