class UserModel(BaseModel): __tablename__ = 'user_client' username = db.Column(db.String(32), unique=True) _password = db.Column(db.String(256)) phone = db.Column(db.String(32), unique=True) is_delete = db.Column(db.Boolean, default=False) permission = db.Column(db.Integer, default=COMMON_USER_CLIENT_PERMISSION) @property def password(self): return self._password @password.setter def password(self, passwd): self._password = generate_password_hash(password=passwd) def check_password(self, passwd=None): if passwd is None: passwd = '' if check_password_hash(self._password, passwd): return True return False def check_permission(self, permission): return permission & self.permission == permission
class CityModel(BaseModel): __tablename__ = 'city' city_id = db.Column(db.Integer, unique=True) parent_id = db.Column(db.Integer, default=0) region_name = db.Column(db.String(256), nullable=True) city_code = db.Column(db.Integer, unique=True, default=0) pin_yin = db.Column(db.String(256), nullable=True) letter = db.Column(db.String(256), nullable=False)
class CinemaModel(BaseModel): ''' insert into cinemas(name,city,district,address,phone,score,hallnum,servicecharge,astrict,flag,isdelete) values("深圳戏院影城","深圳","罗湖","罗湖区新园路1号东门步行街西口","0755-82175808",9.7,9,1.2,20,1,0); ''' __tablename__ = 'cinemas' name = db.Column(db.String(256), name='name') city = db.Column(db.String(256), name='city') district = db.Column(db.String(256), name='district') address = db.Column(db.String(256), name='address') phone = db.Column(db.String(256), name='phone') score = db.Column(db.Integer, name='score') hall_num = db.Column(db.Integer, name='hallnum') service_charge = db.Column(db.Integer, name='servicecharge') astrict = db.Column(db.Integer, name='astrict') flag = db.Column(db.Integer, name='flag') is_delete = db.Column(db.Boolean, name='isdelete') cinema_user_id = db.Column(db.Integer, db.ForeignKey(CinemaUserModel.id), default=1)
class CinemaUserModel(BaseModel): __tablename__ = 'cinema_user' username = db.Column(db.String(256), unique=True) _password = db.Column(db.String(256), nullable=False) is_delete = db.Column(db.Boolean, default=False) is_verify = db.Column(db.Boolean, default=False) @property def password(self): return self._password @password.setter def password(self, passwd): self._password = generate_password_hash(password=passwd) def check_password(self, passwd=None): if passwd is None: passwd = '' if check_password_hash(self._password, passwd): return True return False
class MovieModel(BaseModel): __tablename__ = 'movies' ''' insert into movies(id, showname, shownameen, director, leadingRole, type, country, language, duration, screeningmodel, openday, backgroundpicture, flag, isdelete) values(228830,"梭哈人生","The Drifting Red Balloon","郑来志","谭佑铭,施予斐,赵韩樱子,孟智超,李林轩","剧情,爱情,喜剧","中国大陆","汉语普通话",90,"4D" ,date("2018-01-30 00:00:00"),"i1/TB19_XCoLDH8KJjy1XcXXcpdXXa_.jpg",1,0); ''' show_name = db.Column(db.String(256), name='showname', ) show_name_en = db.Column(db.String(256), name='shownameen') director = db.Column(db.String(256)) leading_role = db.Column(db.String(256), name='leadingRole') type = db.Column(db.String(256)) country = db.Column(db.String(256)) language = db.Column(db.String(256)) duration = db.Column(db.Integer) screening_model = db.Column(db.String(256), name='screeningmodel') open_day = db.Column(db.Date, name='openday') background_picture = db.Column(db.String(256), name='backgroundpicture') flag = db.Column(db.Integer, default=1) is_delete = db.Column(db.Boolean, default=0, name='isdelete')
class Permissions(BaseModel): __tablename__ = 'permissions' p_name = db.Column(db.String(256), unique=True)