class UserStock(db.Model):
__tablename__ = 'user_stocks'
id = db.Column(db.Integer, primary_key=True)
symbol = db.Column(db.String(5), nullable=False)
volume = db.Column(db.Integer, nullable=False)
user_id = db.Column(db.Integer, nullable=False)
def serialize(self):
return dict(id=self.id,
user_id=self.user_id,
symbol=self.symbol,
volume=self.volume)
class UserModel(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer,
db.Sequence('seq_users_id', start=1, increment=1),
primary_key=True)
identification = db.Column(db.String(255))
email = db.Column(db.String(255))
phone = db.Column(db.String(255))
password = db.Column(db.String(255))
status = db.Column(db.String(1), default=2) # 2 = user new
created = db.Column(db.DateTime, default=datetime.datetime.utcnow)
rol_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
rol = db.relationship('RolModel')
def __init__(self, identification, password, email, phone, rol_id):
self.identification = identification
self.password = password
self.email = email
self.phone = phone
self.rol_id = rol_id
def save_to_db(self):
db.session.add(self)
db.session.commit()
@classmethod
def find_by_identification(cls, identification):
return cls.query.filter_by(identification=identification).first()
@classmethod
def find_by_id(cls, _id):
return cls.query.filter_by(id=_id).first()
class Experiment(db.Model):
"""
实验表
"""
__tablename__ = 'experiment'
id = db.Column(db.Integer, primary_key=True, doc=u'唯一标识')
name = db.Column(db.String(32), nullable=False, default='', doc=u'实验名称')
remark = db.Column(db.String(512), nullable=False, default='', doc=u'实验备注')
start_time = db.Column(db.DateTime,
nullable=False,
default=func.now(),
doc=u'开始时间')
end_time = db.Column(db.DateTime,
nullable=False,
default=func.now(),
doc=u'结束时间')
lab_no = db.Column(db.Integer, nullable=False, default=0, doc=u'实验室编号')
teacher_id = db.Column(db.Integer, nullable=False, default=0, doc=u'教师id')
status = db.Column(db.Integer, nullable=False, default=1, doc=u'是否审批通过')
class Status(object):
SUCCESS = 0 # 成功
PROCESS = 1 # 审批中
FAILED = 2 # 失败
__label__ = {SUCCESS: "审批通过", PROCESS: "审批中", FAILED: "审批未通过"}
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
created_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
def __init__(self, id, name):
self.id = id
self.name = name
class User(db.Model):
__tablename__ = 'users'
# model schema
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(80))
username = db.Column(db.String(80))
password = db.Column(db.String(80))
def __init__(self, email, username, password):
self._id = _id
self.email = email
self.username = username
self.password = password
@classmethod
def find(cls, id):
return cls.query.filter_by(id=id)
@classmethod
def find_by(cls, **kwargs):
return cls.query.filter_by(kwargs).first()
@classmethod
def first(cls):
return cls.query(cls).one()
@classmethod
def all(cls):
return cls.query(cls)
@classmethod
def new(cls):
pass
@classmethod
def create(cls, **kwargs):
db.session.add(kwargs)
db.session.commit()
def update(self):
db.session.add(self)
db.session.commit()
def destroy(self):
db.session.delete(self)
db.session.commit()
class Email(db.Model):
__tablename__ = 'email'
id = db.Column(db.Integer, primary_key=True, doc=u'email唯一标识')
user_id = db.Column(db.Integer, nullable=False, default=0, doc=u'用户id')
email = db.Column(db.String(32), nullable=False, doc=u'邮箱')
fix_time = db.Column(db.DateTime,
nullable=False,
default=func.now(),
doc=u'绑定时间')
@staticmethod
def create(user_id, fix_email):
email = Email()
email.user_id = user_id
email.email = fix_email
return email
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, doc='用户唯一标识')
username = db.Column(db.String(32), nullable=False, doc='用户名')
password = db.Column(db.String(32), nullable=False, doc='密码')
real_name = db.Column(db.String(32),
nullable=False,
default=u'',
doc='真实姓名')
telephone = db.Column(db.String(32), nullable=False, doc='联系电话')
identity_type = db.Column(db.Integer,
nullable=False,
default=2,
doc='0管理者 1快递员 2普通用户')
status = db.Column(db.Integer,
nullable=False,
default=0,
doc='状态 0 启用 1 禁用')
class IdentityType(object):
"""
用户身份
"""
MANAGER = 0 # 管理员
COURIER = 1 # 快递员
CUSTOMER = 2 # 普通客户
class Status(object):
"""
用户状态
"""
NORMAL = 0 # 正常
ABANDON = 1 # 废弃
class HospitalModel(db.Model):
__tablename__ = 'hospital'
id = db.Column(db.Integer,
db.Sequence('seq_hospital_id', start=1, increment=1),
primary_key=True)
name = db.Column(db.String(255))
direccion = db.Column(db.String(255))
service = db.Column(db.String(255))
status = db.Column(db.String(1), default=1)
created = db.Column(db.DateTime, default=datetime.datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
user = db.relationship('UserModel')
def __init__(self, name, direccion, service, user_id):
self.name = name
self.direccion = direccion
self.service = service
self.user_id = user_id
def save_to_db(self):
db.session.add(self)
db.session.commit()
@classmethod
def find_by_id(cls, _id):
return cls.query.filter_by(id=_id).first()
class Suscripcion(db.Model):
idsuscripcion = db.Column(db.Integer, primary_key=True)
tipo = db.Column(db.String(250))
fecha_renovacion = db.Column(db.Date)
fecha_vencimiento = db.Column(db.Date)
estado = db.Column(db.String(50))
relacionuservet = db.relationship('Uservet',
backref='suscripcion',
lazy=True)
relacionpagosuscripcion = db.relationship('PagoSuscripcion',
backref='suscripcion',
lazy=True)
def __init__(self, tipo, fecha_renovacion, fecha_vencimiento, estado):
self.tipo = tipo
self.fecha_renovacion = fecha_renovacion
self.fecha_vencimiento = fecha_vencimiento
self.estado = estado
class User(db.Model):
# 数据库的表名
__tablename__ = 'py_user'
# 单个属性 对应数据库中的列 db.BigInteger 为列的类型此列为bigint,primary_key为主键
userId = db.Column(db.BigInteger, primary_key=True)
# 姓名
userName = db.Column(db.String(255), unique=False)
# 密码
userPwd = db.Column(db.String(255), unique=False)
# 用户头像
userPhoto = db.Column(db.String(255), unique=False)
# 帐号
userAccount = db.Column(db.String(255), unique=False)
class Record(db.Model):
__tablename__ = 'record'
id = db.Column(db.Integer, primary_key=True, doc=u'签到记录id')
user_id = db.Column(db.Integer, nullable=False, default=0, doc=u'绑定用户id') # 用户是一个组（此系统为老师）
pro_class = db.Column(db.String(32), nullable=False, doc=u'专业班级')
unchecked = db.Column(db.Text, nullable=False, default='', doc=u'未签到的人')
create_time = db.Column(db.DateTime, nullable=False, default=func.now(), doc=u'创建时间')
end_time = db.Column(db.DateTime, nullable=False, default=func.now(), onupdate=func.now(), doc=u'结束时间')
record = db.Column(db.Text, nullable=False, default='', doc=u'签到记录')
status = db.Column(db.Integer, nullable=False, default=1, doc=u'签到结束前是否可查, 0-可看,1-不可看')
class Help(db.Model):
"""
帮助表
"""
__tablename__ = 'help'
id = db.Column(db.Integer, primary_key=True, doc=u'唯一标识')
lab_id = db.Column(db.Integer, nullable=False, default=0, doc=u'实验室id')
question = db.Column(db.String(512), nullable=False, doc=u'问题')
status = db.Column(db.Integer, nullable=False, doc=u'状态 0 已解决, 1未解决')
class Status(object):
"""
状态
"""
SOLVED = 0 # 已解决
UNRESOLVED = 1 # 未解决
__labels__ = {SOLVED: "已处理", UNRESOLVED: "未处理"}
class PlanetModel(db.Model):
__tablename__ = 'planets'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
climate = db.Column(db.String(20))
terrain = db.Column(db.String(20))
nMovies = db.Column(db.Integer)
def __init__(self, name, climate, terrain):
self.name = name
self.climate = climate
self.terrain = terrain
self.nMovies = self.find_nMovies_by_name(self.name)
def json(self):
return {
'name': self.name,
'climate': self.climate,
'terrain': self.terrain,
'nMovies': self.nMovies
}
@classmethod
def find_by_name(cls, name):
return cls.query.filter_by(name=name).first()
def find_nMovies_by_name(self, name):
planetList = requests.get("https://swapi.dev/api/planets/")
if planetList.status_code == 200:
for i in range(0, len(planetList.json()['results'])):
if name == planetList.json()['results'][i]['name']:
return len(planetList.json()['results'][i]['films'])
else:
return 0
def save_to_db(self):
db.session.add(self)
db.session.commit()
def delete_from_db(self):
db.session.delete(self)
db.session.commit()
class Users(db.Model):
__tablename__ = 'users'
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.String)
username = db.Column('username', db.String)
password = db.Column('password', db.String)
def __init__(self,id=None, username=None,password=None, name=None):
self.id = id
self.name = name
self.username = username
self.password = password
def __repr__(self):
return '<Users %r>' % self.id
class StoreModel(db.Model):
__tablename__ = "store"
storeId = db.Column(
db.String(80), primary_key=True
) # prefix ST_ + Serial + registerDate(from UserModel) + userId
storeName = db.Column(db.String(40), nullable=False)
storeLocation = db.Column(db.Text, nullable=True)
storeCoverImage = db.Column(db.Text, nullable=True)
storePicture = db.Column(db.Text, nullable=True)
createDate = db.Column(db.BigInteger, default=time)
updateDate = db.Column(db.BigInteger, onupdate=time)
userId = db.Column(db.String(50), db.ForeignKey('users.userId'))
user = db.relationship('UserModel')
product = db.relationship('ProductModel',
lazy="dynamic",
cascade="all ,delete-orphan")
@classmethod
def fetchAll(cls):
return cls.query.all()
@classmethod
def findSerial(cls):
return cls.query.count()
@classmethod
def findByStoreId(cls, storeid):
return cls.query.filter_by(storeId=storeid).first()
@classmethod
def findByUserId(cls, userid):
return cls.query.filter_by(userId=userid).first()
@classmethod
def isLimit(cls, userid) -> bool:
return cls.query.filter_by(userId=userid).count() >= 5
@classmethod
def findByStoreName(cls, storename):
return cls.query.filter_by(storeName=storename).first()
def insert(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()
class User(db.Model):
"""
用户表
"""
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, doc=u'用户唯一标识')
username = db.Column(db.String(32), nullable=False, doc=u'用户名')
password = db.Column(db.String(32), nullable=False, doc=u'密码')
role = db.Column(db.Integer,
nullable=False,
default=2,
doc=u'身份标识 0, 1, 2')
contacts = db.Column(db.String(64),
nullable=False,
default='',
doc=u'联系方式')
join_experiments = db.Column(db.String(128),
nullable=False,
default='',
doc=u'学生参加的实验')
class Role(object):
"""
用户身份
"""
MANAGER = 0 # 管理员
TEACHER = 1 # 老师
STUDENT = 2 # 学生
__label__ = {MANAGER: u"管理员", TEACHER: u"教师", STUDENT: u"学生"}
class OrderModel(db.Model):
__tablename__ = 'orders'
orderId = db.Column(db.String(80),primary_key=True) #userid + time() +
inOrederStatus = db.Column(db.Boolean,default=True)
createDate = db.Column(db.BigInteger,default=time)
updateDate = db.Column(db.BigInteger,onupdate=time)
userId = db.Column(db.String(50),db.ForeignKey('users.userId'))
user = db.relationship('UserModel')
orderhistory = db.relationship(OrderHistoryModel,lazy="dynamic",cascade="all ,delete-orphan")
@classmethod
def fetchAll(cls):
return cls.query.all()
@classmethod
def generateId(cls,userid):
return f"ORDER_{userid}_{int(time())}"
@classmethod
def fetchJoinAll(cls):
return UserModel.query.filter_by(userId=cls.userId).all()
@classmethod
def findById(cls,orderid):
return cls.query.filter_by(orderId=orderid).first()
@classmethod
def findByUserId(cls,userid):
return cls.query.filter_by(userId=userid).all()
def insert(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()
class UserModel(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20))
password = db.Column(db.String(20))
def __init__(self, username, password):
self.username = username
self.password = password
def save_to_db(self):
db.session.add(self)
db.session.commit()
@classmethod
def find_by_username(cls, username):
return cls.query.filter_by(username=username).first()
@classmethod
def find_by_id(cls, _id):
return cls.query.filter_by(id=_id)
class Template(db.Model):
__tablename__ = 'template'
id = db.Column(db.Integer, primary_key=True) # 编号
title = db.Column(db.String(40), nullable=False) #
content = db.Column(db.Text, nullable=False) # 内容
saveName = db.Column(db.String(100), nullable=False) #
toPath = db.Column(db.String(100), nullable=False) #
addtime = db.Column(db.DateTime, nullable=False) # 注册时间
class Pet(db.Model):
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(255))
birthdate = db.Column(db.DateTime)
color = db.Column(db.String(25))
bread = db.Column(db.String(55))
photo = db.Column(db.String(255))
owner = db.Column(db.Integer,db.ForeignKey('usuario.id'))
def __init__(self,name,birthdate,color,bread,photo,owner):
self.name= name
self.birthdate= birthdate
self.color= color
self.bread= bread
self.photo= photo
self.owner= owner
class Mascota(db.Model):
idmascota = db.Column(db.Integer, primary_key=True)
idcliente = db.Column(db.Integer, db.ForeignKey('cliente.idcliente'))
nombre = db.Column(db.String(250))
tipo = db.Column(db.String(250))
raza = db.Column(db.String(250))
nacimiento = db.Column(db.Date)
peso = db.Column(db.String(250))
observaciones = db.Column(db.String(1000))
def __init__(self, idcliente, nombre, tipo, raza, nacimiento, peso,
observaciones):
self.idcliente = idcliente
self.nombre = nombre
self.tipo = tipo
self.raza = raza
self.nacimiento = nacimiento
self.peso = peso
self.observaciones = observaciones
class PagoSuscripcion(db.Model):
idpagosuscripcion = db.Column(db.Integer, primary_key=True)
idsuscripcion = db.Column(db.Integer,
db.ForeignKey('suscripcion.idsuscripcion'))
monto = db.Column(db.String(20))
estado = db.Column(db.String(20))
imagen = db.Column(db.String(100))
creado = db.Column(db.DateTime,
default=datetime.now(pytz.timezone('America/Lima')))
observacion = db.Column(db.String(200))
mes = db.Column(db.String(20))
anio = db.Column(db.String(20))
def __init__(self, idsuscripcion, monto, estado, imagen, creado,
observacion, mes, anio):
self.idsuscripcion = idsuscripcion
self.monto = monto
self.estado = estado
self.imagen = imagen
self.creado = creado
self.observacion = observacion
self.mes = mes
self.anio = anio
class Email(db.Model):
"""
收件箱表
"""
__tablename__ = 'email'
id = db.Column(db.Integer, primary_key=True, doc=u'唯一标识')
user_id = db.Column(db.Integer, nullable=False, doc=u'用户id')
content = db.Column(db.String(512), nullable=False, doc=u'邮件内容')
create_id = db.Column(db.Integer, nullable=False, doc=u'创建人')
create_name = db.Column(db.String(32), nullable=False, doc=u'创建人姓名')
create_time = db.Column(db.DateTime, nullable=False, default=func.now(), doc=u'创建时间')
class Services(db.Model):
id = db.Column(db.Integer,primary_key = True)
idvet = db.Column(db.Integer,db.ForeignKey('veterinaria.id'))
tipo = db.Column(db.String(200))
nombre = db.Column(db.String(200))
precio = db.Column(db.Float)
foto = db.Column(db.String(250))
def __init__(self,idvet,tipo,nombre,precio,foto):
self.idvet = idvet
self.tipo = tipo
self.nombre = nombre
self.precio = precio
self.foto = foto
class AtencionDetalle(db.Model):
idatenciondetalle = db.Column(db.Integer, primary_key=True)
tipo = db.Column(db.String(100))
nombre = db.Column(db.String(250))
cantidad = db.Column(db.Integer)
precio_unitario = db.Column(db.Float)
subtotal = db.Column(db.Float)
idatencion = db.Column(db.Integer, db.ForeignKey('atencion.idatencion'))
def __init__(self, tipo, nombre, cantidad, precio_unitario, subtotal,
idatencion):
self.tipo = tipo
self.nombre = nombre
self.cantidad = cantidad
self.precio_unitario = precio_unitario
self.subtotal = subtotal
self.idatencion = idatencion
class Transaction(db.Model):
__tablename__ = 'transactions'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
symbol = db.Column(db.String(5), nullable=False)
volume = db.Column(db.Integer, nullable=False)
stock_price = db.Column(db.Float, nullable=False)
total_price = db.Column(db.Float, nullable=False)
datetime = db.Column(db.TIMESTAMP, nullable=False)
txntype = db.Column(db.String, nullable=False)
def serialize(self):
return dict(id=self.id,
user_id=self.user_id,
symbol=self.symbol,
volume=self.volume,
stock_price=self.stock_price,
total_price=self.total_price,
datetime=self.datetime,
txntype=self.txntype)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80))
password = db.Column(db.String(80))
userGroup = db.Column(db.Integer)
active = db.Column(db.Integer)
locked = db.Column(db.Integer)
def __init__(self,
_id,
username,
password,
userGroup=1,
active=1,
locked=0):
"""
Instance attributes:
username
password
userGroup:
*1: Normal
*2: Admin
active:
*0: Inactive: Being used instead of physical deletion
*1: Active
locked:
*0: Not locked
*1: Locked for any reason that doesn't comply with the available policies. For exapmale suspecious activity.
"""
self.id = _id
self.username = username
self.password = password
self.active = active
self.locked = locked
def json(self):
return {
'id': self.id,
'usrename': self.username,
'active': self.active
}
@classmethod
def find_by_username(cls, username):
return cls.query.filter_by(username=username, active=1).first()
@classmethod
def find_by_id(cls, id):
return cls.query.filter_by(id=id, active=1).first()
class Servicios(db.Model):
idServicio = db.Column(db.Integer, primary_key=True)
nombre = db.Column(db.String(250))
tipo = db.Column(db.String(250))
precio = db.Column(db.Float)
detalles = db.Column(db.String(250))
idvet = db.Column(db.Integer, db.ForeignKey('vet.idvet'))
def __init__(self, nombre, tipo, precio, detalles, idvet):
self.nombre = nombre
self.tipo = tipo
self.precio = precio
self.detalles = detalles
self.idvet = idvet
class OrderHistoryModel(db.Model):
__tablename__ = 'orderhistories'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
quantity = db.Column(db.Integer, nullable=False)
flaskSaleStatus = db.Column(db.Boolean, nullable=False)
createDate = db.Column(db.BigInteger, default=time)
updateDate = db.Column(db.BigInteger, onupdate=time)
orderId = db.Column(db.String(80), db.ForeignKey('orders.orderId'))
proId = db.Column(db.String(80), db.ForeignKey('products.proId'))
order = db.relationship('OrderModel')
product = db.relationship('ProductModel')
@classmethod
def fetchAll(cls):
return cls.query.all()
@classmethod
def fetchById(cls, _id):
return cls.query.filter_by(id=_id).first()
@classmethod
def fetchByOrderId(cls, orderid):
return cls.query.filter_by(orderId=orderid).all()
@classmethod
def fetchByProId(cls, proid):
return cls.query.filter_by(proId=proid).all()
@classmethod
def insertMany(self, value):
db.session.add_all(value)
db.session.commit()
def insert(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()
class HistorialPagovendedor(db.Model):
idhp = db.Column(db.Integer, primary_key=True)
creado = db.Column(db.DateTime,
default=datetime.now(pytz.timezone('America/Lima')))
idvendedor = db.Column(db.String(20))
cliente = db.Column(db.String(100))
accion = db.Column(db.String(200))
observaciones = db.Column(db.String(200))
def __init__(self, creado, idvendedor, cliente, accion, observaciones):
self.creado = creado
self.idvendedor = idvendedor
self.cliente = cliente
self.accion = accion
self.observaciones = observaciones
