PersistentObject/tests/persistent_session_identity_decorator/save_test.php

<?php
/**
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 * 
 *   http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 * @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
 * @version //autogentag//
 * @filesource
 * @package PersistentObject
 * @subpackage Tests
 */

require_once 'test_case.php';

/**
 * Tests the save facilities of ezcPersistentSession.
 *
 * @package PersistentObject
 * @subpackage Tests
 */
class ezcPersistentSessionIdentityDecoratorSaveTest extends ezcPersistentSessionIdentityDecoratorTest
{
    public static function suite()
    {
        return new PHPUnit_Framework_TestSuite( __CLASS__ );
    }

    // update
    
    public function testUpdateValid()
    {
        $object = $this->idSession->loadIfExists( 'PersistentTestObject', 1 );
        $this->assertEquals( 'PersistentTestObject', get_class( $object ) );
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text = "Finland has Nokia!";
        $this->idSession->update( $object );

        // check that we got the correct values
        $object2 = $this->idSession->loadIfExists( 'PersistentTestObject', 1 );

        $this->assertSame( $object, $object2 );
    }

    public function testUpdateInvalidObject()
    {
        try
        {
            $this->idSession->update( new Exception() );
            $this->fail( "Update of non-persistent object did not throw exception" );
        }
        catch ( ezcPersistentObjectException $e ) {}
    }

    public function testUpdateNotInDatabase()
    {
        try
        {
            $this->idSession->update( new PersistentTestObject() );
            $this->fail( "Update of object not in database did not fail." );
        }
        catch ( ezcPersistentObjectNotPersistentException $e ) {}
    }

    public function testConversionOnUpdate()
    {
        $obj = new PersistentTestObjectConverter();

        $obj->varchar = 'Foo Bar';
        // Leave null
        // $obj->integer = new DateTime( '@327535200' );
        $obj->decimal = 23.42;
        $obj->text    = 'Foo Bar Baz';

        $this->idSession->save( $obj );

        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertNull(
            $arr[5]->integer
        );

        $arr[5]->integer = new DateTime( '@327535200' );

        $this->idSession->update( $arr[5] );
        
        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertType(
            'DateTime',
            $arr[5]->integer
        );

        $this->assertEquals(
            '327535200',
            $arr[5]->integer->format( 'U' )
        );
    }

    public function testConversionNotBreaksState()
    {
        $date = new DateTime( '@327535200' );

        $obj = new PersistentTestObjectConverter();

        $obj->varchar = 'Foo Bar';
        $obj->integer = $date;
        $obj->decimal = 23.42;
        $obj->text    = 'Foo Bar Baz';

        $this->idSession->save( $obj );
        
        $this->assertSame(
            $date,
            $obj->integer
        );
    }
    
    public function testNoConversionOnUpdate()
    {
        $obj = new PersistentTestObjectConverter();

        $obj->varchar = 'Foo Bar';
        $obj->integer = new DateTime( '@327535200' );
        $obj->decimal = 23.42;
        $obj->text    = 'Foo Bar Baz';

        $this->idSession->save( $obj );

        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertType(
            'DateTime',
            $arr[5]->integer
        );

        $this->assertEquals(
            '327535200',
            $arr[5]->integer->format( 'U' )
        );

        $arr[5]->integer = null;

        $this->idSession->update( $arr[5] );
        
        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertNull(
            $arr[5]->integer
        );
    }

    // save

    public function testSaveValid()
    {
        $object          = new PersistentTestObject();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text    = "Finland has Nokia!";

        $this->idSession->save( $object );

        $this->assertEquals( 5, $object->id );

        $object2 = $this->idSession->loadIfExists( 'PersistentTestObject', 5 );

        $this->assertSame( $object, $object2 );
    }

    public function testSaveInvalidObject()
    {
        try
        {
            $this->idSession->save( new Exception() );
            $this->fail( "Save of non-persistent object did not throw exception" );
        }
        catch ( ezcPersistentDefinitionNotFoundException $e ) {}
    }

    public function testSaveAlreadyInDatabase()
    {
        $object = new PersistentTestObject();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text = "Finland has Nokia!";
        $this->idSession->save( $object );

        try
        {
            $this->idSession->save( $object );
            $this->fail( "Save of object already saved did not fail." );
        }
        catch ( ezcPersistentObjectAlreadyPersistentException $e ) {};
    }

    public function testSaveAlreadyInDatabaseRefetch()
    {
        $this->idSession->options->refetch = true;

        $object = new PersistentTestObject();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text = "Finland has Nokia!";
        $this->idSession->save( $object );

        try
        {
            $this->idSession->save( $object );
            $this->fail( "Save of object already saved did not fail." );
        }
        catch ( ezcPersistentObjectAlreadyPersistentException $e ) {};
    }

