How to use python list in "IN" operator Python Cassandra Driver?

Question

i am using Python Cassandra driver and CQL on back end, i want to update the data with IN operator

a = [1,2,3,4]
I want to run the following query
query = session.execute("update users set status=True where userid IN(%s)",[a])

but it does not work, i want to update the record where userid in list

Can any body help me please?

ktdrv · Accepted Answer · 2019-10-02 22:02:08Z

7

Try this:

from cassandra import query

yourquery = session.execute("update users set status=True where userid IN %s", query.ValueSequence([a]));

edited Oct 2, 2019 at 22:02

ktdrv

3,6933 gold badges32 silver badges45 bronze badges

answered Nov 13, 2017 at 15:10

user2187598

1312 bronze badges

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

Comments

wscourge · Accepted Answer · 2019-04-01 06:21:26Z

0

Try This :

dateList = ('2019-03-01', '2019-03-02')

cid_prep_statement = session.prepare('SELECT cid from table_name where "entry_date" **IN ?** and "language_name"=? LIMIT 10')

cassandra_cids = session.execute(cid_prep_statement, (**ValueSequence(dateList)**,'English'))

edited Apr 1, 2019 at 6:21

wscourge

11.4k17 gold badges65 silver badges87 bronze badges

answered Apr 1, 2019 at 6:03

aakash gouda

612 bronze badges

Collectives™ on Stack Overflow

How to use python list in "IN" operator Python Cassandra Driver?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related