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