Class User

shared/database/user.py:9–357

from shared.data_tools_core import data_tools

class User(Base):
    __tablename__ = 'userbase'


    id = Column(Integer, primary_key = True)

    member_id = Column(Integer, ForeignKey('member.id'))
    member = relationship('Member', foreign_keys = "Member.user_id", uselist = False)

    qos_last_cached_value = Column(Float)  # Quality of service, most recent

    first_name = Column(String(100))
    last_name = Column(String(100))

    occupation_list = Column((ARRAY(String)))
    linkedin_profile_url = Column(String())

    how_hear_about_us = Column(String())

    company_name = Column(String())

    security_disable_global = Column(Boolean)  # If True, Disable user login completely
    security_email_verified = Column(Boolean)  # If True, email is

    api_actions = Column(Boolean, default = False)

    api_enabled_builder_brain = Column(Boolean)
    api_enabled_builder = Column(Boolean)  # Computer vision suite
    api_enabled_trainer = Column(Boolean)  # Annotation

    # A user can have both in theory,
    # so we say last in case they change modes
    last_builder_or_trainer_mode = Column(String)  # ["builder", "trainer"]

    phone_number = Column(String)
    city = Column(String)  # Until we get proper address collection setup

    # Should a user have a generic hash we can reference them by
    # And should this be the username until the user picks one?
    username = Column(String())

    email = Column(String(100), nullable = False)  # email is key
    password_hash = Column(String())

    # TODO rename to "attempt_count" in light of magic email thing?
    password_attempt_count = Column(Integer, default = 0)

    auto_commit = Column(Boolean, default = True)

    otp_secret = Column(String())
    otp_enabled = Column(Boolean)
    otp_backup = Column(MutableDict.as_mutable(JSONEncodedDict),
                        default = {})  # code : redeemed_or_not
    otp_current_session = Column(String())
    otp_current_session_expiry = Column(Integer)

    # TODO add otp_remember_browser (/ip?) and otp_recovery?