Django实现数据库自动化监控

views.py

import json

from django.forms import models
from django.shortcuts import render
import psutil
import pymysql
from django.shortcuts import render, redirect

# Create your views here.
def index(request):
conn = pymysql.connect(host=ip, user=user, passwd=passwd, port=port db="database", charset='utf8', cursorclass=pymysql.cursors.DictCursor)
with conn.cursor() as cursor:
cursor.execute("SELECT * FROM mysql_db.jiankong_db")
list_data = cursor.fetchall()
str(list_data)
print(list_data)
print(type(list_data))
cursor.execute("select * from mysql_db.jiankong_processlist")
proce_list = cursor.fetchall()
print(proce_list)
return render(request, 'jiank/shouye.html', {'list_data': list_data, 'proce_list':proce_list})
 

index.html

<!D