+++ /dev/null
-<?php
-
-namespace RedUNIT\Base;
-
-use RedUNIT\Base as Base;
-use RedBeanPHP\Facade as R;
-use RedBeanPHP\ToolBox as ToolBox;
-use RedBeanPHP\AssociationManager as AssociationManager;
-use RedBeanPHP\RedException\SQL as SQL;
-use RedBeanPHP\QueryWriter\AQueryWriter as AQueryWriter;
-
-/**
- * Via
- *
- * Tests the via() function to hop over an N-M table to
- * obtain a indirectly related bean, i.e. given person, participant
- * and project you should be able to obtain a the project associated
- * with a certain person via() the participant entity.
- *
- * @file RedUNIT/Base/Via.php
- * @desc Via 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 Via extends Base
-{
- /**
- * Tests fix for issue #378.
- * Via property does not get cleared properly.
- *
- * @return void
- */
- public function testIssue378()
- {
- R::nuke();
- $mediaBean = R::dispense('media');
- $fooPerson = R::dispense('person');
- $mediaBean->sharedPersonList[] = $fooPerson;
- R::store($mediaBean);
- asrt( count( $mediaBean->sharedPersonList ), 1 );
- $person = R::findOne('person');
- $person->via('relation')->sharedMarriageList[] = R::dispense('marriage');
- //this second one caused the via property to not get cleared
- $person->via('relation')->sharedMarriageList;
- asrt( count( $person->sharedMediaList ), 1 );
- //also found this scenario, non-existing property
- $book = R::dispense('book');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->nothing;
- asrt( count( $book->sharedPageList ), 1 );
- //yet another
- $book = R::dispense('magazine');
- $book->ownAdList[] = R::dispense('ad');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->ownAdList;
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('folder');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->sharedItemList[] = R::dispense('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('folder2');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->sharedItemList[] = R::dispense('item');
- $book->via('garbage')->sharedItemList[] = R::dispense('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('folder3');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->item = R::dispense('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('folder3');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->item = 'test';
- asrt( count( $book->sharedPageList ), 1 );
- //yet another
- $book = R::dispense('leaflet');
- $book->title = 'leaflet';
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->title;
- asrt( count( $book->sharedPageList ), 1 );
- //yet another
- $book = R::dispense('paper');
- $book->author = R::dispense('author');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->author;
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('paper2');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('garbage')->author;
- asrt( count( $book->sharedPageList ), 1 );
- //yet another one
- $book = R::dispense('archive');
- $book->sharedItem[] = R::dispense('item');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- unset( $book->via('garbage')->sharedItem );
- asrt( count( $book->sharedPageList ), 1 );
- //theoretic cases
- $book = R::dispense('guide');
- $book->sharedItem[] = R::dispense('item');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('relation')->countShared('item');
- $book->via('relation')->countShared('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('catalogue');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('relation')->countShared('item');
- $book->via('relation')->countShared('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('tabloid');
- $book->ownItemList[] = R::dispense('item');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('relation')->countOwn('item');
- $book->via('relation')->countOwn('item');
- asrt( count( $book->sharedPageList ), 1 );
- $book = R::dispense('booklet');
- $book->ownItemList[] = R::dispense('item');
- $book->sharedPage[] = R::dispense('page');
- R::store($book);
- $book = $book->fresh();
- $book->via('relation')->countOwn('item');
- $book->via('relation')->countOwn('item');
- asrt( count( $book->sharedPageList ), 1 );
- AQueryWriter::clearRenames();
- }
-
- /**
- * Via specific tests.
- *
- * @return void
- */
- public function testViaAndSQL()
- {
- R::nuke();
- list($p1, $p2) = R::dispense('participant', 2);
- list($e1, $e2) = R::dispense('employee', 2);
- list($x1, $x2) = R::dispense('project', 2);
- $e1->name = 'Anna';
- $e2->name = 'John';
- $p1->project = $x1;
- $p1->employee = $e1;
- $p1->arole = 'designer';
- $p2->project = $x1;
- $p2->employee = $e2;
- $p2->arole = 'coder';
- R::storeAll(array( $p1, $p2 ));
- $project = R::load('project', $x1->id);
- $designers = $project
- ->withCondition(' participant.arole = ? ', array( 'designer' ) )
- ->via( 'participant' )
- ->sharedEmployeeList;
- $anna = reset( $designers );
- asrt(count($designers), 1);
- asrt($anna->name, 'Anna');
- $coders = $project
- ->withCondition(' participant.arole = ? ', array( 'coder' ) )
- ->via( 'participant' )
- ->sharedEmployeeList;
- $john = reset( $coders );
- asrt(count($coders), 1);
- asrt($john->name, 'John');
- }
-
- /**
- * Test Via and Link together.
- *
- * @return void
- */
- public function testViaAndLink()
- {
- R::nuke();
- list( $John, $Anna, $Celine ) = R::dispense( 'employee', 3 );
- $John->badge = 'John';
- $Anna->badge = 'Anna';
- $Celine->badge = 'Celine';
- $project = R::dispense( 'project' );
- $project->name = 'x';
- $project2 = R::dispense( 'project' );
- $project2->name = 'y';
- $John->link( 'participant', array(
- 'arole' => 'designer'
- ) )->project = $project;
- $Anna->link( 'participant', array(
- 'arole' => 'developer'
- ) )->project = $project;
- $Celine->link( 'participant', array(
- 'arole' => 'sales'
- ) )->project = $project2;
- $Anna->link('participant', array(
- 'arole' => 'lead'
- ) )->project = $project2;
- R::storeAll( array( $project, $project2, $John, $Anna, $Celine ) );
- $employees = $project
- ->with(' ORDER BY badge ASC ')
- ->via( 'participant' )
- ->sharedEmployee;
- asrt( is_array( $employees ), TRUE );
- asrt( count( $employees ), 2 );
- $badges = array();
- foreach( $employees as $employee ) {
- $badges[] = $employee->badge;
- }
- asrt( implode( ',', $badges ), 'Anna,John' );
- $employees = $project2
- ->with(' ORDER BY badge ASC ')
- ->via( 'participant' )
- ->sharedEmployee;
- asrt( is_array( $employees ), TRUE );
- asrt( count( $employees ), 2 );
- $badges = array();
- foreach( $employees as $employee ) {
- $badges[] = $employee->badge;
- }
- asrt( implode( ',', $badges ), 'Anna,Celine' );
- $projects = $John->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 1 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'x' );
- $projects = $Anna->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 2 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'x,y' );
- $projects = $Anna->via( 'participant' )->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 2 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'x,y' );
- $projects = $Celine->via( 'participant' )->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 1 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'y' );
- $roles = $Anna->ownParticipant;
- asrt( is_array( $roles ), TRUE );
- asrt( count( $roles ), 2 );
- $roleList = array();
- foreach( $roles as $role ) {
- $roleList[] = $role->arole;
- }
- sort( $roleList );
- asrt( implode( ',', $roleList ), 'developer,lead' );
- $project2->sharedEmployee[] = $John;
- R::store( $project2 );
- $projects = $John->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 2 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'x,y' );
- $projects = $John->via( 'participant' )->sharedProject;
- asrt( is_array( $projects ), TRUE );
- asrt( count( $projects ), 2 );
- $projectList = array();
- foreach( $projects as $project ) {
- $projectList[] = $project->name;
- }
- sort( $projectList );
- asrt( implode( ',', $projectList ), 'x,y' );
- }
-
- /**
- * Test effect of via on shared list removal of beans.
- *
- * @return void
- */
- public function testViaAndRemove()
- {
- R::nuke();
- $project = R::dispense( 'project' );
- $employees = R::dispense( 'employee', 2);
- $project->via( 'partcipant' )->sharedEmployeeList = $employees;
- R::store( $project );
- asrt( R::count('employee'), 2 );
- asrt( R::count('participant'), 2 );
- $project = $project->fresh();
- $project->sharedEmployee = array();
- R::store( $project );
- asrt( R::count( 'employee' ), 2 );
- asrt( R::count( 'participant' ), 0 );
- }
-}