I have a table in UserAdminPage
where tags are listed by alpha order (code below).
I want to add a link that will change the order to by date. I know I will change the query.order(owner_tag")
to query.order("-date")
but do I need to create a new handler?
I don't understand what the link should be where the question marks are.
Thanks
class UserAdminPage(webapp.RequestHandler):
def get(self):
...
#-----------tags table-----------------#
query = Owner.all()
query.filter("owner =", user)
query.order("owner_tag")
w = query.fetch(500)
user_tag_list = []
for item in w:
user_tag_list.append(item.owner_tag)
unique_tags = sorted(f1.f2(user_tag_list))
#-----------holding table start--------#
self.response.out.write("""
<table border="0" cellpadding="0" cellspacing="20" >
<tr>
<td>""")
#-----------tags table start--------#
self.response.out开发者_如何学运维.write("""<table border="1">
<tr>
<th colspan="3">tags<br />
#the link that will sort by most recent:
#<a href="?????">order tags by most recent</a></th>
</tr>
""")
for tag in unique_tags:
self.response.out.write("""
<tr>
<td><a href="/tag?tag=%s">%s</a></td>
</tr>
""" %
(tag, tag)
)
self.response.out.write("""</table>""")
#holding table first column end
self.response.out.write("""</td>""")
#holding table second column start
self.response.out.write("""<td style="vertical-align:top">""")
UPDATED CODE AS PER KEVIN P'S ANSWER:
class UserAdminPage(webapp.RequestHandler):
def get(self):
order_by = self.request.get("order")
...
#-----------tags table-----------------#
query = Owner.all()
query.filter("owner =", user)
if not order_by:
query.order("owner_tag")
elif order_by == "date":
query.order("-date")
w = query.fetch(500)
user_tag_list = []
for item in w:
user_tag_list.append(item.owner_tag)
unique_tags = f1.f2(user_tag_list)
#-----------holding table start--------#
self.response.out.write("""
<table border="0" cellpadding="0" cellspacing="20" >
<tr>
<td>""")
#-----------tags table start--------#
# I put the link here but when I click on it, no table is drawn
# because the `for` block below draws the tag table
# so I don't understand how I can draw the table with `order=date`
self.response.out.write("""<table border="1">
<tr>
<th colspan="3">tags<br />
<a href="/tag?order=date"><span id=small>most recent</span></a></th>
</tr>
""")
for tag in unique_tags:
self.response.out.write("""
<tr>
<td><a href="/tag?tag=%s">%s</a></td>
</tr>
""" %
(tag, tag)
)
self.response.out.write("""</table>""")
...
There are a number of ways to optimize your approach to this, but to answer your specific question - rather than duplicate your handler you could add a GET parameter to the link and then check for that while constructing your query:
class UserAdminPage(webapp.RequestHandler):
def get(self):
order_by = self.request.get('order')
query = Owner.all()
query.filter("owner =", user)
if not order_by:
query.order("owner_tag")
elif order_by == 'date':
query.order("-date")
...
<a href="your_page_url?order=date">order tags by most recent</a>
精彩评论