PHP TYPO3\CMS\Core\Database\DatabaseConnection::SELECT_mm_query Examples

Example #1

File: DatabaseConnectionTest.php Project: rickymathew/TYPO3.CMS

 /**
  * @test
  */
 public function sqlForSelectMmQuery()
 {
     $subject = new \TYPO3\CMS\Core\Database\DatabaseConnection();
     $result = $subject->SELECT_mm_query('*', 'sys_category', 'sys_category_record_mm', 'tt_content', 'AND sys_category.uid = 1', '', 'sys_category.title DESC');
     $expected = 'SELECT * FROM sys_category,sys_category_record_mm,tt_content WHERE sys_category.uid=sys_category_record_mm.uid_local AND tt_content.uid=sys_category_record_mm.uid_foreign AND sys_category.uid = 1 ORDER BY sys_category.title DESC';
     $this->assertEquals($expected, $result);
 }