Python Django Queryset

Question

I'm playing with querysets in django.

What I'm looking it's to save a new foreign product or item but I can not achieve it.

shell

from applaboratorio.models import Datos_empresa_DB, Datos_equipo_DB

detalle = Datos_empresa_DB.objects.filter(pk=58)

resp = Datos_equipo_DB(equipo='dell-labtop',marca='dell', modelo='432423',Foraneo_Datos_empresa_DB = detalle)

models.py

class Datos_empresa_DB(models.Model):
    nombre = models.CharField(max_length=150)
    empresa = models.CharField(max_length=150)

class Datos_equipo_DB(models.Model):
    Foraneo_Datos_empresa_DB = models.ForeignKey(Datos_empresa_DB)
    equipo = models.CharField(max_length=300)
    marca = models.CharField(max_length=300)
    modelo = models.CharField(max_length=300)

What am I doing bad?

I'm trying to create a new product for a client that already exist in db.

You should include your models definition so we can tell what is the shape of the tables. — McAbra
– McAbra, Commented Oct 16, 2016 at 17:45

Moses Koledoye · Accepted Answer · 2016-10-16 18:02:19Z

2

I think you're nearly there. You need to call the save method of the new product to save to the DB, and to retrieve the related client object, you should get not filter so you have the object itself and not a list of objects (or QuerySet):

detalle = Datos_empresa_DB.objects.get(pk=58)
#                                  ^^^
resp = Datos_equipo_DB(equipo='dell-labtop',marca='dell', modelo='432423',Foraneo_Datos_empresa_DB =detalle)
#                                          Save on model's related field <-^^^^^^^
resp.save()

edited Oct 16, 2016 at 18:02

answered Oct 16, 2016 at 17:46

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

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

4 Comments

spectras Over a year ago

This. Or, alternatively, resp = Datos_empresa_DB.objects.create(equipo='dell-labtop', marca='dell', modelo='432423', detalle=detalle)

Moses Koledoye Over a year ago

@spectras Yes, that too :)

El arquitecto Over a year ago

Are you sure guys?

Moses Koledoye Over a year ago

@Elarquitecto Change detalle to Foraneo_Datos_empresa_DB in the model instantiation

Collectives™ on Stack Overflow

Python Django Queryset

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related