public $__table = 'local_group'; // table name
public $group_id; // int(4) primary_key not_null
public $nickname; // varchar(64) unique_key
- public $created; // datetime not_null default_0000-00-00%2000%3A00%3A00
- public $modified; // timestamp not_null default_CURRENT_TIMESTAMP
-
- /* Static get */
- function staticGet($k,$v=NULL) { return Memcached_DataObject::staticGet('Local_group',$k,$v); }
+ public $created; // datetime() not_null default_0000-00-00%2000%3A00%3A00
+ public $modified; // datetime() not_null default_CURRENT_TIMESTAMP
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
'fields' => array(
'group_id' => array('type' => 'int', 'not null' => true, 'description' => 'group represented'),
'nickname' => array('type' => 'varchar', 'length' => 64, 'description' => 'group represented'),
-
- 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+ 'created' => array('type' => 'datetime', 'not null' => true, 'default' => '0000-00-00 00:00:00', 'description' => 'date this record was created'),
+ 'modified' => array('type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was modified'),
),
'primary key' => array('group_id'),
'foreign keys' => array(
);
}
+ public function getProfile()
+ {
+ return $this->getGroup()->getProfile();
+ }
+
+ public function getGroup()
+ {
+ $group = new User_group();
+ $group->id = $this->group_id;
+ $group->find(true);
+ if (!$group instanceof User_group) {
+ common_log(LOG_ERR, 'User_group does not exist for Local_group: '.$this->group_id);
+ throw new NoSuchGroupException(array('id' => $this->group_id));
+ }
+ return $group;
+ }
+
function setNickname($nickname)
{
$this->decache();
- $qry = 'UPDATE local_group set nickname = "'.$nickname.'" where group_id = ' . $this->group_id;
+ $qry = 'UPDATE local_group set nickname = "'.$this->escape($nickname).'" where group_id = ' . $this->group_id;
$result = $this->query($qry);