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())
