public function testOfInsertOption()
{
# init our dao
$dao = new PluginOptionMySQLDAO();
$this->assertEqual($dao->insertOption(101, 'an option name', 'an option value'), 1, "added/inserted an option, id is 1");
$sql = "select * from " . $this->prefix . 'plugin_options where plugin_id = 101';
$stmt = PluginOptionMysqlDAO::$PDO->query($sql);
$data = $stmt->fetch();
$this->assertEqual($data['id'], 1);
$this->assertEqual($data['plugin_id'], 101);
$this->assertEqual($data['option_name'], 'an option name', 'an option name');
$this->assertEqual($data['option_value'], 'an option value', 'an option value');
$sql = "select count(*) as option_count from " . $this->prefix . 'plugin_options';
$stmt = PluginOptionMysqlDAO::$PDO->query($sql);
$data = $stmt->fetch();
$this->assertEqual($data['option_count'], 1, 'we should have one option');
}
public function testOfInsertOption()
{
# init our dao
$dao = new PluginOptionMySQLDAO();
$this->assertEqual($dao->insertOption(101, 'an option name', 'an option value'), 2, "added/inserted an option, id is 2");
$sql = "select * from " . $this->prefix . 'options where namespace = \'' . OptionDAO::PLUGIN_OPTIONS . '-101\'';
$stmt = PluginOptionMysqlDAO::$PDO->query($sql);
$data = $stmt->fetch();
$this->assertEqual($data['option_id'], 2);
$this->assertEqual($data['namespace'], OptionDAO::PLUGIN_OPTIONS . '-101');
$this->assertEqual($data['option_name'], 'an option name', 'an option name');
$this->assertEqual($data['option_value'], 'an option value', 'an option value');
$sql = "select count(*) as option_count from " . $this->prefix . 'options';
$stmt = PluginOptionMysqlDAO::$PDO->query($sql);
$data = $stmt->fetch();
$this->assertEqual($data['option_count'], 2, 'we should have two options');
}
