DatabaseEventTable

Description

The DatabaseEventTable object is a special DatabaseTable which can stores Event objects. The additional properties correspond to each property of Event.

› Inherits:: DatabaseTable

Overview

Methods

Signals

Enumerations

Properties

category

This property holds a DataObject for the category property of Event.

› Type:: DataObject
› Signal:: categoryChanged()
› Attributes:: Readonly

data

This property holds a DataObject for the data property of Event.

› Type:: DataObject
› Signal:: dataChanged()
› Attributes:: Readonly

description

This property holds a DataObject for the description property of Event.

› Type:: DataObject
› Signal:: descriptionChanged()
› Attributes:: Readonly

errorCode

This property holds a DataObject for the errorCode property of Event.

› Type:: DataObject
› Signal:: errorCodeChanged()
› Attributes:: Readonly

eventId

This property holds a DataObject for the id property of Event.

› Type:: DataObject
› Signal:: eventIdChanged()
› Attributes:: Readonly

severity

This property holds a DataObject for the severity property of Event.

› Type:: DataObject
› Signal:: severityChanged()
› Attributes:: Readonly

timestamp

This property holds a DataObject for the timestamp property of Event.

› Type:: DataObject
› Signal:: timestampChanged()
› Attributes:: Readonly

uuid

This property holds a DataObject for the uuid property of Event.

› Type:: DataObject
› Signal:: uuidChanged()
› Attributes:: Readonly

Example

import InCore.Foundation 2.5
import InCore.Database 2.5

Application {
    name: "EventDemo"
    description: "Event Demo"

    property alias evntTbl: eventWriter.eventTable

    DatabaseQuery {
        id: eventQuery
        table: evntTbl
        objects: [ evntTbl.data, evntTbl.timestamp, evntTbl.eventId ]
        filters: [
            DatabaseQueryFilter {
                DatabaseQueryWhere { key: evntTbl.severity; operation: DatabaseQueryWhere.GreaterOrEquals; value: Event.Warning }
            }
        ]
        onResultsChanged: {
            console.log("data, timestamp, id")
            for(var i = 0; i < results.length; i++) {
                console.log(results[i].data, results[i].timestamp, results[i].eventId)
            }
        }
        onCompleted: eventQuery.execute()
    }

    EventLog {
        outputs: [
            DatabaseEventWriter { id: eventWriter }
        ]

        // categories allow filtering events for outputs based on OR (instead of severity which filters by number)
        EventCategory { id: ioErrorCategory }

        EventGroup {
            severity: Event.Information // Info Warning Debug Fatal
            Event {
                id: generalErrorEvent
                severity: Event.Error
                uuid: "7f160be3-4ba9-42f0-a524-5359057c034b"
                description: "General error"
            }

            Event {
                id: fileOpenErrorEvent
                category: ioErrorCategory
                errorCode: 42
                description: "Could not open file %1"
            }

            Event {
                id: deviceStartedEvent
                description: "Database error: %1"
            }
        }

        onCompleted: deviceStartedEvent.trigger()
    }
}