Horde_Alarm_Sql
extends Horde_Alarm
in package
The Horde_Alarm_Sql class is a Horde_Alarm storage implementation using the Horde Db package.
The table structure can be created by the migration script.
Tags
Table of Contents
- $_db : Horde_Db_Adapter
- Handle for the current database connection.
- $_errors : array<string|int, mixed>
- A list of errors, exceptions etc. that occured during notify() calls.
- $_handlers : array<string|int, mixed>
- All registered notification handlers.
- $_handlersLoaded : bool
- Whether handler classes have been dynamically loaded already.
- $_loader : mixed
- Alarm loader callback.
- $_logger : Horde_Log_Logger
- Logger.
- $_params : array<string|int, mixed>
- Hash containing connection parameters.
- __construct() : mixed
- Constructor.
- addHandler() : mixed
- Registers a notification handler.
- delete() : mixed
- Deletes an alarm from the backend.
- exists() : bool
- Returns whether an alarm with the given id exists already.
- gc() : mixed
- Garbage collects old alarms in the backend.
- get() : array<string|int, mixed>
- Returns an alarm hash from the backend.
- getErrors() : array<string|int, mixed>
- Returns a list of errors, exceptions etc. that occured during notify() calls.
- globalAlarms() : array<string|int, mixed>
- Returns a list of all global alarms from the backend.
- handlers() : array<string|int, mixed>
- Returns a list of available notification handlers and parameters.
- initialize() : mixed
- Initialization tasks.
- internal() : mixed
- Updates internal alarm properties, i.e. properties not determined by the application setting the alarm.
- isSnoozed() : bool
- Returns whether an alarm is snoozed.
- listAlarms() : array<string|int, mixed>
- Returns a list of alarms from the backend.
- notify() : mixed
- Notifies the user about any active alarms.
- set() : mixed
- Stores an alarm hash in the backend.
- snooze() : mixed
- Delays (snoozes) an alarm for a certain period.
- _add() : mixed
- Adds an alarm hash to the backend.
- _convertBinary() : string
- Converts results from TEXT columns to strings.
- _delete() : mixed
- Deletes an alarm from the backend.
- _dismiss() : mixed
- Dismisses an alarm.
- _exists() : bool
- Returns whether an alarm with the given id exists already.
- _fromDriver() : mixed
- Converts a value from the driver's charset.
- _gc() : mixed
- Garbage collects old alarms in the backend.
- _get() : array<string|int, mixed>
- Returns an alarm hash from the backend.
- _getHash() : mixed
- _global() : array<string|int, mixed>
- Returns a list of all global alarms from the backend.
- _isSnoozed() : bool
- Returns whether an alarm is snoozed.
- _list() : array<string|int, mixed>
- Returns a list of alarms from the backend.
- _snooze() : mixed
- Delays (snoozes) an alarm for a certain period.
- _toDriver() : mixed
- Converts a value to the driver's charset.
- _update() : mixed
- Updates an alarm hash in the backend.
Properties
$_db
Handle for the current database connection.
protected
Horde_Db_Adapter
$_db
$_errors
A list of errors, exceptions etc. that occured during notify() calls.
protected
array<string|int, mixed>
$_errors
= array()
$_handlers
All registered notification handlers.
protected
array<string|int, mixed>
$_handlers
= array()
$_handlersLoaded
Whether handler classes have been dynamically loaded already.
protected
bool
$_handlersLoaded
= \false
$_loader
Alarm loader callback.
protected
mixed
$_loader
$_logger
Logger.
protected
Horde_Log_Logger
$_logger
$_params
Hash containing connection parameters.
protected
array<string|int, mixed>
$_params
= array('ttl' => 300)
Methods
__construct()
Constructor.
public
__construct([array<string|int, mixed> $params = array() ]) : mixed
Parameters
- $params : array<string|int, mixed> = array()
-
Configuration parameters:
'db' - (Horde_Db_Adapter) [REQUIRED] The DB instance. 'table' - (string) The name of the alarm table in 'database'. DEFAULT: 'horde_alarms'
Tags
Return values
mixed —addHandler()
Registers a notification handler.
public
addHandler(string $name, Horde_Alarm_Handler $handler) : mixed
Parameters
- $name : string
-
A handler name.
- $handler : Horde_Alarm_Handler
-
A notification handler.
Return values
mixed —delete()
Deletes an alarm from the backend.
public
delete(string $id[, string $user = null ]) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string = null
-
The alarm's user. All users' alarms if null.
Tags
Return values
mixed —exists()
Returns whether an alarm with the given id exists already.
public
exists(string $id, string $user[, string $instanceid = null ]) : bool
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $instanceid : string = null
-
An optional instanceid to check for. @since 2.2.0
Return values
bool —True if the specified alarm exists.
gc()
Garbage collects old alarms in the backend.
public
gc([bool $force = false ]) : mixed
Parameters
- $force : bool = false
-
Force garbace collection? If false, GC happens with a 1% chance.
Tags
Return values
mixed —get()
Returns an alarm hash from the backend.
public
get(string $id, string $user) : array<string|int, mixed>
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
Tags
Return values
array<string|int, mixed> —An alarm hash. Contains the following:
id: Unique alarm id.
user: The alarm's user. Empty if a global alarm.
start: The alarm start as a Horde_Date.
end: The alarm end as a Horde_Date.
methods: The notification methods for this alarm.
params: The paramters for the notification methods.
title: The alarm title.
text: An optional alarm description.
snooze: The snooze time (next time) of the alarm as a Horde_Date.
internal: Holds internally used data.
instanceid: Holds an instance identifier for recurring alarms.
(@since 2.2.0)
getErrors()
Returns a list of errors, exceptions etc. that occured during notify() calls.
public
getErrors() : array<string|int, mixed>
Tags
Return values
array<string|int, mixed> —Error list.
globalAlarms()
Returns a list of all global alarms from the backend.
public
globalAlarms() : array<string|int, mixed>
Tags
Return values
array<string|int, mixed> —A list of alarm hashes.
handlers()
Returns a list of available notification handlers and parameters.
public
handlers() : array<string|int, mixed>
The returned list is a hash with method names as the keys and optionally associated parameters as values. The parameters are hashes again with parameter names as keys and parameter information as values. The parameter information is hash with the following keys: 'desc' contains a parameter description; 'required' specifies whether this parameter is required.
Return values
array<string|int, mixed> —List of methods and parameters.
initialize()
Initialization tasks.
public
initialize() : mixed
Tags
Return values
mixed —internal()
Updates internal alarm properties, i.e. properties not determined by the application setting the alarm.
public
internal(string $id, string $user, array<string|int, mixed> $internal) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $internal : array<string|int, mixed>
-
A hash with the internal data.
Tags
Return values
mixed —isSnoozed()
Returns whether an alarm is snoozed.
public
isSnoozed(string $id, string $user[, Horde_Date $time = null ]) : bool
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $time : Horde_Date = null
-
The time when the alarm may be snoozed. Defaults to now.
Tags
Return values
bool —True if the alarm is snoozed.
listAlarms()
Returns a list of alarms from the backend.
public
listAlarms([string $user = null ][, Horde_Date $time = null ][, bool $load = false ][, bool $preload = true ]) : array<string|int, mixed>
Parameters
- $user : string = null
-
Return alarms for this user, all users if null, or global alarms if empty.
- $time : Horde_Date = null
-
The time when the alarms should be active. Defaults to now.
- $load : bool = false
-
Update active alarms from all applications?
- $preload : bool = true
-
Preload alarms that go off within the next ttl time span?
Tags
Return values
array<string|int, mixed> —A list of alarm hashes.
notify()
Notifies the user about any active alarms.
public
notify([string $user = null ][, bool $load = true ][, bool $preload = true ][, array<string|int, mixed> $exclude = array() ]) : mixed
Parameters
- $user : string = null
-
Notify this user, all users if null, or guest users if empty.
- $load : bool = true
-
Update active alarms from all applications?
- $preload : bool = true
-
Preload alarms that go off within the next ttl time span?
- $exclude : array<string|int, mixed> = array()
-
Don't notify with these methods.
Tags
Return values
mixed —set()
Stores an alarm hash in the backend.
public
set(array<string|int, mixed> $alarm[, bool $keep = false ]) : mixed
The alarm will be added if it doesn't exist, and updated otherwise.
Parameters
- $alarm : array<string|int, mixed>
-
An alarm hash. See self::get() for format.
- $keep : bool = false
-
Whether to keep the snooze value and notification status unchanged. If true, the alarm will get "un-snoozed", and notifications (like mails) are sent again.
Tags
Return values
mixed —snooze()
Delays (snoozes) an alarm for a certain period.
public
snooze(string $id, string $user, int $minutes) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The notified user.
- $minutes : int
-
The delay in minutes. A negative value dismisses the alarm completely.
Tags
Return values
mixed —_add()
Adds an alarm hash to the backend.
protected
_add(array<string|int, mixed> $alarm) : mixed
Parameters
- $alarm : array<string|int, mixed>
-
An alarm hash.
Tags
Return values
mixed —_convertBinary()
Converts results from TEXT columns to strings.
protected
_convertBinary(string $column, mixed $value) : string
Parameters
- $column : string
-
A column name.
- $value : mixed
-
A TEXT column value.
Return values
string —The column value as plain string.
_delete()
Deletes an alarm from the backend.
protected
_delete(string $id[, string $user = null ]) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string = null
-
The alarm's user. All users' alarms if null.
Tags
Return values
mixed —_dismiss()
Dismisses an alarm.
protected
_dismiss(string $id, string $user) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
Tags
Return values
mixed —_exists()
Returns whether an alarm with the given id exists already.
protected
_exists(string $id, string $user[, string $instanceid = null ]) : bool
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $instanceid : string = null
-
An optional instanceid to match.
Tags
Return values
bool —True if the specified alarm exists.
_fromDriver()
Converts a value from the driver's charset.
protected
_fromDriver(mixed $value) : mixed
Parameters
- $value : mixed
-
Value to convert.
Return values
mixed —Converted value.
_gc()
Garbage collects old alarms in the backend.
protected
_gc() : mixed
Return values
mixed —_get()
Returns an alarm hash from the backend.
protected
_get(string $id, string $user) : array<string|int, mixed>
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
Tags
Return values
array<string|int, mixed> —An alarm hash.
_getHash()
protected
_getHash(array<string|int, mixed> $alarm) : mixed
Parameters
- $alarm : array<string|int, mixed>
Return values
mixed —_global()
Returns a list of all global alarms from the backend.
protected
_global() : array<string|int, mixed>
Tags
Return values
array<string|int, mixed> —A list of alarm hashes.
_isSnoozed()
Returns whether an alarm is snoozed.
protected
_isSnoozed(string $id, string $user, Horde_Date $time) : bool
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $time : Horde_Date
-
The time when the alarm may be snoozed.
Tags
Return values
bool —True if the alarm is snoozed.
_list()
Returns a list of alarms from the backend.
protected
_list(string $user, Horde_Date $time) : array<string|int, mixed>
Parameters
- $user : string
-
Return alarms for this user, all users if null, or global alarms if empty.
- $time : Horde_Date
-
The time when the alarms should be active.
Tags
Return values
array<string|int, mixed> —A list of alarm hashes.
_snooze()
Delays (snoozes) an alarm for a certain period.
protected
_snooze(string $id, string $user, Horde_Date $snooze) : mixed
Parameters
- $id : string
-
The alarm's unique id.
- $user : string
-
The alarm's user
- $snooze : Horde_Date
-
The snooze time.
Tags
Return values
mixed —_toDriver()
Converts a value to the driver's charset.
protected
_toDriver(mixed $value) : mixed
Parameters
- $value : mixed
-
Value to convert.
Return values
mixed —Converted value.
_update()
Updates an alarm hash in the backend.
protected
_update(array<string|int, mixed> $alarm[, bool $keepsnooze = false ]) : mixed
Parameters
- $alarm : array<string|int, mixed>
-
An alarm hash.
- $keepsnooze : bool = false
-
Whether to keep the snooze value unchanged.