/** * Handler for CMSAPI database version manipulating * * @param string $toVersion Version to switch to * * @return string Current database version */ public function migrator($toVersion = null) { // If something passed - change database version to it if (func_num_args()) { // Save current version to special db table $this->database->execute("ALTER TABLE `" . dbMySQLConnector::$prefix . "cms_version`\n CHANGE `version` `version` VARCHAR( 15 ) CHARACTER SET utf8\n COLLATE utf8_general_ci NOT NULL DEFAULT '" . $toVersion . "';"); die('Database successfully migrated to [' . $toVersion . ']'); } else { // Return current database version $version_row = $this->database->fetch('SHOW COLUMNS FROM `' . dbMySQLConnector::$prefix . 'cms_version`'); if (isset($version_row[0]['Default'])) { return $version_row[0]['Default']; } else { return 0; } } }
public function testExecute() { $this->database->execute('SELECT * FROM `table`'); }