alarmdecoder.com

Hi
Is there any functionality to purge old events? While some mart need the history i dont need more tha a few weeks.

Tim

If I recall correctly there is a button to clear the event log that should delete from the database, but I don't remember if that was left in or not... check the logging section

Thanks. I cleared the events. I may look at some auto purge code at some point

timlegge wrote:Thanks. I cleared the events. I may look at some auto purge code at some point

Would be fairly trivial, as an example you can look at the code for the automatic configuration backups.

So there is no automatic purge setting? If this is to be coded, where are the log files kept? Are they just text on the disk or in a database and, if in a database, how is that accomplished? I haven't been smart enough to link the "clear events" button on the screen to the corresponding section of python code it calls. Pointing me to a module/function would be a big help if you can. After running for about a month I've got over 27,000 entries - mostly hardwired motion sensors. Thanks.

They're kept in the database.

https://github.com/nutechsoftware/alarm ... ews.py#L58

Thanks for pointing me in the right direction.

alternatively you can issue a truncate table event_log within a sqlite utility

More unknown realms to explore. Thanks for the guidance. Is there a data dictionary for the table, or can you tell me the name of the time stamp field in it? I think I'd rather just delete records older than X days.

Here is the event_log table definition

Code: Select all

    id = Column(db.Integer, primary_key=True)
    type = Column(db.SmallInteger, nullable=False)
    timestamp = Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), index=True)
message = Column(db.Text, nullable=False)