Products :: ZenEvents :: MySqlEventManager :: MySqlEventManager :: Class MySqlEventManager

Class MySqlEventManager

                                        MySqlSendEvent.MySqlSendEventMixin --+
                                                                             |
                                                        object --+           |
                                                                 |           |
                                ZenModel.ZenModelBase.ZenModelBase --+       |
                                                                     |       |
                               ExtensionClass.Base --+               |       |
                                                     |               |       |
                         OFS.CopySupport.CopyContainer --+           |       |
                                                         |           |       |
              ZenRelations.RelCopySupport.RelCopyContainer --+       |       |
                                                             |       |       |
                               ExtensionClass.Base --+       |       |       |
                                                     |       |       |       |
                         OFS.CopySupport.CopyContainer --+   |       |       |
                                                         |   |       |       |
                               ExtensionClass.Base --+   |   |       |       |
                                                     |   |   |       |       |
                             App.Management.Navigation --+   |       |       |
                                                         |   |       |       |
                               ExtensionClass.Base --+   |   |       |       |
                                                     |   |   |       |       |
                                   App.Management.Tabs --+   |       |       |
                                                         |   |       |       |
                                  Acquisition.Implicit --+   |       |       |
                                                         |   |       |       |
                                Persistence.Persistent --+   |       |       |
                                                         |   |       |       |
                           ExtensionClass.Base --+       |   |       |       |
                                                 |       |   |       |       |
            webdav.EtagSupport.EtagSupport --+   |       |   |       |       |
                                             |   |       |   |       |       |
                  webdav.Lockable.LockableItem --+       |   |       |       |
                                                 |       |   |       |       |
                          webdav.Resource.Resource --+   |   |       |       |
                                                     |   |   |       |       |
                          webdav.Collection.Collection --+   |       |       |
                                                         |   |       |       |
                           OFS.Traversable.Traversable --+   |       |       |
                                                         |   |       |       |
                           OFS.ObjectManager.ObjectManager --+       |       |
                                                             |       |       |
                               ExtensionClass.Base --+       |       |       |
                                                     |       |       |       |
                           ExtensionClass.Base --+   |       |       |       |
                                                 |   |       |       |       |
                        OFS.CopySupport.CopySource --+       |       |       |
                                                     |       |       |       |
                           ExtensionClass.Base --+   |       |       |       |
                                                 |   |       |       |       |
                               App.Management.Tabs --+       |       |       |
                                                     |       |       |       |
                       OFS.Traversable.Traversable --+       |       |       |
                                                     |       |       |       |
                           ExtensionClass.Base --+   |       |       |       |
                                                 |   |       |       |       |
                         AccessControl.Owned.Owned --+       |       |       |
                                                     |       |       |       |
                              ZenRelations.ZItem.ZItem --+   |       |       |
                                                         |   |       |       |
                                  Acquisition.Implicit --+   |       |       |
                                                         |   |       |       |
                               ExtensionClass.Base --+   |   |       |       |
                                                     |   |   |       |       |
       AccessControl.PermissionMapping.RoleManager --+   |   |       |       |
                                                     |   |   |       |       |
                        AccessControl.Role.RoleManager --+   |       |       |
                                                         |   |       |       |
  ZenRelations.PrimaryPathObjectManager.PrimaryPathManager --+       |       |
                                                             |       |       |
                                   ExtensionClass.Base --+   |       |       |
                                                         |   |       |       |
                                      App.Undo.UndoSupport --+       |       |
                                                             |       |       |
