3 * Table Definition for local_group
6 class Local_group extends Managed_DataObject
9 /* the code below is auto generated do not remove the above tag */
11 public $__table = 'local_group'; // table name
12 public $group_id; // int(4) primary_key not_null
13 public $nickname; // varchar(64) unique_key
14 public $created; // datetime() not_null default_0000-00-00%2000%3A00%3A00
15 public $modified; // datetime() not_null default_CURRENT_TIMESTAMP
17 /* the code above is auto generated do not remove the tag below */
20 public static function schemaDef()
23 'description' => 'Record for a user group on the local site, with some additional info not in user_group',
25 'group_id' => array('type' => 'int', 'not null' => true, 'description' => 'group represented'),
26 'nickname' => array('type' => 'varchar', 'length' => 64, 'description' => 'group represented'),
27 'created' => array('type' => 'datetime', 'not null' => true, 'default' => '0000-00-00 00:00:00', 'description' => 'date this record was created'),
28 'modified' => array('type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was modified'),
30 'primary key' => array('group_id'),
31 'foreign keys' => array(
32 'local_group_group_id_fkey' => array('user_group', array('group_id' => 'id')),
34 'unique keys' => array(
35 'local_group_nickname_key' => array('nickname'),
40 public function getProfile()
42 return $this->getGroup()->getProfile();
45 public function getGroup()
47 $group = new User_group();
48 $group->id = $this->group_id;
50 if (!$group instanceof User_group) {
51 common_log(LOG_ERR, 'User_group does not exist for Local_group: '.$this->group_id);
52 throw new NoSuchGroupException(array('id' => $this->group_id));
57 function setNickname($nickname)
60 $qry = 'UPDATE local_group set nickname = "'.$this->escape($nickname).'" where group_id = ' . $this->group_id;
62 $result = $this->query($qry);
65 $this->nickname = $nickname;
66 $this->fixupTimestamps();
69 common_log_db_error($local, 'UPDATE', __FILE__);
70 // TRANS: Server exception thrown when updating a local group fails.
71 throw new ServerException(_('Could not update local group.'));