How to construct sql query with bitwise operation using sqlobject ORM in python3?

Question

I am trying to create a query in python3 using sqlobject mapper. I have a requirement of filtering a custom field based on the output of bitise operation. Query looks like this:

query = sqlobject.AND(query,dl.<table_object>.q.anomalyType & alert_type == alert_type)

But when the actual SQL transformation happens, this bitwise & gets converted into "SQL AND", which changes the whole meaning of the query.

Can someone advise the right way to add bitwise operator in the query sqlobject in python3?

What SQL do you want to get in result? (I'm the current maintainer of SQLObject.) — phd
– phd, Commented Mar 2, 2022 at 13:28
I want sql like "Select * from table1 where column1 & 2 = 2 ". Can this be done ? — Rajat Doshi
– Rajat Doshi, Commented Mar 2, 2022 at 14:42
Not with q-magic: it always maps Table.q.x & y to x AND y. Perhaps you can drop to simple strings: 'anomalyType & alert_type == alert_type' (note apostrophes). May be SQLConstant('anomalyType & alert_type == alert_type') or even SQLConstant('anomalyType & alert_type') == alert_type — phd
– phd, Commented Mar 2, 2022 at 15:10

Rajat Doshi · Accepted Answer · 2022-03-03 06:55:35Z

2

SQLConstant does the trick. Working sql query looks like this:

query = sqlobject.AND(query, sqlbuilder.SQLConstant(f'anomalyType & {alert_type}') == alert_type)

Thanks for the help @phd.

answered Mar 3, 2022 at 6:55

Rajat Doshi

1481 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to construct sql query with bitwise operation using sqlobject ORM in python3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related