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()