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'); }