def lookup_redirect(url):
"""Looks up a redirect. If there is not redirect for the given URL,
the return value is `None`.
"""
row = db.execute(redirects.select(
redirects.c.original == _strip_url(url)
)).fetchone()
if row:
return make_external_url(row.new)
def get_redirect_map():
"""Return a dict of all redirects."""
return dict((row.original, make_external_url(row.new)) for row in
db.execute(redirects.select()))