class TagsTree(db.Model): """Древовидная структура тегов""" __bind_key__ = 'caesar' __tablename__ = '%s_tags_tree' % TABLE_PREFIX id = db.Column(db.Integer, primary_key=True, autoincrement=True) tag_id = db.Column(db.Integer, db.ForeignKey('%s_tag.id' % TABLE_PREFIX), index=True) parent_id = db.Column(db.Integer, db.ForeignKey('%s.id' % __tablename__), index=True) template_id = db.Column(db.Integer, db.ForeignKey('%s_template.id' % TABLE_PREFIX), nullable=False, index=True) ordernum = db.Column(db.Integer, doc=u'Поле для сортировки тегов') tag = db.relationship(Tag) parent = db.relationship('TagsTree', remote_side=[id], backref=db.backref('children', order_by=ordernum)) # template = db.relationship(Template) __table_args__ = {'order_by': ordernum} def __unicode__(self): return self.tag.code
class BaoCaoNghiNgoNhiemBenhQuocGia(CommonModel): __tablename__ = 'baocaonghingonhiembenhquocgia' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True) baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhquocgia',lazy='dynamic')) tenquocgia = db.Column(db.String()) ngaydiqua = db.Column(db.DateTime())
class BangDichBenh(CommonModel): __tablename__ = 'bangdichbenh' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangdichbenh',lazy='dynamic')) cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String(25)) sothutu = db.Column(db.SmallInteger()) db_csbc = db.Column(db.Integer()) db_dvdtc = db.Column(db.Integer()) db_dvkd = db.Column(db.Integer()) db_mdc = db.Column(db.Integer()) db_mdm = db.Column(db.Integer()) db_sldtc = db.Column(db.Integer()) db_slgs = db.Column(db.Integer()) db_sxdtc = db.Column(db.Integer()) db_sxkd = db.Column(db.Integer()) #bosung: db_mdc_slgs = db.Column(db.Integer()) db_mdc_slxl = db.Column(db.Integer()) db_csbc_slgs = db.Column(db.Integer()) db_csbc_slxl = db.Column(db.Integer()) db_mdm_slgs = db.Column(db.Integer()) db_mdm_slxl = db.Column(db.Integer()) db_csdv_slgs = db.Column(db.Integer()) db_csdv_sld = db.Column(db.Integer()) db_cssx_slgs = db.Column(db.Integer()) db_cssx_sld = db.Column(db.Integer())
class BangHangHoa(CommonModel): __tablename__ = 'banghanghoa' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('banghanghoa',lazy='dynamic')) cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String(25)) sothutu = db.Column(db.SmallInteger()) hh_nc_bpbk_sl = db.Column(db.Integer()) hh_nc_bpbk_skt = db.Column(db.Integer()) hh_nc_bpbk_sxl = db.Column(db.Integer()) hh_nc_hhk_tl = db.Column(db.Float()) hh_nc_hhk_skt = db.Column(db.Integer()) hh_nc_hhk_sxl = db.Column(db.Integer()) hh_nc_ghichu = db.Column(db.String()) hh_xc_bpbk_sl = db.Column(db.Integer()) hh_xc_bpbk_skt = db.Column(db.Integer()) hh_xc_bpbk_sxl = db.Column(db.Integer()) hh_xc_hhk_tl = db.Column(db.Float()) hh_xc_hhk_skt = db.Column(db.Integer()) hh_xc_hhk_sxl = db.Column(db.Integer()) hh_xc_ghichu = db.Column(db.String()) hh_qc_bpbk_sl = db.Column(db.Integer()) hh_qc_bpbk_skt = db.Column(db.Integer()) hh_qc_bpbk_sxl = db.Column(db.Integer()) hh_qc_hhk_tl = db.Column(db.Float()) hh_qc_hhk_skt = db.Column(db.Integer()) hh_qc_hhk_sxl = db.Column(db.Integer()) hh_qc_ghichu = db.Column(db.String())
class CuaKhau(CommonModel): __tablename__ = 'cuakhau' id = db.Column(db.Integer, primary_key=True) ma = db.Column(db.String(255), unique=True) ten = db.Column(db.String(255), nullable=False) #loaicuakhau = db.Column(db.SmallInteger) # kiemdichyte = db.Column(db.Boolean, default=True) phongcachly = db.Column(db.Boolean, default=True) nguoilienlac = db.Column(db.String(255), nullable=True) sodienthoai = db.Column(db.String, nullable=True) diachi = db.Column(db.String, nullable=True) email = db.Column(db.String, nullable=True) donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True) donvi = db.relationship('DonVi', backref=db.backref('cuakhau',lazy='dynamic'),viewonly=True) tinhthanh_id = db.Column(db.Integer,db.ForeignKey('tinhthanh.id'), nullable=True) tinhthanh = db.relationship('TinhThanh',viewonly=True) thutu = db.Column(db.Integer, nullable=True) #loaicuakhau duongboquocte = db.Column(db.Boolean, default=False) duongbochinh = db.Column(db.Boolean, default=False) duongbophu = db.Column(db.Boolean, default=False) duongsat = db.Column(db.Boolean, default=False) duonghangkhong = db.Column(db.Boolean, default=False) duongthuyloai1 = db.Column(db.Boolean, default=False) duongthuyloai2 = db.Column(db.Boolean, default=False) quocgia_tiepgiap = db.Column(db.String, nullable=True) cuakhau_tiepgiap = db.Column(db.String, nullable=True)
class BangKinhPhi(CommonModel): __tablename__ = 'bangkinhphi' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangkinhphi',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) nguonkinhphi = db.Column(db.String()) kinhphi = db.Column(db.Float())
class BaoCaoNghiNgoNhiemBenhXetNghiem(CommonModel): __tablename__ = 'baocaonghingonhiembenhxetnghiem' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True) baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhxetnghiem',lazy='dynamic')) loaimauxetnghiem = db.Column(db.String()) ngaylay = db.Column(db.DateTime()) ketqua = db.Column(db.String())
class BangHopTacQuocTe(CommonModel): __tablename__ = 'banghoptacquocte' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('banghoptacquocte',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) quocgia = db.Column(db.String()) noidung = db.Column(db.String())
class GamePhoto(db.Model): __tablename__ = "game_photo" id = db.Column(db.Integer, primary_key=True) path = db.Column(db.String(255), unique=True) url = db.Column(db.Text()) game_id = db.Column(db.Integer, db.ForeignKey("games.id")) game = db.relationship("Game", uselist=False, backref=db.backref("game_photo", uselist=False))
class BangVienCanBo(CommonModel): __tablename__ = 'bangviencanbo' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangviencanbo',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) trinhdochuyenmon = db.Column(db.String()) soluongchuyentrach = db.Column(db.Integer()) soluongkiemnhiem = db.Column(db.Integer())
class BaoCaoNghiNgoNhiemBenhNguoiTiepXuc(CommonModel): __tablename__ = 'baocaonghingonhiembenhnguoitiepxuc' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True) baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhnguoitiepxuc',lazy='dynamic')) hoten = db.Column(db.String()) quoctich = db.Column(db.String()) cmtnd = db.Column(db.String()) dienthoai = db.Column(db.String()) email = db.Column(db.String())
class BangVienHoatDongChung(CommonModel): __tablename__ = 'bangvienhoatdongchung' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangvienhoatdongchung',lazy='dynamic')) noidung = db.Column(db.String()) sothutu = db.Column(db.SmallInteger()) tenhoatdong = db.Column(db.String()) soluong = db.Column(db.Integer())
class BaoCaoNghiNgoNhiemBenhVacxin(CommonModel): __tablename__ = 'baocaonghingonhiembenhvacxin' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True) baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhvacxin',lazy='dynamic')) tenvacxin = db.Column(db.String()) solandung = db.Column(db.SmallInteger) ngaydunggannhat = db.Column(db.DateTime()) ketqua = db.Column(db.String())
class UserDonvi(CommonModel): __tablename__ = 'user_donvi' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) fullname = db.Column(db.String(255)) email = db.Column(db.String(255)) password = db.Column(db.String(255)) cfpassword = db.Column(db.String(255)) phone = db.Column(db.String(255)) macongdan = db.Column(String(200)) user_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id', onupdate="CASCADE", ondelete="SET NULL"), nullable=True) users = db.relationship('User', viewonly=True) donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id', onupdate="CASCADE", ondelete="SET NULL"), nullable=True) donvi = db.relationship('DonVi', foreign_keys=[donvi_id], viewonly=True) donvi_sodienthoai = db.Column(db.String()) donvi_diachi = db.Column(db.String()) donvi_ten = db.Column(db.String()) donvi_tuyendonvi_id = db.Column(db.Integer, db.ForeignKey('tuyendonvi.id', onupdate="SET NULL"), nullable=True) donvi_tuyendonvi = db.relationship('TuyenDonVi') xaphuong_id = db.Column(UUID(as_uuid=True), ForeignKey('xaphuong.id'), nullable=True) xaphuong = relationship('XaPhuong') quanhuyen_id = db.Column(UUID(as_uuid=True), ForeignKey('quanhuyen.id'), nullable=True) quanhuyen = relationship('QuanHuyen') tinhthanh_id = db.Column(UUID(as_uuid=True), ForeignKey('tinhthanh.id'), nullable=True) tinhthanh = relationship('TinhThanh', viewonly=True) quocgia_id = db.Column(UUID(as_uuid=True), ForeignKey('quocgia.id'), nullable=True) quocgia = relationship('QuocGia') captren_id = db.Column(db.Integer, db.ForeignKey('donvi.id', onupdate="CASCADE", ondelete="SET NULL"), nullable=True) captren = db.relationship('DonVi', foreign_keys=[captren_id], backref=db.backref('user_donvi', lazy='dynamic'), viewonly=True) trangthai = db.Column(db.SmallInteger, default=2)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) draft = db.Column(db.Integer) tags = db.relationship("Tag", secondary=tag_table, backref=db.backref('posts', lazy='dynamic'), lazy='dynamic') #Tag.posts user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) #user.id = primary_key of User thumbnail = db.Column(db.String(32), default="default.jpg") likes = db.relationship("Like", backref=db.backref('post'), lazy="dynamic") #Post.liked_users def __repr__(self): return f"Post({self.title}, {self.date_posted} Draft: {self.draft} {self.content})"
class BangTiemChung(CommonModel): __tablename__ = 'bangtiemchung' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangtiemchung',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tenbenh = db.Column(db.String()) tenvacxin = db.Column(db.String()) soluong = db.Column(db.Integer()) ghichu = db.Column(db.String())
class BangXetNghiem(CommonModel): __tablename__ = 'bangxetnghiem' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangxetnghiem',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) loaixetnghiem = db.Column(db.String()) soluongmau = db.Column(db.Integer()) dattieuchuan = db.Column(db.Integer()) ghichu = db.Column(db.String())
class BangVienSuKien(CommonModel): __tablename__ = 'bangviensukien' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangviensukien',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tensukien = db.Column(db.String()) diadiem = db.Column(db.String()) bienphap = db.Column(db.String()) ketqua = db.Column(db.String())
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) password = db.Column(db.String(120)) permissions = db.relationship('Permission', secondary=user_permissions, backref=db.backref('users', lazy='dynamic')) def __init__(self, username, password): self.username = username self.password = password
class BangTruyenThong(CommonModel): __tablename__ = 'bangtruyenthong' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangtruyenthong',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) hinhthuc = db.Column(db.String()) noidung = db.Column(db.String()) doituong = db.Column(db.String()) ketqua = db.Column(db.Integer())
class BangNghienCuuKhoaHoc(CommonModel): __tablename__ = 'bangnghiencuukhoahoc' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangnghiencuukhoahoc',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tendetai = db.Column(db.String()) thoigianthuchien = db.Column(db.String()) detaicap = db.Column(db.String()) linhvucnghiencuu = db.Column(db.String())
class User(db.Model): __tablename__ = 'na_user' __table_args__ = {'extend_existing': True} uuid = db.Column(UUID(), primary_key=True, default=uuid_ext.uuid4) firstname = db.Column(db.String(255), index=True, nullable=False) secondname = db.Column(db.String(255), index=True, nullable=False) email = db.Column(db.String(255), index=True, unique=True, nullable=False) password_hash = db.Column(db.String(128)) thirdparty_authenticated = db.Column(db.Boolean, nullable=False, default=False) thirdparty_name = db.Column(db.String(255)) authenticated = db.Column(db.Boolean, nullable=False, default=False) last_login_at = db.Column(db.DateTime()) current_login_at = db.Column(db.DateTime()) last_login_ip = db.Column(db.String(100)) current_login_ip = db.Column(db.String(100)) login_count = db.Column(db.Integer) active = db.Column(db.Boolean()) roles = relationship('Role', secondary=user_role_assoc, backref=db.backref('users', lazy='dynamic')) group_uuid = db.Column(UUID, db.ForeignKey('na_user_group.uuid')) group = relationship('Group', back_populates='users') group_admin = db.Column(db.Boolean, nullable=False, default=False) created = db.Column(db.DateTime, default=datetime.utcnow) updated = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow) def get_id(self): return self.uuid def is_authenticated(self): return self.authenticated def set_password(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password) def is_active(self): return self.active def add_roles(self, *roles): self.roles.extend([role for role in roles if role not in self.roles]) def remove_roles(self, *roles): self.roles = [role for role in self.roles if role not in roles]
class BangDaoTaoCanBo(CommonModel): __tablename__ = 'bangdaotaocanbo' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangdaotaocanbo',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) hinhthucdaotao = db.Column(db.String()) soluong = db.Column(db.Integer()) vesinhdichte = db.Column(db.Integer()) ytecongdong = db.Column(db.Integer()) xetnghiem = db.Column(db.Integer()) ngoaingu = db.Column(db.Integer()) khac = db.Column(db.Integer())
class BangPhuongTien(CommonModel): __tablename__ = 'bangphuongtien' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangphuongtien',lazy='dynamic')) cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String(25)) sothutu = db.Column(db.SmallInteger()) pt_nc_hk_sl = db.Column(db.Integer()) pt_nc_hk_skt = db.Column(db.Integer()) pt_nc_hk_sxl = db.Column(db.Integer()) pt_nc_db_sl = db.Column(db.Integer()) pt_nc_db_skt = db.Column(db.Integer()) pt_nc_db_sxl = db.Column(db.Integer()) pt_nc_dt_sl = db.Column(db.Integer()) pt_nc_dt_skt = db.Column(db.Integer()) pt_nc_dt_sxl = db.Column(db.Integer()) pt_nc_ghichu = db.Column(db.String()) pt_xc_ghichu = db.Column(db.String()) pt_qc_ghichu = db.Column(db.String()) pt_nc_ds_sl = db.Column(db.Integer()) pt_nc_ds_skt = db.Column(db.Integer()) pt_nc_ds_sxl = db.Column(db.Integer()) #pt_nc_ds_ghichu pt_xc_hk_sl = db.Column(db.Integer()) pt_xc_hk_skt = db.Column(db.Integer()) pt_xc_hk_sxl = db.Column(db.Integer()) pt_xc_db_sl = db.Column(db.Integer()) pt_xc_db_skt = db.Column(db.Integer()) pt_xc_db_sxl = db.Column(db.Integer()) pt_xc_dt_sl = db.Column(db.Integer()) pt_xc_dt_skt = db.Column(db.Integer()) pt_xc_dt_sxl = db.Column(db.Integer()) pt_xc_ds_sl = db.Column(db.Integer()) pt_xc_ds_skt = db.Column(db.Integer()) pt_xc_ds_sxl = db.Column(db.Integer()) pt_qc_hk_sl = db.Column(db.Integer()) pt_qc_hk_skt = db.Column(db.Integer()) pt_qc_hk_sxl = db.Column(db.Integer()) pt_qc_db_sl = db.Column(db.Integer()) pt_qc_db_skt = db.Column(db.Integer()) pt_qc_db_sxl = db.Column(db.Integer()) pt_qc_dt_sl = db.Column(db.Integer()) pt_qc_dt_skt = db.Column(db.Integer()) pt_qc_dt_sxl = db.Column(db.Integer()) pt_qc_ds_sl = db.Column(db.Integer()) pt_qc_ds_skt = db.Column(db.Integer()) pt_qc_ds_sxl = db.Column(db.Integer())
class Permission(CommonModel): __tablename__ = 'permission' id = db.Column(db.Integer, primary_key=True) role_id = db.Column(db.Integer, db.ForeignKey('role.id'), nullable=True) role = db.relationship('Role', backref=db.backref('permission', lazy='dynamic')) model = db.Column(db.String,index=True) canread = db.Column(db.Boolean,index=True, default=False) cancreate = db.Column(db.Boolean,index=True, default=False) canupdate = db.Column(db.Boolean,index=True, default=False) candelete = db.Column(db.Boolean,index=True, default=False) cancreateown = db.Column(db.Boolean,index=True, default=False) canupdateown = db.Column(db.Boolean,index=True, default=False) candeleteown = db.Column(db.Boolean,index=True, default=False) __table_args__ = (UniqueConstraint('role_id', 'model', name='uq_permission_rolename_modelname'),)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default="default.jpg") #user's profile picture password = db.Column(db.String(60), nullable=False) posts = db.relationship("Post", backref="author", lazy=True) bio = db.Column(db.String(200)) gender = db.Column(db.String(20)) role = db.Column(db.String(10), default="Member") liked_posts = db.relationship('Like', backref=db.backref('user'), lazy="dynamic") def get_reset_token(self, expires_seconds=1800): serializer_obj = Serializer(current_app.config["SECRET_KEY"], expires_seconds) return serializer_obj.dumps({"user_id": self.id}).decode() @staticmethod def verify_reset_token(token): serializer_obj = Serializer(current_app.config["SECRET_KEY"]) try: user_id = serializer_obj.loads(token)["user_id"] except: #token expired. itsdangerous.exc.SignatureExpired: Signature expired return None return User.query.get(user_id) def like_post(self, post): if not self.has_liked_post( post): #if the user has not already liked this post yet, like = Like(user_id=self.id, post_id=post.id) db.session.add(like) db.session.commit() def unlike_post(self, post): if self.has_liked_post(post): #if the user has already liked the post, Like.query.filter_by(user_id=self.id, post_id=post.id).delete() def has_liked_post(self, post): return Like.query.filter(Like.user_id == self.id, Like.post_id == post.id).count() > 0 def __repr__(self): return f"User({self.username}, {self.email}, {self.gender}, {self.bio}, {self.image_file})"
class User(CommonModel): __tablename__ = 'user' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) first_name = db.Column(db.String(255)) last_name = db.Column(db.String(255)) fullname = db.Column(db.String(255)) email = db.Column(db.String(255), unique=True) password = db.Column(db.String(255)) confirmpassword = db.Column(db.String(255)) active = db.Column(db.Boolean(), default=True) phone = db.Column(db.String(255), unique=True) birthday = db.Column(db.DateTime()) gender = db.Column(db.String(255)) macongdan = db.Column(db.String(255), unique=True) roles = db.relationship('Role', secondary=roles_users, backref=db.backref('users', lazy='dynamic')) donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False) donvi = db.relationship('DonVi', viewonly=True) confirmed_at = db.Column(db.DateTime()) last_login_at = db.Column(db.DateTime()) current_login_at = db.Column(db.DateTime()) last_login_ip = db.Column(db.String(255)) current_login_ip = db.Column(db.String(255)) login_count = db.Column(db.Integer) trangthai = db.Column(db.SmallInteger) def __repr__(self): """ Show user object info. """ return '<User: {}>'.format(self.id) def has_role(self, role): if isinstance(role, str): return role in (role.name for role in self.roles) else: return role in self.roles def add_role(self, role): pass def remove_role(self, role): pass
class Book(db.Model): __tablename__ = 'books' book_id = db.Column(db.Integer, primary_key=True, autoincrement=True) series_id = db.Column(db.Integer, nullable=False) book_name = db.Column(db.String(256), nullable=False) vol = db.Column(db.Integer, nullable=False, default=1) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) categories = db.relationship('Category', secondary=book_category, lazy='subquery', backref=db.backref('books', lazy=True)) places = db.relationship('Place', backref='places', lazy=True) def __init__(self, series_id, book_name, vol, user_id): self.series_id = series_id self.book_name = book_name self.vol = vol self.user_id = user_id
class Game(db.Model): __tablename__ = "games" id = db.Column(db.Integer, primary_key=True) uuid = db.Column(db.String(36), unique=True) title = db.Column(db.String(255)) details = db.Column(db.Text()) price = db.Column(db.Float()) genres = db.relationship( "Genre", secondary=game_genre, lazy="subquery", backref=db.backref("games", lazy=True), ) def __init__(self, title, details, price): self.uuid = str(uuid.uuid4()) self.title = title self.details = details self.price = price
class BangVSSH(CommonModel): __tablename__ = 'bangvssh' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True) baocao = db.relationship('BaoCao', backref=db.backref('bangvssh',lazy='dynamic')) cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String(25)) sothutu = db.Column(db.SmallInteger()) vssh_nc_vs_sl = db.Column(db.Integer()) vssh_nc_vs_skt = db.Column(db.Integer()) vssh_nc_vs_sxl = db.Column(db.Integer()) vssh_nc_sh_sl = db.Column(db.Integer()) vssh_nc_sh_skt = db.Column(db.Integer()) vssh_nc_sh_sxl = db.Column(db.Integer()) vssh_nc_mo_sl = db.Column(db.Integer()) vssh_nc_mo_skt = db.Column(db.Integer()) vssh_nc_mo_sxl = db.Column(db.Integer()) vssh_xc_vs_sl = db.Column(db.Integer()) vssh_xc_vs_skt = db.Column(db.Integer()) vssh_xc_vs_sxl = db.Column(db.Integer()) vssh_xc_sh_sl = db.Column(db.Integer()) vssh_xc_sh_skt = db.Column(db.Integer()) vssh_xc_sh_sxl = db.Column(db.Integer()) vssh_xc_mo_sl = db.Column(db.Integer()) vssh_xc_mo_skt = db.Column(db.Integer()) vssh_xc_mo_sxl = db.Column(db.Integer()) vssh_qc_vs_sl = db.Column(db.Integer()) vssh_qc_vs_skt = db.Column(db.Integer()) vssh_qc_vs_sxl = db.Column(db.Integer()) vssh_qc_sh_sl = db.Column(db.Integer()) vssh_qc_sh_skt = db.Column(db.Integer()) vssh_qc_sh_sxl = db.Column(db.Integer()) vssh_qc_mo_sl = db.Column(db.Integer()) vssh_qc_mo_skt = db.Column(db.Integer()) vssh_qc_mo_sxl = db.Column(db.Integer()) vssh_nc_ghichu = db.Column(db.String()) vssh_xc_ghichu = db.Column(db.String()) vssh_qc_ghichu = db.Column(db.String())