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