def save(user_id):
id = RequestUtil.get_parameter(request, 'id', None)
title = RequestUtil.get_parameter(request, 'title', None)
completed = RequestUtil.get_parameter(request, 'completed', None)
if completed == 'true':
completed = True
else:
completed = False
if id:
todo = Todo.query.filter_by(id=id).first()
else:
todo = Todo(user_id=user_id,
add_time=DateUtil.now_datetime()) # new todo
if todo and todo.user_id == user_id:
# update it.
if title:
todo.title = title
if completed is not None:
todo.completed = completed
# print todo.dict()
todo.save()
return ResponseUtil.standard_response(1, todo.dict())
else:
return ResponseUtil.standard_response(0, 'save error.')
def github_authorized(oauth_token):
if oauth_token is None:
flash("Authorization failed.")
return redirect(url_for('index'))
session['oauth_token'] = oauth_token
me = github.get('user')
user_id = me['login']
# is user exist
user = User.query.get(user_id)
if user is None:
# not exist, add
user = User(id=user_id)
# update github user information
user.last_login = DateUtil.now_datetime()
user.name = me.get('name', user_id)
user.location = me.get('location', '')
user.avatar = me.get('avatar_url', '')
user.save()
RequestUtil.login_user(user.dict())
return redirect(url_for('index'))
def loginApi(username, password):
user = User.query.filter_by(username=username).first()
if not user or not user.verify_password(password):
return ResponseUtil.standard_response(0, '用户名不存在或密码错误')
user.last_login = DateUtil.now_datetime()
user.save()
RequestUtil.login_user(user.dict())
return ResponseUtil.standard_response(1, user.dict())
def add_redis(host, port, psw, email):
'''
info: 添加一个redis信息到数据库
'''
add_time = DateUtil.now_datetime()
md5 = StringUtil.md5(host + str(port))
r = get_redis(md5)
if r:
#存在，update
sql = "update redis_info set redis_host = ?, redis_port = ?, redis_pass = ?, email = ?, add_time = ? where md5 = ?"
params = (host, port, psw, email, add_time, md5)
return SqliteHandler().exec_update(sql, params)
else:
sql = "insert into redis_info (redis_host, redis_port, redis_pass, email, add_time, md5) values (?, ?, ?, ?, ?, ?)"
params = (host, port, psw, email, add_time, md5)
return SqliteHandler().exec_insert(sql, params)
def add_redis(host, port, psw, email):
'''
info: 添加一个redis信息到数据库
'''
add_time = DateUtil.now_datetime()
md5 = StringUtil.md5(host + str(port))
r = get_redis(md5)
if r:
#存在，update
sql = "update redis_info set redis_host = ?, redis_port = ?, redis_pass = ?, email = ?, add_time = ? where md5 = ?"
params = (host, port, psw, email, add_time, md5)
return SqliteHandler().exec_update(sql, params)
else:
sql = "insert into redis_info (redis_host, redis_port, redis_pass, email, add_time, md5) values (?, ?, ?, ?, ?, ?)"
params = (host, port, psw, email, add_time, md5)
return SqliteHandler().exec_insert(sql, params)
def authorized(oauth_token):
next_url = request.args.get('next') or url_for('index')
if oauth_token is None:
flash("Authorization failed.")
return redirect(next_url)
session['oauth_token'] = oauth_token
me = github.get('user')
user_id = me['login']
user = User.query.filter_by(id=user_id).first()
if user is None:
user = User(id=user_id, uid=user_id, name=me['name'], source='github')
user.last_login = DateUtil.now_datetime()
user.save()
RequestUtil.login(session, user_id)
return redirect(next_url)
def log_invalid(request, ext_text):
log = '%s - - [%s] %s %s %s' % (request.remote_addr, DateUtil.now_datetime(), request.method, request.path, ext_text)
append_log('record_invaild_log.log', log)
def log_invalid(request, ext_text):
log = '%s - - [%s] %s %s %s' % (request.remote_addr,
DateUtil.now_datetime(), request.method,
request.path, ext_text)
append_log('record_invaild_log.log', log)
