/* the code below is auto generated do not remove the above tag */
public $__table = 'status_network'; // table name
- public $nickname; // varchar(64) primary_key not_null
+ public $site_id; // int(4) primary_key not_null
+ public $nickname; // varchar(64) unique_key not_null
public $hostname; // varchar(255) unique_key
public $pathname; // varchar(255) unique_key
public $dbhost; // varchar(255)
public $logo; // varchar(255)
public $created; // datetime() not_null
public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
- public $tags; // text
/* Static get */
- function staticGet($k,$v=NULL) {
+ static function getKV($k,$v=NULL) {
+ // TODO: This must probably be turned into a non-static call
$i = DB_DataObject::staticGet('Status_network',$k,$v);
// Don't use local process cache; if we're fetching multiple
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
- static $cache = null;
- static $cacheInitialized = false;
+ // XXX: made public so Status_network_tag can eff with it
+ public static $cache = null;
+ public static $cacheInitialized = false;
static $base = null;
static $wildcard = null;
* @param string $dbname
* @param array $servers memcached servers to use for caching config info
*/
- static function setupDB($dbhost, $dbuser, $dbpass, $dbname, $servers)
+ static function setupDB($dbhost, $dbuser, $dbpass, $dbname, array $servers)
{
global $config;
$config['db']['database_'.$dbname] = "mysqli://$dbuser:$dbpass@$dbhost/$dbname";
$config['db']['ini_'.$dbname] = INSTALLDIR.'/classes/status_network.ini';
- $config['db']['table_status_network'] = $dbname;
+
+ foreach (array('status_network', 'status_network_tag', 'unavailable_status_network') as $table) {
+ $config['db']['table_'.$table] = $dbname;
+ }
if (class_exists('Memcache')) {
self::$cache = new Memcache();
// or a single-process script which is switching
// configurations.
$persist = php_sapi_name() != 'cli' || self::$cacheInitialized;
- if (is_array($servers)) {
- foreach($servers as $server) {
- self::$cache->addServer($server, 11211, $persist);
+ if (!is_array($servers)) {
+ $servers = array($servers);
+ }
+ foreach($servers as $server) {
+ $parts = explode(':', $server);
+ $server = $parts[0];
+ if (count($parts) > 1) {
+ $port = $parts[1];
+ } else {
+ $port = 11211;
}
- } else {
- self::$cache->addServer($servers, 11211, $persist);
+ self::$cache->addServer($server, $port, $persist);
}
self::$cacheInitialized = true;
}
static function memGet($k, $v)
{
if (!self::$cache) {
- return self::staticGet($k, $v);
+ return self::getKV($k, $v);
}
$ck = self::cacheKey($k, $v);
$sn = self::$cache->get($ck);
if (empty($sn)) {
- $sn = self::staticGet($k, $v);
+ $sn = self::getKV($k, $v);
if (!empty($sn)) {
self::$cache->set($ck, clone($sn));
}
}
}
- function update($orig=null)
+ function update($dataObject=false)
+ {
+ if (is_object($dataObject)) {
+ $dataObject->decache(); # might be different keys
+ }
+ return parent::update($dataObject);
+ }
+
+ /**
+ * DB_DataObject doesn't allow updating keys (even non-primary)
+ */
+ function updateKeys(&$orig)
{
- if (is_object($orig)) {
- $orig->decache(); # might be different keys
+ $this->_connect();
+ foreach (array('hostname', 'pathname') as $k) {
+ if (strcmp($this->$k, $orig->$k) != 0) {
+ $parts[] = $k . ' = ' . $this->_quote($this->$k);
+ }
+ }
+ if (count($parts) == 0) {
+ // No changes
+ return true;
}
- return parent::update($orig);
+
+ $toupdate = implode(', ', $parts);
+
+ $table = common_database_tablename($this->tableName());
+ $qry = 'UPDATE ' . $table . ' SET ' . $toupdate .
+ ' WHERE nickname = ' . $this->_quote($this->nickname);
+ $orig->decache();
+ $result = $this->query($qry);
+ $this->decache();
+
+ return $result;
}
- function delete()
+ function delete($useWhere=false)
{
$this->decache(); # while we still have the values!
- return parent::delete();
+ return parent::delete($useWhere);
}
/**
* @param string $servername hostname
- * @param string $pathname URL base path
* @param string $wildcard hostname suffix to match wildcard config
+ * @return mixed Status_network or null
*/
- static function setupSite($servername, $pathname, $wildcard)
+ static function getFromHostname($servername, $wildcard)
{
- global $config;
-
$sn = null;
-
- // XXX I18N, probably not crucial for hostnames
- // XXX This probably needs a tune up
-
if (0 == strncasecmp(strrev($wildcard), strrev($servername), strlen($wildcard))) {
// special case for exact match
if (0 == strcasecmp($servername, $wildcard)) {
}
}
}
+ return $sn;
+ }
+
+ /**
+ * @param string $servername hostname
+ * @param string $pathname URL base path
+ * @param string $wildcard hostname suffix to match wildcard config
+ */
+ static function setupSite($servername, $pathname, $wildcard)
+ {
+ global $config;
+
+ $sn = null;
+
+ // XXX I18N, probably not crucial for hostnames
+ // XXX This probably needs a tune up
+ $sn = self::getFromHostname($servername, $wildcard);
if (!empty($sn)) {
*/
function getTags()
{
- return array_filter(explode("|", strval($this->tags)));
+ return Status_network_tag::getTags($this->site_id);
+ }
+
+ /**
+ * Save a given set of tags
+ * @param array tags
+ * @fixme only add/remove differentials
+ */
+ function setTags(array $tags)
+ {
+ $this->clearTags();
+ foreach ($tags as $tag) {
+ if (!empty($tag)) {
+ $snt = new Status_network_tag();
+ $snt->site_id = $this->site_id;
+ $snt->tag = $tag;
+ $snt->created = common_sql_now();
+
+ $id = $snt->insert();
+ if (!$id) {
+ // TRANS: Exception thrown when a tag cannot be saved.
+ throw new Exception(_("Unable to save tag."));
+ }
+ }
+ }
+
+ return true;
+ }
+
+ function clearTags()
+ {
+ $tag = new Status_network_tag();
+ $tag->site_id = $this->site_id;
+
+ if ($tag->find()) {
+ while($tag->fetch()) {
+ $tag->delete();
+ }
+ }
+
+ $tag->free();
}
/**