Display GAE list by most recent entry

Question

n00b problem- I am trying to have a list show the most recent entry first. This works without the reverse(), but retrieves nothing with it in. I have heard I should try and use order_by(), but I can't seem to get that to work either. Thanks for the help!

class MainHandler(webapp.RequestHandler):

def get(self):

    que = db.Query(models.URL)
    url_list = que.fetch(limit=100)
    new_list = url_list.reverse()

    path = self.request.path        
    if doRender(self,path):
        return
    doRender(self,'base/index.html', { 'new_list' : new_list })

Answer 1

reverse() modifies the list in place. It doesn't return the sorted list, so just do:

url_list.reverse()
path = self.request.path        
if doRender(self,path):
    return
doRender(self,'base/index.html', { 'new_list' : url_list })

Answer 2

In django, you use order_by(), but for GAE it is order().

So the answer was not in using reverse but:

class MainHandler(webapp.RequestHandler):

def get(self):

    que = db.Query(models.URL).order('-created')
    url_list = que.fetch(limit=100)

    path = self.request.path        
    if doRender(self,path):
        return
    doRender(self,'base/index.html', { 'url_list' : url_list })

Answer 3

Keys aren't automatically in incrementing order; if you want to sort by the date an entity was added, you need to add a DateTimeProperty with auto_now_add set to True, and sort on that.