Database¶
We support Oracle and Postgres databases.
DB scheme.¶
Backport3 database models.
- class luna_backport3.db.models.Account(**kwargs)[source]¶
Database table model for account.
- account_id¶
account id.
- Type
uuid4
- active¶
account status (blocked or not).
- Type
bool
- email¶
account email.
- Type
str
- fillAccount(tup)[source]¶
Fill account data from array of elements
- Parameters
tup – array with elements (id, active status, password, e-mail, organization name).
- Return type
Base- Returns
self
- organization_name¶
organization name account represents.
- Type
str
- password¶
hash from account password. Encryption algorithm is pbkdf2_sha256 from passlib.
- Type
str
- class luna_backport3.db.models.AccountToken(**kwargs)[source]¶
Token table.
- account_id¶
account id, token is linked to
- Type
uuid4
- token_id¶
token id
- Type
uuid4
- token_info¶
string with token data
- Type
str
- class luna_backport3.db.models.DescriptorsList(**kwargs)[source]¶
Database table model for descriptors lists.
- account_id¶
account id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- create_descr_list_time_index = Index('create_descr_list_time_index', Column('account_id', String(length=36), ForeignKey('account.account_id'), table=<descriptors_list>, comment='uuid4: id of the account to which the list belongs'), Column('create_time', TIMESTAMP(), table=<descriptors_list>, nullable=False, comment='list: person create time'))¶
index for pagination by list
- create_time¶
date and time of creating list
- Type
DateTime
- list_id¶
list id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- class luna_backport3.db.models.Handler(**kwargs)[source]¶
Database table model for handlers.
- account_id¶
account uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”, to which this handler belong
- Type
str
- create_time¶
date and time of creating handler
- Type
DateTime
- classmethod getColumnNames()[source]¶
Get all column name of table.
- Returns
list of column name in order as in db
- Return type
List[str]
- handler_id¶
handler id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- last_update_time¶
date and time of creating face
- Type
DateTime
- policies¶
json with policies
- Type
str
- type¶
handler type (extractor - 0, identify - 1, verify - 2)
- Type
integer
- version¶
handler version
- Type
int
- class luna_backport3.db.models.ListPerson(**kwargs)[source]¶
Database table model for links between persons and lists.
- list_id¶
list id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- person_id¶
person id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- class luna_backport3.db.models.Person(**kwargs)[source]¶
Database table model for persons.
- account_id¶
descriptor id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- create_time¶
date and time of creating person
- Type
DateTime
- external_id¶
external id of the person, if it has its own mapping in external system
- Type
str
- person_id¶
person id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- user_data¶
client info about the face
- Type
str
- class luna_backport3.db.models.PersonFace(**kwargs)[source]¶
Database table model for links between persons and faces.
- face_id¶
face id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- person_id¶
person id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- class luna_backport3.db.models.PersonsList(**kwargs)[source]¶
Database table model for person lists.
- account_id¶
account id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str
- create_persons_list_time_index = Index('create_persons_list_time_index', Column('account_id', String(length=36), ForeignKey('account.account_id'), table=<persons_list>, comment='uuid4: id of the account to which the list belongs'), Column('create_time', TIMESTAMP(), table=<persons_list>, nullable=False, comment='date: list create time'))¶
index for pagination by list
- create_time¶
date and time of creating list
- Type
DateTime
- list_id¶
list id, uuid4 in format “xxxxxxxx-xxxx-4xxx-{8-9}xx-xxxxxxxxxxxx”
- Type
str