app.db

Database file for the user-login-manager service, user authentication check and other general purpose tasks.

Submodules

• app.db.mongodb
• app.db.postgres

Attributes

postgres_user_filepath
postgres_password_filepath
postgres_db_name_filepath
postgres_user

Classes

Base	Define base class.
UserSQL	User ORM model.

Functions

init_db(→ None)

Initialize the database.

Module Contents

class app.db.Base

Bases: sqlalchemy.orm.DeclarativeBase

Define base class.

DeclarativeBase cannot be used directly.

app.db.postgres_user_filepath = '/run/secrets/scanhub_database_postgres_user'

app.db.postgres_password_filepath = '/run/secrets/scanhub_database_postgres_password'

app.db.postgres_db_name_filepath = '/run/secrets/scanhub_database_postgres_db_name'

app.db.postgres_user

app.db.init_db() → None

Initialize the database.

class app.db.UserSQL

Bases: Base

User ORM model.

__tablename__ = 'user'

__table_args__

username: sqlalchemy.orm.Mapped[str]

first_name: sqlalchemy.orm.Mapped[str]

last_name: sqlalchemy.orm.Mapped[str]

email: sqlalchemy.orm.Mapped[str]

role: sqlalchemy.orm.Mapped[str]

password_hash: sqlalchemy.orm.Mapped[str]

salt: sqlalchemy.orm.Mapped[str]

access_token: sqlalchemy.orm.Mapped[str]

last_activity_unixtime: sqlalchemy.orm.Mapped[int]

last_login_unixtime: sqlalchemy.orm.Mapped[int]