3 namespace RedUNIT\Mysql;
5 use RedUNIT\Mysql as Mysql;
6 use RedBeanPHP\Facade as R;
11 * This class has been designed to test set/get operations
12 * for a specific Query Writer / Adapter. Since RedBeanPHP
13 * creates columns based on values it's essential that you
14 * get back the 'same' value as you put in - or - if that's
15 * not the case, that there are at least very clear rules
16 * about what to expect. Examples of possible issues tested in
19 * - Test whether booleans are returned correctly (they will become integers)
20 * - Test whether large numbers are preserved
21 * - Test whether floating point numbers are preserved
22 * - Test whether date/time values are preserved
25 * @file RedUNIT/Mysql/Setget.php
26 * @desc Tests whether values are stored correctly.
27 * @author Gabor de Mooij and the RedBeanPHP Community
28 * @license New BSD/GPLv2
30 * (c) G.J.G.T. (Gabor) de Mooij and the RedBeanPHP Community.
31 * This source file is subject to the New BSD/GPLv2 License that is bundled
32 * with this source code in the file license.txt.
34 class Setget extends Mysql
37 * Tests R::getInsertID convenience method.
41 public function testGetInsertID()
44 $id = R::store( R::dispense( 'book' ) );
45 $id2 = R::getInsertID();
54 public function testNumbers()
56 asrt( setget( "-1" ), "-1" );
57 asrt( setget( -1 ), "-1" );
59 asrt( setget( "-0.25" ), "-0.25" );
60 asrt( setget( -0.25 ), "-0.25" );
62 asrt( setget( "1.0" ), "1" );
63 asrt( setget( 1.0 ), "1" );
65 asrt( setget( "3.20" ), "3.20" );
66 asrt( setget( "13.20" ), "13.20" );
67 asrt( setget( "134.20" ), "134.20" );
68 asrt( setget( 3.21 ), '3.21' );
70 asrt( setget( "0.12345678" ), "0.12345678" );
71 asrt( setget( 0.12345678 ), "0.12345678" );
73 asrt( setget( "-0.12345678" ), "-0.12345678" );
74 asrt( setget( -0.12345678 ), "-0.12345678" );
76 asrt( setget( "2147483647" ), "2147483647" );
77 asrt( setget( 2147483647 ), "2147483647" );
79 asrt( setget( -2147483647 ), "-2147483647" );
80 asrt( setget( "-2147483647" ), "-2147483647" );
82 asrt( setget( -4294967295 ), "-4294967295" );
83 asrt( setget( "-4294967295" ), "-4294967295" );
85 asrt( setget( 4294967295 ), "4294967295" );
86 asrt( setget( "4294967295" ), "4294967295" );
88 asrt( setget( "2147483648" ), "2147483648" );
89 asrt( setget( "-2147483648" ), "-2147483648" );
91 asrt( setget( "199936710040730" ), "199936710040730" );
92 asrt( setget( "-199936710040730" ), "-199936710040730" );
94 //Architecture dependent... only test this if you are sure what arch
95 //asrt(setget("2147483647123456"),"2.14748364712346e+15");
96 //asrt(setget(2147483647123456),"2.14748364712e+15");
104 public function testDates()
106 asrt( setget( "2010-10-11" ), "2010-10-11" );
107 asrt( setget( "2010-10-11 12:10" ), "2010-10-11 12:10" );
108 asrt( setget( "2010-10-11 12:10:11" ), "2010-10-11 12:10:11" );
109 asrt( setget( "x2010-10-11 12:10:11" ), "x2010-10-11 12:10:11" );
117 public function testStrings()
119 asrt( setget( "a" ), "a" );
120 asrt( setget( "." ), "." );
121 asrt( setget( "\"" ), "\"" );
122 asrt( setget( "just some text" ), "just some text" );
130 public function testBool()
132 asrt( setget( TRUE ), "1" );
133 asrt( setget( FALSE ), "0" );
135 asrt( setget( "TRUE" ), "TRUE" );
136 asrt( setget( "FALSE" ), "FALSE" );
144 public function testNull()
146 asrt( setget( "NULL" ), "NULL" );
147 asrt( setget( "NULL" ), "NULL" );
149 asrt( setget( "0123" ), "0123" );
150 asrt( setget( "0000123" ), "0000123" );
152 asrt( setget( NULL ), NULL );
154 asrt( ( setget( 0 ) == 0 ), TRUE );
155 asrt( ( setget( 1 ) == 1 ), TRUE );
157 asrt( ( setget( TRUE ) == TRUE ), TRUE );
158 asrt( ( setget( FALSE ) == FALSE ), TRUE );