9.5/_add_test_8php_source.html

<?php

namespace ‪TYPO3\CMS\Extbase\Tests\Functional\Persistence;


/*

 * This file is part of the TYPO3 CMS project.

 *

 * It is free software; you can redistribute it and/or modify it under

 * the terms of the GNU General Public License, either version 2

 * of the License, or any later version.

 *

 * For the full copyright and license information, please read the

 * LICENSE.txt file that was distributed with this source code.

 *

 * The TYPO3 project - inspiring people to share!

 */


use ‪TYPO3\CMS\Core\Authentication\BackendUserAuthentication;

use ‪TYPO3\CMS\Core\Database\ConnectionPool;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;


class ‪AddTest extends \TYPO3\TestingFramework\Core\Functional\FunctionalTestCase

{

    protected ‪$persistentManager;


    protected ‪$testExtensionsToLoad = ['typo3/sysext/extbase/Tests/Functional/Fixtures/Extensions/blog_example'];


    protected ‪$coreExtensionsToLoad = ['extbase', 'fluid'];


    protected ‪$objectManager;


    protected ‪$blogRepository;


    protected function ‪setUp()

    {

        parent::setUp();


        $this->objectManager = GeneralUtility::makeInstance(\‪TYPO3\CMS\‪Extbase\Object\ObjectManager::class);

        $this->persistentManager = $this->objectManager->get(\‪TYPO3\CMS\‪Extbase\Persistence\Generic\PersistenceManager::class);

        $this->blogRepository = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Repository\BlogRepository::class);

        ‪$GLOBALS['BE_USER'] = new ‪BackendUserAuthentication();

    }


    public function ‪addSimpleObjectTest()

    {

        $newBlogTitle = 'aDi1oogh';

        $newBlog = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog::class);

        $newBlog->setTitle($newBlogTitle);


        $this->blogRepository->add($newBlog);

        $this->persistentManager->persistAll();


        $queryBuilder = (new ‪ConnectionPool())->getQueryBuilderForTable('tx_blogexample_domain_model_blog');

        $queryBuilder->getRestrictions()

            ->removeAll();

        $newBlogCount = $queryBuilder

            ->count('*')

            ->from('tx_blogexample_domain_model_blog')

            ->where(

                $queryBuilder->expr()->eq(

                    'title',

                    $queryBuilder->createNamedParameter($newBlogTitle, \PDO::PARAM_STR)

                )

            )

            ->execute()

            ->fetchColumn(0);

        $this->assertEquals(1, $newBlogCount);

    }


    public function ‪addObjectSetsDefaultLanguageTest()

    {

        $newBlogTitle = 'aDi1oogh';

        $newBlog = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog::class);

        $newBlog->setTitle($newBlogTitle);


        $this->blogRepository->add($newBlog);

        $this->persistentManager->persistAll();


        $queryBuilder = (new ‪ConnectionPool())->getQueryBuilderForTable('tx_blogexample_domain_model_blog');

        $queryBuilder->getRestrictions()

            ->removeAll();

        $newBlogRecord = $queryBuilder

            ->select('*')

            ->from('tx_blogexample_domain_model_blog')

            ->where(

                $queryBuilder->expr()->eq(

                    'title',

                    $queryBuilder->createNamedParameter($newBlogTitle, \PDO::PARAM_STR)

                )

            )

            ->execute()

            ->fetch();

        $this->assertEquals(0, $newBlogRecord['sys_language_uid']);

    }


    public function ‪addObjectSetsDefinedLanguageTest()

    {

        $newBlogTitle = 'aDi1oogh';

        $newBlog = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog::class);

        $newBlog->setTitle($newBlogTitle);

        $newBlog->_setProperty('_languageUid', -1);


        $this->blogRepository->add($newBlog);

        $this->persistentManager->persistAll();


        $queryBuilder = (new ‪ConnectionPool())->getQueryBuilderForTable('tx_blogexample_domain_model_blog');

        $queryBuilder->getRestrictions()

            ->removeAll();

        $newBlogRecord = $queryBuilder

            ->select('*')

            ->from('tx_blogexample_domain_model_blog')

            ->where(

                $queryBuilder->expr()->eq(

                    'title',

                    $queryBuilder->createNamedParameter($newBlogTitle, \PDO::PARAM_STR)

                )

            )

            ->execute()

            ->fetch();

        $this->assertEquals(-1, $newBlogRecord['sys_language_uid']);

    }


    public function ‪addObjectSetsNullAsNullForSimpleTypes()

    {

        $newBlogTitle = 'aDi1oogh';

        $newBlog = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog::class);

        $newBlog->setTitle($newBlogTitle);

        $newBlog->setSubtitle('subtitle');


        $this->blogRepository->add($newBlog);

        $this->persistentManager->persistAll();


        // make sure null can be set explicitly

        $insertedBlog = $this->blogRepository->findByUid(1);

        $insertedBlog->setSubtitle(null);

        $this->blogRepository->update($insertedBlog);

        $this->persistentManager->persistAll();


        $queryBuilder = (new ‪ConnectionPool())->getQueryBuilderForTable('tx_blogexample_domain_model_blog');

        $queryBuilder->getRestrictions()

            ->removeAll();

        $newBlogRecord = $queryBuilder

            ->select('*')

            ->from('tx_blogexample_domain_model_blog')

            ->where(

                $queryBuilder->expr()->eq(

                    'subtitle',

                    $queryBuilder->createNamedParameter($newBlogTitle, \PDO::PARAM_STR)

                )

            )

            ->execute()

            ->fetch();

        $this->assertNull($newBlogRecord['subtitle']);

    }

}