本文整理汇总了Python中DB.close方法的典型用法代码示例。如果您正苦于以下问题:Python DB.close方法的具体用法?Python DB.close怎么用?Python DB.close使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB.close方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: make_short_url
# 需要导入模块: import DB [as 别名]
# 或者: from DB import close [as 别名]
def make_short_url(self, url):
key = 'AIzaSyBwCHhPcVAdwZJH-hlTU4WM_sHe8-_SGYU'
if(self.is_safe(key, url) == True):
db = DB()
sql = '''SELECT id, short_url FROM links WHERE long_url=%s'''
query = db.query(sql, (url, ))
link = query.fetchone()
if link is not None:
db.close()
return self.format_result("http://goo.rs/"+link['short_url'], 1, "Links already exists")
else:
sql = '''SELECT MAX(id) as id FROM links'''
query = db.query(sql)
id = query.fetchone()
if id is not None:
short_url = encode_url(id['id'])
else:
short_url = encode_url(1)
sql = '''INSERT INTO links(id, long_url, short_url, clicks , u_id, created) VALUES (NULL, %s, %s, %s ,%s, %s )'''
db.query(sql, (url, short_url, 0, 2, time.strftime('%Y-%m-%d %H:%M:%S') ))
return self.format_result("http://goo.rs/"+short_url, 1, 'Url created')
return self.format_result({}, 0, "This url contains malware and can not be shortened.")
示例2: get_url_stats
# 需要导入模块: import DB [as 别名]
# 或者: from DB import close [as 别名]
def get_url_stats(self, short_url):
db = DB()
parts = short_url.split("/",3)
sql = '''SELECT clicks, short_url FROM links WHERE short_url=%s'''
query = db.query(sql, (parts[3], ))
link = query.fetchone()
if link is not None:
db.close()
return self.format_result(link['clicks'], 1, "Clicks on link "+short_url)
return self.format_result(None, 0, "Error"), 404
示例3: redirect
# 需要导入模块: import DB [as 别名]
# 或者: from DB import close [as 别名]
def redirect(self, url):
db = DB()
sql = '''SELECT id, long_url FROM links WHERE short_url=%s'''
query = db.query(sql, (url,))
link = query.fetchone()
if link is not None :
sql = '''UPDATE links SET clicks=clicks+1 WHERE id=%s'''
db.query(sql, (link['id'], ))
db.close()
key = 'AIzaSyBwCHhPcVAdwZJH-hlTU4WM_sHe8-_SGYU'
if(self.is_safe(key, link['long_url']) == True):
return (link['long_url'])
return False
return False