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")
