helper_plugin_data::_aliases PHP Method

    function _aliases()
    {
        if (!is_null($this->aliases)) {
            return $this->aliases;
        }
        $sqlite = $this->_getDB();
        if (!$sqlite) {
            return array();
        }
        $this->aliases = array();
        $res = $sqlite->query("SELECT * FROM aliases");
        $rows = $sqlite->res2arr($res);
        foreach ($rows as $row) {
            $name = $row['name'];
            unset($row['name']);
            $this->aliases[$name] = array_filter(array_map('trim', $row));
            if (!isset($this->aliases[$name]['type'])) {
                $this->aliases[$name]['type'] = '';
            }
        }
        return $this->aliases;
    }

 public function testAliases()
 {
     $helper = new helper_plugin_data();
     $db = $helper->_getDB();
     $this->assertTrue($db !== false);
     $db->query("INSERT INTO aliases (name, type, prefix, postfix, enum) VALUES (?,?,?,?,?)", 'alias', 'wiki', '[[', ']]', '');
     $expect = array('alias' => array('type' => 'wiki', 'prefix' => '[[', 'postfix' => ']]'));
     $this->assertEquals($expect, $helper->_aliases());
 }