python之Django自動(dòng)化資產(chǎn)掃描的實(shí)現(xiàn)

>python manage.py startapp scanhost

setting
# LANGUAGE_CODE = 'en-us'
LANGUAGE_CODE = 'zh-hans'

# TIME_ZONE = 'UTC'
TIME_ZONE = 'Asia/Shanghai'
# USE_TZ = True
USE_TZ = False

INSTALLED_APPS = [
 'scanhost',
]

>python manage.py makemigrations # 生成數(shù)據(jù)庫(kù)遷移腳本（每次修改了數(shù)據(jù)庫(kù)必備操作）
>python manage.py migrate # 將遷移腳本寫入數(shù)據(jù)庫(kù)并創(chuàng)建數(shù)據(jù)庫(kù)表
>python manage.py createsuperuser

>python manage.py runserver 9999

安裝插件 .ignore，并生成python上傳git項(xiàng)目需要忽略內(nèi)容的文件 .gitignore
>pip freeze > requirements.txt 生成 requirements.txt
創(chuàng)建README.md ## 導(dǎo)入此項(xiàng)目需要的包（最后完成時(shí)導(dǎo)入）

>git init #初始化git倉(cāng)庫(kù)管理
>git add * # 將本地增刪改查的文件全部添加到暫存區(qū)
>git commit -m "django project init" # # 添加到本地倉(cāng)庫(kù)
>git remote add origin https://gitee.com/***/*** ##上傳到gitee倉(cāng)庫(kù) 關(guān)聯(lián)倉(cāng)庫(kù)
>git push --set-upstream origin master
>git push --set-upstream origin master -f #首次上傳

from .base import *
DATABASES = {
 'default': {
  'ENGINE': 'django.db.backends.sqlite3',
  'NAME': BASE_DIR / 'db.sqlite3',
 }
}

from .base import *
DATABASES = {
 'default': {
  'ENGINE': 'django.db.backends.postgresql',
  'NAME': 'mydatabase',
  'USER': 'mydatabaseuser',
  'PASSWORD': 'mypassword',
  'HOST': '127.0.0.1',
  'PORT': '5432',
 }
}

DEBUG = False # 開(kāi)發(fā)環(huán)境一定要關(guān)閉調(diào)試模式
ALLOWED_HOSTS = ['*'] # 允許所有主機(jī)訪問(wèn)

import os

env = os.environ.get('PROJECT_ENV', 'dev') ##dev開(kāi)發(fā)環(huán)境，prod生產(chǎn)環(huán)境
if env == 'dev':
 from .dev import *
elif env == 'prod':
 from .prod import *
else:
 from .dev import *

>python manage.py migrate
>python manage.py createsuperuser
>python manage.py runserver 9999
>git add *
>git commit -m "add dev and prod settings"
>git push

[root@localhost yum.repos.d]# ssh root@192.168.139.130 ##虛擬機(jī)ip
[root@localhost yum.repos.d]# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
[root@localhost yum.repos.d]# vim CentOS-Base.repo
:%s/$releasever/7/g
[root@localhost yum.repos.d]# yum install -y python3

[root@localhost ~]# pip3 install virtualenv -i https://pypi.douban.com/simple ##安裝虛擬環(huán)境
[root@localhost cmdb]# which python3
/usr/bin/python3
[root@localhost ~]# virtualenv -p /usr/bin/python3 venv ## 激活虛擬環(huán)境
[root@localhost ~]# source venv/bin/activate
(venv) [root@localhost cmdb]# pip install -r requirements.txt -i https://pypi.douban.com/simple ##安裝所需的包

(venv) [root@localhost cmdb]# yum install mariadb-server -y
(venv) [root@localhost cmdb]# systemctl start mariadb
(venv) [root@localhost cmdb]# systemctl enable mariadb
(venv) [root@localhost cmdb]# mysql
(venv) [root@localhost cmdb]# mysql_secure_installation ## 初始化
(venv) [root@server1 ~]# mysql -uroot -pwestos
MariaDB [(none)]> create database cmdb default charset='utf8'; ## 創(chuàng)建數(shù)據(jù)庫(kù)cmdb；（設(shè)置編碼格式為'utf8'）
MariaDB [(none)]> create user cmdb@'%' identified by "cmdb"; ## .創(chuàng)建遠(yuǎn)程訪問(wèn)數(shù)據(jù)庫(kù)用戶并授權(quán)
MariaDB [(none)]> grant all on cmdb.* to cmdb@'%';
(venv) [root@server1 ~]# mysql -ucmdb -pcmdb -h192.168.139.130 ##測(cè)試遠(yuǎn)程訪問(wèn)數(shù)據(jù)庫(kù)

(venv) [root@server1 ~]# yum install -y mariadb-devel
(venv) [root@server1 ~]# yum install -y gcc
(venv) [root@server1 ~]# yum install -y python3-devel
(venv) [root@server1 ~]# pip3 install -y mysqlclient -i https://pypi.douban.com/simple

(venv) [root@server1 ~]# systemctl stop firewalld.service
(venv) [root@server1 ~]# systemctl disable firewalld.service
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
(venv) [root@server1 ~]# setenforce 0
(venv) [root@server1 ~]# pip3 install -y mysqlclient -i https://pypi.douban.com/simple

from .base import *

DATABASES = {
 'default': {
  'ENGINE': 'django.db.backends.mysql',
  'NAME': 'cmdb',
  'USER': 'cmdb',
  'PASSWORD': 'cmdb',
  'HOST': '192.168.139.130',
  'PORT': '3306',
 }
}
DEBUG = True # debug調(diào)試在生產(chǎn)環(huán)境一定要關(guān)閉
# ALLOWED_HOSTS = ['192.168.0.0/16'] # 允許訪問(wèn)服務(wù)器的客戶端網(wǎng)段信息
ALLOWED_HOSTS = ['*'] # 允許訪問(wèn)服務(wù)器的客戶端網(wǎng)段信息

(venv) [root@server1 cmdb]# python manage.py makemigrations
No changes detected
(venv) [root@server1 cmdb]# python manage.py migrate
(venv) [root@server1 cmdb]# python manage.py createsuperuser