BIT_COUNT in SQLAlchemy

Question

I'd like to represent the following query in SQLAlchemy:

select * from table where bit_count(column & bitmask) > 5

Basically I'm looking to select any row with a certain count of flags set. However, SQLAlchemy doesn't seem to have defined the BIT_COUNT() function. Anyone know any tricks to make this query in SQLAlchemy?

Joran Beasley · Accepted Answer · 2012-10-15 14:32:31Z

3

>>> session.query("id", "name", "thenumber12").\
...         from_statement("SELECT id, name, 12 as "
...                 "thenumber12 FROM users where bit_count(column&bitmask)<:the_val").\
...                 params(the_val=5).all()

something like that I imagine...

or

>>> from sqlalchemy import create_engine
>>> engine = create_engine('sqlite:///:memory:', echo=True)
>>> engine.execute("select * from table where bit_count(column & bitmask) > 5").scalar()

keep in mind im operating under the assumption that this is the correct use of bit_count ...

edited Oct 15, 2012 at 14:32

answered Oct 15, 2012 at 14:27

Joran Beasley

114k13 gold badges167 silver badges187 bronze badges

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

1 Comment

John Walthour Over a year ago

Thanks, that first form is what I ended up using. It seems to take advantage of SQLAlchemy the most.

Collectives™ on Stack Overflow

BIT_COUNT in SQLAlchemy

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related