+++ /dev/null
-<?php
-
-namespace RedUNIT\Base;
-
-use RedUNIT\Base as Base;
-use RedBeanPHP\Facade as R;
-use RedBeanPHP\RedException as RedException;
-use RedBeanPHP\QueryWriter\AQueryWriter as AQueryWriter;
-
-/**
- * Threeway
- *
- * Tests link/via relations, i.e. N-M tables with additional
- * columns.
- *
- * @file RedUNIT/Base/Threeway.php
- * @desc Various tests for 3-way tables or X-way tables.
- * @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 Threeway extends Base
-{
- /**
- * Test whether we can use threeway tables without being
- * bothered by unique constraints.
- *
- * @return void
- */
- public function testUniqueConstraintOnThreeways()
- {
- AQueryWriter::clearRenames();
- R::nuke();
- $person = R::dispense( 'person' );
- $role = R::dispense( 'role' );
- $person->sharedRole[] = $role;
- R::store( $person );
- $person->link( 'person_role', array(
- 'unit' => R::dispense('unit')
- ))->role = $role;
- //Can we add a duplicate role now? - No because we started with a simple N-M table
- //and unique constraint has been applied accordingly, manually change database.
- asrt( R::count( 'person_role' ), 1 );
- R::nuke();
- $person = R::dispense( 'person' );
- $role = R::dispense( 'role' );
- $person->via('participant')->sharedRole[] = $role;
- R::store( $person );
- $person->link( 'participant', array(
- 'unit' => R::dispense('unit')
- ))->role = $role;
- //Can we add a duplicate role now? - No because we started with a simple N-M table
- //and unique constraint has been applied accordingly, manually change database.
- asrt( R::count( 'participant' ), 1 );
- R::nuke();
- $participant = R::dispense( 'participant' );
- $person = R::dispense( 'person' );
- $role = R::dispense( 'role' );
- $unit = R::dispense( 'unit' );
- $participant->person = $person;
- $participant->role = $role;
- $participant->unit = $unit;
- R::store( $participant );
- $person->link( 'participant', array(
- 'unit' => R::dispense('unit')
- ))->role = $role;
- R::store( $person );
- //Can we add a duplicate role now?
- asrt( R::count( 'participant' ), 2 );
- AQueryWriter::clearRenames();
- }
-
- /**
- * Test whether a duplicate bean in the list isnt saved.
- * This was an issue with Postgres while testing the threeway tables.
- * Postgres returned the ID as a string while other drivers returned
- * a numeric value causing different outcome in array_diff when
- * calculating the shared additions.
- *
- * @return void
- */
- public function testIssueWithDriverReturnID()
- {
- AQueryWriter::clearRenames();
- R::nuke();
- $book = R::dispense( 'book' );
- $page = R::dispense( 'page' );
- $book->sharedPageList[] = $page;
- R::store( $book );
- asrt( R::count( 'page' ), 1 );
- $book = $book->fresh();
- $book->sharedPageList[] = $page;
- R::store( $book );
- //don't save the duplicate bean!
- asrt( R::count( 'page' ), 1 );
- $book = $book->fresh();
- $page->item = 2; //even if we change a property ?
- $book->sharedPageList[] = $page;
- R::store( $book );
- foreach( $book->sharedPageList as $listItem) {
- asrt( is_string( $listItem->id ), TRUE );
- }
- //same test but for own-list
- R::nuke();
- $book = R::dispense( 'book' );
- $page = R::dispense( 'page' );
- $book->ownPageList[] = $page;
- R::store( $book );
- asrt( R::count( 'page' ), 1 );
- $book = $book->fresh();
- $book->ownPageList[] = $page;
- R::store( $book );
- //don't save the duplicate bean!
- asrt( R::count( 'page' ), 1 );
- $book = $book->fresh();
- $book->ownPageList[] = $page;
- $page->item = 3;
- R::store( $book );
- //don't save the duplicate bean!
- asrt( R::count( 'page' ), 1 );
- foreach( $book->ownPageList as $listItem) {
- asrt( is_string( $listItem->id ), TRUE );
- }
- AQueryWriter::clearRenames();
- }
-}