ZenRelations.PrimaryPathObjectManager.PrimaryPathObjectManager --+   |       |
                                                                 |   |       |
                                                    object --+   |   |       |
                                                             |   |   |       |
                                   ExtensionClass.Base --+   |   |   |       |
                                                         |   |   |   |       |
                                 OFS.ZDOM.Node --+       |   |   |   |       |
                                                 |       |   |   |   |       |
                                  OFS.ZDOM.Element --+   |   |   |   |       |
                                                     |   |   |   |   |       |
                        OFS.ZDOM.ElementWithAttributes --+   |   |   |       |
                                                         |   |   |   |       |
                       OFS.PropertyManager.PropertyManager --+   |   |       |
                                                             |   |   |       |
            ZenRelations.ZenPropertyManager.ZenPropertyManager --+   |       |
                                                                 |   |       |
              ZenRelations.RelationshipManager.RelationshipManager --+       |
                                                                     |       |
                                           ExtensionClass.Base --+   |       |
                                                                 |   |       |
                                            OFS.History.Historical --+       |
                                                                     |       |
                                                        object --+   |       |
                                                                 |   |       |
                                      ZenModel.ZenPacker.ZenPacker --+       |
                                                                     |       |
                                        ZenModel.ZenModelRM.ZenModelRM --+   |
                                                                         |   |
                                                Globals.Persistent --+   |   |
                                                                     |   |   |
                                      ZenUtils.ObjectCache.ObjectCache --+   |
                                                                         |   |
                                                            object --+   |   |
                                                                     |   |   |
                                             DbAccessBase.DbAccessBase --+   |
                                                                         |   |
                                         EventManagerBase.EventManagerBase --+
                                                                             |
                                                                            MySqlEventManager

Instance Methods

[hide private]

list

getEventSummary(self, where="", severity=1, state=1, prodState=None, parameterizedWhere=None)
Return a list of tuples with the CSS class, acknowledged count, count

source code

countEventsSince(self, since)
since is number of seconds since epoch, see documentation for python time.time()

source code

Inherited from MySqlSendEvent.MySqlSendEventMixin: applyDeviceContext, applyEventContext, buildClearUpdate, buildDetailInsert, buildInsert, buildStatusInsert, doSendEvent, escape, eventDataMaps, getNetworkRoot, sendEvent

Inherited from MySqlSendEvent.MySqlSendEventMixin (private): _findByIp, _sendHeartbeat

Inherited from EventManagerBase.EventManagerBase: __init__, convert, convertEventField, dateDB, dateString, defaultAvailabilityEnd, defaultAvailabilityStart, deleteEvents, eventControls, filteredWhere, getAllComponentStatus, getAvailability, getAvgFieldLength, getBatchComponentInfo, getComponentStatus, getDeviceIssues, getDevicePingIssues, getDeviceStatus, getDeviceStatusIssues, getEventActions, getEventBatchME, getEventCssClass, getEventDetail, getEventDetailFromStatusOrHistory, getEventIds, getEventList, getEventListME, getEventOwnerList, getEventOwnerListME, getEventResultFields, getEventStates, getEventSummaryME, getFieldList, getGenericStatus, getHeartbeat, getHeartbeatObjects, getMaxSeverity, getOrganizerStatus, getOrganizerStatusIssues, getPriorities, getPriorityString, getSeverities, getSeverityString, getStatusCssClass, getStatusImgSrc, getStatusME, installIntoPortal, isDate, loadSchema, lookupManagedEntityField, lookupManagedEntityResultFields, lookupManagedEntityWhere, manage_ackEvents, manage_addCommand, manage_addEvent, manage_addLogMessage, manage_clearCache, manage_clearHeartbeats, manage_createEventMap, manage_deleteAllEvents, manage_deleteCommands, manage_deleteEvents, manage_deleteHeartbeat, manage_deleteHistoricalEvents, manage_editCache, manage_editEventManager, manage_refreshConversions, manage_setEventStates, manage_unackEvents, manage_undeleteEvents, restrictedUserFilter, sendEvents, undeleteEvents, updateEvents, zmanage_editProperties

Inherited from EventManagerBase.EventManagerBase (private): _filterCatalogResultsForIds, _getComponentIdsMatching, _getDeviceIdsMatching, _scrubOrderby, _setupDateRange, _wand

Inherited from ZenModel.ZenModelRM.ZenModelRM: changePythonClass, creator, editableDeviceList, findChild, getCreatedTimeString, getDmdKey, getModificationTimeString, getSubObjects, getTreeItems, getZenRootNode, index_object, primarySortKey, reindex_all, rename, setTitle, unindex_object, viewName, zmanage_addProperty, zmanage_delObjects, zmanage_delProperties, zmanage_exportObject, zmanage_importObject, zmanage_importObjects

