DM8+Django+Python 搭建网站示例

最新推荐文章于 2024-08-30 22:50:30 发布

zhuhong78

最新推荐文章于 2024-08-30 22:50:30 发布

阅读量1.5k

点赞数 1

分类专栏： DM8 文章标签： python django

本文链接：https://blog.csdn.net/zhuhong78/article/details/122824651

版权

DM8 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本文档详细介绍了如何在Django3.1.7环境中配置DM8数据库，包括驱动安装、数据库连接、模型创建、视图和URL配置。此外，还展示了如何使用Python读取文本文件并往DM8数据库中插入数据，最后通过运行Django服务器访问展示系统信息的网页。

摘要由CSDN通过智能技术生成

一.准备工作

1.安装好DM8数据库

过程略

2.下载DM8相关驱动包

下载地址：产品下载 | 达梦数据库

3.安装Django3.1.7版本

过程略

4.python环境：版本3.7.9

过程略

二.驱动安装

解压Python-20211220.zip

1.安装dmPython驱动

cd dmPython

python3 setup.py install

2.安装django驱动

cd django317/django_dmPython

python3 setup.py install

3.检查安装情况

[root@localhost django_dmPython]# python3
Python 3.7.9 (default, Mar 2 2021, 02:43:11)
[GCC 7.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import re
>>> import django
>>> import dmPython
>>> import django_dmPython
>>>

三.Django配置

1.创建项目

django-admin startproject dmtest

2.创建应用

python3 manage.py startapp syscheck

3.修改settings.py文件

vim dmtest/settings.py

访问主机部分：

ALLOWED_HOSTS = ['*']

应用安装部分：

INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'syscheck',
]

数据库连接部分：

DATABASES = {
'default': {
'ENGINE': 'django_dmPython',
'NAME': 'dmsystest',
'USER': 'dmsystest',
'PASSWORD': 'dameng123',
'HOST': '192.168.163.137',
'PORT': '5237',
'OPTINOS': {'local_code': 1, 'connection_timeout': 5},
}
}
语言显示部分：
LANGUAGE_CODE = 'zh-Hans'

4.创建数据库对应关系

vim syscheck/models.py

from django.db import models

class info1(models.Model):
ip_addr = models.CharField(max_length=50, null=True)
sys_name = models.CharField(max_length=50, null=True)
sys_version = models.CharField(max_length=50, null=True)
cpu_type = models.CharField(max_length=50, null=True)
cpu_cores = models.CharField(max_length=50, null=True)
cpu_sockets = models.CharField(max_length=50, null=True)
net_info1 = models.CharField(max_length=50, null=True)
net_info2 = models.CharField(max_length=50, null=True)
# Create your models here.

5.修改views.py文件，显示html模板

vim syscheck/views.py

from django.shortcuts import render

from syscheck.models import info1

import datetime

# Create your views here.

def localinfo(request):
time1=datetime.datetime.now()
infos=info1.objects.all()
return render(request,"test1.html",locals())

6.创建html模板

mkdir syscheck/templates

vim syscheck/templates/test1.html

{% load static %}
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Upload Successfully</title>
</head>
<body style="background-image: url({% static '2.jpg' %});background-size:100% 133.5%;" >
系统信息
服务器时间：{{ time1 }}
 
{% for i in infos %}
{{i.ip_addr}}
系统名称: {{i.sys_name}}
系统版本: {{i.sys_version}}
 
 
{% endfor %}
</body>
</html>

7.修改urls文件

vim dmtest/urls.py

from django.contrib import admin
from django.urls import path
from syscheck import views

urlpatterns = [
path('admin/', admin.site.urls),
path('sysinfo/',views.localinfo),
]

8.添加静态图片背景

mkdir static

拷贝2.jpg文件至static目录下

修改settings.py文件

STATIC_URL = '/static/'
STATICFILES_DIRS = [
os.path.join(BASE_DIR, "static"),
]

9.同步数据

python3 manage.py makemigrations
python3 manage.py migrate

四.使用python处理文本文件，往DM8数据库插入数据

文本如图：

python程序：

import re
import dmPython

#定义空列表
list_local_sysinfo=[]

#读取文件，将每行的值存入列表
with open(r'/opt/web/produce/python/system_check_.tmp', 'r', encoding='UTF-8') as f:
for line in f:
m=re.search('：.*\n|:.*\n',line)
#print(m)
if (m != None):
(m1,m2) = re.search('：.*\n|:.*\n',line).span()
m3=line[m1+1:m2-1]
#print(m3)
list_local_sysinfo.append(m3)
#print(list_local_sysinfo)

#从列表中给变量赋值，方便知道往数据库里存入的数据是什么
sys_name = list_local_sysinfo[0]
sys_version = list_local_sysinfo[1]
net_exter = list_local_sysinfo[2]
net_inter = list_local_sysinfo[3]
cpu_type = list_local_sysinfo[4]
cpu_cores = list_local_sysinfo[5]
cpu_frequency = list_local_sysinfo[6]
cpu_threads_percore = list_local_sysinfo[7]
cpu_cores_persocket = list_local_sysinfo[8]
cpu_sockets = list_local_sysinfo[9]
memory = list_local_sysinfo[10]
sys_disk = list_local_sysinfo[11]
nums_lun = list_local_sysinfo[12]
java_version = list_local_sysinfo[13]

'''
print(
sys_name,'\n',sys_version,'\n',net_exter ,'\n',net_inter ,'\n',cpu_type ,'\n',cpu_cores ,'\n',cpu_frequency ,'\n',
cpu_threads_percore ,'\n',cpu_cores_persocket ,'\n',cpu_sockets ,'\n',memory ,'\n',sys_disk ,'\n',nums_lun ,'\n',
java_version ,'\n'
)
'''

#调用dmPython接口，插入数据
try:
conn = dmPython.connect(user='dmsystest', password='dameng123', server='192.168.163.137', port=5237)
cursor = conn.cursor()
try:
#清空表，初始化测试环境
cursor.execute ('delete from t_syscheck')
except (dmPython.Error, Exception) as err:
null

try:
#插入数据
cursor.execute ("insert into t_syscheck values('192.168.163.136',?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
sys_name,sys_version,net_exter,net_inter,cpu_type,cpu_cores,cpu_frequency,
cpu_threads_percore,cpu_cores_persocket,cpu_sockets,memory,sys_disk,nums_lun,java_version)
print('python: insert success!')

except (dmPython.Error, Exception) as err:
print(err)
cursor.close()
conn.close()
except (dmPython.Error, Exception) as err:
print(err)

五.运行网站

[root@localhost dmtest]# python3 manage.py runserver 192.168.163.138:8000
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
January 27, 2022 - 17:08:59
Django version 3.1.7, using settings 'dmtest.settings'
Starting development server at http://192.168.163.138:8000/
Quit the server with CONTROL-C.

访问：http://192.168.163.138:8000/sysinfo/