device-manager.app.api.db

Definition of device database ORM models.

Attributes

Base
postgres_user_filepath
postgres_password_filepath
postgres_db_name_filepath
postgres_user

Classes

Device

Device ORM model.

Functions

init_db(→ None)

Create database helper function.

Module Contents

device-manager.app.api.db.Base: sqlalchemy.orm.decl_api.DeclarativeMeta

device-manager.app.api.db.postgres_user_filepath = '/run/secrets/scanhub_database_postgres_user'

device-manager.app.api.db.postgres_password_filepath = '/run/secrets/scanhub_database_postgres_password'

device-manager.app.api.db.postgres_db_name_filepath = '/run/secrets/scanhub_database_postgres_db_name'

device-manager.app.api.db.postgres_user

device-manager.app.api.db.init_db() → None

Create database helper function.

class device-manager.app.api.db.Device

Bases: Base

Device ORM model.

__tablename__ = 'device'

id: sqlalchemy.orm.Mapped[uuid.UUID]

datetime_created: sqlalchemy.orm.Mapped[datetime.datetime]

datetime_updated: sqlalchemy.orm.Mapped[datetime.datetime]

title: sqlalchemy.orm.Mapped[str]

description: sqlalchemy.orm.Mapped[str]

token_hash: sqlalchemy.orm.Mapped[str]

salt: sqlalchemy.orm.Mapped[str]

status: sqlalchemy.orm.Mapped[str]

name: sqlalchemy.orm.Mapped[str]

manufacturer: sqlalchemy.orm.Mapped[str]

modality: sqlalchemy.orm.Mapped[str]

site: sqlalchemy.orm.Mapped[str]

ip_address: sqlalchemy.orm.Mapped[str]

update(data: dict)

Update attributes of orm model.

Parameters

data {dict} – Entries to be updated