Questions tagged [gql]

GQL is a SQL-like language for retrieving entities or keys from Google Cloud Datastore.

GQL is a SQL-like language for retrieving entities or keys from the . While GQL's features are different from those of a query language for a traditional relational database, the GQL syntax is similar to that of SQL.

Resources

537 questions
5
votes
2 answers

Is there a way to get gql tag to autocomplete with Typescript/GraphQL?

Is there a way to get autocomplete when writing a GraphQL query using the gql `...` tag, when using Typescript? Something similar to when writing queries in Graphiql for example.
Greg Forel
  • 2,199
  • 6
  • 25
  • 46
5
votes
2 answers

How to retrieve entity from key value in GQL

I am using Google App Engine's datastore and wants to retrieve an entity whose key value is written as ID/Name id=1 Can anyone suggest me a GQL query to view that entity in datastore admin console and also in my python program?
niteshb
  • 2,599
  • 2
  • 17
  • 16
5
votes
1 answer

Google Datastore Composite index issue

I am getting below exception : Exception in thread "main" com.google.cloud.datastore.DatastoreException: no matching index found. recommended index is: - kind: cp_outbox properties: - name: format - name: occasion_name - name: sent_datetime …
ganesh_patil
  • 356
  • 3
  • 18
5
votes
1 answer

Is there a way to set all db queries to only retrieve a given user's entries, or would each query throughout the app have to include "AND user..."?

I created an app that lets users input products and compare them. I am at the point where i need to consider scaling and multiple users, and I want to only show users the items that they've created (instead of the entire db, which may be an option…
Max Cascone
  • 648
  • 9
  • 25
5
votes
1 answer

Cloud Datastore 'like' query

I've an entity in Google Cloud Datastore. One of the properties is array of strings. For example: property: skills Entity 1: value: ["mysql","sqlserver","postgresql","sqllite","sql-server-2008","sql"] Entity 2: value: ["css","css3"] Now, I need to…
5
votes
1 answer

I am able to add composite indexes to index.yaml file and get it to work without removing and reloading the data from datastore

I thought that this was not possible and that you had to reload all the data if you added new indexes. Is this supposed to happen?
A Ba
  • 275
  • 2
  • 10
5
votes
1 answer

Best way to design app engine datastore and text search modelling

We have a Java application running on google app engine. Having a kind called Contact. following is the sample schema Contact { long id String firstName String lastName ... } The above is the existig model,for supporting few requirements we…
5
votes
2 answers

Between query equivalent on App Engine datastore?

I have a model containing ranges of IP addresses, similar to this: class Country(db.Model): begin_ipnum = db.IntegerProperty() end_ipnum = db.IntegerProperty() On a SQL database, I would be able to find rows which contained an IP in a certain…
tijs
  • 797
  • 7
  • 24
5
votes
1 answer

App Engine's filter vs. gql methods

I have a user in my system who has created an entity which I'd like to retrieve. I'm attempting to do this using a filter because it's supposed to be faster than a call to the gql method. However, the filter returns no results and gql works.…
Matt Norris
  • 8,596
  • 14
  • 59
  • 90
5
votes
2 answers

GQL query where field is not null

I have an entity kind called Account. One of the fields is a String named selfie, which is basically the url to a selfie uploaded by a user. I want to fetch for users who have a selfie (so if a user does not have a selfie they should not be included…
Katedral Pillon
  • 14,534
  • 25
  • 99
  • 199
5
votes
1 answer

HAS ANCESTOR and HAS DESCENDANT clauses in google cloud datastore

I'm studying the Google Cloud Datastore GQL grammar - specifically the HAS ANCESTOR and HAS DESCENDANT comparison operators. Giving the following Person entities: Amy Fred, parent = Amy Laura, parent = Amy Paul Agnes ... Would the GQL queries…
lorenagmad
  • 89
  • 1
  • 4
5
votes
1 answer

GQL only for Python projects and not for java?

In Google App Engine, GQL(an SQL-like query mechanism foe datastore) is available only for Python Projects and not for java projects. Why is it so? Also it there anyway to overcome this and use GQL in java projects also?
vivek_jonam
  • 3,237
  • 8
  • 32
  • 44
5
votes
2 answers

What is the Google Appengine Ndb GQL query max limit?

I am looking around in order to get an answer what is the max limit of results I can have from a GQL query on Ndb on Google AppEngine. I am using an implementation with cursors but it will be much faster if I retrieve them all at once.
topless
  • 8,069
  • 11
  • 57
  • 86
4
votes
1 answer

On Google App Engine, how would I look up the latest order for a customer in GQL?

If I have two tables, Customers and Orders, and I want to look up the latest order for a customer, how would I do this on Google App Engine using GQL? Normally, I would join these two tables through the foreign key, customer_id, which exists in the…
pez_dispenser
  • 4,394
  • 7
  • 37
  • 47
4
votes
2 answers

How do I communicate using gql with Apollo websocket protocol

I want to connect to the websocket. When I inspect the traffic between the client and the server I see that the first message is the handshake: {"type": "connection_init", "payload": { "accept-language": "en", …
HJA24
  • 410
  • 2
  • 11
  • 33
1 2
3
35 36