<?php
namespace RedUNIT\Base;
use RedUNIT\Base as Base;
use RedBeanPHP\Facade as R;
/**
* Indexes
*
* Tests whether indexes are created properly and whether
* index creation errors are supressed (they are not important
* enough to cause exceptions during development phase).
*
* @file RedUNIT/Base/Indexes.php
* @desc Tests whether indexes are applied properly.
* @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 Indexes extends Base {
/**
* Tests whether a regular index is created properly.
*
* @return void
*/
public function testIndexCreation()
{
R::nuke();
$book = R::dispense( 'book' );
$page = R::dispense( 'page' );
$book->ownPageList[] = $page;
R::store( $book );
$indexes = getIndexes( 'page' );
asrt( in_array( 'index_foreignkey_page_book', $indexes ), TRUE );
}
/**
* Tests indexes on parent beans.
*
* @return void
*/
public function testIndexCreationParentBean()
{
R::nuke();
$book = R::dispense( 'book' );
$page = R::dispense( 'page' );
$page->book = $book;
R::store( $page );
$indexes = getIndexes( 'page' );
asrt( in_array( 'index_foreignkey_page_book', $indexes ), TRUE );
}
/**
* Tests indexes on link tables.
*
* @return void
*/
public function testIndexCreationMany2Many()
{
R::nuke();
$book = R::dispense( 'book' );
$category = R::dispense( 'category' );
$book->sharedCategoryList[] = $category;
R::store( $book );
$indexes = getIndexes( 'book_category' );
asrt( in_array( 'index_foreignkey_book_category_book', $indexes ), TRUE );
asrt( in_array( 'index_foreignkey_book_category_category', $indexes ), TRUE );
R::nuke();
R::nuke();
$book = R::dispense( 'book' );
$category = R::dispense( 'category' );
$category->sharedBookList[] = $book;
R::store( $category );
$indexes = getIndexes( 'book_category' );
asrt( in_array( 'index_foreignkey_book_category_book', $indexes ), TRUE );
asrt( in_array( 'index_foreignkey_book_category_category', $indexes ), TRUE );
}
/**
* Tests indexes on aliases.
*
* @return void
*/
public function testIndexCreationAlias()
{
R::nuke();
$book = R::dispense( 'book' );
$author = R::dispense( 'author' );
$book->coAuthor = $author;
R::store( $book );
$indexes = getIndexes( 'book' );
asrt( in_array( 'index_foreignkey_book_co_author', $indexes ), TRUE );
R::nuke();
$project = R::dispense( 'project' );
$person = R::dispense( 'person' );
$person->alias( 'teacher' )->ownProject[] = $project;
$person2 = R::dispense( 'person' );
$person2->alias( 'student' )->ownProject[] = $project;
R::store( $person );
$indexes = getIndexes( 'project' );
asrt( in_array( 'index_foreignkey_project_teacher', $indexes ), TRUE );
R::store( $person2 );
$indexes = getIndexes( 'project' );
asrt( in_array( 'index_foreignkey_project_student', $indexes ), TRUE );
}
/**
* Tests index fails.
*
* @return void
*/
public function testIndexCreationFail()
{
R::nuke();
$book = R::dispense( 'book' );
$book->author_id = '999';
R::store( $book );
$indexes = getIndexes( 'book' );
//should just work fine
asrt( in_array( 'index_foreignkey_book_author', $indexes ), TRUE );
//these should just pass, no indexes but no errors as well
R::getWriter()->addIndex( 'book', 'bla', 'nonexist' );
pass();
R::getWriter()->addIndex( 'book', '@#$', 'nonexist' );
pass();
R::getWriter()->addIndex( 'nonexist', 'bla', 'nonexist' );
pass();
$indexesAfter = getIndexes( 'book' );
asrt( count( $indexesAfter ), count( $indexes ) );
}
}
|
Download
