class Monolithic(models.Model): facepng_id = models.IntegerField(blank=True, null=True)
facepng_id as Integer not ForeignKey? > UPDATE items_monolithic SET facepng_id=items_monolithic.id FROM items_monolithic INNER JOIN items_facepng ON items_monolithic.object=items_facepng.obj ; Error: near "from": syntax error I'll keep working on the code. Add a facepng_id Integer Field to Monolith. Run makemigrations. Add a > RunSQL command to the new migrations file ( > https://docs.djangoproject.com/en/2.2/ref/migration-operations/#runsql). > Something like this: > > Update items_monolith SET facepng_id=items_monolith.id FROM > items_monolith INNER JOIN items_facepng ON > items_monolith.object=items_facepng.obj > > > > Then delete the object and obj fields from the models. Run makemigrations > again. Verify that your app doesn’t reference those fields anywhere else. > > > > Then you could access facepng like so: > > monolithic.facepng_set > > > > Of course, this is just a very rough idea of what to do, and I’m not sure > what the whole structure of your tables is. > > > > *From:* django...@googlegroups.com <javascript:> [mailto: > django...@googlegroups.com <javascript:>] *On Behalf Of *b...@tanners.org > <javascript:> > *Sent:* Monday, May 6, 2019 11:28 AM > *To:* Django users > *Subject:* ORM help with INNER JOIN and GROUP BY > > > > I've inherited an application written django 1.11. The old application > uses raw() with INNER JOIN and GROUP BY. > > I cannot seem to figure out how to do inner join and group by properly > the ORM way. > > > > The raw() query is below. > > > > SELECT * FROM items_monolithic > > INNER JOIN items_facepng > > ON items_monolithic.object == items_facepng.obj > > GROUP BY items_monolithic.object > > ORDER BY object ASC > > > > > > Things kind of work with raw() but that doesn't feel right. And I get > nasty warnings about RawQuerySet not supporting certain things when I try > to use the query set that is returned. > > > > From what I understand every monolithic object has 1 or more faces > (graphic/picture). > > > > I would call the monolithic a one-to-many relationship with facepng but I > see django calls this a ForeignKey. > > > > I'm working with these models (yes, a field named object is "bad", it's > what I was given) > > > > > > class Monolithic(models.Model): > > object = models.CharField(max_length=128, blank=False, null=False, > unique=True) > > > > class FacePng(models.Model): > > obj = models.CharField(max_length=128, blank=True, null=True) > > > > > > I do not see the ForeignKey relationship between Monolithic and FacePng. > > > > Changing Monolithic class to models.ForeignKey() breaks lots of things. > > > > So I'd prefer to figure out how to do the inner join and group by query > but if that's not the django way and I need to change Monolithic.objects to > a ForeignKey() and fix all the stuff that is broken I can do that that too. > > > > Just need some guidance on how to proceed. > > > > > > > > -- > 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...@googlegroups.com <javascript:>. > To post to this group, send email to djang...@googlegroups.com > <javascript:>. > 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/ab7ecf5b-9ae8-4428-9502-6b7d5dec03b5%40googlegroups.com > > <https://groups.google.com/d/msgid/django-users/ab7ecf5b-9ae8-4428-9502-6b7d5dec03b5%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/7af29fa6-5cfc-4bda-a471-ed8ee26b37ff%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
