protected function prepareFetchObjects(array $data) { $stmt = $this->createMock(\PDOStatement::class); $stmt->method('fetchAll')->willReturn($data); $this->driver->method('query')->willReturn($stmt); return $this->database->fetchObjectsWithJoin('SELECT column1, column2 FROM `table`', $this->metadata, $this->joinedMetadata); }
/** * 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; } } }