-
- static function getStream($tag, $offset=0, $limit=20) {
- $qry =
- 'SELECT notice.* ' .
- 'FROM notice JOIN notice_tag ON notice.id = notice_tag.notice_id ' .
- 'WHERE notice_tag.tag = "%s"';
-
- return Notice::getStream(sprintf($qry, $tag),
- 'notice_tag:notice_stream:' . $tag,
- $offset, $limit);
+
+ static function getStream($tag, $offset=0, $limit=20) {
+
+ $ids = Notice::stream(array('Notice_tag', '_streamDirect'),
+ array($tag),
+ 'notice_tag:notice_ids:' . Cache::keyize($tag),
+ $offset, $limit);
+
+ return Notice::getStreamByIds($ids);
+ }
+
+ function _streamDirect($tag, $offset, $limit, $since_id, $max_id)
+ {
+ $nt = new Notice_tag();
+
+ $nt->tag = $tag;
+
+ $nt->selectAdd();
+ $nt->selectAdd('notice_id');
+
+ Notice::addWhereSinceId($nt, $since_id, 'notice_id');
+ Notice::addWhereMaxId($nt, $max_id, 'notice_id');
+
+ $nt->orderBy('created DESC, notice_id DESC');
+
+ if (!is_null($offset)) {
+ $nt->limit($offset, $limit);
+ }
+
+ $ids = array();
+
+ if ($nt->find()) {
+ while ($nt->fetch()) {
+ $ids[] = $nt->notice_id;
+ }
+ }
+
+ return $ids;
+ }
+
+ function blowCache($blowLast=false)
+ {
+ self::blow('notice_tag:notice_ids:%s', Cache::keyize($this->tag));
+ if ($blowLast) {
+ self::blow('notice_tag:notice_ids:%s;last', Cache::keyize($this->tag));
+ }
+ }
+
+ function pkeyGet($kv)
+ {
+ return Memcached_DataObject::pkeyGet('Notice_tag', $kv);
+ }
+
+ static function url($tag)
+ {
+ if (common_config('singleuser', 'enabled')) {
+ // regular TagAction isn't set up in 1user mode
+ $nickname = User::singleUserNickname();
+ $url = common_local_url('showstream',
+ array('nickname' => $nickname,
+ 'tag' => $tag));
+ } else {
+ $url = common_local_url('tag', array('tag' => $tag));
+ }
+
+ return $url;