django 访问数据库返回 JSON数据格式

最新推荐文章于 2023-07-27 14:10:47 发布

weixin_33856370

最新推荐文章于 2023-07-27 14:10:47 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： python 数据库 json

原文链接：https://my.oschina.net/zhiyonghe/blog/920475

本文介绍了一个使用Python和Django框架实现的数据库查询功能，通过连接Oracle数据库获取特定时间段内的数据库使用情况，并返回JSON格式的数据供前端展示。

2019独角兽企业重金招聘Python工程师标准>>>

from django.shortcuts import render

# Create your views here.

from django.shortcuts import render
from django.http import HttpResponse
from django.contrib.auth.decorators import login_required
from django.shortcuts import render_to_response

# Create your views here.
import cx_Oracle as oracle
import json
def search_db(sqlcmd):
conn = oracle.connect('test/test@test:1526/orcl')
cur = conn.cursor()
cur.execute(sqlcmd)
result = cur.fetchall()
# print ("Exec sql:%s"%(sqlcmd))
conn.close()
return result
def cont_json_format(dbname, USED_SIZE, FREE_SIZE,SM_SIZE,OTIME):
json_str = {"code":200, "message": "OK", "descriptions": {"DB_NAME":dbname, "USED_SIZE": USED_SIZE, "FREE_SIZE": FREE_SIZE, "SM_SIZE":SM_SIZE, "OTIME":OTIME}}
return json.dumps(json_str)

def cont(request,dbname):
starttime = request.GET['starttime']
endtime = request.GET['endtime']
sql='''select *
from ORADB_SIZE t
where
t.DB_NAME = '%s' and
t.OTIME > to_date('%s','YYYY/MM/DD') and
t.OTIME < to_date('%s','YYYY/MM/DD')''' % (dbname, starttime, endtime)
result = search_db(sql)
USED_SIZE = [round(e[1],2) for e in result]
FREE_SIZE = [round(e[2],2) for e in result]
SM_SIZE = [round(e[3],2) for e in result]
OTIME = [e[4].strftime('%Y-%m-%d') for e in result]
json_data = cont_json_format(dbname, USED_SIZE, FREE_SIZE, SM_SIZE, OTIME)
return HttpResponse(json_data)

def echarts_cont(request):
return render_to_response("content.html")

转载于:https://my.oschina.net/zhiyonghe/blog/920475