Hello,
I'm getting the following error whenever I attempt to save to the table in
a SQLite database:
foreign key mismatch - "procedure_tbl" referencing "filename_tbl"
In models.py, these are the tables that the error is refering to:
class FilenameTbl(models.Model):
rowid = models.AutoField(auto_created=True, primary_key=True,
serialize=False, verbose_name='FileID', db_column='rowid')
filename = models.TextField(blank=True, null=True)
creation_datetime = models.TextField(blank=True, null=True)
class Meta:
managed = False
db_table = 'filename_tbl'
ordering = ['rowid']
class ProcedureTbl(models.Model):
rowid = models.AutoField(auto_created=True, primary_key=True,
serialize=False, verbose_name='ProcedureID', db_column='rowid')
...
filename_id = models.ForeignKey(FilenameTbl,db_column='filename_id',
to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL)
class Meta:
managed = False
db_table = 'procedure_tbl'
ordering = ['rowid']
Data can be read from the tables and querysets like the following return
the correct data:
queryset = FilenameTbl.objects.values(
'rowid', 'filename',
'proceduretbl__rowid')
Raw SQLite commands to write/update to the ProcedureTbl table function
properly.
If I removed filename_id from the ProcedureTbl, then data can be saved to
the table.
Any insight into the issue would be much appreciated.
Cheers,
Wai
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/b90d237f-8c29-42ef-897a-34221704699dn%40googlegroups.com.
