Writing a python script to fetch content of a datastore entity in GCP

Question

I am trying to fetch a column of a datastore entity in Google Cloud Platform. I can do it by writing a GQL query from the console, but I want to do the same using a python script and use the same GQL query and run it through the cloudshell of GCP. Here is a table similar to the one used in datastore :

I have to find out the names whose Salary is more than 280000. I wrote a GQL query in the console :

SELECT Name from Person where Salary>280000 ;

I got the result, but I want to do the same using Python script which could run in the cloudshell.

Hsn · Accepted Answer · 2020-09-08 11:49:41Z

3

Its pretty simple.

from google.cloud import datastore
client = datastore.Client()
query = client.query(kind='Kindname')
query = query.add_filter('Salary', '>', 280000)
l = query.fetch()
l = list(l)
if not l:
    print("No result is returned")
else:  
    d = dict(l[0])
    print(d['name'])

answered Sep 8, 2020 at 11:49

Hsn

1,2382 gold badges20 silver badges52 bronze badges

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

Comments

llompalles · Accepted Answer · 2020-09-08 11:35:51Z

0

What you are looking for is the Python client library for Cloud Datastore.

You can use it to query data from a Python script, in your example it would be something similar to this:

from google.cloud import datastore
client = datastore.Client()
query = client.query(kind='Person')
query = query.add_filter('Salary', '>', 280000)

To learn more, I recommend you to take a look at the documentation for queries and on how to set up authentication.

answered Sep 8, 2020 at 11:35

llompalles

3,19614 silver badges22 bronze badges

Collectives™ on Stack Overflow

Writing a python script to fetch content of a datastore entity in GCP

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