X-Git-Url: http://www.aleph1.co.uk/gitweb/?a=blobdiff_plain;ds=sidebyside;f=vendor%2Fgabordemooij%2Fredbean%2Ftesting%2FRedUNIT%2FBase%2FUpdate.php;fp=vendor%2Fgabordemooij%2Fredbean%2Ftesting%2FRedUNIT%2FBase%2FUpdate.php;h=0000000000000000000000000000000000000000;hb=9917807b03b64faf00f6a1f29dcb6eafc454efa5;hp=dae0a9257c5280a3fbfdf2ae8964f4c800c31b74;hpb=aea91e65e895364e460983b890e295aa5d5540a5;p=yaffs-website

diff --git a/vendor/gabordemooij/redbean/testing/RedUNIT/Base/Update.php b/vendor/gabordemooij/redbean/testing/RedUNIT/Base/Update.php
deleted file mode 100644
index dae0a9257..000000000
--- a/vendor/gabordemooij/redbean/testing/RedUNIT/Base/Update.php
+++ /dev/null
@@ -1,403 +0,0 @@
-<?php
-
-namespace RedUNIT\Base;
-
-use RedUNIT\Base as Base;
-use RedBeanPHP\Facade as R;
-use RedBeanPHP\RedException as RedException;
-use RedBeanPHP\QueryWriter as QueryWriter;
-use RedBeanPHP\QueryWriter\AQueryWriter as AQueryWriter;
-
-/**
- * Update
- *
- * Tests basic update functionality - however this test suite
- * has grown to cover various other scenarios involving updates as
- * well, including setting of property filters (necessary for
- * spatial tools in MySQL), storiging INF value and more...
- *
- * @file    RedUNIT/Base/Update.php
- * @desc    Tests basic storage features through OODB class.
- * @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 Update extends Base
-{
-	/**
-	 * Test whether we can use SQL filters and
-	 * whether they are being applied properly for
-	 * different types of SELECT queries in the QueryWriter.
-	 */
-	public function testSQLFilters()
-	{
-		R::nuke();
-		AQueryWriter::setSQLFilters(array(
-			QueryWriter::C_SQLFILTER_READ => array(
-				'book' => array( 'title' => ' LOWER(book.title) '),
-			),
-			QueryWriter::C_SQLFILTER_WRITE => array(
-				'book' => array( 'title' => ' UPPER(?) '),
-			),
-		));
-
-		$book = R::dispense( 'book' );
-		$book->title = 'story';
-		R::store( $book );
-		asrt( R::getCell( 'SELECT title FROM book WHERE id = ?', array( $book->id ) ), 'STORY' );
-		$book = $book->fresh();
-		asrt( $book->title, 'story' );
-		$library = R::dispense( 'library' );
-		$library->sharedBookList[] = $book;
-		R::store( $library );
-		$library = $library->fresh();
-		$books = $library->sharedBookList;
-		$book = reset( $books );
-		asrt( $book->title, 'story' );
-		$otherBook = R::dispense('book');
-		$otherBook->sharedBook[] = $book;
-		R::store( $otherBook );
-		$otherBook = $otherBook->fresh();
-		$books = $otherBook->sharedBookList;
-		$book = reset( $books );
-		asrt( $book->title, 'story' );
-		$links = $book->ownBookBookList;
-		$link = reset( $links );
-		$link->shelf = 'x13';
-		AQueryWriter::setSQLFilters(array(
-			QueryWriter::C_SQLFILTER_READ => array(
-				'book' => array( 'title' => ' LOWER(book.title) '),
-				'book_book' => array( 'shelf' => ' LOWER(book_book.shelf) '),
-			),
-			QueryWriter::C_SQLFILTER_WRITE => array(
-				'book' => array( 'title' => ' UPPER(?) '),
-				'book_book' => array( 'shelf' => ' UPPER(?) ')
-			),
-		));
-		R::store( $link );
-		asrt( R::getCell( 'SELECT shelf FROM book_book WHERE id = ?', array( $link->id ) ), 'X13' );
-		$otherBook = $otherBook->fresh();
-		unset($book->sharedBookList[$otherBook->id]);
-		R::store( $book );
-		AQueryWriter::setSQLFilters(array());
-	}
-
-	/**
-	 * Test unsetting properties.
-	 *
-	 * @return void
-	 */
-	public function testUnsetUpdate()
-	{
-		R::nuke();
-		$book = R::dispense( 'book' );
-		$book->name = 'x';
-		$book->price = 40;
-		R::store( $book );
-		$book = $book->fresh();
-		$book->name = 'y';
-		unset( $book->name );
-		R::store( $book );
-		$book = $book->fresh();
-		asrt( $book->name, 'x' );
-		asrt( (int) $book->price, 40 );
-		$book->price = 30;
-		R::store( $book );
-		$book = $book->fresh();
-		asrt( $book->name, 'x' );
-		asrt( (int) $book->price, 30 );
-		$book->price = 20;
-		unset( $book->price );
-		$book->name = 'y';
-		R::store( $book );
-		$book = $book->fresh();
-		asrt( $book->name, 'y' );
-		asrt( (int) $book->price, 30 );
-	}
-
-	/**
-	 * Tests whether we can update or unset a parent bean
-	 * with an alias without having to use fetchAs and
-	 * without loading the aliased bean causing table-not-found
-	 * errors.
-	 */
-	public function testUpdatingParentBeansWithAliases()
-	{
-		testpack( 'Test updating parent beans with aliases' );
-		R::nuke();
-		$trans  = R::dispense( 'transaction' );
-		$seller = R::dispense( 'user' );
-		$trans->seller = $seller;
-		$id = R::store( $trans );
-		R::freeze( TRUE );
-		$trans = R::load( 'transaction', $id );
-		//should not try to load seller, should not require fetchAs().
-		try {
-			$trans->seller = R::dispense( 'user' );
-			pass();
-		} catch( Exception $e ) {
-			fail();
-		}
-		$trans = R::load( 'transaction', $id );
-		//same for unset...
-		try {
-			unset( $trans->seller );
-			pass();
-		} catch ( Exception $e ) {
-			fail();
-		}
-		R::freeze( FALSE );
-		$account = R::dispense( 'user' );
-		asrt( count( $account->alias( 'seller' )->ownTransaction ), 0 );
-		$account->alias( 'seller' )->ownTransaction = R::dispense( 'transaction', 10 );
-		$account->alias( 'boo' ); //try to trick me...
-		$id = R::store( $account );
-		R::freeze( true );
-		$account = R::load( 'user', $id );
-		asrt( count( $account->alias( 'seller' )->ownTransaction ), 10 );
-		//you cannot unset a list
-		unset( $account->alias( 'seller' )->ownTransaction );
-		$id = R::store( $account );
-		$account = R::load( 'user', $id );
-		asrt( count( $account->alias( 'seller' )->ownTransaction ), 10 );
-		$account->alias( 'seller' )->ownTransaction = array();
-		$id = R::store( $account );
-		$account = R::load( 'user', $id );
-		asrt(count($account->alias( 'seller' )->ownTransaction), 0 );
-		asrt(count($account->ownTransaction), 0 );
-		R::freeze( FALSE );
-		//but also make sure we don't cause extra column issue #335
-		R::nuke();
-		$building = R::dispense('building');
-		$village  = R::dispense('village');
-		$building->village = $village;
-		R::store($building);
-		$building = $building->fresh();
-		$building->village = NULL;
-		R::store($building);
-		$building = $building->fresh();
-		$columns = R::inspect('building');
-		asrt( isset( $columns['village'] ), FALSE );
-		asrt( isset( $building->village ), FALSE );
-		R::nuke();
-		$building = R::dispense('building');
-		$village  = R::dispense('village');
-		$building->village = $village;
-		R::store($building);
-		$building = $building->fresh();
-		unset($building->village);
-		R::store($building);
-		$building = $building->fresh();
-		$columns = R::inspect('building');
-		asrt( isset( $columns['village'] ), FALSE );
-		asrt( isset( $building->village ), FALSE );
-		$building = R::dispense('building');
-		$village  = R::dispense('village');
-		$building->village = $village;
-		R::store($building);
-		$building = $building->fresh();
-		$building->village = FALSE;
-		R::store($building);
-		$building = $building->fresh();
-		$columns = R::inspect('building');
-		asrt( isset( $columns['village'] ), FALSE );
-		asrt( isset( $building->village ), FALSE );
-	}
-
-	/**
-	 * All kinds of tests for basic CRUD.
-	 *
-	 * Does the data survive?
-	 *
-	 * @return void
-	 */
-	public function testUpdatingBeans()
-	{
-		testpack( 'Test basic support UUID/override ID default value' );
-		$bean = R::dispense( 'bean' );
-		R::store( $bean );
-		if ($this->currentlyActiveDriverID === 'mysql') {
-			//otherwise UTF8 causes index overflow in mysql: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
-			R::exec('alter table bean modify column id char(3);');
-		} else {
-			R::getWriter()->widenColumn( 'bean', 'id', R::getWriter()->scanType( 'abc' ) );
-		}
-		$bean->id = 'abc';
-		R::store( $bean );
-		asrt( $bean->id, 'abc' );
-		testpack( 'Test Update' );
-		try {
-			R::store( array() );
-			fail();
-		} catch ( RedException $e ) {
-			pass();
-		}
-		$toolbox = R::getToolBox();
-		$adapter = $toolbox->getDatabaseAdapter();
-		$writer  = $toolbox->getWriter();
-		$redbean = $toolbox->getRedBean();
-		$pdo     = $adapter->getDatabase();
-		$page    = $redbean->dispense( "page" );
-		$page->name = "old name";
-		$id = $redbean->store( $page );
-		asrt( $page->getMeta( 'tainted' ), FALSE );
-		$page->setAttr( 'name', "new name" );
-		asrt( $page->getMeta( 'tainted' ), TRUE );
-		$id = $redbean->store( $page );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		// Null should == NULL after saving
-		$page->rating = NULL;
-		$newid = $redbean->store( $page );
-		$page  = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( ( $page->rating === NULL ), TRUE );
-		asrt( !$page->rating, TRUE );
-		$page->rating = FALSE;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( (bool) $page->rating, FALSE );
-		asrt( ( $page->rating == FALSE ), TRUE );
-		asrt( !$page->rating, TRUE );
-		$page->rating = TRUE;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( (bool) $page->rating, TRUE );
-		asrt( ( $page->rating == TRUE ), TRUE );
-		asrt( ( $page->rating == TRUE ), TRUE );
-		$page->rating = NULL;
-		R::store( $page );
-		$page = R::load( 'page', $page->id );
-		asrt( $page->rating, NULL );
-		$page->rating = '1';
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( $page->rating, "1" );
-		$page->rating = "0";
-		$newid = $redbean->store( $page );
-		asrt( $page->rating, "0" );
-		$page->rating = 0;
-		$newid = $redbean->store( $page );
-		asrt( $page->rating, 0 );
-		$page->rating = "0";
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( !$page->rating, TRUE );
-		asrt( ( $page->rating == 0 ), TRUE );
-		asrt( ( $page->rating == FALSE ), TRUE );
-		$page->rating = 5;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( strval( $page->rating ), "5" );
-		$page->rating = 300;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( strval( $page->rating ), "300" );
-		$page->rating = -2;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( strval( $page->rating ), "-2" );
-		$page->rating = 2.5;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( ( $page->rating == 2.5 ), TRUE );
-		$page->rating = -3.3;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( ( $page->rating == -3.3 ), TRUE );
-		$page->rating = "good";
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( $page->rating, "good" );
-		$longtext = str_repeat( 'great! because..', 100 );
-		$page->rating = $longtext;
-		$newid = $redbean->store( $page );
-		asrt( $newid, $id );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->name, "new name" );
-		asrt( $page->rating, $longtext );
-		// Test leading zeros
-		$numAsString = "0001";
-		$page->numasstring = $numAsString;
-		$redbean->store( $page );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->numasstring, "0001" );
-		$page->numnotstring = "0.123";
-		$redbean->store( $page );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->numnotstring == 0.123, TRUE );
-		$page->numasstring2 = "00.123";
-		$redbean->store( $page );
-		$page = $redbean->load( "page", $id );
-		asrt( $page->numasstring2, "00.123" );
-		try {
-			$redbean->trash( array() );
-			fail();
-		} catch ( RedException $e ) {
-			pass();
-		}
-		$redbean->trash( $page );
-		asrt( (int) $pdo->GetCell( "SELECT count(*) FROM page" ), 0 );
-	}
-
-	/**
-	 * Tests whether empty strings are preserved as such.
-	 *
-	 * @return void
-	 */
-	public function testEmptyStringShouldNotBeStoredAsInteger()
-	{
-		R::nuke();
-		$bean = R::dispense('bean');
-		$bean->str = '';
-		R::store($bean);
-		$bean = $bean->fresh();
-		asrt( ( $bean->str === '' ), TRUE);
-	}
-
-	/**
-	 * Test handling of infinity values.
-	 *
-	 * @return void
-	 */
-	public function testStoringInf()
-	{
-		R::nuke();
-		$bean = R::dispense( 'bean' );
-		$bean->inf = INF;
-		R::store( $bean );
-		$bean = $bean->fresh();
-		asrt( ( $bean->inf === 'INF' ), TRUE );
-		asrt( ( $bean->inf == 'INF' ), TRUE );
-		$bean->modifyme = 'yes';
-		R::store( $bean );
-		$bean = $bean->fresh();
-		asrt( ( $bean->inf === 'INF' ), TRUE );
-		asrt( ( $bean->inf == 'INF' ), TRUE );
-		$bean->modifyme = 'yes';
-	}
-}
-