gqlquery for no values in ListProperty

Question

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 retrieve all the TreeNodes. I have tried TreeNode.all().filter(branches=[]) but this gives me a message, "BadValueError('Filtering on lists is not supported'" . How can I do something like TreeNode.gql('WHERE branches=:1', []).fetch(100). I tried this, but I get a "BadValueError: May not use the empty list as a property value; property is []". Is there any other efficient way?

BTW, Here is what TreeNode looks Like

class TreeNode(db.Model): name = db.StringProperty() branches =db.ListProperty(db.Key)

Just guessing, but what about `WHERE branches=None`? – sje397 Oct 13 '10 at 05:16 — sje397, Oct 13 '10 at 05:16
branches is never None if it is empty is is an empty list – Venkat S. Rao Oct 13 '10 at 05:57 — Venkat S. Rao, Oct 13 '10 at 05:57

score 1 · Answer 1 · answered Oct 13 '10 at 08:28

You can't do this with a filter: as Saxon says, there's no index row matching what you want to retrieve, and so no way to retrieve it.

One simple alternative is to store another property that contains the number of elements in the list, and filter on that. aetycoon is a library that contains computed properties that may help with that:

class TreeNode(db.Model):
  name = db.StringProperty()
  branches = db.ListProperty(db.Key)
  branch_count = aetycoon.DerivedProperty(lambda self: len(self.branches))

score 0 · Accepted Answer · answered Oct 13 '10 at 06:29

The documentation on how indexes are stored says:

For multi-valued properties, such as ListProperty and StringListProperty, each value has its own index row, so using multi-valued properties does result in more indexing overhead.

So for each item in your list property, there is a row in the index.

My expectation would be that if there are no items in the list property, then there would be no rows in the index. So it wouldn't be possible to use the index to retrieve entities with an empty list.

One solution would be to add another property (eg hasbranches = db.BooleanProperty()), which you maintain when you add or remove branches. Then you will be able to filter for hasbranches = False.

gqlquery for no values in ListProperty

2 Answers2