*
* @see DB_DataObject
*/
-
-class Nickname_blacklist extends Memcached_DataObject
+class Nickname_blacklist extends Managed_DataObject
{
public $__table = 'nickname_blacklist'; // table name
- public $pattern; // string pattern
- public $created; // datetime
+ public $pattern; // varchar(255) pattern
+ public $created; // datetime not_null
+ public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
- /**
- * Get an instance by key
- *
- * This is a utility method to get a single instance with a given key value.
- *
- * @param string $k Key to use to lookup
- * @param mixed $v Value to lookup
- *
- * @return Nickname_blacklist object found, or null for no hits
- *
- */
-
- function staticGet($k, $v=null)
+ public static function schemaDef()
{
- return Memcached_DataObject::staticGet('Nickname_blacklist', $k, $v);
- }
-
- /**
- * return table definition for DB_DataObject
- *
- * @return array array of column definitions
- */
-
- function table()
- {
- return array('pattern' => DB_DATAOBJECT_STR + DB_DATAOBJECT_NOTNULL,
- 'created' => DB_DATAOBJECT_STR + DB_DATAOBJECT_DATE + DB_DATAOBJECT_TIME + DB_DATAOBJECT_NOTNULL);
- }
-
- /**
- * return key definitions for DB_DataObject
- *
- * @return array key definitions
- */
-
- function keys()
- {
- return array_keys($this->keyTypes());
- }
-
- /**
- * return key definitions for Memcached_DataObject
- *
- * @return array key definitions
- */
-
- function keyTypes()
- {
- return array('pattern' => 'K');
+ return array(
+ 'fields' => array(
+ 'pattern' => array('type' => 'varchar', 'not null' => true, 'length' => 255, 'description' => 'blacklist pattern'),
+ '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('pattern'),
+ );
}
/**
*
* @return array string patterns to check
*/
-
static function getPatterns()
{
$patterns = self::cacheGet('nickname_blacklist:patterns');
*
* @return array of patterns to check
*/
-
static function saveNew($newPatterns)
{
$oldPatterns = self::getPatterns();
// Delete stuff that's old that not in new
-
$toDelete = array_diff($oldPatterns, $newPatterns);
// Insert stuff that's in new and not in old
-
$toInsert = array_diff($newPatterns, $oldPatterns);
foreach ($toDelete as $pattern) {
- $nb = Nickname_blacklist::staticGet('pattern', $pattern);
+ $nb = Nickname_blacklist::getKV('pattern', $pattern);
if (!empty($nb)) {
$nb->delete();
}
static function ensurePattern($pattern)
{
- $nb = Nickname_blacklist::staticGet('pattern', $pattern);
+ $nb = Nickname_blacklist::getKV('pattern', $pattern);
if (empty($nb)) {
$nb = new Nickname_blacklist();