class ParkInfo(Base, MixinModelJSONSerializer):
"""城南新区信息"""
__tablename__ = 'park_info'
id = db.Column(db.Integer, primary_key=True, doc="资讯分类自增ID")
name = db.Column(db.String(20), unique=True, nullable=False)
url = db.Column(db.String(20))
dec = db.Column(db.Text)
class ParkIndustryShow(Base, MixinModelJSONSerializer):
"""
资讯分类
"""
__tablename__ = 'park_ind_show'
id = db.Column(db.Integer, primary_key=True, doc="资讯分类自增ID")
type = db.Column(db.String(20))
active = db.Column(db.SmallInteger, default=0)
class ParkMerchant(Base, MixinModelJSONSerializer):
"""
招商资讯
"""
__tablename__ = 'park_merchant'
id = db.Column(db.Integer, primary_key=True, doc="招商资讯自增ID")
title = db.Column(db.String(20))
content = db.Column(db.String(20))
class ParkBreaking(Base, MixinModelJSONSerializer):
"""
大事件
"""
__tablename__ = 'park_breaking'
id = db.Column(db.Integer, primary_key=True, doc="大事件自增ID")
title = db.Column(db.String(20))
note = db.Column(db.Text)
class ParkPush(Base, MixinModelJSONSerializer):
"""
需求推送
"""
__tablename__ = 'park_push'
id = db.Column(db.Integer, primary_key=True, doc="需求推送自增ID")
company = db.Column(db.String(20))
type = db.Column(db.SmallInteger)
content = db.Column(db.Text)
class EduExperience(Base, MixinModelJSONSerializer):
__tablename__ = 'edu_experience'
id = db.Column(db.Integer, primary_key=True)
school = db.Column(db.String(32), nullable=False)
# 所学专业
specialty = db.Column(db.String(32), nullable=False)
degree = db.Column(db.String(16))
resume_id = db.Column(db.Integer, db.ForeignKey('resume.id'))
resume = db.relationship('Resume', uselist=False)
class Resume(Base, MixinModelJSONSerializer):
__tablename__ = 'resume'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
user = db.relationship('User', uselist=False)
job_experiences = db.relationship('JobExperience')
edu_experiences = db.relationship('EduExperience')
project_experiences = db.relationship('ProjectExperience')
def profile(self):
pass
class ParkIndustrialPark(Base, MixinModelJSONSerializer):
"""园区实景"""
__tablename__ = 'park_indupark'
id = db.Column(db.Integer, primary_key=True, doc="行业资讯自增ID")
type = db.Column(db.SmallInteger)
name = db.Column(db.String(20), unique=True, nullable=False)
_image = db.Column('image', db.String(50))
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkEnterprise(Base, MixinModelJSONSerializer):
"""企业风采"""
__tablename__ = 'park_enterprise'
id = db.Column(db.Integer, primary_key=True, doc="行业资讯自增ID")
name = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
content = db.Column(db.Text)
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkSmallTown(Base, MixinModelJSONSerializer):
"""数梦小镇"""
__tablename__ = 'park_smalltown'
id = db.Column(db.Integer, primary_key=True, doc="行业资讯自增ID")
name = db.Column(db.String(20), unique=True, nullable=False)
_image = db.Column('image', db.String(50))
dec = db.Column(db.Text)
content = db.Column(db.Text)
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkNews(Base, MixinModelJSONSerializer):
"""
新闻动态
"""
__tablename__ = 'park_news'
id = db.Column(db.Integer, primary_key=True, doc="新闻动态自增ID")
title = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
content = db.Column(db.Text)
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkPolicy(Base, MixinModelJSONSerializer):
"""
园区政策
"""
__tablename__ = 'park_policy'
id = db.Column(db.Integer, primary_key=True, doc="政策动态自增ID")
title = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
_file = db.Column('file', db.String(32))
type = db.Column(db.String(20))
content = db.Column(db.Text)
@property
def image(self):
"""
处理图片
:return:
"""
return self._image
@image.setter
def image(self, filename):
self._image = filename
@property
def file(self):
"""
处理文件
:return:
"""
return self._file
@file.setter
def file(self, filename):
self._file = filename
class ProjectExperience(Base, MixinModelJSONSerializer):
__tablename__ = 'preject_experience'
id = db.Column(db.Integer, primary_key=True)
begin_at = db.Column(db.DateTime)
end_at = db.Column(db.DateTime)
name = db.Column(db.String(32), nullable=False)
# 在项目中扮演的角色
role = db.Column(db.String(32))
# 多个技术用逗号隔开
technologys = db.Column(db.String(64))
resume_id = db.Column(db.Integer, db.ForeignKey('resume.id'))
resume = db.relationship('Resume', uselist=False)
class JobExperience(Base, MixinModelJSONSerializer):
__tablename__ = 'job_experience'
id = db.Column(db.Integer, primary_key=True)
begin_at = db.Column(db.DateTime)
end_at = db.Column(db.DateTime)
company = db.Column(db.String(32), nullable=False)
city = db.Column(db.String(32), nullable=False)
resume_id = db.Column(db.Integer, db.ForeignKey('resume.id'))
resume = db.relationship('Resume', uselist=False)
class ParkCircum(Base, MixinModelJSONSerializer):
"""
周边园区
"""
__tablename__ = 'park_circum'
id = db.Column(db.Integer, primary_key=True, doc="周边自增ID")
title = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
city = db.Column(db.String(20))
url = db.Column(db.String(20))
mobile = db.Column(db.String(20))
content = db.Column(db.Text)
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkIndustry(Base, MixinModelJSONSerializer):
"""
行业资讯
"""
__tablename__ = 'park_industry'
id = db.Column(db.Integer, primary_key=True, doc="行业资讯自增ID")
title = db.Column(db.String(20))
type = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
content = db.Column(db.String(20))
remark = db.Column(db.String(20))
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
class ParkEduNotices(Base, MixinModelJSONSerializer):
"""
园区&政府动态
"""
__tablename__ = 'park_notices'
id = db.Column(db.Integer, primary_key=True, doc="园区动态自增ID")
title = db.Column(db.String(20))
_image = db.Column('image', db.String(50))
type = db.Column(db.String(20))
content = db.Column(db.Text)
introduction = db.Column(db.String(30))
@property
def image(self):
return self._image
@image.setter
def image(self, filename):
self._image = filename
# -*- encoding:utf-8 -*-
"""
@ Created by Seven on 2018/06/20
"""
from flask import g, current_app
from werkzeug.security import generate_password_hash, check_password_hash
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from app.libs.data_scope import (admin_scope, company_scope, user_scope,
literacy_scope, property_scope,
merchants_cope, get_defualt)
from app.libs.error_code import AuthFailed, UserNotExistException
from app.libs.model_base import (db, Base, MixinModelJSONSerializer)
user_job = db.Table(
'user_job',
db.Column('user_id', db.Integer,
db.ForeignKey('user.id', ondelete='CASCADE')),
db.Column('job_id', db.Integer, db.ForeignKey('job.id',
ondelete='CASCADE')))
class User(Base, MixinModelJSONSerializer):
id = db.Column(db.Integer, primary_key=True, comment="用户自增ID")
auth = db.Column(db.SmallInteger, default=100, comment="默认组")
username = db.Column(db.String(24),
unique=True,
nullable=True,
comment="用户名")
nickname = db.Column(db.String(24),
unique=True,
nullable=False,
comment="用户昵称")
