[google-appengine] Re: Clearing an entire table

2009-03-16 Thread Wooble

Kludgy solution: add a "week" property to your objects, and use an
equality filter on it.

On Mar 16, 6:26 am, "sucram.mar...@gmail.com"
 wrote:
> Hello everyone!
>
> I am looking at designing a feature where I would have a weekly window
> of database entries. This means that I would like to sort the last
> weeks entries in a particular order.
>
> The problem is that I have difficulties to see a solution with app
> engine. Since you can't write a query that sorts on two properties in
> the same query.
>
> The next way I thought to solve this was to clear the database once a
> week. But I have not seen a way to do this, I have only found delete
> entry by entry API:s and that may a bit slow since I have a lot of
> entries.
>
> Ideas ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to 
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---



[google-appengine] Re: Clearing an entire table

2009-03-16 Thread xml2jsonp

But why this GAE limit --> "Since you can't write a query that sorts
on two properties in the same query"
Could I open a "New Issue" ???

On Mar 16, 6:58 pm, Wooble  wrote:
> Kludgy solution: add a "week" property to your objects, and use an
> equality filter on it.
>
> On Mar 16, 6:26 am, "sucram.mar...@gmail.com"
>
>  wrote:
> > Hello everyone!
>
> > I am looking at designing a feature where I would have a weekly window
> > of database entries. This means that I would like to sort the last
> > weeks entries in a particular order.
>
> > The problem is that I have difficulties to see a solution with app
> > engine. Since you can't write a query that sorts on two properties in
> > the same query.
>
> > The next way I thought to solve this was to clear the database once a
> > week. But I have not seen a way to do this, I have only found delete
> > entry by entry API:s and that may a bit slow since I have a lot of
> > entries.
>
> > Ideas ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to 
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---