    public function testMissingIdProperty()
    {
        $object          = new PersistentTestObjectNoId();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text    = "Finland has Nokia!";

        try
        {
            $this->idSession->save( $object );
        }
        catch ( ezcPersistentDefinitionMissingIdPropertyException $e )
        {
            return;
        }
        $this->fail( "Exception not thrown on missing ID property." );
    }

    public function testSaveFailDuplicateIdentity()
    {
        $object          = new PersistentTestObject();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text    = "Finland has Nokia!";

        $secondObject = clone $object;

        $this->idSession->save( $object );

        $this->assertEquals( 5, $object->id );

        $secondObject->id = 5;
        
        try
        {
            $this->idSession->save( $secondObject );
            $this->fail( 'Exception not thrown on duplicate identity.' );
        }
        catch ( ezcPersistentIdentityAlreadyExistsException $e ) {}
    }

    public function testConversionOnSave()
    {
        $obj = new PersistentTestObjectConverter();

        $obj->varchar = 'Foo Bar';
        $obj->integer = new DateTime( '@327535200' );
        $obj->decimal = 23.42;
        $obj->text    = 'Foo Bar Baz';

        $this->idSession->save( $obj );

        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertType(
            'DateTime',
            $arr[5]->integer
        );

        $this->assertEquals(
            '327535200',
            $arr[5]->integer->format( 'U' )
        );
    }

    public function testNoConversionOnSave()
    {
        $obj = new PersistentTestObjectConverter();

        $obj->varchar = 'Foo Bar';
        // Leave null
        // $obj->integer = new DateTime( '@327535200' );
        $obj->decimal = 23.42;
        $obj->text    = 'Foo Bar Baz';

        $this->idSession->save( $obj );

        $q = $this->idSession->createFindQuery( 'PersistentTestObjectConverter' );
        $q->where(
            $q->expr->eq( 
                $this->idSession->database->quoteIdentifier( 'type_varchar' ),
                $q->bindValue( 'Foo Bar' )
            )
        );
        $arr = $this->idSession->find( $q, 'PersistentTestObjectConverter' );

        $this->assertEquals(
            1,
            count( $arr )
        );
        $this->assertTrue( isset( $arr[5] ) );

        $this->assertNull(
            $arr[5]->integer
        );
    }

    // Save or update

    public function testSaveOrUpdateSave()
    {
        $object          = new PersistentTestObject();
        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text    = "Finland has Nokia!";

        $this->idSession->saveOrUpdate( $object );

        $this->assertEquals( 5, $object->id );

        $object2 = $this->idSession->loadIfExists( 'PersistentTestObject', 5 );

        $this->assertSame( $object, $object2 );
    }

    public function testSaveOrUpdateUpdate()
    {
        $object = $this->idSession->loadIfExists( 'PersistentTestObject', 1 );
        $this->assertEquals( 'PersistentTestObject', get_class( $object ) );

        $object->varchar = 'Finland';
        $object->integer = 42;
        $object->decimal = 1.42;
        $object->text    = "Finland has Nokia!";

        $this->idSession->saveOrUpdate( $object );

        $object2 = $this->idSession->loadIfExists( 'PersistentTestObject', 1 );

        $this->assertSame( $object, $object2 );
    }

    public function testSaveOrUpdateInvalidObject()
    {
        try
        {
            $this->idSession->saveOrUpdate( new Exception() );
            $this->fail( "SaveorUpdate of non-persistent object did not throw exception" );
        }
        catch ( ezcPersistentDefinitionNotFoundException $e ) {}
    }

    // From query

    public function testUpdateFromQueryResetIdMap()
    {
        $o1 = $this->idSession->load( 'PersistentTestObject', 1 );
        $o2 = $this->idSession->load( 'PersistentTestObject', 2 );

        $this->assertNotNull(
            $this->idMap->getIdentity( 'PersistentTestObject', 1 )
        );
        $this->assertNotNull(
            $this->idMap->getIdentity( 'PersistentTestObject', 2 )
        );

        $q = $this->idSession->createUpdateQuery( 'PersistentTestObject' );
        $q->set( 'type_varchar', $this->session->database->quote( 'Foo bar' ) );
        $q->where( $q->expr->neq( 'integer', 1 ) );
        $this->idSession->updateFromQuery( $q );

        // ID map has been reset
        $this->assertNull(
            $this->idMap->getIdentity( 'PersistentTestObject', 1 )
        );
        $this->assertNull(
            $this->idMap->getIdentity( 'PersistentTestObject', 2 )
        );
    }
    
}

?>