Inherited from ZenModel.ZenModelBase.ZenModelBase: __call__, __hash__, all_meta_types, aqBaseHasAttr, breadCrumbs, callZenScreen, checkRemotePerm, checkValidId, createHierarchyObj, custPropertyIds, custPropertyMap, getBreadCrumbName, getBreadCrumbUrlPath, getDmd, getDmdObj, getDmdRoot, getHierarchyObj, getIconPath, getIdLink, getNowString, getObjByPath, getPrimaryDmdId, getUnusedId, getZopeObj, helpLink, isLocalName, manage_deleteObjects, prepId, saveCustProperties, todayDate, upToOrganizerBreadCrumbs, urlLink, view, visibleCustPropertyMap, yesterdayDate, zenScreenUrl, zenpathjoin, zenpathsplit, zentinelTabs

Inherited from ZenModel.ZenModelBase.ZenModelBase (private): _selectedTabName

Inherited from ZenRelations.RelationshipManager.RelationshipManager: addRelation, buildRelations, cb_isMoveable, checkRelations, exportXml, exportXmlProperties, exportXmlRelationships, getRelationshipManagerId, getRelationshipNames, getRelationships, manage_addRelation, manage_removeRelation, manage_workspace, moveMeBetweenRels, moveObject, removeRelation

Inherited from ZenRelations.RelationshipManager.RelationshipManager (private): _getCopy, _notifyOfCopyTo, _setObject

Inherited from ZenRelations.PrimaryPathObjectManager.PrimaryPathObjectManager (private): _delObject

Inherited from ZenRelations.RelCopySupport.RelCopyContainer: manage_linkObjects, manage_unlinkObjects

Inherited from ZenRelations.RelCopySupport.RelCopyContainer (private): _checkId, _getRelName, _getSourceObjects, _verifyObjectLink, _verifyObjectPaste

Inherited from OFS.ObjectManager.ObjectManager: __class_init__, __contains__, __delitem__, __getitem__, __iter__, __len__, __nonzero__, __setitem__, filtered_meta_types, get, getSiteManager, hasObject, items, keys, list_imports, manage_FTPlist, manage_FTPstat, manage_afterAdd, manage_afterClone, manage_beforeDelete, manage_delObjects, manage_exportObject, manage_hasId, manage_importObject, objectIds, objectIds_d, objectItems, objectItems_d, objectMap, objectMap_d, objectValues, objectValues_d, setSiteManager, superValues, tpValues, values

Inherited from OFS.ObjectManager.ObjectManager (private): _delOb, _getImportPaths, _getOb, _importObjectFromFile, _setOb, _subobject_permissions

Inherited from OFS.CopySupport.CopyContainer: cb_dataItems, cb_dataValid, manage_CopyContainerAllItems, manage_CopyContainerFirstItem, manage_clone, manage_copyObjects, manage_cutObjects, manage_pasteObjects, manage_renameObject, manage_renameObjects, validClipData

Inherited from OFS.CopySupport.CopyContainer (private): _get_id

Inherited from App.Management.Navigation: manage_zmi_logout

Inherited from ZenRelations.PrimaryPathObjectManager.PrimaryPathManager: getPrimaryId, getPrimaryParent, getPrimaryPath, getPrimaryUrlPath, primaryAq

Inherited from ZenRelations.ZItem.ZItem: __repr__, getId, manage_editedDialog, this, titleOrId, title_and_id, title_or_id, tpURL

Inherited from OFS.CopySupport.CopySource: cb_isCopyable, cb_userHasCopyOrMovePermission

Inherited from OFS.CopySupport.CopySource (private): _canCopy, _postCopy, _setId

Inherited from App.Management.Tabs: filtered_manage_options, tabs_path_default, tabs_path_info

Inherited from webdav.Collection.Collection: DELETE, HEAD, PUT, dav__init, listDAVObjects

Inherited from webdav.Resource.Resource: COPY, LOCK, MKCOL, MOVE, OPTIONS, PROPFIND, PROPPATCH, TRACE, UNLOCK, dav__simpleifhandler, dav__validate, manage_DAVget

Inherited from webdav.Lockable.LockableItem: wl_clearLocks, wl_delLock, wl_getLock, wl_hasLock, wl_isLocked, wl_lockItems, wl_lockTokens, wl_lockValues, wl_lockmapping, wl_setLock

Inherited from webdav.EtagSupport.EtagSupport: http__etag, http__parseMatchList, http__processMatchHeaders, http__refreshEtag

