Thanks!
On Mon, Feb 20, 2017 at 10:52 AM, m1chael <[email protected]> wrote: > i did something like this recently using .extra / select > > https://docs.djangoproject.com/en/1.10/ref/models/querysets/#extra > > > > On Mon, Feb 20, 2017 at 10:49 AM, Larry Martell <[email protected]> > wrote: >> >> Is there any way to use both the ORM and raw SQL in the same query? >> >> I have an existing app that uses the ORM and now I have a need to add >> SQL like this to the select: >> >> (CASE >> WHEN TRIM(IFNULL(roiname, '')) IN ('', 'None') THEN CONCAT_WS('.', >> roi_type_id, roi_id) >> WHEN CONCAT_WS('.', roi_type_id, roi_id) = roiname THEN roiname >> ELSE CONCAT_WS('.', roi_type_id, roi_id, roiname) >> END) as roiname >> >> and SQL like this to the where: >> >> AND (CASE >> WHEN TRIM(IFNULL(roiname, '')) IN ('', 'None') THEN CONCAT_WS('.', >> roi_type_id, roi_id) >> WHEN CONCAT_WS('.', roi_type_id, roi_id) = roiname THEN roiname >> ELSE CONCAT_WS('.', roi_type_id, roi_id, roiname) >> END) REGEXP 'foo' >> >> As far as I know I cannot do anything like that with the ORM. I don't >> want to have to rewrite everything with raw SQL. Is there a way to mix >> them? -- 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 post to this group, send email to [email protected]. 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/CACwCsY7xjBPYK17Vp2H-uV2c0aH3p-%2BG_Ya5n9dBjifE0Nk6ag%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
