Flasksqlalchemy和Flask-SQLAlchemy使用对比
📖Flask实战的经验总结📖
📱有问题随时与我联系,一起学习交流📱
❤️喜欢的话点个三连吧❤️
sqlalchemy创建数据模型
# sqlalchemy的基本使用
from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String, Text, Date, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationship
from settings import DB_URI
engine = create_engine(DB_URI)
# 所有的类都要继承自`declarative_base`这个函数生成的基类
Base = declarative_base(engine)
Session = sessionmaker(bind=engine)
# 用户信息表
class User(Base):
# 定义表名为users
__tablename__ = 'users'
# 将id设置为主键,并且默认是自增长的
id = Column(Integer, primary_key=True)
# name字段,字符类型,最大的长度是50个字符
username = Column(String(50))
password = Column(String(50))
# 让打印出来的数据更好看,可选的
def __repr__(self):
return "<User(id='%s',username='%s',password='%s')>" % (self.id, self.username, self.password)
# 管理员信息表
class Admin(Base):
__tablename__ = 'admin'
id = Column(Integer, primary_key=True)
username = Column(String(50))
password = Column(String(50))
def __repr__(self):
return "<Admin(id='%s',username='%s',password='%s')>" % (self.id, self.username, self.password)
# 柱状图数据表
class DataBar(Base):
__tablename__ = 'databar'
id = Column(Integer, primary_key=True)
label = Column(Integer)
data = Column(Integer)
def __repr__(self):
return "<DataBar(id='%s',label='%s',data='%s')>" % (self.id, self.label, self.data)
# 线状图数据表
class DataLine(Base):
__tablename__ = 'dataline'
id = Column(Integer, primary_key=True)
label = Column(Integer)
data = Column(Integer)
def __repr__(self):
return "<DataLine(id='%s',label='%s',data='%s')>" % (self.id, self.label, self.data)
# 单位名称映射表
class Unit(Base):
__tablename__ = 'unit'
id = Column(Integer, primary_key=True)
unitname = Column(String(50))
contents = relationship('Content', back_populates='unit')
def __repr__(self):
return "<Unit(id='%s',unitname='%s')>" % (self.id, self.unitname)
# 问题分类映射表
class Category(Base):
__tablename__ = 'category'
id = Column(Integer, primary_key=True)
category = Column(String(50))
contents = relationship('Content', back_populates='category')
def __repr__(self):
return "<Unit(id='%s',unitname='%s')>" % (self.id, self.unitname)
# 情况登记表,问题,问题类型编号,单位编号,发生时间
class Content(Base):
__tablename__ = 'content'
id = Column(Integer, primary_key=True)
problem = Column(Text)
cid = Column(Integer, ForeignKey('category.id'))
uid = Column(Integer, ForeignKey('unit.id'))
date = Column(Date)
category = relationship('Category', back_populates='contents')
unit = relationship('Unit', back_populates='contents')
# Base.metadata.create_all()
# session = Session()
# tmp_user = User(username='user3', password='1234')
# print(tmp_user)
# session.add(tmp_user)
# session.commit()
Flask-SQLAlchemy创建数据模型
# flask-sqlalchemy的基本使用
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
# 管理员信息表
class Admin(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), unique=True)
password = db.Column(db.String(50))
def __init__(self, username, password):
self.username = username
self.password = password
def __repr__(self):
return "<Admin(id='%s',username='%s',password='%s')>" % (self.id, self.username, self.password)
# 用户信息表
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
# name字段,字符类型,最大的长度是50个字符
username = db.Column(db.String(50), unique=True)
password = db.Column(db.String(50))
def __init__(self, username, password):
self.username = username
self.password = password
# 让打印出来的数据更好看,可选的
def __repr__(self):
return "<User(id='%s',username='%s',password='%s')>" % (self.id, self.username, self.password)
# 柱状图数据表
class DataBar(db.Model):
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.Integer)
data = db.Column(db.Integer)
def __init__(self, label, data):
self.label = label
self.data = data
def __repr__(self):
return "<DataBar(id='%s',label='%s',data='%s')>" % (self.id, self.label, self.data)
# 线状图数据表
class DataLine(db.Model):
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.Integer)
data = db.Column(db.Integer)
def __init__(self, label, data):
self.label = label
self.data = data
def __repr__(self):
return "<DataLine(id='%s',label='%s',data='%s')>" % (self.id, self.label, self.data)
# 单位名称映射表
class Unit(db.Model):
id = db.Column(db.Integer, primary_key=True)
unitname = db.Column(db.String(50))
contents = db.relationship('Content', back_populates='unit')
def __init__(self, unitname):
self.unitname = unitname
def __repr__(self):
return "<Unit(id='%s',unitname='%s')>" % (self.id, self.unitname)
# 问题一级分类映射表
class Category1(db.Model):
id = db.Column(db.Integer, primary_key=True)
category = db.Column(db.String(50))
contents = db.relationship('Content', back_populates='category1')
category2s = db.relationship('Category2', back_populates='category1')
def __init__(self, category):
self.category = category
def __repr__(self):
return "<Unit(id='%s',category='%s')>" % (self.id, self.category)
# 问题二级分类映射表,细化分类
class Category2(db.Model):
id = db.Column(db.Integer, primary_key=True)
category = db.Column(db.String(50))
c1id = db.Column(db.Integer, db.ForeignKey('category1.id'))
contents = db.relationship('Content', back_populates='category2')
category1 = db.relationship('Category1', back_populates='category2s')
def __init__(self, category, c1id):
self.category = category
self.c1id = c1id
def __repr__(self):
return "<Unit(id='%s',category='%s',c1id='%s)>" % (self.id, self.category, self.c1id)
# 情况登记表,问题,问题类型编号,单位编号,发生时间
class Content(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
problem = db.Column(db.Text)
c1id = db.Column(db.Integer, db.ForeignKey('category1.id'))
c2id = db.Column(db.Integer, db.ForeignKey('category2.id'))
uid = db.Column(db.Integer, db.ForeignKey('unit.id'))
date = db.Column(db.Date)
modificationstate = db.Column(db.Boolean)
modificationdate = db.Column(db.Date)
category1 = db.relationship('Category1', back_populates='contents')
category2 = db.relationship('Category2', back_populates='contents')
unit = db.relationship('Unit', back_populates='contents')
def __init__(self, problem, c1id, c2id, uid, date, modificationstate, modificationdate):
self.problem = problem
self.c1id = c1id
self.c2id = c2id
self.uid = uid
self.date = date
self.modificationstate = modificationstate
self.modificationdate = modificationdate
def __repr__(self):
return "<Content(id='%s',problem='%s',c1id='%s',c2id='%s',uid='%s',date='%s'),modificationstate='%s',modificationdate='%s'>" \
% (self.id, self.problem, self.c1id, self.c2id, self.uid, self.date, self.modificationstate, self.modificationdate)
# db.create_all()
# admin = Admin('admin', '123456')
# user = User('user', '123456')
# unit = Unit('单位一')
# db.session.add(admin)
# db.session.add(user)
# db.session.add(unit)
# db.session.commit()
这篇好文章是转载于:学新通技术网
- 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
- 本站站名: 学新通技术网
- 本文地址: /boutique/detail/tanhfjiajb
系列文章
更多
同类精品
更多
-
photoshop保存的图片太大微信发不了怎么办
PHP中文网 06-15 -
《学习通》视频自动暂停处理方法
HelloWorld317 07-05 -
word里面弄一个表格后上面的标题会跑到下面怎么办
PHP中文网 06-20 -
Android 11 保存文件到外部存储,并分享文件
Luke 10-12 -
photoshop扩展功能面板显示灰色怎么办
PHP中文网 06-14 -
微信公众号没有声音提示怎么办
PHP中文网 03-31 -
excel下划线不显示怎么办
PHP中文网 06-23 -
excel打印预览压线压字怎么办
PHP中文网 06-22 -
TikTok加速器哪个好免费的TK加速器推荐
TK小达人 10-01 -
怎样阻止微信小程序自动打开
PHP中文网 06-13