/** * @test */ public function messageAfterQueryWithLastQueryEnabledContainsLastQuery() { Tx_Phpunit_Service_Database::getDatabaseConnection()->exec_SELECTquery('title', 'tx_phpunit_test', ''); $subject = new Tx_Phpunit_Exception_EmptyQueryResult(); self::assertContains('SELECT', $subject->getMessage()); }
/** * @test */ public function getDatabaseConnectionReturnsGlobalsDatabaseConnection() { self::assertSame($GLOBALS['TYPO3_DB'], \Tx_Phpunit_Service_Database::getDatabaseConnection()); }
/** * Imports the SQL definitions from a (ext_)tables.sql file. * * @param string $definitionContent * the SQL to import, must not be empty * * @return void */ private function importDatabaseDefinitions($definitionContent) { /* @var $install \TYPO3\CMS\Install\Service\SqlSchemaMigrationService */ $install = GeneralUtility::makeInstance('TYPO3\\CMS\\Install\\Service\\SqlSchemaMigrationService'); $fieldDefinitionsFile = $install->getFieldDefinitions_fileContent($definitionContent); if (empty($fieldDefinitionsFile)) { return; } // find statements to query $fieldDefinitionsDatabase = $install->getFieldDefinitions_fileContent($this->getTestDatabaseSchema()); $diff = $install->getDatabaseExtra($fieldDefinitionsFile, $fieldDefinitionsDatabase); $updateStatements = $install->getUpdateSuggestions($diff); $updateTypes = array('add', 'change', 'create_table'); $databaseConnection = Tx_Phpunit_Service_Database::getDatabaseConnection(); foreach ($updateTypes as $updateType) { if (array_key_exists($updateType, $updateStatements)) { foreach ((array) $updateStatements[$updateType] as $string) { $databaseConnection->admin_query($string); } } } }
/** * Updates an int field of a database table by one. This is mainly needed * for counting up the relation counter when creating a database relation. * * The field to update must be of type int. * * @param string $tableName * name of the table, must not be empty * @param int $uid * the UID of the record to modify, must be > 0 * @param string $fieldName * the field name of the field to modify, must not be empty * * @return void * * @throws \InvalidArgumentException * @throws Tx_Phpunit_Exception_Database */ public function increaseRelationCounter($tableName, $uid, $fieldName) { if (!$this->isTableNameAllowed($tableName)) { throw new \InvalidArgumentException('The table name "' . $tableName . '" is invalid. This means it is either empty or not in the list of allowed tables.', 1334439601); } if (!Tx_Phpunit_Service_Database::tableHasColumn($tableName, $fieldName)) { throw new \InvalidArgumentException('The table ' . $tableName . ' has no column ' . $fieldName . '.', 1334439616); } Tx_Phpunit_Service_Database::enableQueryLogging(); $dbResult = Tx_Phpunit_Service_Database::getDatabaseConnection()->sql_query('UPDATE ' . $tableName . ' SET ' . $fieldName . '=' . $fieldName . '+1 WHERE uid=' . $uid); if (!$dbResult) { throw new Tx_Phpunit_Exception_Database(1334439623); } if (Tx_Phpunit_Service_Database::getDatabaseConnection()->sql_affected_rows() === 0) { throw new Tx_Phpunit_Exception_Database(1334439632); } $this->markTableAsDirty($tableName); }
/** * @test * * @throws \Tx_Phpunit_Exception_Database */ public function getAutoIncrementReturnsOneForTruncatedTable() { \Tx_Phpunit_Service_Database::enableQueryLogging(); $dbResult = \Tx_Phpunit_Service_Database::getDatabaseConnection()->sql_query('TRUNCATE TABLE tx_phpunit_test;'); if ($dbResult === false) { throw new \Tx_Phpunit_Exception_Database(1334438839); } self::assertSame(1, $this->subject->getAutoIncrement('tx_phpunit_test')); }