CODEWITHSUNDEEP
pythongoogle-app-engine
Pete
Pete

Reputation: 11

Google app engine: empty property in datastore

Let say I have a model:

class A(db.Model):
    B = db.StringProperty()
    C = db.StringProperty()

How do I query if I wanted to search all empty property (not None, just empty) in C using python?

Upvotes: 1

Views: 629

Answers (2)

Mattijle
Mattijle

Reputation: 109

From GAE Python documents

It is not possible to perform a query for entities that are missing a given property. One alternative is to create a fixed (modeled) property with a default value of None, then create a filter for entities with None as the property value.

Upvotes: 4

CoreyD
CoreyD

Reputation: 220

Well if you want to return all rows with empty C properties you could do this.

empty = db.GqlQuery('SELECT * FROM A WHERE C = ""')

Upvotes: -2

Related Questions