Yaffs site version 1.1

[yaffs-website] / vendor / gabordemooij / redbean / testing / RedUNIT / Postgres / Parambind.php

diff --git a/vendor/gabordemooij/redbean/testing/RedUNIT/Postgres/Parambind.php b/vendor/gabordemooij/redbean/testing/RedUNIT/Postgres/Parambind.php
new file mode 100644 (file)
index 0000000..fdfa517
--- /dev/null
+++ b/vendor/gabordemooij/redbean/testing/RedUNIT/Postgres/Parambind.php
@@ -0,0 +1,51 @@
+<?php
+
+namespace RedUNIT\Postgres;
+
+use RedUNIT\Postgres as Postgres;
+use RedBeanPHP\Facade as R;
+
+/**
+ * Parambind
+ *
+ * Tests the parameter binding functionality in RedBeanPHP.
+ * These test scenarios include for instance: NULL handling,
+ * binding parameters in LIMIT clauses and so on.
+ *
+ * @file    RedUNIT/Postgres/Parambind.php
+ * @desc    Tests\PDO parameter binding for Postgres.
+ * @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 Parambind extends Postgres
+{
+       /**
+        * Test parameter binding.
+        *
+        * @return void
+        */
+       public function testParamBindingWithPostgres()
+       {
+               testpack( "param binding pgsql" );
+               $page = R::dispense( "page" );
+               $page->name   = "abc";
+               $page->number = 2;
+               R::store( $page );
+               R::exec( "insert into page (name) values(:name) ", array( ":name" => "my name" ) );
+               R::exec( "insert into page (number) values(:one) ", array( ":one" => 1 ) );
+               R::exec( "insert into page (number) values(:one) ", array( ":one" => "1" ) );
+               R::exec( "insert into page (number) values(:one) ", array( ":one" => "1234" ) );
+               R::exec( "insert into page (number) values(:one) ", array( ":one" => "-21" ) );
+               pass();
+               testpack( 'Test whether we can properly bind and receive NULL values' );
+               $adapter = R::getDatabaseAdapter();
+               asrt( $adapter->getCell( 'SELECT TEXT( :nil ) ', array( ':nil' => 'NULL' ) ), 'NULL' );
+               asrt( $adapter->getCell( 'SELECT TEXT( :nil ) ', array( ':nil' => NULL ) ), NULL );
+               asrt( $adapter->getCell( 'SELECT TEXT( ? ) ', array( 'NULL' ) ), 'NULL' );
+               asrt( $adapter->getCell( 'SELECT TEXT( ? ) ', array( NULL ) ), NULL );
+       }
+}