doctrine / orm

     * @group locking

     * @group DDC-178

     */

    public function testPessimisticReadLockQueryHintPostgreSql()

    {

        $this->_em->getConnection()->setDatabasePlatform(new PostgreSqlPlatform());

        $this->assertSqlGeneration(

            "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.username = 'gblanco'",

            "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.username AS username_2, c0_.name AS name_3 ".

            "FROM cms_users c0_ WHERE c0_.username = 'gblanco' FOR SHARE",

            [ORMQuery::HINT_LOCK_MODE => LockMode::PESSIMISTIC_READ]

        );

    }

    /**

     * @group DDC-1693

     * @group locking

     * @group DDC-178

     */

    public function testPessimisticReadLockQueryHintMySql()

    {

        $this->_em->getConnection()->setDatabasePlatform(new MySqlPlatform());

        $this->assertSqlGeneration(

            "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.username = 'gblanco'",

            "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.username AS username_2, c0_.name AS name_3 ".

            "FROM cms_users c0_ WHERE c0_.username = 'gblanco' LOCK IN SHARE MODE",

            [ORMQuery::HINT_LOCK_MODE => LockMode::PESSIMISTIC_READ]

        );

    }

    /**

     * @group locking

     * @group locking

     * @group DDC-178

     */

    public function testPessimisticReadLockQueryHintOracle()

    {

        $this->_em->getConnection()->setDatabasePlatform(new OraclePlatform());

        $this->assertSqlGeneration(

            "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.username = 'gblanco'",

            "SELECT c0_.id AS ID_0, c0_.status AS STATUS_1, c0_.username AS USERNAME_2, c0_.name AS NAME_3 ".

            "FROM cms_users c0_ WHERE c0_.username = 'gblanco' FOR UPDATE",

            [ORMQuery::HINT_LOCK_MODE => LockMode::PESSIMISTIC_READ]

        );

    }

    /**

     * @group DDC-431