X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FProfile_list.php;h=000e10b41f5fb7cc598c7c7a2d7ffa37378e98ed;hb=42c653a9d0a57d8b575614827a569badd054e5a7;hp=2395a369f3b0d2f9059abb17ec7e021afe47de9b;hpb=25198a8d4cee5b2182f1ecb99192a4108a01afa4;p=quix0rs-gnu-social.git diff --git a/classes/Profile_list.php b/classes/Profile_list.php index 2395a369f3..000e10b41f 100644 --- a/classes/Profile_list.php +++ b/classes/Profile_list.php @@ -21,20 +21,10 @@ * @license GNU Affero General Public License http://www.gnu.org/licenses/ */ -if (!defined('STATUSNET') && !defined('LACONICA')) { - exit(1); -} - -/** - * Table Definition for profile_list - */ -require_once INSTALLDIR.'/classes/Memcached_DataObject.php'; +if (!defined('GNUSOCIAL')) { exit(1); } -class Profile_list extends Memcached_DataObject +class Profile_list extends Managed_DataObject { - ###START_AUTOCODE - /* the code below is auto generated do not remove the above tag */ - public $__table = 'profile_list'; // table name public $id; // int(4) primary_key not_null public $tagger; // int(4) @@ -43,28 +33,44 @@ class Profile_list extends Memcached_DataObject public $private; // tinyint(1) public $created; // datetime not_null default_0000-00-00%2000%3A00%3A00 public $modified; // timestamp not_null default_CURRENT_TIMESTAMP - public $uri; // varchar(255) unique_key - public $mainpage; // varchar(255) + public $uri; // varchar(191) unique_key not 255 because utf8mb4 takes more space + public $mainpage; // varchar(191) not 255 because utf8mb4 takes more space public $tagged_count; // smallint public $subscriber_count; // smallint - /* Static get */ - function staticGet($k,$v=NULL) { return Memcached_DataObject::staticGet('Profile_list',$k,$v); } - - /* the code above is auto generated do not remove the tag below */ - ###END_AUTOCODE - - /** - * return a profile_list record, given its tag and tagger. - * - * @param array $kv ideally array('tag' => $tag, 'tagger' => $tagger) - * - * @return Profile_list a Profile_list object with the given tag and tagger. - */ - - function pkeyGet($kv) + public static function schemaDef() { - return Memcached_DataObject::pkeyGet('Profile_list', $kv); + return array( + 'fields' => array( + 'id' => array('type' => 'serial', 'not null' => true, 'description' => 'unique identifier'), + 'tagger' => array('type' => 'int', 'not null' => true, 'description' => 'user making the tag'), + 'tag' => array('type' => 'varchar', 'length' => 64, 'not null' => true, 'description' => 'people tag'), + 'description' => array('type' => 'text', 'description' => 'description of the people tag'), + 'private' => array('type' => 'int', 'size' => 'tiny', 'default' => 0, 'description' => 'is this tag private'), + + 'created' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date the tag was added'), + 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date the tag was modified'), + + 'uri' => array('type' => 'varchar', 'length' => 191, 'description' => 'universal identifier'), + 'mainpage' => array('type' => 'varchar', 'length' => 191, 'description' => 'page to link to'), + 'tagged_count' => array('type' => 'int', 'default' => 0, 'description' => 'number of people tagged with this tag by this user'), + 'subscriber_count' => array('type' => 'int', 'default' => 0, 'description' => 'number of subscribers to this tag'), + ), + 'primary key' => array('tagger', 'tag'), + 'unique keys' => array( + 'profile_list_id_key' => array('id') + ), + 'foreign keys' => array( + 'profile_list_tagger_fkey' => array('profile', array('tagger' => 'id')), + ), + 'indexes' => array( + 'profile_list_modified_idx' => array('modified'), + 'profile_list_tag_idx' => array('tag'), + 'profile_list_tagger_tag_idx' => array('tagger', 'tag'), + 'profile_list_tagged_count_idx' => array('tagged_count'), + 'profile_list_subscriber_count_idx' => array('subscriber_count'), + ), + ); } /** @@ -75,7 +81,7 @@ class Profile_list extends Memcached_DataObject function getTagger() { - return Profile::staticGet('id', $this->tagger); + return Profile::getByID($this->tagger); } /** @@ -126,7 +132,7 @@ class Profile_list extends Memcached_DataObject $url = $this->mainpage; } else { $url = common_local_url('showprofiletag', - array('tagger' => $this->getTagger()->nickname, + array('nickname' => $this->getTagger()->nickname, 'tag' => $this->tag)); } } @@ -185,10 +191,12 @@ class Profile_list extends Memcached_DataObject function getSubscribers($offset=0, $limit=null, $since=0, $upto=0) { $subs = new Profile(); - $sub = new Profile_tag_subscription(); - $sub->profile_tag_id = $this->id; - $subs->joinAdd($sub); + $subs->joinAdd( + array('id', 'profile_tag_subscription:profile_id') + ); + $subs->whereAdd('profile_tag_subscription.profile_tag_id = ' . $this->id); + $subs->selectAdd('unix_timestamp(profile_tag_subscription.' . 'created) as "cursor"'); @@ -313,7 +321,7 @@ class Profile_list extends Memcached_DataObject * @return boolean success */ - function delete() + function delete($useWhere=false) { // force delete one item at a time. if (empty($this->id)) { @@ -328,30 +336,30 @@ class Profile_list extends Memcached_DataObject self::blow('profile:lists:%d', $this->tagger); - return parent::delete(); + return parent::delete($useWhere); } /** * Update a people tag gracefully * also change "tag" fields in profile_tag table * - * @param Profile_list $orig Object's original form + * @param Profile_list $dataObject Object's original form * * @return boolean success */ - function update($orig=null) + function update($dataObject=false) { - $result = true; - - if (!is_object($orig) && !$orig instanceof Profile_list) { - parent::update($orig); + if (!is_object($dataObject) && !$dataObject instanceof Profile_list) { + return parent::update($dataObject); } + $result = true; + // if original tag was different // check to see if the new tag already exists // if not, rename the tag correctly - if($orig->tag != $this->tag || $orig->tagger != $this->tagger) { + if($dataObject->tag != $this->tag || $dataObject->tagger != $this->tagger) { $existing = Profile_list::getByTaggerAndTag($this->tagger, $this->tag); if(!empty($existing)) { // TRANS: Server exception. @@ -360,10 +368,9 @@ class Profile_list extends Memcached_DataObject } // move the tag // XXX: allow OStatus plugin to send out profile tag - $result = Profile_tag::moveTag($orig, $this); + $result = Profile_tag::moveTag($dataObject, $this); } - parent::update($orig); - return $result; + return parent::update($dataObject); } /** @@ -386,18 +393,6 @@ class Profile_list extends Memcached_DataObject return $xs->getString(); } - /** - * return an xml string to represent this people tag - * as the subject of an activitystreams feed. - * - * @return string activitystreams subject - */ - - function asActivitySubject() - { - return $this->asActivityNoun('subject'); - } - /** * return an xml string to represent this people tag * as a noun in an activitystreams feed. @@ -581,7 +576,7 @@ class Profile_list extends Memcached_DataObject * * @return mixed Profile_list on success, false on fail */ - static function saveNew($fields) { + static function saveNew(array $fields) { extract($fields); $ptag = new Profile_list(); @@ -649,9 +644,9 @@ class Profile_list extends Memcached_DataObject if (!isset($mainpage) || empty($mainpage)) { $orig = clone($ptag); - $user = User::staticGet('id', $ptag->tagger); + $user = User::getKV('id', $ptag->tagger); if(!empty($user)) { - $ptag->mainpage = common_local_url('showprofiletag', array('tag' => $ptag->tag, 'tagger' => $user->nickname)); + $ptag->mainpage = common_local_url('showprofiletag', array('tag' => $ptag->tag, 'nickname' => $user->getNickname())); } else { $ptag->mainpage = $uri; // assume this is a remote peopletag and the uri works } @@ -692,7 +687,7 @@ class Profile_list extends Memcached_DataObject // XXX: This should be in Memcached_DataObject... eventually. - static function getAtCursor($fn, $args, $cursor, $count=20) + static function getAtCursor($fn, array $args, $cursor, $count=20) { $items = array(); @@ -865,7 +860,7 @@ class Profile_list extends Memcached_DataObject * @return Profile_list results */ - static function getByKeys($keys) { + static function getByKeys(array $keys) { $cache = Cache::instance(); if (!empty($cache)) {