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