Questions tagged [gqlquery]
129 questions
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
0
votes
1 answer
How to call GQLQuery
Is it possible to call GQL query inside a gwt application in the server's implementation something like:
SELECT * FROM User order by score desc
To be able to retrieve a sorted list ???I tested the query in databaseviewer and it returned the sorted…
user3008437
- 41
- 7
0
votes
1 answer
Google App Engine Datastore: Extracting data using GQL query
I'm currently playing with the Google App Engine datastore, and trying to extract some data from my applications database using GQL.
import os
import re
import random
import hashlib
import hmac
from string import letters
import webapp2
import…
Manas Chaturvedi
- 5,210
- 18
- 52
- 104
0
votes
1 answer
Where condition in GQL query giving error
I am sorry if my query is stupid but please excuse me as i am new to google app engine and python
I have and entity named Location
class Location(db.Model):
place = db.StringProperty(required = True)
address = db.TextProperty(required =…
Bhushan
- 354
- 9
- 25
0
votes
1 answer
GqlQuery by ID always returns None result
My code is intended to:
Retrieve a user_id from a cookie, if it exists.
Query the datastore using the user_id to retrieve the user record.
Finally, if a record is found, it displays a welcome message. (signup is passed to a template)
I cannot get…
Hess
- 130
- 4
0
votes
1 answer
why is my Python GAE code asynchronous?
This is the code:
def create_game(user_id):
game = classes.Games(user_id = user_id)
game.put()
def get_game(user_id):
game_query = classes.Games.gql('WHERE user_id = :1', user_id)
game = False
for item in game_query:
…
Edmund Sulzanok
- 1,883
- 3
- 20
- 39
0
votes
1 answer
Google App Engine: IN filter and argument position
I have a table where one of the columns contains a list. I want to know if it is possible to select all rows where the list contains a specific element.
More concretely, I have a guests column containing a list of strings and I want to know if a…
user2689968
- 21
- 1
0
votes
1 answer
GqlQuery returns random results
I'm writing a quite simple web application based on Google's Application Engine. It's the first time I'm working with Python and Google's datastore.
The application should display some questions on its home page. Those questions are stored in a…
offz
- 223
- 1
- 2
- 6
0
votes
1 answer
Use variable to get property value
I want be able to get values from my database using a variable, the last line is what I'm trying to achieve.
class Data(db.Model):
property = db.StringProperty()
data = Data(property = 'value')
data.put()
query = db.GqlQuery("SELECT * FROM…
AshClarke
- 2,990
- 5
- 21
- 27
0
votes
2 answers
Querying the Google App Engine Datastrore
I am trying to learn how to work with Google App Engine, I'm looking at their datastore example for querying here I have never done SQL, GQL or the like. So can someone please break down this string and explain what each part is doing?
# GqlQuery…
EasilyBaffled
- 3,822
- 10
- 50
- 87
0
votes
3 answers
Unable to get results when passing a string via parameter substitution in gql query
I am able to properly pass a string variable to the gqlquery through parameter substitution, here's the code i've tried to use;
user_name = self.request.get('username') #retrieved from UI
p = models.UserDetails.all().filter('user_name = ',…
Arun
- 43
- 2
- 10
0
votes
3 answers
GQL Queries - Retrieving specific data from query object
I'm building a database using Google Datastore. Here is my model...
class UserInfo(db.Model):
name = db.StringProperty(required = True)
password = db.StringProperty(required = True)
email = db.StringProperty(required = False)
...and below is my…
Suraj Kapoor
- 1,615
- 4
- 22
- 34
0
votes
1 answer
Query problem in Google app engine
I am very new to sql and more over GQL used in Google app engine. I have managed to push my data to the Google servers but I am not able to figure out a way to query from the entities I've loaded to the datastrore.
Here's the problem, i want to…
Arun
- 43
- 2
- 10
0
votes
1 answer
Using GQL to get all new results since the previous result
I'm pretty useless when it comes to queries, I'm wondering what's the correct structure for this problem.
Clients are sent data including the key of the object, they use the key to tell the server what was the most recent object they downloaded.
I…
monkeymad2
- 153
- 1
- 11
0
votes
2 answers
how to make a key in Datastore based upon more than one property
how to make own unique key based upon more than one peoperties(fields) of a model(Kind) in datastore.
here it is a situation i have 4 fields name,device,id,data. now i want to make a key based upon my 3 fields i.e name,device,id so that whenever…
yasir
- 137
- 2
- 14