CategoryCollectionTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Core\Tests\Functional\Category\Collection;

use TYPO3\CMS\Core\Utility\GeneralUtility;

class CategoryCollectionTest extends \TYPO3\CMS\Core\Tests\FunctionalTestCase {

    private $fixture;

    private $tableName = 'tx_foo_5001615c50bed';

    private $tables = array('sys_category', 'sys_category_record_mm');

    private $categoryUid = 0;

    private $collectionRecord = array();

    private $numberOfRecords = 5;

    private $database;

    public function setUp() {
        parent::setUp();
        $this->database = $this->getDatabaseConnection();
        $this->fixture = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Category\\Collection\\CategoryCollection', $this->tableName);
        $this->collectionRecord = array(
            'uid' => 0,
            'title' => $this->getUniqueId('title'),
            'description' => $this->getUniqueId('description'),
            'table_name' => $this->tableName,
        );
        $GLOBALS['TCA'][$this->tableName] = array('ctrl' => array());
        // prepare environment
        $this->createDummyTable();
        $this->populateDummyTable();
        $this->prepareTables();
        $this->makeRelationBetweenCategoryAndDummyTable();
    }

    public function checkIfFromArrayMethodSetCorrectProperties() {
        $this->fixture->fromArray($this->collectionRecord);
        $this->assertEquals($this->collectionRecord['uid'], $this->fixture->getIdentifier());
        $this->assertEquals($this->collectionRecord['uid'], $this->fixture->getUid());
        $this->assertEquals($this->collectionRecord['title'], $this->fixture->getTitle());
        $this->assertEquals($this->collectionRecord['description'], $this->fixture->getDescription());
        $this->assertEquals($this->collectionRecord['table_name'], $this->fixture->getItemTableName());
    }

    public function canCreateDummyCollection() {
        $collection = \TYPO3\CMS\Core\Category\Collection\CategoryCollection::create($this->collectionRecord);
        $this->assertInstanceOf('\TYPO3\CMS\Core\Category\Collection\CategoryCollection', $collection);
    }

    public function canCreateDummyCollectionAndFillItems() {
        $collection = \TYPO3\CMS\Core\Category\Collection\CategoryCollection::create($this->collectionRecord, TRUE);
        $this->assertInstanceOf('\TYPO3\CMS\Core\Category\Collection\CategoryCollection', $collection);
    }

    public function getCollectedRecordsReturnsEmptyRecordSet() {
        $method = new \ReflectionMethod('TYPO3\\CMS\\Core\\Category\\Collection\\CategoryCollection', 'getCollectedRecords');
        $method->setAccessible(TRUE);
        $records = $method->invoke($this->fixture);
        $this->assertInternalType('array', $records);
        $this->assertEmpty($records);
    }

    public function isStorageTableNameEqualsToSysCategory() {
        $this->assertEquals('sys_category', \TYPO3\CMS\Core\Category\Collection\CategoryCollection::getStorageTableName());
    }

    public function isStorageItemsFieldEqualsToItems() {
        $this->assertEquals('items', \TYPO3\CMS\Core\Category\Collection\CategoryCollection::getStorageItemsField());
    }

    public function canLoadADummyCollectionFromDatabase() {
        $collection = \TYPO3\CMS\Core\Category\Collection\CategoryCollection::load($this->categoryUid, TRUE, $this->tableName);
        // Check the number of record
        $this->assertEquals($this->numberOfRecords, $collection->count());
        // Check that the first record is the one expected
        $record = $this->database->exec_SELECTgetSingleRow('*', $this->tableName, 'uid=1');
        $collection->rewind();
        $this->assertEquals($record, $collection->current());
        // Add a new record
        $fakeRecord = array(
            'uid' => $this->numberOfRecords + 1,
            'pid' => 0,
            'title' => $this->getUniqueId('title'),
            'categories' => 0
        );
        // Check the number of records
        $collection->add($fakeRecord);
        $this->assertEquals($this->numberOfRecords + 1, $collection->count());
    }

    public function canLoadADummyCollectionFromDatabaseAndAddRecord() {
        $collection = \TYPO3\CMS\Core\Category\Collection\CategoryCollection::load($this->categoryUid, TRUE, $this->tableName);
        // Add a new record
        $fakeRecord = array(
            'uid' => $this->numberOfRecords + 1,
            'pid' => 0,
            'title' => $this->getUniqueId('title'),
            'categories' => 0
        );
        // Check the number of records
        $collection->add($fakeRecord);
        $this->assertEquals($this->numberOfRecords + 1, $collection->count());
    }

    public function canLoadADummyCollectionWithoutContentFromDatabase() {
        $collection = \TYPO3\CMS\Core\Category\Collection\CategoryCollection::load($this->categoryUid, FALSE, $this->tableName);
        // Check the number of record
        $this->assertEquals(0, $collection->count());
    }

    /********************/
    /* INTERNAL METHODS */
    /********************/
    private function populateDummyTable() {
        for ($index = 1; $index <= $this->numberOfRecords; $index++) {
            $values = array(
                'title' => $this->getUniqueId('title')
            );
            $this->database->exec_INSERTquery($this->tableName, $values);
        }
    }

    private function makeRelationBetweenCategoryAndDummyTable() {
        for ($index = 1; $index <= $this->numberOfRecords; $index++) {
            $values = array(
                'uid_local' => $this->categoryUid,
                'uid_foreign' => $index,
                'tablenames' => $this->tableName,
                'fieldname' => 'categories'
            );
            $this->database->exec_INSERTquery('sys_category_record_mm', $values);
        }
    }

    private function createDummyTable() {
        $sql = 'CREATE TABLE ' . $this->tableName . ' (' . LF . TAB .
            'uid int(11) auto_increment,' . LF . TAB .
            'pid int(11) unsigned DEFAULT \'0\' NOT NULL,' . LF . TAB .
            'title tinytext,' . LF . TAB .
            'tcategories int(11) unsigned DEFAULT \'0\' NOT NULL,' . LF . TAB .
            'sys_category_is_dummy_record int(11) unsigned DEFAULT \'0\' NOT NULL,' . LF . LF . TAB .
            'PRIMARY KEY (uid)' . LF . ');';
        $this->database->sql_query($sql);
    }

    private function dropDummyTable() {
        $sql = 'DROP TABLE ' . $this->tableName . ';';
        $this->database->sql_query($sql);
    }

    private function prepareTables() {
        $sql = 'ALTER TABLE %s ADD is_dummy_record tinyint(1) unsigned DEFAULT \'0\' NOT NULL';
        foreach ($this->tables as $table) {
            $_sql = sprintf($sql, $table);
            $this->database->sql_query($_sql);
        }
        $values = array(
            'title' => $this->getUniqueId('title'),
            'is_dummy_record' => 1
        );
        $this->database->exec_INSERTquery('sys_category', $values);
        $this->categoryUid = $this->database->sql_insert_id();
    }
}