models.py

from database import db
from flask.ext.security import UserMixin, RoleMixin, SQLAlchemyUserDatastore

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 User(db.Model, UserMixin):
	id = db.Column(db.Integer, primary_key=True)
	email = db.Column(db.String(255), unique=True)
	firstname = db.Column(db.String(255))
	lastname = db.Column(db.String(255))
	password = db.Column(db.String(255))
	active = db.Column(db.Boolean())
	confirmed_at = db.Column(db.DateTime())
	roles = db.relationship('Role', secondary=roles_users,
							backref=db.backref('users', lazy='dynamic'))
	last_login_at = db.Column(db.DateTime())
	current_login_at = db.Column(db.DateTime())
	last_login_ip = db.Column(db.String(255))
	current_login_ip = db.Column(db.String(255))
	login_count = db.Column(db.Integer)

	def __repr__(self):
		return '<models.User[email=%s]>' % self.email

	def __unicode__(self):
		return "%s %s" %(self.firstname,self.lastname)

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 '<models.Role[name=%s]>' % self.name

	def __unicode__(self):
		return "%s" %(self.description)

user_datastore = SQLAlchemyUserDatastore(db, User, Role)

# class SomeStuff(db.Model):
# 	__tablename__ = 'somestuff'
# 	id = db.Column(db.Integer, primary_key=True)
# 	data1 = db.Column(db.Integer)
# 	data2 = db.Column(db.String(10))
# 	user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
# 	user = db.relationship(User, lazy='joined', join_depth=1, viewonly=True)