python(18) : flask_sqlalchemy 配置sqlserver数据库对象

最新推荐文章于 2025-02-12 00:55:55 发布

原创最新推荐文章于 2025-02-12 00:55:55 发布 · 630 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#python #flask #开发语言 #flask数据库

收录于

python 专栏收录该内容

71 篇文章

订阅专栏

1.安装依赖

pip3 install flask_sqlalchemy -i https://mirrors.aliyun.com/pypi/simple/ requests

2.数据库配置信息(db_manager.py)

import os

from flask import Flask
from flask_cors import CORS
from flask_sqlalchemy import SQLAlchemy

database = 'test'

app = Flask(__name__)

# 设置文件上传大小限制为500MB
app.config['MAX_CONTENT_LENGTH'] = 500 * 1024 * 1024
CORS(app)

if os.path.exists('/root'):
    app.config[
        'SQLALCHEMY_DATABASE_URI'] = f'mssql+pyodbc://root:123456@127.0.0.1:3433/{database}?driver=ODBC+Driver+17+for+SQL+Server&charset=utf8'
else:
    app.config[
        'SQLALCHEMY_DATABASE_URI'] = f'mssql+pyodbc://root:123456@127.0.0.1:1433/{database}?driver=SQL+Server'
db = SQLAlchemy(app)

3.数据表对象

# -*- coding: utf-8 -*-

# ====> 配置管理中心 <==== #

from datetime import datetime

from db_manager import db


# 配置分组
class AISConfGroup(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    create_time = db.Column(db.DateTime, default=datetime.now)
    modify_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
    parent_code = db.Column(db.String(50))
    code = db.Column(db.String(50))
    name = db.Column(db.String(50))
    type_c = db.Column(db.String(50))