123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179 |
- <?php
- class Profile_prefs extends Managed_DataObject
- {
- public $__table = 'profile_prefs';
- public $profile_id;
- public $namespace;
- public $topic;
- public $data;
- public $created;
- public $modified;
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'user'),
- 'namespace' => array('type' => 'varchar', 'length' => 255, 'not null' => true, 'description' => 'namespace, like pluginname or category'),
- 'topic' => array('type' => 'varchar', 'length' => 255, 'not null' => true, 'description' => 'preference key, i.e. description, age...'),
- 'data' => array('type' => 'blob', 'description' => 'topic data, may be anything'),
- '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'),
- ),
- 'primary key' => array('profile_id', 'namespace', 'topic'),
- 'foreign keys' => array(
- 'profile_prefs_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
- ),
- 'indexes' => array(
- 'profile_prefs_profile_id_idx' => array('profile_id'),
- ),
- );
- }
- static function getNamespacePrefs(Profile $profile, $namespace, array $topic=array())
- {
- if (empty($topic)) {
- $prefs = new Profile_prefs();
- $prefs->profile_id = $profile->id;
- $prefs->namespace = $namespace;
- $prefs->find();
- } else {
- $prefs = self::pivotGet('profile_id', $profile->id, array('namespace'=>$namespace, 'topic'=>$topic));
- }
- if (empty($prefs->N)) {
- throw new NoResultException($prefs);
- }
- return $prefs;
- }
- static function getNamespace(Profile $profile, $namespace, array $topic=array())
- {
- $prefs = self::getNamespacePrefs($profile, $namespace, $topic);
- return $prefs->fetchAll();
- }
- static function getAll(Profile $profile)
- {
- try {
- $prefs = self::listFind('profile_id', $profile->id);
- } catch (NoResultException $e) {
- return array();
- }
- $list = array();
- while ($entry = $prefs->fetch()) {
- if (!isset($list[$entry->namespace])) {
- $list[$entry->namespace] = array();
- }
- $list[$entry->namespace][$entry->topic] = $entry->data;
- }
- return $list;
- }
- static function getTopic(Profile $profile, $namespace, $topic) {
- $pref = new Profile_prefs;
- $pref->profile_id = $profile->id;
- $pref->namespace = $namespace;
- $pref->topic = $topic;
- if (!$pref->find(true)) {
- throw new NoResultException($pref);
- }
- return $pref;
- }
- static function getData(Profile $profile, $namespace, $topic, $def=null) {
- try {
- $pref = self::getTopic($profile, $namespace, $topic);
- } catch (NoResultException $e) {
- if ($def === null) {
-
- throw $e;
- }
-
- return $def;
- }
- return $pref->data;
- }
- static function getConfigData(Profile $profile, $namespace, $topic) {
- try {
- $data = self::getData($profile, $namespace, $topic);
- } catch (NoResultException $e) {
- $data = common_config($namespace, $topic);
- }
- return $data;
- }
-
- static function setData(Profile $profile, $namespace, $topic, $data=null) {
- try {
- $pref = self::getTopic($profile, $namespace, $topic);
- if (is_null($data)) {
- $pref->delete();
- } else {
- $orig = clone($pref);
- $pref->data = $data;
- $pref->update($orig);
- }
- return true;
- } catch (NoResultException $e) {
- if (is_null($data)) {
- return false;
- }
- }
- $pref = new Profile_prefs();
- $pref->profile_id = $profile->id;
- $pref->namespace = $namespace;
- $pref->topic = $topic;
- $pref->data = $data;
- $pref->created = common_sql_now();
-
- if ($pref->insert() === false) {
- throw new ServerException('Could not save profile preference.');
- }
- return true;
- }
- }
|