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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/b90d237f-8c29-42ef-897a-34221704699dn%40googlegroups.com.
