Opened 14 years ago
Last modified 14 years ago
#15081 closed
When running tests you cannot use data that is inserted the <app>/sql/model.sql — at Initial Version
| Reported by: | maesjoch | Owned by: | nobody |
|---|---|---|---|
| Component: | Testing framework | Version: | 1.2 |
| Severity: | Keywords: | custom sql | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
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.