def index_origin(): db = init_db() cursor = db.cursor() cursor.execute('''select * from feedback order by id DESC''') ret = cursor.fetchall() ret_list = [] for _ in ret: try: ret_list.append([ _[1].decode('utf-8'), _[2].decode('utf-8', ''), _[3].decode('utf-8', '') ]) except Exception as e: print str(e) import traceback, sys traceback.print_exc(file=sys.stdout) #ret_list = [ ['error', 'error', 'error'] ] #try: # ret_list = [ [ _[1].encode('utf-8', '') , _[2].encode('utf-8', ''), _[3].encode('utf-8', '') ] for _ in ret ] #except Exception as e: # print str(e) # import traceback, sys # traceback.print_exc(file=sys.stdout) # ret_list = [ ['error', 'error', 'error'] ] return render_template('index.html', comments=ret_list)
def index(): db = init_db() cursor = db.cursor() cursor.execute('''select * from feedback''') ret = cursor.fetchall() try:ret_list = [ [ _[1] , _[2], _[3] ] for _ in ret ] except:ret_list = [ ['error', 'error', 'error'] ] return render_template('index.html', comments = ret_list)
def _dianzan(): if request.method != 'POST': return 'methods not allowed!' try: qq = request.form.get('qq', '') pwd = request.form.get('pwd', '') cnt = request.form.get('cnt', '1') feq = request.form.get('feq', '10') # 点赞次数 inc = request.form.get('inc', '10') frr = request.form.get('frr', '') pos = request.form.get('pos', '') neg = request.form.get('neg', '') try:D = dianzan.Dianzan(qq = qq, pwd = pwd, cnt = int(cnt), feq = int(feq), inc = int(inc)) except Exception as e: print e; traceback.print_exc(file = sys.stdout) ret = D.dianzan(cnt = int(cnt)) try: feq = int(feq) inc = int(inc) if (feq * inc - inc) > 0: db = init_db() add_task(db, uid = D.qq, url = D.url, ttl = feq * inc - inc, inc = inc, pos = pos, neg = neg) except Exception as e: logging.error('/dianzan:' + str(e)) traceback.print_exc(file=sys.stdout) if str(frr) == "on": try:ret = D.get_friend() except:ret={} if len(ret) == 0: return ''' <html> <body> </p>妈蛋, 好像获取好友列表失败了,<a href="/">再试一次</a>吧</p> </body> </html> ''' return render_template('select_friend.html', frr = ret) except Exception as e: #logging.error(str(e)) print str(e) traceback.print_exc(file=sys.stdout) ret = "<p>%s</p>"%("用户名,密码或者验证码错误!请再试一次") ret += '<script> console.log("%s") </script>' % str(e) return ret
def comment(): db = init_db() cursor = db.cursor() cursor.execute('''select * from feedback order by id DESC''') ret = cursor.fetchall() ret_list = [] for _ in ret: try: ret_list.append([ _[1].decode('utf-8'), _[2].decode('utf-8', ''), _[3].decode('utf-8', '') ]) except Exception as e: print str(e) import traceback, sys traceback.print_exc(file=sys.stdout) #ret_list = [ ['error', 'error', 'error'] ] return render_template('feedback.html', comments = ret_list)
def feedback(): db = init_db() nickname = request.form.get('nickname', '这个人很懒什么都没留下') contact = request.form.get('contact', '这个人很懒什么都没留下') comment = request.form.get('comment', '妈蛋, 这个人什么都没写') import MySQLdb nickname = MySQLdb.escape_string(nickname) contact = MySQLdb.escape_string(contact) comment = MySQLdb.escape_string(comment) sql = r''' insert feedback (nickname, contact, comment) values ("%s", "%s", "%s"); ''' % (nickname, contact, comment) cursor = db.cursor() cursor.execute(sql) db.commit() db.close() return r'''
def feedback(): db = init_db() nickname = request.form.get('nickname', '这个人很懒什么都没留下').strip() # T_T 这样不管用,,当为空时得到的就是空字符串,,,我这个傻逼 contact = request.form.get('contact', '这个人很懒什么都没留下').strip() comment = request.form.get('comment', '妈蛋, 这个人什么都没写').strip() if not nickname: nickname = '这个人很懒什么都没留下' if not contact: contact = '这个人很懒什么都没留下' if not comment: comment = '妈蛋,这个人太懒了吧! 什么都没写...' import MySQLdb nickname = MySQLdb.escape_string(nickname) contact = MySQLdb.escape_string(contact) comment = MySQLdb.escape_string(comment) sql = r''' insert feedback (nickname, contact, comment) values ("%s", "%s", "%s"); ''' % (nickname, contact, comment) cursor = db.cursor() cursor.execute(sql) db.commit() db.close() return r'''
) app.config.from_object('application.config') import urllib @app.template_filter('urlquote') def urlquote(uri): return urllib.quote(uri) app.jinja_env.globals['urlquote'] = urlquote @app.before_request def before_request(): pass from application.apps.db_methods import init_db db = init_db() @app.teardown_request def teardown_request(exception): try:db.close() except:pass # views from application.views import index # control from application.control import qq from application.control import user from application.control import kvdbmanage # apps from application.apps import proxy
def _test_db(self): db = init_db() add_task(db, uid = 'ts', url = 'ts')
def _dianzan(): try: qq = request.form.get('qq', '') pwd = request.form.get('pwd', '') cnt = request.form.get('cnt', '1') feq = request.form.get('feq', '10') # 点赞次数 inc = request.form.get('inc', '10') frr = request.form.get('frr', '') pos = request.form.get('pos', '') neg = request.form.get('neg', '') remember = request.form.get('remember', '') _url = None data = {} data['remember'] = remember if remember == "on" and session.get('qq') == qq: with kvdbwrap.KVDB() as kv: try: ret = kv.get('qq#%s' % qq) data = json.loads(ret) except Exception as e: print str(e) import sys, traceback traceback.print_exc(file=sys.stdout) data['remember'] = 'on' else: if 'qq' in session: session.pop('qq', None) data.update({ 'qq': qq, 'pwd': pwd, 'cnt': cnt, 'feq': feq, 'inc': inc, 'frr': frr, 'pos': pos, 'neg': neg }) try: D = dianzan.Dianzan(**data) #D = dianzan.Dianzan( # qq = qq, # pwd = pwd, # cnt = int(cnt), # feq = int(feq), # inc = int(inc), # pos = pos, # neg = neg, # url = _url # ) except Exception as e: print e traceback.print_exc(file = sys.stdout) ret = D.dianzan(cnt = int(cnt)) try: feq = int(feq) inc = int(inc) if (feq * inc - inc) > 0: db = init_db() add_task(db, uid = D.qq, url = D.url, ttl = feq * inc - inc, inc = inc, pos = pos, neg = neg) except Exception as e: logging.error('/dianzan:' + str(e)) traceback.print_exc(file=sys.stdout) if str(frr) == "on": try:ret = D.get_friend() except:ret={} if len(ret) == 0: return ''' <html> <body> </p>妈蛋, 好像获取好友列表失败了,<a href="/">再试一次</a>吧</p> </body> </html> ''' return render_template('select_friend.html', frr = ret) except Exception as e: #logging.error(str(e)) print str(e) import traceback, sys traceback.print_exc(file=sys.stdout) ret = "<p>%s</p>"%("用户名,密码或者验证码错误!请再试一次") ret += '<script> console.log("%s") </script>' % str(e) return ret