class Role(db.Model, RoleMixin): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255)) def __repr__(self): return "<Role Name:%s Description:%s>" % (self.name, self.description)
from flask_sqlalchemy import SQLAlchemy, SignallingSession, SessionBase from flask_security import RoleMixin, UserMixin, current_user from flask_security.utils import encrypt_password from flask_security import SQLAlchemyUserDatastore from sqlalchemy import and_, or_ import arrow import datetime from unifispot.core.db import db, FORMAT_DATETIME, JSONEncodedDict from unifispot.core.const import * from unifispot.utils.modelhelpers import SerializerMixin, CRUDMixin, ExportMixin from unifispot.utils.translation import format_datetime #Roles for flask-security roles_users = db.Table( 'roles_users', db.Column('user_id', db.Integer(), db.ForeignKey('user.id')), db.Column('role_id', db.Integer(), db.ForeignKey('role.id'))) class Role(db.Model, RoleMixin): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255)) def __repr__(self): return "<Role Name:%s Description:%s>" % (self.name, self.description) #going to use joined table inheritance as given in #http://docs.sqlalchemy.org/en/rel_1_0/orm/inheritance.html#joined-table-inheritance