1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- <?php
- require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
- class Queue_item extends Managed_DataObject
- {
-
-
- public $__table = 'queue_item';
- public $id;
- public $frame;
- public $transport;
- public $created;
- public $claimed;
-
-
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'id' => array('type' => 'serial', 'not null' => true, 'description' => 'unique identifier'),
- 'frame' => array('type' => 'blob', 'not null' => true, 'description' => 'data: object reference or opaque string'),
- 'transport' => array('type' => 'varchar', 'length' => 32, 'not null' => true, 'description' => 'queue for what? "email", "xmpp", "sms", "irc", ...'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
- 'claimed' => array('type' => 'datetime', 'description' => 'date this item was claimed'),
- ),
- 'primary key' => array('id'),
- 'indexes' => array(
- 'queue_item_created_idx' => array('created'),
- ),
- );
- }
-
- static function top($transports=null) {
- $qi = new Queue_item();
- if ($transports) {
- if (is_array($transports)) {
-
- $list = implode("','", array_map(array($qi, 'escape'), $transports));
- $qi->whereAdd("transport in ('$list')");
- } else {
- $qi->transport = $transports;
- }
- }
- $qi->orderBy('created');
- $qi->whereAdd('claimed is null');
- $qi->limit(1);
- $cnt = $qi->find(true);
- if ($cnt) {
-
-
-
- common_log(LOG_INFO, 'claiming queue item id = ' . $qi->id .
- ' for transport ' . $qi->transport);
- $orig = clone($qi);
- $qi->claimed = common_sql_now();
- $result = $qi->update($orig);
- if ($result) {
- common_log(LOG_INFO, 'claim succeeded.');
- return $qi;
- } else {
- common_log(LOG_INFO, 'claim failed.');
- }
- }
- $qi = null;
- return null;
- }
-
- function releaseCLaim()
- {
-
- $sql = sprintf("UPDATE queue_item SET claimed=NULL WHERE id=%d", $this->id);
- $this->query($sql);
- $this->claimed = null;
- $this->encache();
- }
- }
|