def updateOne(request): id = request.GET.get('id', None) if request.method == "GET": data = models.Environment.objects.get (id=id).values() return HttpResponse(format(data),content_type="application/json") elif request.method == "POST": name = request.POST.get('name', None) dbHost = request.POST.get('dbHost', None) dbName= request.POST.get('dbName', None) dbUsername= request.POST.get('dbUsername', None) dbPassword= request.POST.get('dbPassword', None) dbProt= request.POST.get('dbProt', None) models.Environment.objects.filter(id=id).update (name=name,dbHost=dbHost,dbName=dbName,dbUsername=dbUsername,dbPassword=dbPassword,dbProt=dbProt) return HttpResponse(format(), content_type="application/json")
def show(request): mobile = request.GET.get ('mobile', None) envName = request.GET.get('envName', None) # todo kyCms 配置改成正确的 with connections[envName].cursor () as cursor: sql = 'SELECT * from gms_users WHERE `mobile` = %s' cursor.execute (sql,[mobile]) data = dictfetchall (cursor) return HttpResponse (format (data), content_type="application/json")
def getOneUserInfoById(request): userId = request.GET.get('userId') userObj = models.AdminUser.objects.filter(id=userId).first() user = {} if userObj: user = { "id": userId, "name": userObj.name, "createTime": userObj.createTime, } return HttpResponse(format(user), content_type="application/json")
def getSqlData(request): postBody = request.body json_result = json.loads(postBody) connName = json_result.get('connName', None) sql = json_result.get('sql', None) envName = json_result.get('envName', None) if request.method == "POST" and connName != None and sql != None and envName != None: with connections[envName + '_' + connName].cursor() as cursor: cursor.execute(sql) data = dictfetchall(cursor) return HttpResponse(format(data), content_type="application/json")
def login(request): if request.method == "POST": from django.contrib.auth.hashers import make_password, check_password postBody = request.body json_result = json.loads(postBody) username = json_result.get('name', None) password = json_result.get('password', None) user = models.AdminUser.objects.filter(name=username).first() if user: # check_password ("原始值","加密值") if check_password(password, user.password): # 登录成功 写session request.session['is_login'] = '******' # 用于判断登录 request.session['username'] = username request.session['user_id'] = user.id adminUser = { "id": user.id, "username": username, } return HttpResponse(format(adminUser), content_type="application/json") return HttpResponse(format([], 10202, "用户名密码错误"), content_type="application/json")
def addOne(request): if request.method == 'POST': name = request.POST.get('name', None) dbHost = request.POST.get('dbHost', None) dbName = request.POST.get('dbName', None) dbUsername = request.POST.get('dbUsername', None) dbPassword = request.POST.get('dbPassword', None) dbProt = request.POST.get('dbProt', None) createTime = datetime.datetime.now() models.Environment.objects.create(name=name, dbHost=dbHost, dbName=dbName, dbUsername=dbUsername, dbPassword=dbPassword, dbProt=dbProt, createTime=createTime) return HttpResponse(format(), content_type="application/json")
def zhuShow(request): phone_number = request.GET.get ('phone_number', None) envName = request.GET.get('envName', None) # todo kyCms 配置改成正确的 with connections[envName + '_' + 'user-account'].cursor () as cursor: # 先通过手机号得到id,拿到id最后一位数字,去具体的表汇总得到具体的信息 idSql = 'select id from user_id_phone_number where phone_number = %s' cursor.execute (idSql,[phone_number]) IdData = dictfetchall (cursor) data = [] if IdData : id = IdData[0]['id'] num = str(id % 10) intID = str(id) sql = 'select * from users'+ num + ' WHERE id ='+ intID cursor.execute(sql) data = dictfetchall(cursor) return HttpResponse (format (data), content_type="application/json")
def saveRechargeByUser(request): if request.method == "GET": return HttpResponse([], content_type="application/json") elif request.method == "POST": postBody = request.body json_result = json.loads(postBody) userNumber = json_result.get('userNumber', None) balance = json_result.get('balance', None) envName = json_result.get('envName', None) # todo kyCms 库名setting with connections[envName + '_' + 'mryxpay'].cursor() as cursor: cursor.execute('SELECT * FROM accounts WHERE user_number = %s', [userNumber]) # data = cursor.fetchone() data = dictfetchall(cursor) if data: # update accounts SET `recharge_balance` = 11 , `balance`=2 where user_number = "blg1" rechargeBalance = data[0].get("recharge_balance") + int( balance) balance = data[0].get("balance") + int(balance) flag = cursor.execute( 'UPDATE `accounts` SET `recharge_balance` = %s ,`balance` = %s ,`updated_at` = %s WHERE user_number = %s', [ rechargeBalance, balance, datetime.datetime.now(), userNumber ]) else: # 默认将余额充值到了recharge_balance flag = cursor.execute( 'INSERT INTO accounts (`user_number`,`balance`,`recharge_balance`,`created_at`,`updated_at`) VALUES (%s,%s,%s,%s,%s)', [ userNumber, balance, balance, datetime.datetime.now(), datetime.datetime.now() ]) return HttpResponse(format(flag), content_type="application/json")
def logout(request): request.session.flush() return HttpResponse(format(1), content_type="application/json")
def getManageSqlByManageDbId(request): with connection.cursor() as cursor: cursor.execute('select * from manageSql where manageDbId = %s', [request.GET.get('manageDbId', None)]) data = dictfetchall(cursor) return HttpResponse(format(data), content_type="application/json")
def index(request): with connection.cursor() as cursor: cursor.execute('select * from manageDb') data = dictfetchall(cursor) return HttpResponse(format(data), content_type="application/json")
def delOne(request): models.Environment.objects.filter(id=request.GET.get('id', None)).delete() return HttpResponse(format(), content_type="application/json")