Database

We support Oracle and Postgres databases.

Multiple hosts

The dsn parameter of service database config should be specified to enable multihost option for Postgres.

DSN may be specified in the following format: luna:luna@postgres01:5432,postgres02:5432/luna_video_manager?some_option=some_value. It is possible to partially fill in the DSN string (e.g. postgres01,postgres02/luna_video_manager), and then the missing parameters will be filled in from proprietary parameter values (or defaults).

At startup, the service will create a pool of connections to one of DSN hosts available. In case of problems with establishing a connection after several unsuccessful attempts, the service will again try to set up a connection pool to any of DSN hosts available.

DB scheme

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.Agent(**kwargs)

Database table model for agent.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.AgentAnalytic(**kwargs)

Database table model for links between agent and analytic.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.AgentStream(**kwargs)

Database table model for links between stream and agent.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.Group(**kwargs)

Database table model for group.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.GroupStream(**kwargs)

Database table model for links between stream and group.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.Log(**kwargs)

Database table model for stream logging.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.Restart(**kwargs)

Database table model for stream restart info.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.SingleProcessLock(**kwargs)

Table for storing one-at-time process lock. Lock a needed process by selecting row with FOR UPDATE for a guaranteed single-instance execution.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.Stream(**kwargs)

Database table model for streams.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.StreamAnalytic(**kwargs)

Database table model for links between stream and analytic.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.StreamMeta(**kwargs)

Database table model for stream meta info.

class luna_video_manager.db.video_manager_db_tools.models.video_manager_models.VideoAnalytic(**kwargs)

Database table model for analytic.

luna_video_manager.db.video_manager_db_tools.models.video_manager_models.view(name, selectable)

Create a simple view object. Use it like a table: select([SomeView.c.roi]) or SomeView.insert().values(name=’foo’).

Parameters:

• name (str) – view name

• selectable – any selectable that has columns

Return type:

TableClause

Returns:

sa.table object (NOT Model)