Questions tagged [gqlquery]
129 questions
3
votes
1 answer
Number of entities returned from a GQL Query
I'm new to Python and currently working on my first Google App Engine application. In my program I have an 'Inbox' database model which contains string proporties like to_user, from_user, title, content, etc. When a user logs in to my app I want…
user553565
- 77
- 2
3
votes
2 answers
gqlquery for no values in ListProperty
I have this code to find all the nodes where property branches is empty.
nobranches=TreeNode.all()
for tree in nobranches:
if tree.branches==[]:
I wanted to find a better, more efficient way to do this. A meathod where I don't have to…
Venkat S. Rao
- 1,110
- 3
- 13
- 29
3
votes
1 answer
How to construct GQL to not contain a value from a set?
Is it possible to select from a google app engine db where the key of a db.Model object is not in a given list? If so, what would be the syntax?
Ex of a model class:
class Spam(db.Model):
field1 = db.BooleanProperty(default=false)
field2 =…
Cuga
- 17,668
- 31
- 111
- 166
3
votes
1 answer
how to query not null values in google app engine admin console
How to query not null values in google app engine admin console using GQL Syntax?
Consider i am having a table with property FirstName. I need to get the values for which the First Name is not null. How do i do that? whats the query?
Benson michael
- 53
- 1
- 9
3
votes
4 answers
Turning a GqlQuery result set into a python dictionary
Let's say I have a model like this
class Foo(db.Model):
id = db.StringProperty()
bar = db.StringProperty()
baz = db.StringProperty()
And I'm going a GqlQuery like this
foos = db.GqlQuery("SELECT * FROM Foo")
I want to take the results…
Mark Biek
- 146,731
- 54
- 156
- 201
2
votes
2 answers
Google App Engine python, GQL, select only one column from datastore
Im trying to pull only one column from a datastore table
I have a Books model with
id, key, title, author, isbn and price
everything = db.GqlQuery('SELECT * FROM Books') gives me everything, but say i only want the title
books = db.GqlQuery('SELECT…
sidarcy
- 2,958
- 2
- 36
- 37
2
votes
1 answer
Invalid AST Node with GQL query that works in playground
I can get this exact query to execute and return data in the GQL playground.
During debug, I can capture the query string immediately prior to passing it to gql.
I will not be able to share the schema
The query is
query {
vessels{
…
Bruce Bookman
- 134
- 1
- 13
2
votes
1 answer
Google App Engine - Datastore - GQL Query
class ProjectCategory(db.Model):
name = db.StringProperty("Category name", required = True)
def __str__(self):
return str(self.name)
class Project(db.Model):
name = db.StringProperty("Name", required = True)
category =…
Kubas
- 976
- 1
- 15
- 34
2
votes
1 answer
Using List in GQL Filter
How can I make a selection in GQL using a List as filter.
If I have the class
public class Obj{
@Persistent
private Long name;
}
How can I get all Obj's that the name are not in a list?
Victor
- 8,309
- 14
- 80
- 129
2
votes
2 answers
Twitter-ish DB structure in Google App Engine
I'm trying to create a site which is quite similar to Twitter. Users will be able to post messages. And users will be able to 'follow' each other. On the homepage, they see the messages from the users they follow, sorted by time.
How do I go about…
Shrihari
- 105
- 2
- 10
2
votes
1 answer
How to extract data from two GQL classes?
I have the following 2 classes:
class UsersRSS(db.Model):
userId = db.IntegerProperty()
fileHash = db.StringProperty()
added = db.DateTimeProperty(auto_now_add=True)
class Files(db.Model):
fileHash = db.StringProperty()
title =…
LA_
- 19,823
- 58
- 172
- 308
2
votes
1 answer
DeadlineExceededError
When I try to use a query in Google App Engine's datastore like this:
user = User.all().filter('name =',userName).get()
I have this error: DeadlineExceededError.
EDIT:
This is my function:
def feeds(request):
dict = get_user_details()
…
linhtruong
- 49
- 1
- 3
2
votes
1 answer
how to add parameter in gql query
I would like to add parameter in gql query :
onSubmit() {
console.log(this.contact);
let SendEmailQuery = gql`
{
sendemail(contactorFirstname:"",
contactorLastname:"",
contactorEmail:"",
…
Nicolas Maujean
- 23
- 2
- 7
2
votes
2 answers
Datastore: `SELECT * FROM Entity WHERE property IS NULL` returns no result despite entities without property
I am using Google Cloud Datastore and successfully stored entities.
Now I am trying to query them based on the presence of a property.
I use the "Query by GQL" tab in the Datastore UI:…
Steren
- 7,311
- 3
- 31
- 51
2
votes
1 answer
GQL query help - How can I write a query with where clause in GQL ? I am using google appengine datastore
I have three records in a table
example:
*Usernames* *email* *city*
Nick nick@example.com London
Vikky vicky@example.com Paris
Lisa lisa@example.com Sydney
Now I want to…
srivigneshwar
- 23
- 1
- 3