+++ /dev/null
-<?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 );
- }
-}