def get_recent_urls(n, db):
sql = "select * from urls order by created desc limit %s" % n
result = storage.query_db(sql, [], db=db)
return result
def get_top_urls(n, db):
sql = "select * from urls order by hits desc limit %s" % n
result = storage.query_db(sql, [], db=db)
return result
def get_url(alias, db):
sql = "select url from urls where alias = ?"
result = storage.query_db(sql, [alias], one=True, db=db)
if not result:
raise storage.NotFound()
return result['url']
def record_hit(alias, db):
sql = "update urls set hits = hits + 1 where alias = ?"
storage.query_db(sql, [alias], db=db)
db.commit()
def insert_url(url, alias, db):
sql = "insert into urls(alias, url, created, hits) "\
"values(?, ?, ?, 0)"
created = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S.000")
storage.query_db(sql, [alias, url, created], db=db)
db.commit()
