Stack Overflow
Stack Overflow

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
0
votes
1 answer

Google App data store and GQL in Django

Is there a way to use GQL and Google App engine data store with Django? If yes then how to use it, I have searched on web but I am unable to find any satisfying answers to this problem?
Ankit Agrawal
  • 1
  • 1
0
votes
1 answer

how to limit the results from datastore of google app engine.?

Hello sir I am trying to get data from datastore of google app engine. I am executing following query to get data in descending order using app engine endpoint method. Query highScorer = mgr.createQuery("select from CheckIn as CheckIn ORDER BY…
user3687223
  • 185
  • 5
  • 14
0
votes
2 answers

Google app engine- how to delete single entity wen u have ID for that entity in python

I am building a blog using GAE. i would like to delete specific posts stored in datastore with the ID key.My code being.. #my db model class Post(db.Model): subject = db.StringProperty(required = True) content = db.TextProperty(required =…
DeadDjangoDjoker
  • 534
  • 2
  • 8
  • 20
0
votes
1 answer

ORDER BY in appengine DataViewer using GQL doesnt work for one column

I have a question which presumably has a simple solution, but I cannot find any documentation to solve the following problem. I have a DB with a few columns, such as firstname, modified, and version. I can order by firstname or modified easily,…
Baltheros
  • 3
  • 2
0
votes
1 answer

Hierarchical queries for Parent-Child entities in App Engine

Is it possible to query Parent + Child entities in a single query pass? This would require a JOIN in SQL, but in the underlying BigTable the keys are sequential, so it should theoretically by possible to scan Parent and Child entities in a single…
rsb
  • 1,020
  • 1
  • 10
  • 25
0
votes
2 answers

Query all Children for Parent using Appengine Admin Console Datastore Viewer

I have an Entity named RouteCompletion that identifies Route as it's Parent (using Objectify @Parent annotation). In the AppEngine Admin Console I am able to query for the specific child by writing a standard key query. SELECT * FROM…
Aaron Roller
  • 1,074
  • 1
  • 14
  • 19
0
votes
1 answer

ndb query select both __key__ and properties simultaneously

Is it possible to select both the key as well as properties in an ndb query? Right now I have: one = ndb.gql('SELECT __key__ FROM Subject ORDER BY order ASC') two = ndb.gql('SELECT name,order FROM Subject ORDER BY order ASC') Is it possible to have…
mrmo123
  • 725
  • 1
  • 8
  • 23
0
votes
2 answers

Placement of sorted entry in Google App Engine Datastore

I'd like to determine what place a particular entry is in, but the appropriate GQL query is escaping me. Ideally I'd like to know the following details, which seem like they should be known by the Datastore. I just can't seem to figure how to…
Joey
  • 7,537
  • 12
  • 52
  • 104
0
votes
1 answer

Google JSON API and GQL. Get objects by date range

I try to find objects in google datastore via GQL and JSON API by date range. For example, this is my request: SELECT * FROM table WHERE uuid = "test" AND start >= 100 AND end <= 150 But i get error: { errors: [ { domain: 'global', reason:…
MrPovod
  • 193
  • 6
0
votes
1 answer

Why standard NDB query returns different result compared to GQL query?

I use the following code to count number of entities: def get_emails_count(email_type=None, yesterday=None, status=None): emails = EmailQueue.query() if email_type: emails = emails.filter(EmailQueue.email_type == email_type) if…
LA_
  • 19,823
  • 58
  • 172
  • 308
0
votes
0 answers

Parse GQL query for Java

Besides: https://github.com/andreacimino/gql4j Are there any other GQL parser that can generate a Query object from GQL String query?
quarks
  • 33,478
  • 73
  • 290
  • 513
0
votes
2 answers

How to look for a substring GQL?

I'm trying to stop duplicates of a database entity called "Post" in my program. In order to do this I want to append a number like "1" or "2" next to it. In other words: helloworld helloworld1 helloworld2 In order to do this I need to query the…
user2200321
  • 325
  • 1
  • 4
  • 18
0
votes
1 answer

app engine max occurrence query

I have following structure of entities(table) class MovieStatus(ndb.Model): movie_name = ndb.TextProperty() preference = ndb.IntergerPropety() and my entries are like below, movie_name | preference Highway 3 Highway …
Nikhil Rupanawar
  • 4,061
  • 10
  • 35
  • 51
0
votes
1 answer

How to edit record in google datastore in AppEngine?

I was create one app which have model and it was created but i facing problem how to edit data in google data store using python or Django. Please Help me.
Sagar Kanabar
  • 464
  • 4
  • 18
0
votes
1 answer

Gql query returning unexpected empty

I'm trying to use a query i know is supposed to return a value but it does'nt and i'm unable to filter using Type heres the query: SELECT Type FROM machinetype WHERE Brand = 'Avant' heres the index serving: Type ▲ , Brand ▲
user3062352
  • 1
  • 2
1 2 3
…
35 36