Cloud Firestore - Python - Performing simple Where query always returns Query object

Question

I know this question may sound silly, but how can I properly query data using the Firebase Admin SDK (Cloud Firestore) with Python?

Yes, I have read the docs here:

• Perform simple and compound queries in Cloud Firestore
• Order and limit data with Cloud Firestore

My database:

My code:

existing_post = db.collection(u'posts').where(u'id', u'==', u'BpzIbkqAkk0').get()
print(existing_post)

I also tried omitting the .get() method, but also getting the same result each time.

All I've been getting is

<google.cloud.firestore_v1beta1.query.Query object at 0x10e7aab00>

Any ideas?

Answer 1

@Gerardo's comment has lead me to the right direction. Here's the working code:

existing_posts = db.collection(u'posts').where(u'id', u'==', u'BpzIbkqAkk0').get()
for post in existing_posts:
    print(u'{} => {}'.format(post.id, post.to_dict()))

Answer 2

You have to convert generator object into dictionary format using to_dict(). Then you can easily access whatever value you want.

existing_posts = db.collection(u'posts').document(u'id').get()
result=existing_posts.to_dict()
id='BpzIbkqAkk0'
result_id=result[id]

try this it may help you.