<?php
namespace RedUNIT\Base;
use RedUNIT\Base as Base;
use RedBeanPHP\Facade as R;
use RedBeanPHP\RedException as RedException;
use RedBeanPHP\OODBBean as OODBBean;
/**
* Typechecking
*
* Tests whether RedBeanPHP handles type casting correctly.
*
* @file RedUNIT/Base/Typechecking.php
* @desc Tests basic bean validation rules; invalid bean handling.
* @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 Typechecking extends Base
{
/**
* Test types.
* Test how RedBeanPHP OODB and OODBBean handle type and type casts.
*
* Rules:
*
* 1. before storing a bean all types are preserved except booleans (they are converted to STRINGS '0' or '1')
* 2. after store-reload all bean property values are STRINGS or NULL
* (or ARRAYS but that's only from a user perspective because these are lazy loaded)
* 3. the ID returned by store() is an INTEGER (if possible; on 32 bit systems overflowing values will be cast to STRINGS!)
*
* After loading:
* ALL VALUES EXCEPT NULL -> STRING
* NULL -> NULL
*
* @note Why not simply return bean->id in store()? Because not every driver returns the same type:
* databases without insert_id support require a separate query or a suffix returning STRINGS, not INTEGERS.
*
* @note Why not preserve types? I.e. I store integer, why do I get back a string?
* Answer: types are handled different across database platforms, would cause overhead to inspect every value for type,
* also PHP is a dynamically typed language so types should not matter that much. Another reason: due to the nature
* of RB columns in the database might change (INT -> STRING) this would cause return types to change as well which would
* cause 'cascading errors', i.e. a column gets widened and suddenly your code would break.
*
* @note Unfortunately the 32/64-bit issue cannot be tested fully. Return-strategy store() is probably the safest
* solution.
*
* @return void
*/
public function testTypes()
{
testpack( 'Beans can only contain STRING and NULL after reload' );
R::nuke();
$bean = R::dispense( 'bean' );
$bean->number = 123;
$bean->float = 12.3;
$bean->bool = FALSE;
$bean->bool2 = TRUE;
$bean->text = 'abc';
$bean->null = null;
$bean->datetime = new \DateTime( 'NOW', new \DateTimeZone( 'Europe/Amsterdam' ) );
$id = R::store( $bean );
asrt( is_int( $id ), TRUE );
asrt( is_float( $bean->float ), TRUE );
asrt( is_integer( $bean->number ), TRUE );
asrt( is_string( $bean->bool ), TRUE );
asrt( is_string( $bean->bool2 ), TRUE );
asrt( is_string( $bean->datetime ), TRUE );
asrt( is_string( $bean->text ), TRUE );
asrt( is_null( $bean->null ), TRUE );
$bean = R::load('bean', $id );
asrt( is_string( $bean->id ), TRUE );
asrt( is_string( $bean->float ), TRUE );
asrt( is_string( $bean->number ), TRUE );
asrt( is_string( $bean->bool ), TRUE );
asrt( is_string( $bean->bool2 ), TRUE );
asrt( is_string( $bean->datetime ), TRUE );
asrt( is_string( $bean->text ), TRUE );
asrt( is_null( $bean->null ), TRUE );
asrt( $bean->bool, '0' );
asrt( $bean->bool2, '1' );
}
/**
* Test bean type checking.
*
* @return void
*/
public function testBeanTypeChecking()
{
$redbean = R::getRedBean();
$bean = $redbean->dispense( "page" );
// Set some illegal values in the bean; this should trigger Security exceptions.
// Arrays are not allowed.
$bean->name = array( "1" );
try {
$redbean->store( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
try {
$redbean->check( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
$bean->name = new OODBBean;
try {
$redbean->check( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
// Property names should be alphanumeric
$prop = ".";
$bean->$prop = 1;
try {
$redbean->store( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
try {
$redbean->check( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
// Really...
$prop = "-";
$bean->$prop = 1;
try {
$redbean->store( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
try {
$redbean->check( $bean );
fail();
} catch ( RedException $e ) {
pass();
}
}
}
|
Download
