class Role(SurrogatePK, Model, RoleMixin):
__tablename__ = 'roles'
name = Column(db.String(80), unique=True)
description = db.Column(db.String(255))
def __repr__(self):
return '<Role({name})>'.format(name=self.name)
class RolePair(SurrogatePK, Model):
__tablename__ = 'role_pair'
member_role_id = ReferenceCol('roles', nullable=True)
leader_role_id = ReferenceCol('roles', nullable=True)
name = Column(db.String(80), unique=True)
description = db.Column(db.String(255))
member_role = relationship('Role', foreign_keys=[member_role_id], backref='member_pairs')
reviewer_user = relationship('Role', foreign_keys=[leader_role_id], backref='leader_pairs')
def __repr__(self):
return '<RolePair({name})>'.format(name=self.name)
class Role(SurrogatePK, Model, RoleMixin):
__tablename__ = 'roles'
name = Column(db.String(80), unique=True)
description = db.Column(db.String(255))
#user_id = ReferenceCol('users', nullable=True)
#user = relationship('User', backref='roles')
# def __init__(self, name, **kwargs):
# db.Model.__init__(self, name=name, **kwargs)
def __repr__(self):
return '<Role({name})>'.format(name=self.name)
# -*- coding: utf-8 -*-
import datetime as dt
from flask_security import UserMixin, RoleMixin
from flask_security.utils import verify_and_update_password, encrypt_password
from recruit_app.extensions import bcrypt
from recruit_app.database import Column, db, Model, ReferenceCol, relationship, SurrogatePK, TimeMixin
roles_users = db.Table(
'roles_users', db.Column('user_id', db.Integer(),
db.ForeignKey('users.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('roles.id')))
class Role(SurrogatePK, Model, RoleMixin):
__tablename__ = 'roles'
name = Column(db.String(80), unique=True)
description = db.Column(db.String(255))
def __repr__(self):
return '<Role({name})>'.format(name=self.name)
class User(SurrogatePK, Model, UserMixin):
__tablename__ = 'users'
email = Column(db.String(80), unique=True, nullable=False)
#: The hashed password
password = Column(db.String(128), nullable=True)
created_at = Column(db.DateTime,
nullable=False,
# import flask_whooshalchemy as whooshalchemy
# from sqlalchemy_searchable import make_searchable
# from sqlalchemy_utils.types import TSVectorType, ScalarListType
#
# from sqlalchemy_searchable import SearchQueryMixin
from flask_sqlalchemy import BaseQuery
# from sqlalchemy.dialects import postgresql
import datetime
# make_searchable()
character_apps = db.Table('app_characters',
db.Column('app_id', db.Integer(), db.ForeignKey('hr_applications.id')),
db.Column('character_id', db.String(), db.ForeignKey('characters.character_id')))
class HrApplication(SurrogatePK, TimeMixin, Model):
# query_class = HrApplicationQuery
__tablename__ = 'hr_applications'
__searchable__ = ['thesis',
'how_long',
'notable_accomplishments',
'corporation_history',
'why_leaving',
'what_know',
'what_expect',
'bought_characters',
from flask_security import UserMixin, RoleMixin
from flask_security.utils import verify_and_update_password
from recruit_app.extensions import bcrypt
from recruit_app.database import (
Column,
db,
Model,
ReferenceCol,
relationship,
SurrogatePK,
)
roles_users = db.Table('roles_users',
db.Column('user_id', db.Integer(), db.ForeignKey('users.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('roles.id')))
class Role(SurrogatePK, Model, RoleMixin):
__tablename__ = 'roles'
name = Column(db.String(80), unique=True)
description = db.Column(db.String(255))
#user_id = ReferenceCol('users', nullable=True)
#user = relationship('User', backref='roles')
# def __init__(self, name, **kwargs):
# db.Model.__init__(self, name=name, **kwargs)
def __repr__(self):
return '<Role({name})>'.format(name=self.name)