How to covert SQL CASE expression to SQL Alchemy with an alias

Asked Dec 10 '18 at 13:40

Active Dec 11 '18 at 17:57

Viewed 152 times

How to covert given SQL Case expression with an alias to SQL Alchemy ORM

SELECT `id` AS `emailId`, `email`, `type`,
CASE WHEN `type` = 'Home' THEN 1
WHEN `type` = 'Work' THEN 2
ELSE 4 END `s_order`
FROM `emails`
WHERE `id` = '1121212'
ORDER BY `s_order` ASC'

I know case can be used like this

from sqlalchemy import case

stmt = select([users_table]).\
            where(
                case(
                    [
                        (users_table.c.name == 'wendy', 'W'),
                        (users_table.c.name == 'jack', 'J')
                    ],
                    else_='E'
                )
            )

but how do I include s_order ??

edited Dec 11 '18 at 17:57

Ilja Everilä

50,538
7
126
127

asked Dec 10 '18 at 13:40

Vaibhav Jain

5,287
10
54
114

Case _expression_, not statement. – jarlh Dec 10 '18 at 13:40
Possible duplicate of [Select as in sqlalchemy](https://stackoverflow.com/questions/3576382/select-as-in-sqlalchemy) – Caius Jard Dec 10 '18 at 13:54
@CaiusJard I don't think so, please look again – Vaibhav Jain Dec 10 '18 at 16:05
Possible duplicate of [Using a label in a having clause in sqlachemy](https://stackoverflow.com/questions/30313872/using-a-label-in-a-having-clause-in-sqlachemy) – Ilja Everilä Dec 11 '18 at 17:53
Also related to https://stackoverflow.com/questions/15555920/python-sqlalchemy-label-usage – Ilja Everilä Dec 11 '18 at 17:56

How to covert SQL CASE expression to SQL Alchemy with an alias

0 Answers0