You of course mean, no foreign key ? Are the models pre written so no change can be made to them.
Sent from my iPad > On 13-Feb-2020, at 2:58 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; > > 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. -- 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/90F33E3C-4554-44C9-BDBE-0AFCD8E46FD9%40gmail.com.
