class Office(db.Model):
__tablename__ = 'office'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.String(5), nullable=False)
english_name = db.Column(db.String(125), nullable=False)
@property
def serialize(self):
return to_json(self, self.__class__)
class Department(db.Model):
__tablename__ = 'department'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.String(3), nullable=False)
english_name = db.Column(db.String(60), nullable=False)
chinese_name = db.Column(db.String(60), nullable=False)
@property
def serialize(self):
return to_json(self, self.__class__)
class People(db.Model):
__tablename__ = 'people'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(55), nullable=False)
gender = db.Column(ENUM('F', 'M'), nullable=False)
mobile = db.Column(db.String(30))
phone = db.Column(db.String(125))
wechat = db.Column(db.String(125))
email = db.Column(db.String(125))
attendance = db.Column(db.Integer)
first_name = db.Column(db.String(155), nullable=False)
last_name = db.Column(db.String(155), nullable=False)
chinese_name = db.Column(db.String(60), nullable=False)
start_date = db.Column(db.Date)
level_id = db.Column(db.Integer)
office_id = db.Column(db.Integer, db.ForeignKey('office.id'))
department_id = db.Column(db.Integer, db.ForeignKey('department.id'))
title_id = db.Column(db.Integer, db.ForeignKey('title.id'))
logical_company_id = db.Column(db.Integer,
db.ForeignKey('logical_company.id'))
class Logical_company(db.Model):
__tablename__ = 'logical_company'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.String(3), nullable=False)
class Title(db.Model):
__tablename__ = 'title'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
english_name = db.Column(db.String(255), nullable=False)
wiki_title = db.Column(db.String(255), nullable=False)
wiki_title_cn = db.Column(db.String(255), nullable=False)
from db.exts import db
from sqlalchemy.dialects.mysql.enumerated import ENUM
import pymysql
import json
pymysql.install_as_MySQLdb()
t_book_view = db.Table('book_view',
db.Column('id', db.Integer, primary_key=True),
db.Column('username', db.String(55)),
db.Column('gender', ENUM('F', 'M')),
db.Column('mobile', db.String(30)),
db.Column('phone', db.String(125)),
db.Column('wechat', db.String(125)),
db.Column('email', db.String(125)),
db.Column('attendance', db.Integer),
db.Column('first_name', db.String(155)),
db.Column('last_name', db.String(155)),
db.Column('chinese_name', db.String(60)),
db.Column('office_id', db.Integer),
db.Column('department_id', db.Integer),
db.Column('title_id', db.Integer),
db.Column('logical_company_id', db.Integer),
db.Column('dep_code', db.String(3)),
db.Column('dep_english_name', db.String(60)),
db.Column('dep_chinese_name', db.String(60)),
db.Column('office_code', db.String(5)),
db.Column('start_date', db.Date),
db.Column('level_id', db.Integer),
db.Column('office_english_name', db.String(125)),
db.Column('title', db.String(255)),
db.Column('title_cn', db.String(255)),