On Thu, Feb 13, 2020 at 2:59 PM Jérôme Le Carrou <[email protected]> wrote:
> Hi, > > I have 2 models that are not related (maybe it should...) > > I need to make a query that select all records of my table Stock WITH > related rows in Parametrage based on asp_sto_loc=asp_par_loc > > Something like SQL: select * from pha_asp_sto left join pha_asp_par on > pha_asp_par.asp_par_loc=asp_sto_loc; > Have a look at django.db.models.SubQuery <https://docs.djangoproject.com/en/3.0/ref/models/expressions/#subquery-expressions> <http://django.db.models.SubQuery> How can I make such a query in Django? > I have see extra() but seems to be deprecated... > Another option would be to use raw() but not recommended... > > class Stock(models.Model): > > asp_sto_cle = models.AutoField(primary_key=True) > asp_sto_loc = models.CharField("Site concerned", max_length=10, > null=True, blank=True) > asp_sto_pla = models.IntegerField("Quantity of placebos available", > null=True, blank=True,) > asp_sto_asp = models.IntegerField("Quantity of aspirin available", > null=True, blank=True) > class Parametrage(models.Model): > > asp_par_cle = models.AutoField(primary_key=True) > asp_par_loc = models.CharField("Site concerned by settings", > max_length=10, null=True, blank=True) > asp_par_ale = models.IntegerField("Site alert value for the site", > null=True, blank=True,) > asp_par_con = models.IntegerField("Site confort value for the site", > null=True, blank=True,) > > thanks for your help > > -- > 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/029c93e0-4093-4a4f-bc99-b3af000c3c31%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/029c93e0-4093-4a4f-bc99-b3af000c3c31%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAD%3DM5eQiPuR%3DsASF04wv6sdCUhiRu-oyfiLq60axZr%3D3qF-i0w%40mail.gmail.com.
