When running tests you cannot use data that is inserted the <app>/sql/model.sql

[maesjoch]

Consider following case:

#model

class sqltest(models.Model):
    
    name = models.CharField(max_length=100, unique=True)

#test

from django.test import TestCase
from testapp.app_test.models import sqltest

class SimpleTest(TestCase):
    def test_basic_addition(self):
        s = sqltest.objects.get(name='test1')
        self.assertTrue(s)

#in <app>/sql/sqltest.py

insert into app_test_sqltest (name) values ('test1');
insert into app_test_sqltest (name) values ('test2');
insert into app_test_sqltest (name) values ('test3');

When running your tests will not find the test1 entry. This is not consistent with how django docs explain it (although not that much testing information on custom sql).

Was this by design or is it an actual bug I do not know.

[Russell Keith-Magee]

I can't reproduce this. The test described passes as expected for me under SQLite and Postgres.

[Russell Keith-Magee]

Following more detail on IRC: This only affects MySQL.

[maesjoch]

I can reproduce with 'ENGINE': 'django.db.backends.postgresql_psycopg2',
Same app.

[Russell Keith-Magee]

I've already accepted the ticket. There's no need to move it back for another review.

[Russell Keith-Magee]

Turns out this is already caught by Django's test suite, and has been reported as #14661,