report_sprint = db.relationship('Report') class EmployeeRole(db.Model): __tablename__ = 'Employee_role' id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(45), nullable=False) t_Employee_task = db.Table( 'Employee_task', db.metadata, db.Column('employee_id', db.ForeignKey('Employee.id'), primary_key=True, nullable=False, index=True), db.Column('task_id', db.ForeignKey('Task.id'), primary_key=True, nullable=False, index=True)) class FreetimeType(db.Model): __tablename__ = 'Freetime_type' id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(45), nullable=False) class Project(db.Model):
for obj in session._changes['delete']: if isinstance(obj, SearchableMixin): remove_from_index(obj.__tablename__, obj) session._changes = None @classmethod def reindex(cls): for obj in cls.query: add_to_index(cls.__tablename__, obj) db.event.listen(db.session, 'before_commit', SearchableMixin.before_commit) db.event.listen(db.session, 'after_commit', SearchableMixin.after_commit) followers = db.Table( 'followers', db.Column('follower_id', db.Integer, db.ForeignKey('user.id')), db.Column('followed_id', db.Integer, db.ForeignKey('user.id'))) class User(UserMixin, db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) password_hash = db.Column(db.String(128)) posts = db.relationship('Post', backref='author', lazy='dynamic') about_me = db.Column(db.String(140)) last_seen = db.Column(db.DateTime, default=datetime.utcnow) followed = db.relationship('User', secondary=followers, primaryjoin=(followers.c.follower_id == id), secondaryjoin=(followers.c.followed_id == id),
import datetime import hashlib import re import urllib.parse from my_app import bcrypt, db, login_manager def slugify(title): return re.sub('[^\w]+', '-', title).lower() entry_tags = db.Table( 'entry_tags', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')), db.Column('entry_id', db.Integer, db.ForeignKey('entry.id')), ) class Entry(db.Model): STATUS_PUBLIC = 0 STATUS_DRAFT = 1 STATUS_DELETED = 2 id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) slug = db.Column(db.String(100), unique=True) body = db.Column(db.Text) status = db.Column(db.SmallInteger, default=STATUS_PUBLIC) created_timestamp = db.Column(db.DateTime, default=datetime.datetime.now) modified_timestamp = db.Column(
"lawyers_name": self.lawyers_name, "lawyers_password": self.lawyers_password, "lawyers_email": self.lawyers_email, "lawyers_rut": self.lawyers_rut, "lawyers_phone": self.lawyers_phone, "lawyers_field": self.lawyers_field, "lawyers_title": self.lawyers_title, "lawyers_file_speciality": self.lawyers_file_speciality, "lawyers_bank": self.lawyers_bank, "lawyers_account": self.lawyers_account, "lawyers_bank_number": self.lawyers_bank_number } lawyer_case = db.Table('lawyer_case', db.Column('lawyers_id', db.Integer, db.ForeignKey('lawyers.lawyers_id'), primary_key=True), db.Column('cases_id', db.Integer, db.ForeignKey('cases.cases_id'), primary_key=True) ) class Case(db.Model): __tablename__ ='cases' cases_id = db.Column(db.Integer, primary_key=True) cases_matter = db.Column(db.String(20), unique=False, nullable=False) cases_date = db.Column(db.DateTime, unique=False, nullable=False) cases_description = db.Column(db.Text(300), unique=False, nullable=False) client_id = db.Column(db.Integer, db.ForeignKey('clients.clients_id')) cases_documents = db.relationship('Document', backref='Case', lazy=True) lawyers_case = db.relationship('Lawyer', secondary=lawyer_case, lazy='subquery', backref=db.backref('case', lazy=True)) def __repr__(self): return '<Case %r>' % self.cases_id, self.cases_matter, self.cases_date, self.cases_description
from werkzeug.security import generate_password_hash, check_password_hash from flask_wtf import FlaskForm from wtforms import TextField, PasswordField from wtforms.validators import InputRequired, EqualTo from my_app import db roles = db.Table('role_users', db.Column('user_id', db.Integer, db.ForeignKey('user.id')), db.Column('role_id', db.Integer, db.ForeignKey('role.id'))) class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(100)) pwdhash = db.Column(db.String()) roles = db.relationship('Role', secondary=roles, backref=db.backref('users', lazy='dynamic')) def __init__(self, username, password): default = Role.query.filter_by(name='default').one() self.roles.append(default) self.username = username self.pwdhash = generate_password_hash(password) def has_role(self, name): for role in self.roles: if role.name == name: return True return False
wechat_id (str): 公众号id """ id = db.Column(db.Integer, primary_key=True) app_id = db.Column(db.String(255), unique=True) app_secret = db.Column(db.String(255)) wechat_id = db.Column(db.String(255)) token = db.Column(db.String(255)) access_token = db.Column(db.String(255)) expired_time = db.Column(db.Integer) account_id = db.Column(db.Integer, db.ForeignKey('account.id')) account = db.relationship('Account', backref=db.backref('tokens', lazy='dynamic')) tags = db.Table('tags', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')), db.Column('user_id', db.Integer, db.ForeignKey('user.id'))) class Tag(db.Model): """用户标签类 Attributes: count (str): 该标签下的用户数 id (int): 自增键 name (str): 标签名 """ id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255)) count = db.Column(db.Integer)
# write a class for each type of entity that we are going to start in the database. from datetime import datetime from werkzeug.security import generate_password_hash, check_password_hash from flask_login import UserMixin from my_app import db, login from flask import current_app from hashlib import md5 from time import time import jwt followers = db.Table( "followers", db.Column("follower_id", db.Integer, db.ForeignKey("user.id")), db.Column("followed_id", db.Integer, db.ForeignKey("user.id"))) class User(UserMixin, db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) password_hash = db.Column(db.String(128)) posts = db.relationship("Post", backref="author", lazy="dynamic") about_me = db.Column(db.String(140)) last_seen = db.Column(db.DateTime, default=datetime.utcnow) followed = db.relationship('User', secondary=followers, primaryjoin=(followers.c.follower_id == id), secondaryjoin=(followers.c.followed_id == id), backref=db.backref("followers", lazy="dynamic"), lazy="dynamic")