Source code for carepoint.models.cph.user

# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).

import enum

from carepoint import Carepoint
from sqlalchemy import (Column,
                        Integer,
                        String,
                        DateTime,
                        ForeignKey,
                        Text,
                        )


class EnumUserType(enum.Enum):
    """ It provides PEP-0435 compliant Carepoint User Type Enumerable """

    user = 'U'
    group = 'G'
    machine = 'M'


class User(Carepoint.BASE):
    __tablename__ = 'csuser'
    __dbname__ = 'cph'

    user_id = Column(
        Integer, 
        primary_key=True,
        autoincrement=False,
    )
    user_type_cd = Column(String)
    login_name = Column(String)
    lname = Column(String)
    fname = Column(String)
    mname = Column(String)
    title_lu = Column(String)
    suffix_lu = Column(String)
    degree_lu = Column(String)
    initials = Column(String)
    job_title_lu = Column(String)
    anote = Column(String)
    employee_no = Column(String)
    ssn = Column(String)
    last_login_date = Column(DateTime)
    email = Column(String)
    db_password = Column(String)
    es_password = Column(String)
    cmt = Column(Text)
    system_yn = Column(Integer)
    license_no = Column(String)
    license_state_cd = Column(String)
    status_cn = Column(Integer)
    app_flags = Column(Integer)
    timestmp = Column(DateTime)
    must_change_password_yn = Column(Integer)
    password_date = Column(DateTime)
    add_user_id = Column(
        Integer,
        ForeignKey('csuser.user_id'),
    )
    add_date = Column(DateTime)
    chg_user_id = Column(
        Integer,
        ForeignKey('csuser.user_id'),
    )
    chg_date = Column(DateTime)

    @property
    def user_type(self):
        return EnumUserType(self.user_type_cd)