def update(): if not session: return redirect('/') if request.method=="POST": user_dict={k:v[0] for k,v in dict(request.form).items()} print user_dict if user_dict.has_key('oldpasswd'): username=session['username'] data1={} data1['username']=username field=['id','username','name','password','phone','email','role','status'] result=utils.get_one(table,field,data1) if user_dict['oldpasswd']==result['msg']['password']: info={} field=['id','password'] info['id']=result['msg']['id'] info['password']=user_dict['newpasswd'] util.WriteLog("update_psswd","/tmp/info.log").info("update_passwd:%s"%session['username']) data=utils.update(table,field,info) return json.dumps(data) else: result={'code':1,'msg':'oldpasswd is error'} util.WriteLog('update_passwd','/tmp/error.log').error("update_password:%s"%session['username']) return json.dumps(result) else: field=[] util.WriteLog("update","/tmp/info.log").info("update:%s"%session['username']) data=utils.update(table,field,user_dict) return json.dumps(data)
def login(): if request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} print "login-data" print data util.WriteLog('[用户开始登录echo post-data]').info(data) result = getone('user', field, data) util.WriteLog('[用户登录echo result]').info(result) print result if result['code'] == 0: if result['msg']['password'] == data['password']: session['username'] = data['username'] session['role'] = result['msg']['role'] session['id'] = result['msg']['id'] print session if session['role'] == 0: return redirect('/userlist/') else: return redirect('/') else: result['errmsg'] = "user is exist, password is wrong" else: result['errmsg'] = "user is not exist" return render_template("login.html", result=result) return render_template("login.html")
def select(table,data): sql='select %s from %s'%(data,table) try: cur.execute(sql) result=cur.fetchall() util.WriteLog("sql","/tmp/info.log").info("select:%s"%sql) except: util.WriteLog('db',"/tmp/info.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def insert(table,field,data): sql="insert into %s (%s) values(%s)"%(table,','.join(field),','.join(['"%s"'% data[x] for x in field])) try: res=cur.execute(sql) util.WriteLog("sql","/tmp/info.log").info("insert:%s"%sql) result ={'code':0,'msg':'insert ok'} except: result={'code':1,'msg':'insert fail'} util.WriteLog("db","/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def update(table,field,data): conditions=['%s="%s"'%(k,data[k])for k in data] sql="update %s set %s where id=%s"%(table,','.join(conditions),data['id']) try: util.WriteLog("sql","/tmp/info.log").info("update:%s"%sql) cur.execute(sql) result={'code':0,'msg':'ok'} except: result={'code':1,'msg':'update fail'} util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def delete(table,uid): sql="delete from %s where id =%s"%(table,uid) print sql try: util.WriteLog("sql","/tmp/info.log").info("delete:%s"%sql) cur.execute(sql) result ={'code':0,'msg':'ok'} except: result={'code':1,'msg':'delete fail'} util.WriteLog("db","/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def addserver(): if request.method == "POST": data = { k:v[0] for k,v in dict(request.form).items()} print "模态窗添加server的信息" print data util.WriteLog('[模态窗添加server信息]').info(data) field = ['name','ip','idc_id','cabinet','os','core_num','mem','disk'] result = insert('server',field,data) print "添加server写完数据库返回的的用户信息" print result util.WriteLog('[管理员添加server完成返回]').info(result) return json.dumps(result)
def reg(): if request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} print "模态窗添加用户的用户信息" print data util.WriteLog('[模态窗添加用户的用户信息]').info(data) field = ['username', 'password', 'email', 'phone', 'role'] result = insert('user', field, data) print "添加用户写完数据库返回的的用户信息" print result util.WriteLog('[管理员添加用户完成返回]').info(result) return json.dumps(result)
def list(table,field): sql="select * from %s"%table try: cur.execute(sql) res=cur.fetchall() util.WriteLog("sql","/tmp/info.log").info("getlist:%s"%sql) user=[{k:row[i] for i,k in enumerate(field)}for row in res] result={'code':0,'msg':user} except: result={'code':1,'msg':'data is null'} util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def reg(): if request.method=='POST': user_dict={k:v[0] for k,v in dict(request.form).items()} field=['username','name','password','phone','email','role','status'] res=utils.get_one(table,field,user_dict) if res['code']==0: result=utils.insert(table,field,user_dict) util.WriteLog("register","/tmp/info.log").info("register:%s"%user_dict["username"]) return json.dumps(result) else: result={'code':1,'msg':'register username is already exists'} util.WriteLog("register","/tmp/error.log").info("register:%s"%result['msg']) return json.dumps(result) return render_template('reg.html')
def delete(table,uid): sql = "delete from %s where id = %s" % (table,uid) print "删除用户sql" print sql res = cur.execute(sql) if res: result = {'code':0,'msg':'delete ok'} util.WriteLog('[删除用户]').info('成功成功成功') else: util.WriteLog('[删除用户]').info('失败失败失败') result = {'code':1,'msg':'delete false'} print "util_delete_result" print result['msg'] return result
def add(): if not session: return redirect("/") if request.method=="POST": user_dict={k:v[0] for k,v in dict(request.form).items()} field=['username','name','password','phone','email','role','status'] result=utils.insert(table,field,user_dict) if result['code']==0: util.WriteLog("insert","/tmp/info.log").info("inster:%s"%session['username']) data=result return json.dumps(data) else: util.WriteLog("insert_error","/tmp/error.log").info("inster_error:%s"%session['username']) data={'code':1,'msg':'insert is error'} return json.dumps(data)
def get_one(table,field,data): if data.has_key("username"): sql='select * from %s where username="******"'%(table,data['username']) else: sql='select * from %s where id="%s"'%(table,data['id']) try: cur.execute(sql) res=cur.fetchone() util.WriteLog("sql","/tmp/info.log").info("getone:%s"%sql) user={k:res[i] for i,k in enumerate(field)} result={'code':0,'msg':user} except: result={'code':1,'msg':'data is null'} util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc())) return result
def server(): if not session: return redirect('/') util.WriteLog("server").info("server:%s" % session['username']) data = utils.list(server_table, server_field) result = data['msg'] return render_template("server.html", res=session, result=result)
def upinfos(): if not session: return redirect("/login") if request.method == 'POST': data = {k: v[0] for k, v in dict(request.form).iteritems()} print "upinfo-post-data" print data if data.has_key('newpasswd'): data = {'id': data['id'], 'password': data['newpasswd']} print data result = update('user', field, data) util.WriteLog('[自己修改密码完成返回]').info(result) return json.dumps(result) result = update('user', field, data) util.WriteLog('[自己更新个人资料完成返回]').info(result) return json.dumps(result)
def modity(): if not session: return redirect("/login") if request.method == 'POST': data = dict(request.form) print "data11111" print data data = {k: v[0] for k, v in data.items()} print "data2222" print data result = update('user', field, data) if result['code'] == 0: util.WriteLog('[管理员更新用户资料]').info(result) return redirect("/userlist/") else: return render_template('update.html', result=result) else: uid = request.args.get('id', '') data = {'id': uid} print "-----------------------管理员更新,get请求过来的form值" print data result = getone('user', field, data) print "-----------------------管理员更新完result" print result return render_template('update.html', result=result['msg'])
def delete(table, uid): sql = "delete from %s where id =%s" % (table, uid) print sql util.WriteLog("sql").info("delete:%s" % sql) cur.execute(sql) result = {'code': 0, 'msg': 'ok'} return result
def admlist(): sql_list = "select * from user;" cur.execute(sql_list) list = cur.fetchall() user_list = [dict((k, v[i]) for i, k in enumerate(field)) for v in list] util.WriteLog('sql').info('SELECT : %s' % sql_list) return user_list
def idc(): if not session: return redirect("/") util.WriteLog("idc", "/tmp/info.log").info("idc:%s" % session['username']) data = utils.list(idc_table, idc_field) result = data['msg'] return render_template("idc.html", res=session, result=result)
def delete(): if not session: return redirect('/') uid=request.args.get('id') util.WriteLog("delete","/tmp/info.log").info("delete:%s"%session['username']) data=utils.delete(table,uid) return json.dumps(data)
def userlist(): if not session: return redirect('/') util.WriteLog("list","/tmp/info.log").info("list:%s"%session['username']) result=utils.list(table,field) if result['code']==0: return render_template('userlist.html',res=session,result=result['msg'])
def server_delete(): if not session: return redirect('/') uid = request.args.get('id') util.WriteLog("server_delete").info("server_delete:%s" % session['username']) data = utils.delete(server_table, uid) return json.dumps(data)
def idc_update(): if not session: return redirect('/') if request.method == 'POST': user_dict = {k: v[0] for k, v in dict(request.form).items()} util.WriteLog("idc_update").info("idc_update:%s" % session['username']) data = utils.update(idc_table, idc_field, user_dict) return json.dumps(data)
def user(): if not session: return redirect("/") username=session['username'] user_dict={'username':username} util.WriteLog("getone","/tmp/info.log").info('get_one:%s'%session['username']) result=utils.get_one(table,field,user_dict) return render_template('list.html',res=session,result=result['msg'])
def cabinet(): if not session: return redirect('/') util.WriteLog("cabinet").info("cabinet:%s" % session['username']) data = utils.list(cab_table, cab_field) print data result = data['msg'] return render_template("cabinet.html", res=session, result=result)
def update(table, filed, data): conditions = ['%s="%s"' % (k, data[k]) for k in data] sql = "update %s set %s where id=%s" % (table, ','.join(conditions), data['id']) util.WriteLog("sql").info("update:%s" % sql) cur.execute(sql) result = {'code': 0, 'msg': 'ok'} return result
def getone(name): sql = "select * from user where username = '******';" % name cur.execute(sql) list = cur.fetchone() col_list = ['id', 'username', 'password', 'role', 'email', 'phone'] user_list = dict((k, list[i]) for i, k in enumerate(col_list)) util.WriteLog('getone').info('getoneinfo : %s' % user_list) return user_list
def cabinet_update(): if not session: return redirect('/') if request.method == 'POST': user_dict = {k: v[0] for k, v in dict(request.form).items()} util.WriteLog("cabinet_update", "/tmp/info.log").info( "cabinet_update:%s" % session['username']) data = utils.update(cab_table, cab_field, user_dict) return json.dumps(data)
def insert(table, field, data): sql = "insert into %s (%s) values (%s)" % ( table, ','.join(field), ','.join(['"%s"' % data[x] for x in field])) util.WriteLog("sql").info("insert:%s" % sql) res = cur.execute(sql) if res: result = {'code': 0, 'msg': 'insert ok'} else: result = {'code': 1, 'msg': 'insert fail'} return result
def login(): if request.method=='POST': user_dict={k:v[0] for k,v in dict(request.form).items()} user=utils.get_one(table,field,user_dict) if user['code']==0 and user_dict['password']==user['msg']['password']: if user['msg']['status']==0: session['username']=user_dict['username'] session['role']=user['msg']['role'] util.WriteLog("login","/tmp/info.log").info('login:%s'%session['username']) return json.dumps(user) else: data={'code':1,'msg':'username is locking'} util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg']) return json.dump(data) else: data={'code':1,'msg':'username or password is error'} util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg']) return json.dumps(data) return render_template("login.html")