3 * Table Definition for profile_tag_subscription
5 require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
7 class Profile_tag_subscription extends Managed_DataObject
10 /* the code below is auto generated do not remove the above tag */
12 public $__table = 'profile_tag_subscription'; // table name
13 public $profile_tag_id; // int(4) not_null
14 public $profile_id; // int(4) not_null
15 public $created; // datetime not_null default_0000-00-00%2000%3A00%3A00
16 public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
19 function staticGet($k,$v=null)
20 { return Memcached_DataObject::staticGet('Profile_tag_subscription',$k,$v); }
22 /* the code above is auto generated do not remove the tag below */
25 public static function schemaDef()
29 'profile_tag_id' => array('type' => 'int', 'not null' => true, 'description' => 'foreign key to profile_tag'),
30 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'foreign key to profile table'),
32 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
33 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
35 'primary key' => array('profile_tag_id', 'profile_id'),
36 'foreign keys' => array(
37 'profile_tag_subscription_profile_list_id_fkey' => array('profile_list', array('profile_tag_id' => 'id')),
38 'profile_tag_subscription_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
41 // @fixme probably we want a (profile_id, created) index here?
42 'profile_tag_subscription_profile_id_idx' => array('profile_id'),
43 'profile_tag_subscription_created_idx' => array('created'),
50 return Memcached_DataObject::pkeyGet('Profile_tag_subscription', $kv);
53 static function add($peopletag, $profile)
55 if ($peopletag->private) {
59 if (Event::handle('StartSubscribePeopletag', array($peopletag, $profile))) {
60 $args = array('profile_tag_id' => $peopletag->id,
61 'profile_id' => $profile->id);
62 $existing = Profile_tag_subscription::pkeyGet($args);
63 if(!empty($existing)) {
67 $sub = new Profile_tag_subscription();
68 $sub->profile_tag_id = $peopletag->id;
69 $sub->profile_id = $profile->id;
70 $sub->created = common_sql_now();
72 $result = $sub->insert();
75 common_log_db_error($sub, 'INSERT', __FILE__);
76 // TRANS: Exception thrown when inserting a list subscription in the database fails.
77 throw new Exception(_('Adding list subscription failed.'));
80 $ptag = Profile_list::staticGet('id', $peopletag->id);
81 $ptag->subscriberCount(true);
83 Event::handle('EndSubscribePeopletag', array($peopletag, $profile));
88 static function remove($peopletag, $profile)
90 $sub = Profile_tag_subscription::pkeyGet(array('profile_tag_id' => $peopletag->id,
91 'profile_id' => $profile->id));
98 if (Event::handle('StartUnsubscribePeopletag', array($peopletag, $profile))) {
99 $result = $sub->delete();
102 common_log_db_error($sub, 'DELETE', __FILE__);
103 // TRANS: Exception thrown when deleting a list subscription from the database fails.
104 throw new Exception(_('Removing list subscription failed.'));
107 $peopletag->subscriberCount(true);
109 Event::handle('EndUnsubscribePeopletag', array($peopletag, $profile));
114 // called if a tag gets deleted / made private
115 static function cleanup($profile_list) {
117 $subs->profile_tag_id = $profile_list->id;
120 while($subs->fetch()) {
121 $profile = Profile::staticGet('id', $subs->profile_id);
122 Event::handle('StartUnsubscribePeopletag', array($profile_list, $profile));
125 Event::handle('StartUnsubscribePeopletag', array($profile_list, $profile));
131 $result = parent::insert();
133 self::blow('profile_list:subscriber_count:%d',
134 $this->profile_tag_id);
141 $result = parent::delete();
143 self::blow('profile_list:subscriber_count:%d',
144 $this->profile_tag_id);