记一次：django models到sqlalchemy models重构

最新推荐文章于 2024-08-24 15:15:00 发布

原创

最新推荐文章于 2024-08-24 15:15:00 发布 · 552 阅读

0 ·

CC 4.0 BY-SA版权

本文记录了一次将Django的models转换为SQLAlchemy models的过程，包括部署Django应用，初始化数据库设置，查看数据库映射，使用Navicat导出数据库结构，以及将数据库逆向工程转化为SQLAlchemy模型。

部署本地开发环境的django应用，初始化数据库设置

PythonWebDev\web_develop\network\networkconsole-master\networkconsole\conf.py

import os

DEBUG = True
ALLOWED_HOSTS = ['*']
DB_NAME = os.getenv("DB_NAME", "nms_console")
DB_USER = os.getenv("DB_USER", 'root')
DB_PASSWORD = os.getenv("DB_PASSWORD", '')
DB_HOST = os.getenv("DB_HOST", "localhost")
DB_PORT = int(os.getenv("DB_PORT", "3306"))
REDIS_HOST = os.getenv("REDIS_HOST", '127.0.0.1')
REDIS_PORT = int(os.getenv("REDIS_PORT", '6379'))
LDAP_SERVER_URI = os.getenv("LDAP_SERVER_URI", 'ldap://10.222.10.244:389')
LDAP_PASSWORD = os.getenv("LDAP_PASSWORD", 'OUm6Wau+VuBX')
LOCK_FILE_PATH = '/ikglobal/lock/'
MESSAGE_PATH = '/ikglobal/logs/message.log'
LOG_REQUEST_ERROR_PATH = '/ikglobal/logs/request_error.log'
LOG_SQL_PATH = '/ikglobal/logs/sql.log'

将jango的sql mode映射到数据库

python manage.py migrate

查看生成的对应数据库和表

映射sql到sqlalchemy models

(vpp_agent_venv3.7) [root@localhost model]# pip install sqlacodegen
(vpp_agent_venv3.7) [root@localhost model]# sqlacodegen --outfile=nms_routein.py mysql+pymysql://root:123456@127.0.0.1:3306/nms_console
(vpp_agent_venv3.7) [root@localhost model]# ls
base_model.py  models2.py  models_mongo.py  models.py  nms_routein.py  __pycache__  route_in.py

通过navicat导出数据库结构

点击nms_console，右键选择转存sql文件数据和结构

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : 127.0.0.1:3306
 Source Schema         : nms_console

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 11/09/2019 20:25:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for common_config
-- ----------------------------
DROP TABLE IF EXISTS `common_config`;
CREATE TABLE `common_config`  (
  `uuid` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `room_id` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`uuid`) USING BTREE,
  UNIQUE INDEX `common_config_name_room_id_50e7a3f4_uniq`(`name`, `room_id`) USING BTREE,
  INDEX `common_config_room_id_1687cb8f_fk_common_room_uuid`(`room_id`) USING BTREE,
  CONSTRAINT `common_config_room_id_1687cb8f_fk_common_room_uuid` FOREIGN KEY (`room_id`) REFERENCES `common_room` (`uuid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for common_local_config
-- ----------------------------
DROP TABLE IF EXISTS `common_local_config`;
CREATE TABLE `common_local_config`  (
  `uuid` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `room_id` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`uuid`) USING BTREE,
  UNIQUE INDEX `common_local_config_name_room_id_2352bdaa_uniq`(`name`, `room_id`) USING BTREE,
  INDEX `common_local_config_room_id_177281a0_fk_common_room_uuid`(`room_id`) USING BTREE,
  CONSTRAINT `common_local_config_room_id_177281a0_fk_common_room_uuid` FOREIGN KEY (`room_id`) REFERENCES `common_room` (`uuid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for co