pyrogue.interfaces.SqlLogger

For conceptual usage, see:

• SQL Logging

• Logging In Rogue

class pyrogue.interfaces.SqlLogger(*, root, url, incGroups=None, excGroups=['NoSql'])

Logs variable updates and system log entries to a SQL database.

Parameters:

• root (Root) – PyRogue root node to monitor.

• url (str) – SQLAlchemy database URL.

• incGroups (str | list[str] | None, default: None) – Groups to include in variable updates.

• excGroups (str | list[str] | None, default: ['NoSql']) – Groups to exclude from variable updates.

__init__(*, root, url, incGroups=None, excGroups=['NoSql'])

Parameters:

• root (Root)

• url (str)

• incGroups (str | list[str] | None)

• excGroups (str | list[str] | None)

Return type:

None

insert_from_q(entry, conn)

Insert a single queue entry into the database.

Parameters:

• entry (tuple[str, Any]) – (path, value) for variables or (path, log_data) for syslog.

• conn (Connection) – SQLAlchemy connection for the transaction.

Return type:

None