How to solve django with mysql error in inserting

Question

I create models for MySQL the foreign key constraints always returning error

The model is

class AirPort(models.Model):

  code = models.CharField(max_length=3)
  city = models.CharField(max_length=100)

  def __str__(self):
     return f"{self.id} - CODE =>{self.code} :: CITY=> {self.city}"

class Flight(models.Model):

  orgin_id = models.ForeignKey(AirPort,on_delete=models.CASCADE,related_name="dep")
  dest_id = models.ForeignKey(AirPort,on_delete=models.CASCADE,related_name="arrival")
  duration = models.IntegerField()

  def __str__(self):
      return f"{self.id} - {self.orgin} TO {self.dest} will take {self.duration} minutes"

and the shell output is

a=Flight(orgin_id=1,dest_id=2,duration=120) Traceback (most recent call last): File "", line 1, in File "/home/kid/PycharmProjects/hardward/venv/lib/python3.6/site-packages/django/db/models/base.py", line 467, in init _setattr(self, field.name, rel_obj) File "/home/kid/PycharmProjects/hardward/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 210, in set self.field.remote_field.model._meta.object_name, ValueError: Cannot assign "1": "Flight.orgin_id" must be a "AirPort" instance.

Don't call your FK origin_id, call it origin. Then you can use origin_id to assign via PK rather than instance. — Daniel Roseman
– Daniel Roseman, Commented Jan 9, 2019 at 15:20

JPG · Accepted Answer · 2019-01-09 04:37:08Z

1

Try

a=Flight(orgin=AirPort.object.get(id=1),dest=AirPort.object.get(id=2),duration=120)

answered Jan 9, 2019 at 4:37

JPG

89.4k24 gold badges164 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

codingKID Over a year ago

thanks its worked but i cant save the error is django.db.utils.OperationalError: (1054, "Unknown column 'orgin_id_id' in 'field list'") this column is auto generated i dont know the reason please help

codingKID Over a year ago

thank you its worked please explain does we need to run a=Flight(orgin=AirPort.object.get(id=1),dest=AirPort.object.get(id=2),duration=120) this code instead of normal one in mysql for foreign key constraints

shafikshaon · Accepted Answer · 2019-01-09 06:22:34Z

0

You may try this

flight_result=Flight()
flight_result.orgin_id = AirPort.object.first()
flight_result.dest_id = AirPort.object.last()
flight_result.duration = 1000
flight_result.save()

answered Jan 9, 2019 at 6:22

shafikshaon

6,5025 gold badges36 silver badges54 bronze badges

Comments

NduJay · Accepted Answer · 2019-01-09 04:35:42Z

0

Have you run python manage.py makemigrations...and migrated the data with python manage.py migrate

answered Jan 9, 2019 at 4:35

NduJay

8201 gold badge12 silver badges26 bronze badges

2 Comments

codingKID Over a year ago

yes django.db.utils.OperationalError: (1054, "Unknown column 'hello_flight.orgin_id_id' in 'field list'") this is the problem every time i make migration it adds coloums like orgin_id_id and dest_id_id

NduJay Over a year ago

Delete all the migrations in the migrations folder and then make migrations again.

Greg Holst · Accepted Answer · 2020-01-25 16:22:14Z

0

I received this error because I did not see the comma at the end

order.employee=Employee.objects.get(employee_id=x),

Its origin was that I used Order.objects.create() before, for which one uses comma separated attribute assignments and I did not immediately delete the commas. May it help someone who also sat too long in front of the computer :)

answered Jan 25, 2020 at 16:22

Greg Holst

97410 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to solve django with mysql error in inserting

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related