Inherited from OFS.Traversable.Traversable: absolute_url, absolute_url_path, getPhysicalPath, restrictedTraverse, unrestrictedTraverse, virtual_url_path

Inherited from AccessControl.Owned.Owned: changeOwnership, getOwner, getOwnerTuple, getWrappedOwner, manage_changeOwnershipType, manage_fixupOwnershipAfterAdd, manage_takeOwnership, owner_info, userCanTakeOwnership

Inherited from AccessControl.Owned.Owned (private): _deleteOwnershipAfterAdd

Inherited from AccessControl.Role.RoleManager: ac_inherited_permissions, access_debug_info, acquiredRolesAreUsedBy, get_local_roles, get_local_roles_for_userid, get_valid_userids, has_local_roles, manage_access, manage_acquiredPermissions, manage_addLocalRoles, manage_changePermissions, manage_defined_roles, manage_delLocalRoles, manage_editRoles, manage_getUserRolesAndPermissions, manage_permission, manage_role, manage_setLocalRoles, permission_settings, permissionsOfRole, possible_permissions, rolesOfPermission, userdefined_roles, users_with_local_role, validRoles, valid_roles, validate_roles

Inherited from AccessControl.Role.RoleManager (private): _addRole, _delRoles, _has_user_defined_role, _setRoles

Inherited from AccessControl.PermissionMapping.RoleManager: manage_getPermissionMapping, manage_setPermissionMapping

Inherited from AccessControl.PermissionMapping.RoleManager (private): _isBeingUsedAsAMethod

Inherited from App.Undo.UndoSupport: get_request_var_or_attr, manage_undo_transactions, undoable_transactions

Inherited from ZenRelations.ZenPropertyManager.ZenPropertyManager: deleteZenProperty, getOverriddenObjects, getProperty, getPropertyType, getZ, hasProperty, isLocal, manage_editProperties, saveZenProperties, setZenProperty, zenPropIsPassword, zenPropertyIds, zenPropertyItems, zenPropertyMap, zenPropertyOptions, zenPropertyPath, zenPropertyString

Inherited from ZenRelations.ZenPropertyManager.ZenPropertyManager (private): _findParentWithProperty, _setPropValue, _setProperty, _updateProperty

Inherited from OFS.History.Historical: manage_afterHistoryCopy, manage_beforeHistoryCopy, manage_change_history, manage_historicalComparison, manage_historyCompare, manage_historyCopy

Inherited from ZenModel.ZenPacker.ZenPacker: addToZenPack, eligiblePacks, findObject

Inherited from ZenUtils.ObjectCache.ObjectCache: addToCache, checkCache, cleanCache, clearCache, getCache, getCacheClearthresh, getCacheTimeout, initCache

Inherited from DbAccessBase.DbAccessBase: cleanstring, close, connect

Inherited from OFS.PropertyManager.PropertyManager: manage_addProperty, manage_changeProperties, manage_changePropertyTypes, manage_delProperties, propdict, propertyDescription, propertyIds, propertyItems, propertyLabel, propertyMap, propertyValues, valid_property_id

Inherited from OFS.PropertyManager.PropertyManager (private): _delPropValue, _delProperty, _propertyMap, _wrapperCheck

Inherited from OFS.ZDOM.ElementWithAttributes: getAttribute, getAttributeNode, getAttributes

Inherited from OFS.ZDOM.Element: getChildNodes, getElementsByTagName, getFirstChild, getLastChild, getNextSibling, getNodeName, getNodeType, getParentNode, getPreviousSibling, getTagName

Inherited from OFS.ZDOM.Node: getNodeValue, getOwnerDocument, hasChildNodes

Class Methods

[hide private]

Inherited from ZenRelations.RelationshipManager.RelationshipManager: lookupSchema

Class Variables

[hide private]

meta_type = 'MySqlEventManager'

portal_type = 'MySqlEventManager'

backend = "mysql"

security = ClassSecurityInfo()

