dynamodb row count via python, boto query

Question

Folks, Am trying to get the following bit of code working to return the row count in a table:

import boto
import boto.dynamodb2
from boto.dynamodb2.table import Table
from boto.dynamodb2.fields import HashKey, RangeKey

drivers = Table('current_fhv_drivers')
rowcountquery = drivers.query(
   number = 'blah',
   expiration = 'foo',
   count=True,
  )
for x in rowcountquery:
 print x['Count']

Error I see is:

boto.dynamodb2.exceptions.UnknownFilterTypeError: Operator 'count' from 'count' is not recognized.

Whats the correct syntaxt to get row count :)

Thanks!

ingh.am · Accepted Answer · 2013-10-20 14:47:14Z

2

That exception is basically telling you that the operator 'count' is not recognized by boto.

If you read the second paragraph on http://boto.readthedocs.org/en/latest/dynamodb2_tut.html#querying you'll see that:

Filter parameters are passed as kwargs & use a __ to separate the fieldname from the operator being used to filter the value.

So I would change your code to:

import boto
import boto.dynamodb2
from boto.dynamodb2.table import Table
from boto.dynamodb2.fields import HashKey, RangeKey

drivers = Table('current_fhv_drivers')
rowcountquery = drivers.query(
   number__eq = 'blah',
   expiration__eq = 'foo',
   count__eq = True,
  )
for x in rowcountquery:
 print x['Count']

answered Oct 20, 2013 at 14:47

ingh.am

26.9k44 gold badges133 silver badges180 bronze badges

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

Comments

spenthil · Accepted Answer · 2015-08-27 23:27:29Z

2

from boto.dynamodb2.table import Table
table = Table('current_fhv_drivers')
print(table.query_count(number__eq = 'blah', expiration__eq = 'foo'))

edited Aug 27, 2015 at 23:27

answered Aug 18, 2015 at 22:08

spenthil

3,51331 silver badges17 bronze badges

Collectives™ on Stack Overflow

dynamodb row count via python, boto query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related