The way I do it is backwards from what you are doing. I.E. I make the
models first and then use ./manage.py makemigrations & ./manage.py
migrate. This way Django creates the tables AND the FK Indexes, which I
think may be missing on your setup. Now that you have the models try
running the above commands.
Hope this helps.
On Tuesday, 17 July, 2018 08:03 PM, Sainath Bavugi wrote:
I am developing a web app using Django. I have created the table in
MySQL database and then generated the models.pyusing inspectdb. I am
able to fetch details and connect to the database without any issues.
But while saving the values to the particular table, below error is shown
*Cannot assign "3": "List.id" must be a "Order" instance.*
*
*
command used
|sav_list =List(id=4,item_name
='name1',item_desc='desc1',location='location',reason='rfp',pid=3)|
|*My models*|
|classList(models.Model):id
=models.IntegerField(db_column='ID',primary_key=True)# Field name made
lowercase.item_name
=models.CharField(db_column='Item_Name',max_length=255)# Field name
made lowercase.item_desc
=models.CharField(db_column='Item_Desc',max_length=300)# Field name
made lowercase.location
=models.CharField(db_column='Location',max_length=100,blank=True,null=True)#
Field name made lowercase.reason
=models.CharField(db_column='Reason',max_length=100,blank=True,null=True)#
Field name made lowercase.pid
=models.ForeignKey('Order',models.DO_NOTHING,db_column='PID')# Field
name made lowercase.classOrder(models.Model):poid
=models.IntegerField(db_column='POID',primary_key=True)# Field name
made lowercase.po
=models.CharField(db_column='PO',unique=True,max_length=20)# Field
name made lowercase.quote
=models.CharField(db_column='Quote',unique=True,max_length=20)# Field
name made lowercase.|
|
|condition =models.CharField(db_column='Condition',max_length=15)#
Field name made lowercase. |
|
I have tried relate_name for foreign key but still same behaviour.
Same values can be stored on database without any issues. Only Django
throws an error.
Please someone help me!!!
|
|
--
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
<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to django-users@googlegroups.com
<mailto:django-users@googlegroups.com>.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/3dce2148-ee12-41c5-996f-f21c7b33b4a5%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/3dce2148-ee12-41c5-996f-f21c7b33b4a5%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/998748ae-abcf-bfae-8133-10286e64499c%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