Inherited from EventManagerBase.EventManagerBase: ComponentResultFields, ComponentWhere, DeviceClassWhere, DeviceGroupField, DeviceGroupWhere, DeviceResultFields, DeviceWhere, EventClassInstWhere, EventClassWhere, IpAddressWhere, LocationWhere, SystemField, SystemWhere, componentField, countField, defaultAvailabilityDays, defaultEventId, defaultFields, defaultPriority, defaultResultFields, detailTable, deviceField, eventActions, eventAgingHours, eventAgingSeverity, eventClassField, eventStateConversions, factory_type_information, firstTimeField, historyMaxAgeDays, lastTimeField, logTable, priorities, priorityConversions, prodStateField, refreshConversionsForm, requiredEventFields, severities, severityConversions, severityField, stateField, statusTable

Inherited from EventManagerBase.EventManagerBase (private): _properties, _relations

Inherited from ZenModel.ZenModelRM.ZenModelRM: default_catalog, isInTree

Inherited from ZenModel.ZenModelBase.ZenModelBase: index_html, sub_meta_types

Inherited from ZenModel.ZenModelBase.ZenModelBase (private): _zendoc

Inherited from ZenRelations.RelationshipManager.RelationshipManager: manage_main, manage_options

Inherited from ZenRelations.RelationshipManager.RelationshipManager (private): _operation

Inherited from OFS.ObjectManager.ObjectManager: has_order_support, isAnObjectManager, isPrincipiaFolderish, manage_addProduct, manage_importExportForm, manage_index_main, meta_types

Inherited from OFS.ObjectManager.ObjectManager (private): _components, _objects

Inherited from OFS.CopySupport.CopyContainer: manage_renameForm

Inherited from App.Management.Navigation: manage, manage_copyright, manage_form_title, manage_menu, manage_page_footer, manage_page_header, manage_top_frame, manage_zmi_prefs, zope_quick_start

Inherited from ZenRelations.ZItem.ZItem: REQUEST, __allow_access_to_unprotected_subobjects__, __name__, __propsets__, getId__roles__, icon, id, isTopLevelPrincipiaApplicationObject, title

Inherited from ZenRelations.ZItem.ZItem (private): _manage_editedDialog

Inherited from App.Management.Tabs: manage_tabs, manage_workspace__roles__

Inherited from webdav.Collection.Collection: __dav_collection__

Inherited from webdav.Resource.Resource: __dav_resource__, __http_methods__

Inherited from OFS.Traversable.Traversable: getPhysicalRoot

Inherited from AccessControl.Owned.Owned: manage_owner

Inherited from AccessControl.Role.RoleManager: __ac_local_roles__, __ac_roles__, aclAChecked, aclEChecked, aclPChecked, manage_acquiredForm, manage_editLocalRoles, manage_listLocalRoles, manage_permissionForm, manage_reportUserPermissions, manage_roleForm, permissionMappingPossibleValues, selectedRoles, smallRolesWidget

Inherited from AccessControl.Role.RoleManager (private): _normal_manage_access

Inherited from App.Undo.UndoSupport: manage_UndoForm

Inherited from ZenRelations.ZenPropertyManager.ZenPropertyManager: __pychecker__, manage_propertiesForm

Inherited from ZenRelations.ZenPropertyManager.ZenPropertyManager (private): _onlystars

Inherited from OFS.History.Historical: HistoricalRevisions, manage_change_history_page

Inherited from OFS.History.Historical (private): _manage_historyComparePage

Inherited from ZenUtils.ObjectCache.ObjectCache: editCache

Inherited from DbAccessBase.DbAccessBase (private): _v_cpool

Inherited from OFS.PropertyManager.PropertyManager: manage_propertyTypeForm, propertysheets

Inherited from OFS.PropertyManager.PropertyManager (private): _reserved_names

Method Details

[hide private]

getEventSummary(self, where="", severity=1, state=1, prodState=None, parameterizedWhere=None)

source code


Return a list of tuples with the CSS class, acknowledged count, count

[['zenevents_5', 0, 3], ...]

select severity, sum(eventState) as ack_events, count(*) as total_events,
    from status where device="win2k.confmon.loc"
    and eventState < 2 group by severity desc;

Parameters:

where - The base where clause to modify.
severity - The minimum severity for which to retrieve events
state - The minimum state for which to retrieve events
prodState - The minimum production state for which to retrieve events

Returns: list

List of lists of the form [class, acked count, unacked count].

Overrides: EventManagerBase.EventManagerBase.getEventSummary