X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FProfile_list.php;h=2b3d2aa5ad4dd87e73f6d86bf94bb0f2886cb392;hb=a1dbe2325c0b9a14c01a2e35ee81170a80f57130;hp=17c2ffd4f470c78dcadddb9327d43f0f6ad642c7;hpb=31b29fde50e9664e1b70064c043879ce87553883;p=quix0rs-gnu-social.git diff --git a/classes/Profile_list.php b/classes/Profile_list.php index 17c2ffd4f4..2b3d2aa5ad 100644 --- a/classes/Profile_list.php +++ b/classes/Profile_list.php @@ -30,7 +30,7 @@ if (!defined('STATUSNET') && !defined('LACONICA')) { */ require_once INSTALLDIR.'/classes/Memcached_DataObject.php'; -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 */ @@ -43,28 +43,47 @@ 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 DB_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 +94,7 @@ class Profile_list extends Memcached_DataObject function getTagger() { - return Profile::staticGet('id', $this->tagger); + return Profile::getKV('id', $this->tagger); } /** @@ -185,10 +204,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 +334,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 +349,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 +381,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 +406,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 +589,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,7 +657,7 @@ 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)); } else { @@ -692,7 +700,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 +873,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)) {