X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FQueue_item.php;h=8a2cc87da355b4896bf42e2a6a6463d6b9e8d688;hb=aa41afc28b9933d2c1da34504ad1c1ef4f020639;hp=cf805a6060a6213cb003efb63f05496885591adc;hpb=78eb9c78a781ba8d6929a260e5f9c07714d59ee3;p=quix0rs-gnu-social.git diff --git a/classes/Queue_item.php b/classes/Queue_item.php index cf805a6060..8a2cc87da3 100644 --- a/classes/Queue_item.php +++ b/classes/Queue_item.php @@ -4,32 +4,58 @@ */ require_once INSTALLDIR.'/classes/Memcached_DataObject.php'; -class Queue_item extends Memcached_DataObject +class Queue_item extends Managed_DataObject { ###START_AUTOCODE /* the code below is auto generated do not remove the above tag */ public $__table = 'queue_item'; // table name - public $notice_id; // int(4) primary_key not_null - public $transport; // varchar(8) primary_key not_null + public $id; // int(4) primary_key not_null + public $frame; // blob not_null + public $transport; // varchar(32) public $created; // datetime() not_null public $claimed; // datetime() - /* Static get */ - function staticGet($k,$v=null) - { return Memcached_DataObject::staticGet('Queue_item',$k,$v); } - /* the code above is auto generated do not remove the tag below */ ###END_AUTOCODE - function sequenceKey() - { return array(false, false); } + 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($transport=null) { + /** + * @param mixed $transports name of a single queue or array of queues to pull from + * If not specified, checks all queues in the system. + */ + static function top($transports=null, array $ignored_transports=array()) { $qi = new Queue_item(); - if ($transport) { - $qi->transport = $transport; + if ($transports) { + if (is_array($transports)) { + // @fixme use safer escaping + $list = implode("','", array_map(array($qi, 'escape'), $transports)); + $qi->whereAdd("transport in ('$list')"); + } else { + $qi->transport = $transports; + } + } + if (!empty($ignored_transports)) { + // @fixme use safer escaping + $list = implode("','", array_map(array($qi, 'escape'), $ignored_transports)); + $qi->whereAdd("transport NOT IN ('$list')"); } $qi->orderBy('created'); $qi->whereAdd('claimed is null'); @@ -39,27 +65,34 @@ class Queue_item extends Memcached_DataObject $cnt = $qi->find(true); if ($cnt) { - # XXX: potential race condition - # can we force it to only update if claimed is still null - # (or old)? - common_log(LOG_INFO, 'claiming queue item = ' . $qi->notice_id . - ' for transport ' . $qi->transport); + // XXX: potential race condition + // can we force it to only update if claimed is still null + // (or old)? + common_log(LOG_INFO, 'claiming queue item id = ' . $qi->getID() . ' for transport ' . $qi->transport); $orig = clone($qi); $qi->claimed = common_sql_now(); $result = $qi->update($orig); if ($result) { - common_log(LOG_INFO, 'claim succeeded.'); + common_log(LOG_DEBUG, 'claim succeeded.'); return $qi; } else { - common_log(LOG_INFO, 'claim failed.'); + common_log(LOG_ERR, 'claim of queue item id= ' . $qi->getID() . ' for transport ' . $qi->transport . ' failed.'); } } $qi = null; return null; } - function pkeyGet($kv) + /** + * Release a claimed item. + */ + function releaseClaim() { - return Memcached_DataObject::pkeyGet('Queue_item', $kv); + // DB_DataObject doesn't let us save nulls right now + $sql = sprintf("UPDATE queue_item SET claimed=NULL WHERE id=%d", $this->getID()); + $this->query($sql); + + $this->claimed = null; + $this->encache(); } }