+++ /dev/null
-<?php
-
-namespace RedUNIT\Base;
-
-use RedUNIT\Base as Base;
-use RedBeanPHP\Facade as R;
-use RedBeanPHP\Logger\RDefault as RDefault;
-use RedBeanPHP\Logger as Logger;
-use RedBeanPHP\OODBBean as OODBBean;
-use RedBeanPHP\OODB as OODB;
-use RedBeanPHP\Adapter as Adapter;
-use RedBeanPHP\QueryWriter as QueryWriter;
-use RedBeanPHP\RedException as RedException;
-use RedBeanPHP\RedException\SQL as SQL;
-use RedBeanPHP\Driver\RPDO as RPDO;
-use RedBeanPHP\SimpleModel as SimpleModel;
-
-/**
- * Misc
- *
- * @file RedUNIT/Base/Misc.php
- * @desc Various tests.
- * @author Gabor de Mooij and the RedBeanPHP Community
- * @license New BSD/GPLv2
- *
- * (c) G.J.G.T. (Gabor) de Mooij and the RedBeanPHP Community.
- * This source file is subject to the New BSD/GPLv2 License that is bundled
- * with this source code in the file license.txt.
- */
-class Misc extends Base
-{
- /**
- * Test whether we can set the 'auto clear'
- * option in OODB.
- *
- * @return void
- */
- public function testAutoClearHistory()
- {
- testpack( 'Auto clear history' );
- $book = R::dispense( 'book' );
- $book->pages = 100;
- $book->title = 'book';
- R::store( $book );
- $book = R::findOne( 'book' );
- asrt( $book->hasChanged( 'title' ), FALSE );
- $book->title = 'yes';
- R::store( $book );
- asrt( $book->hasChanged( 'title' ), TRUE );
- OODB::autoClearHistoryAfterStore( TRUE );
- $book = R::findOne( 'book' );
- asrt( $book->hasChanged( 'title' ), FALSE );
- $book->title = 'yes2';
- R::store( $book );
- asrt( $book->hasChanged( 'title' ), FALSE );
- OODB::autoClearHistoryAfterStore( FALSE );
- $book = R::findOne( 'book' );
- asrt( $book->hasChanged( 'title' ), FALSE );
- $book->title = 'yes';
- R::store( $book );
- asrt( $book->hasChanged( 'title' ), TRUE );
- }
-
- /**
- * Tests the R::inspect() method on the Facade.
- *
- * @return void
- */
- public function testInspect() {
-
- testpack( 'Test R::inspect() ' );
- R::nuke();
- R::store( R::dispense( 'book' )->setAttr( 'title', 'book' ) );
- $info = R::inspect();
- asrt( count( $info ), 1 );
- asrt( strtolower( $info[0] ), 'book' );
- $info = R::inspect( 'book' );
- asrt( count( $info ), 2 );
- $keys = array_keys( $info );
- sort($keys);
- asrt( strtolower( $keys[0] ), 'id' );
- asrt( strtolower( $keys[1] ), 'title' );
- }
-
- /**
- * Test whether we can use the tableExist() method in OODB
- * instances directly to help us determine
- * the existance of a table.
- *
- * @return void
- */
- public function testTableExist()
- {
- R::nuke();
- R::store( R::dispense( 'book' ) );
- R::freeze( FALSE );
- asrt( R::getRedBean()->tableExists( 'book' ), TRUE );
- asrt( R::getRedBean()->tableExists( 'book2' ), FALSE );
- R::freeze( TRUE );
- asrt( R::getRedBean()->tableExists( 'book' ), TRUE );
- asrt( R::getRedBean()->tableExists( 'book2' ), FALSE );
- R::freeze( FALSE );
- }
-
- /**
- * Normally the check() method is always called indirectly when
- * dealing with beans. This test ensures we can call check()
- * directly. Even though frozen repositories do not rely on
- * bean checking to improve performance the method should still
- * offer the same functionality when called directly.
- *
- * @return void
- */
- public function testCheckDirectly()
- {
- $bean = new OODBBean;
- $bean->id = 0;
- $bean->setMeta( 'type', 'book' );
- R::getRedBean()->check( $bean );
- $bean->setMeta( 'type', '.' );
- try {
- R::getRedBean()->check( $bean );
- fail();
- } catch ( \Exception $e ) {
- pass();
- }
- //check should remain the same even if frozen repo is used, method is public after all!
- //we dont want to break the API!
- R::freeze( TRUE );
- try {
- R::getRedBean()->check( $bean );
- fail();
- } catch ( \Exception $e ) {
- pass();
- }
- R::freeze( FALSE );
- }
-
- /**
- * Test Backward compatibility writer ESC-method.
- *
- * @return void
- */
- public function testLegacyCode()
- {
- testpack( 'Test Backward compatibility methods in writer.' );
- asrt( R::getWriter()->safeColumn( 'column', TRUE ), R::getWriter()->esc( 'column', TRUE ) );
- asrt( R::getWriter()->safeColumn( 'column', FALSE ), R::getWriter()->esc( 'column', FALSE ) );
- asrt( R::getWriter()->safeTable( 'table', TRUE ), R::getWriter()->esc( 'table', TRUE ) );
- asrt( R::getWriter()->safeTable( 'table', FALSE ), R::getWriter()->esc( 'table', FALSE ) );
- }
-
- /**
- * Test beautification and array functions.
- *
- * @return void
- */
- public function testBeauficationAndArrayFunctions()
- {
- $bean = R::dispense( 'bean' );
- $bean->isReallyAwesome = TRUE;
- asrt( isset( $bean->isReallyAwesome ), TRUE );
- asrt( isset( $bean->is_really_awesome ), TRUE );
- unset( $bean->is_really_awesome );
- asrt( isset( $bean->isReallyAwesome ), FALSE );
- asrt( isset( $bean->is_really_awesome ), FALSE );
- }
-
- /**
- * Test beautification of column names.
- *
- * @return void
- */
- public function testBeautifulColumnNames()
- {
- testpack( 'Beautiful column names' );
- $town = R::dispense( 'town' );
- $town->isCapital = FALSE;
- $town->hasTrainStation = TRUE;
- $town->name = 'BeautyVille';
- $houses = R::dispense( 'house', 2 );
- $houses[0]->isForSale = TRUE;
- $town->ownHouse = $houses;
- R::store( $town );
- $town = R::load( 'town', $town->id );
- asrt( ( $town->isCapital == FALSE ), TRUE );
- asrt( ( $town->hasTrainStation == TRUE ), TRUE );
- asrt( ( $town->name == 'BeautyVille' ), TRUE );
- testpack( 'Accept datetime objects.' );
- $cal = R::dispense( 'calendar' );
- $cal->when = new\DateTime( '2000-01-01', new\DateTimeZone( 'Pacific/Nauru' ) );
- asrt( $cal->when, '2000-01-01 00:00:00' );
- testpack( 'Affected rows test' );
- $currentDriver = $this->currentlyActiveDriverID;
- $toolbox = R::getToolBox();
- $adapter = $toolbox->getDatabaseAdapter();
- $writer = $toolbox->getWriter();
- $redbean = $toolbox->getRedBean();
- $pdo = $adapter->getDatabase();
- $bean = $redbean->dispense( 'bean' );
- $bean->prop = 3; //make test run with strict mode as well
- $redbean->store( $bean );
- $adapter->exec( 'UPDATE bean SET prop = 2' );
- asrt( $adapter->getAffectedRows(), 1 );
- testpack( 'Testing Logger' );
- R::getDatabaseAdapter()->getDatabase()->setLogger( new RDefault );
- asrt( ( R::getDatabaseAdapter()->getDatabase()->getLogger() instanceof Logger ), TRUE );
- asrt( ( R::getDatabaseAdapter()->getDatabase()->getLogger() instanceof RDefault ), TRUE );
- $bean = R::dispense( 'bean' );
- $bean->property = 1;
- $bean->unsetAll( array( 'property' ) );
- asrt( $bean->property, NULL );
- asrt( ( $bean->setAttr( 'property', 2 ) instanceof OODBBean ), TRUE );
- asrt( $bean->property, 2 );
- asrt( preg_match( '/\d\d\d\d\-\d\d\-\d\d/', R::isoDate() ), 1 );
- asrt( preg_match( '/\d\d\d\d\-\d\d\-\d\d\s\d\d:\d\d:\d\d/', R::isoDateTime() ), 1 );
- $redbean = R::getRedBean();
- $adapter = R::getDatabaseAdapter();
- $writer = R::getWriter();
- asrt( ( $redbean instanceof OODB ), TRUE );
- asrt( ( $adapter instanceof Adapter ), TRUE );
- asrt( ( $writer instanceof QueryWriter ), TRUE );
- R::setRedBean( $redbean );
- pass(); //cant really test this
- R::setDatabaseAdapter( $adapter );
- pass(); //cant really test this
- R::setWriter( $writer );
- pass(); //cant really test this
- $u1 = R::dispense( 'user' );
- $u1->name = 'Gabor';
- $u1->login = 'g';
- $u2 = R::dispense( 'user' );
- $u2->name = 'Eric';
- $u2->login = 'e';
- R::store( $u1 );
- R::store( $u2 );
- $list = R::getAssoc( 'select login,' . R::getWriter()->esc( 'name' ) . ' from ' . R::getWriter()->esc( 'user' ) . ' ' );
- asrt( $list['e'], 'Eric' );
- asrt( $list['g'], 'Gabor' );
- $painting = R::dispense( 'painting' );
- $painting->name = 'Nighthawks';
- $id = R::store( $painting );
- testpack( 'Testing SQL Error Types' );
- foreach ( $writer->typeno_sqltype as $code => $text ) {
- asrt( is_integer( $code ), TRUE );
- asrt( is_string( $text ), TRUE );
- }
- foreach ( $writer->sqltype_typeno as $text => $code ) {
- asrt( is_integer( $code ), TRUE );
- asrt( is_string( $text ), TRUE );
- }
- testpack( 'Testing Nowhere Pt. 1 (unfrozen)' );
- foreach (
- array(
- 'exec', 'getAll', 'getCell', 'getAssoc', 'getRow', 'getCol'
- )
- as $method ) {
- R::$method( 'select * from nowhere' );
- pass();
- }
- testpack( 'Testing Nowhere Pt. 2 (frozen)' );
- R::freeze( TRUE );
- foreach (
- array(
- 'exec', 'getAll', 'getCell', 'getAssoc', 'getRow', 'getCol'
- )
- as $method ) {
- try {
- R::$method( 'select * from nowhere' );
- fail();
- } catch ( SQL $e ) {
- pass();
- }
- }
- R::freeze( FALSE );
- }
-
- /**
- * Test reflectional functions of database.
- *
- * @return void
- */
- public function testDatabaseProperties()
- {
- testpack( 'Testing Database Properties' );
- $adapter = R::getDatabaseAdapter();
- if ( method_exists( R::getDatabaseAdapter()->getDatabase(), 'getPDO' ) ){
- asrt( $adapter->getDatabase()->getPDO() instanceof \PDO, TRUE );
- }
- asrt( strlen( $adapter->getDatabase()->getDatabaseVersion() ) > 0, TRUE );
- asrt( strlen( $adapter->getDatabase()->getDatabaseType() ) > 0, TRUE );
- }
-
- /**
- * Test Transactions.
- *
- * @return void
- */
- public function testTransactions()
- {
- testpack( 'transactions' );
- R::begin();
- $bean = R::dispense( 'bean' );
- R::store( $bean );
- R::commit();
- asrt( R::count( 'bean' ), 1 );
- R::wipe( 'bean' );
- R::freeze( 1 );
- R::begin();
- $bean = R::dispense( 'bean' );
- R::store( $bean );
- R::rollback();
- asrt( R::count( 'bean' ), 0 );
- R::freeze( FALSE );
- testpack( 'genSlots' );
- asrt( R::genSlots( array( 'a', 'b' ) ), '?,?' );
- asrt( R::genSlots( array( 'a' ) ), '?' );
- asrt( R::genSlots( array() ), '' );
- }
-
- /**
- * Test nested FUSE scenarios.
- *
- * @return void
- */
- public function testFUSEnested()
- {
- testpack( 'FUSE models cant touch nested beans in update() - issue 106' );
- $spoon = R::dispense( 'spoon' );
- $spoon->name = 'spoon for test bean';
- $deep = R::dispense( 'deep' );
- $deep->name = 'deepbean';
- $item = R::dispense( 'item' );
- $item->val = 'Test';
- $item->deep = $deep;
- $test = R::dispense( 'test' );
- $test->item = $item;
- $test->sharedSpoon[] = $spoon;
- $test->isnowtainted = TRUE;
- $id = R::store( $test );
- $test = R::load( 'test', $id );
- asrt( $test->item->val, 'Test2' );
- $can = reset( $test->ownCan );
- $spoon = reset( $test->sharedSpoon );
- asrt( $can->name, 'can for bean' );
- asrt( $spoon->name, 'S2' );
- asrt( $test->item->deep->name, '123' );
- asrt( count( $test->ownCan ), 1 );
- asrt( count( $test->sharedSpoon ), 1 );
- asrt( count( $test->sharedPeas ), 10 );
- asrt( count( $test->ownChip ), 9 );
- }
-
- /**
- * Tests FUSE and lists, FUSE enforces no more than
- * 3 sugar cubes in coffee.
- *
- * @return void
- */
- public function testCoffeeWithSugarAndFUSE()
- {
- $coffee = R::dispense( 'coffee' );
- $coffee->size = 'XL';
- $coffee->ownSugar = R::dispense( 'sugar', 5 );
- $id = R::store( $coffee );
- $coffee = R::load( 'coffee', $id );
- asrt( count( $coffee->ownSugar ), 3 );
- $coffee->ownSugar = R::dispense( 'sugar', 2 );
- $id = R::store( $coffee );
- $coffee = R::load( 'coffee', $id );
- asrt( count( $coffee->ownSugar ), 2 );
- $cocoa = R::dispense( 'cocoa' );
- $cocoa->name = 'Fair Cocoa';
- list( $taste1, $taste2 ) = R::dispense( 'taste', 2 );
- $taste1->name = 'sweet';
- $taste2->name = 'bitter';
- $cocoa->ownTaste = array( $taste1, $taste2 );
- R::store( $cocoa );
- $cocoa->name = 'Koko';
- R::store( $cocoa );
- if ( method_exists( R::getDatabaseAdapter()->getDatabase(), 'getPDO' ) ) {
- $pdo = R::getDatabaseAdapter()->getDatabase()->getPDO();
- $driver = new RPDO( $pdo );
- pass();
- asrt( $pdo->getAttribute(\PDO::ATTR_ERRMODE ),\PDO::ERRMODE_EXCEPTION );
- asrt( $pdo->getAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE ),\PDO::FETCH_ASSOC );
- asrt( strval( $driver->GetCell( 'select 123' ) ), '123' );
- }
- $a = new SQL;
- $a->setSqlState( 'test' );
- $b = strval( $a );
- asrt( ( strpos( $b, '[test] - ' ) === 0 ), TRUE );
- }
-
- /**
- * ENUM Basic tests.
- *
- * @return void
- */
- public function testENUMBasics() {
- asrt( R::enum( 'gender:male' )->name, 'MALE' );
- asrt( R::enum( 'country:South-Africa' )->name, 'SOUTH_AFRICA' );
- asrt( R::enum( 'tester:T@E S_t' )->name, 'T_E_S_T' );
- }
-
- /**
- * Test ENUM in Queries and with short hand notation.
- *
- * @return void
- */
- public function testENUMInQuery()
- {
- testpack('Test ENUM in Query and test ENUM short notation');
- R::nuke();
- $coffee = R::dispense( 'coffee' );
- $coffee->taste = R::enum( 'flavour:mocca' );
- R::store( $coffee );
- $coffee = R::dispense( 'coffee' );
- $coffee->taste = R::enum( 'flavour:banana' );
- R::store( $coffee );
- $coffee = R::dispense( 'coffee' );
- $coffee->taste = R::enum( 'flavour:banana' );
- R::store( $coffee );
- //now we have two flavours
- asrt( R::count('flavour'), 2 );
- //use in query
- asrt( R::count( 'coffee', ' taste_id = ? ', array( R::enum( 'flavour:mocca' )->id ) ), 1);
- //use in quer with short notation
- asrt( R::count( 'coffee', ' taste_id = ? ', array( EID( 'flavour:mocca' ) ) ), 1);
- //use in query
- asrt( R::count( 'coffee', ' taste_id = ? ', array( R::enum( 'flavour:banana' )->id ) ), 2);
- //use in quer with short notation
- asrt( R::count( 'coffee', ' taste_id = ? ', array( EID( 'flavour:banana' ) ) ), 2);
- //use in query
- asrt( R::count( 'coffee', ' taste_id = ? ', array( R::enum( 'flavour:strawberry' )->id ) ), 0);
- //use in quer with short notation
- asrt( R::count( 'coffee', ' taste_id = ? ', array( EID( 'flavour:strawberry' ) ) ), 0);
- }
-
- /**
- * Test ENUM functionality offered by Label Maker.
- *
- * @return void
- */
- public function testENUM() {
- testpack('test ENUM');
- $coffee = R::dispense( 'coffee' );
- $coffee->taste = R::enum( 'flavour:mocca' );
- //did we create an enum?
- asrt( implode( '', R::gatherLabels( R::enum( 'flavour' ) ) ), 'MOCCA' );
- R::store( $coffee );
- $coffee = $coffee->fresh();
- //test enum identity check - with alias
- asrt( $coffee->fetchAs( 'flavour' )->taste->equals( R::enum('flavour:mocca') ), TRUE );
- asrt( $coffee->fetchAs( 'flavour' )->taste->equals( R::enum('flavour:banana') ), FALSE );
- //now we have two flavours
- asrt( R::count( 'flavour' ), 2 );
- asrt( implode( ',', R::gatherLabels( R::enum( 'flavour') ) ), 'BANANA,MOCCA' );
- $coffee->flavour = R::enum( 'flavour:mocca' );
- R::store($coffee);
- //same results, can we have multiple flavours?
- asrt( $coffee->fetchAs( 'flavour' )->taste->equals( R::enum( 'flavour:mocca' ) ), TRUE );
- asrt( $coffee->fetchAs( 'flavour' )->taste->equals( R::enum( 'flavour:banana' ) ), FALSE );
- asrt( $coffee->flavour->equals( R::enum( 'flavour:mocca' ) ), TRUE );
- //no additional mocca enum...
- asrt( R::count( 'flavour' ), 2 );
- $drink = R::dispense( 'drink' );
- $drink->flavour = R::enum( 'flavour:choco' );
- R::store( $drink );
- //now we have three!
- asrt( R::count('flavour'), 3 );
- $drink = R::load( 'drink', $drink->id );
- asrt( $drink->flavour->equals( R::enum('flavour:mint') ), FALSE );
- asrt( $drink->flavour->equals( R::enum('flavour:choco') ), TRUE );
- asrt( R::count( 'flavour' ), 4 );
- //trash should not affect flavour!
- R::trash( $drink );
- asrt( R::count( 'flavour' ), 4 );
- }
-
- /**
- * Test trashAll().
- */
- public function testMultiDeleteUpdate()
- {
- testpack( 'test multi delete and multi update' );
- $beans = R::dispenseLabels( 'bean', array( 'a', 'b' ) );
- $ids = R::storeAll( $beans );
- asrt( (int) R::count( 'bean' ), 2 );
- R::trashAll( R::batch( 'bean', $ids ) );
- asrt( (int) R::count( 'bean' ), 0 );
- testpack( 'test assocManager check' );
- $rb = new OODB( R::getWriter() );
- try {
- $rb->getAssociationManager();
- fail();
- } catch ( RedException $e ) {
- pass();
- }
- }
-
- /**
- * Test Bean identity equality.
- */
- public function testBeanIdentityEquality() {
- $beanA = R::dispense( 'bean' );
- $beanB = R::dispense( 'bean' );
- $beanA->id = 1;
- $beanB->id = 1;
- asrt( $beanA->equals( $beanB ), TRUE );
- asrt( $beanB->equals( $beanA ), TRUE );
- asrt( $beanA->equals( $beanA ), TRUE );
- asrt( $beanB->equals( $beanB ), TRUE );
- $beanB->id = 2;
- asrt( $beanA->equals( $beanB ), FALSE );
- asrt( $beanB->equals( $beanA ), FALSE );
- $beanA->id = '2';
- asrt( $beanA->equals( $beanB ), TRUE );
- asrt( $beanB->equals( $beanA ), TRUE );
- $beanB = R::dispense( 'carrot' );
- $beanB->id = $beanA->id;
- asrt( $beanA->equals( $beanB ), FALSE );
- asrt( $beanB->equals( $beanA ), FALSE );
- }
-
- /**
- * Test if adding SimpleModles to a shared list will auto unbox them.
- */
- public function testSharedListsAutoUnbox() {
- $boxedBean = R::dispense( 'boxedbean' );
- $bean = R::dispense( 'bean' );
- $model = new SimpleModel();
- $model->loadBean($boxedBean);
- $bean->ownBoxedbeanList[] = $model;
- try {
- R::store( $bean );
- pass();
- } catch ( \Exception $e ) {
- fail();
- }
- }
-}