return f'{self.name}' @event.listens_for(User.password, 'set', retval=True) def hash_user_password(target, value, old_value, initiator): """ Listener for hashing new password """ if value != old_value: return generate_password_hash(value) else: return old_value meals_orders = db.Table( 'meals_orders', db.Column('order_id', db.Integer, db.ForeignKey('orders.id')), db.Column('meal_id', db.Integer, db.ForeignKey('meals.id'))) class Meal(db.Model): __tablename__ = 'meals' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(80), unique=True, nullable=False) price = db.Column(db.Integer, nullable=False) description = db.Column(db.String(200), nullable=False) picture = db.Column(db.String(80), nullable=False) category_id = db.Column(db.Integer, db.ForeignKey("categories.id")) category = db.relationship("Category", back_populates="meals", lazy='joined') orders = db.relationship('Order',
floor = db.Column(db.Integer) no = db.Column(db.Integer) capacity = db.Column(db.Integer) name = db.Column(db.String(80), nullable=False) detail = db.Column(db.String(80), nullable=False) available = db.Column(db.Boolean, default=True) orders = db.relationship('Order', lazy='select', backref=db.backref('room', lazy=True)) members = db.Table( 'meeting_members', db.Column('order_id', db.UUID(as_uuid=True), db.ForeignKey('room_booking_order.id'), primary_key=True), db.Column('member_id', db.String, db.ForeignKey('user.id'), primary_key=True)) class Order(db.Model, CRUDMixin, TimeMixin): __tablename__ = 'room_booking_order' id = db.Column(db.UUID(as_uuid=True), default=uuid.uuid4, primary_key=True) user_id = db.Column(db.String, db.ForeignKey('user.id')) room_id = db.Column(db.UUID, db.ForeignKey('room.id')) contact = db.Column(db.String) teacher = db.Column(db.String) date = db.Column(db.DateTime) start = db.Column(db.Integer)
from geoalchemy2 import Geometry from sqlalchemy import ForeignKey from sqlalchemy.dialects.postgresql import JSON, JSONB from application.extensions import db organisation_feature = db.Table('organisation_feature', db.Column('organisation', db.String(64), db.ForeignKey('organisation.organisation'), primary_key=True), db.Column('feature', db.String(256), db.ForeignKey('feature.feature'), primary_key=True), ) class Category(db.Model): """ actually our wiki, containing concepts and tags, linked to by markdown """ category = db.Column(db.String(64), primary_key=True) # Local Authority, Planning Authority, etc text = db.Column(db.Text) publications = db.relationship('Publication', backref='category', lazy=True) organisations = db.relationship('Organisation', backref='category', lazy=True) class Licence(db.Model): licence = db.Column(db.String(256), primary_key=True) name = db.Column(db.String(256)) url = db.Column(db.Text) text = db.Column(db.Text)
_external=_external) @cached_property def url(self): return self._url() @cached_property def permalink(self): return self._url(True) post_tags = db.Table( "post_tags", db.Model.metadata, db.Column("post_id", db.Integer, db.ForeignKey('posts.id', ondelete='CASCADE'), primary_key=True), db.Column("tag_id", db.Integer, db.ForeignKey('tags.id', ondelete='CASCADE'), primary_key=True)) class TagQuery(BaseQuery): def cloud(self): tags = self.filter(Tag.num_posts > 0).all() if not tags: return [] max_posts = max(t.num_posts for t in tags)
# """ # 归经 # """ # __tablename__ = 'tb_herb_meridian' # id = Column(Integer, autoincrement=True, primary_key=True) # tb_herb = relationship('Herb') # bin_hid = Column(String(32), # ForeignKey('tb_herb.bin_hid', ondelete='CASCADE')) # type_id = Column(Integer) # s_meridian = Column(String(20), comment=u"归经", nullable=False) # 归经 herb_property_table = db.Table( "tb_rel_herb_property", db.metadata, db.Column( "herb_id", db.String(36), db.ForeignKey("tb_herb.bin_hid", ondelete="CASCADE") ), db.Column( "property_id", BigInteger, db.ForeignKey("tb_dic_data.id", ondelete="CASCADE") ), ) class HerbAlias(BaseModel): """ 别名 """ __tablename__ = "tb_herb_alias" id = Column(Integer, autoincrement=True, primary_key=True) # tb_herb = relationship('Herb') bin_hid = Column(String(32), ForeignKey("tb_herb.bin_hid", ondelete="CASCADE"))
# coding:utf-8 from flask_security.models import fsqla_v2 as fsqla from application.extensions import db role_resource_table = db.Table( "tb_rel_role_resource", db.metadata, db.Column("role_id", db.Integer, db.ForeignKey("role.id")), db.Column("resource_id", db.String(36), db.ForeignKey("resource.id")), ) class Role(db.Model, fsqla.FsRoleMixin): def get_id(self): return str(self.id) def to_dict_simple(self): return dict([(k, getattr(self, k)) for k in self.__dict__.keys() if not k.startswith("_")]) @staticmethod def data_table_fields() -> list: """ 数据表的字段列表 Returns: """ return ["id", "update_datetime", "s_name", "description"]
@contact: [email protected] @software: Pycharm @file: related_tables.py @time: 2021/1/29 21:37 @desc: """ from application.extensions import db target_gene_table = db.Table( "tb_rel_target_gene", db.metadata, db.Column( "target_id", db.String(36), db.ForeignKey("tb_target.bin_id", ondelete="CASCADE"), ), db.Column( "ingredient_id", db.String(36), db.ForeignKey("tb_ingredient.bin_id", ondelete="CASCADE"), ), db.Column("s_name", db.String(100), comment="关系名", default="TargetGene"), ) herb_tcm_table = db.Table( "tb_rel_herb_tcm", db.metadata, db.Column("herb_id", db.String(36), db.ForeignKey("tb_herb.bin_hid", ondelete="CASCADE")), db.Column( "tcm_id",