From ad6f0501ff24cb287dedd21271d58c91e64b6b43 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@pobox.com>
Date: Tue, 26 Jan 2010 09:25:39 -0800
Subject: [PATCH] Site metadata tags in status_network: single 'tags' field,
 pipe-separated. $sn->tags() returns tag list as array; $sn->hasTag('blah') to
 check for a particular tag only

Could be used to control things in config file:

  $sn = Status_network::setupSite($_server, $_path, $_wildcard);
  if (!$sn) { die("No such site"); }
  if ($sn->hasTag('individual')) { /* blah */ }

Note memcached keys are unchanged; if tags are changed from an external tool clear:
  statusnet:<dbname>:status_network:<key>:<val>
  for <key>s 'nickname', 'hostname', and 'pathname'
---
 classes/Status_network.php | 20 ++++++++++++++++++++
 db/site.sql                |  2 ++
 2 files changed, 22 insertions(+)

diff --git a/classes/Status_network.php b/classes/Status_network.php
index 445f8a5a3c..f1314d6151 100644
--- a/classes/Status_network.php
+++ b/classes/Status_network.php
@@ -39,6 +39,7 @@ class Status_network extends DB_DataObject
     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) { return DB_DataObject::staticGet('Status_network',$k,$v); }
@@ -245,4 +246,23 @@ class Status_network extends DB_DataObject
             return $this->nickname . '.' . self::$wildcard;
         }
     }
+
+    /**
+     * Return site meta-info tags as an array
+     * @return array of strings
+     */
+    function getTags()
+    {
+        return array_filter(explode("|", strval($this->tags)));
+    }
+
+    /**
+     * Check if this site record has a particular meta-info tag attached.
+     * @param string $tag
+     * @return bool
+     */
+    function hasTag($tag)
+    {
+        return in_array($tag, $this->getTags());
+    }
 }
diff --git a/db/site.sql b/db/site.sql
index a9f64e5a5d..791303bd54 100644
--- a/db/site.sql
+++ b/db/site.sql
@@ -14,6 +14,8 @@ create table status_network (
     sitename varchar(255) comment 'display name',
     theme varchar(255) comment 'theme name',
     logo varchar(255) comment 'site logo',
+    
+    tags text comment 'site meta-info tags (pipe-separated)',
 
     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified'
-- 
2.39.5