Table name: auth_groups
id = Column(types.Integer(), primary_key=True)
name = Column(Unicode(80), unique=True, nullable=False)
description = Column(Unicode(255), default=u'')
Table name: auth_id
id = Column(types.Integer(), primary_key=True)
display_name = Column(Unicode(80), default=u'')
active = Column(types.Enum(u'Y',u'N',u'D', name=u"active"), default=u'Y')
created = Column(types.DateTime(), default=func.now())
Returns AuthID object or None by id
from apex.models import AuthID
user = AuthID.get_by_id(1)
Returns AuthUser.profile object, creates record if it doesn’t exist.
from apex.models import AuthUser
user = AuthUser.get_by_id(1)
profile = user.get_profile(request)
in development.ini
apex.auth_profile =
Fix this to use association_proxy groups = association_proxy(‘auth_group_table’, ‘authgroup’)
Table name: auth_users
id = Column(types.Integer(), primary_key=True)
login = Column(Unicode(80), default=u'', index=True)
_password = Column('password', Unicode(80), default=u'')
email = Column(Unicode(80), default=u'', index=True)
active = Column(types.Enum(u'Y',u'N',u'D'), default=u'Y')
Returns AuthUser object or None by email
from apex.models import AuthUser
user = AuthUser.get_by_email('email@address.com')