PU_test_dcp_simplequery.php

Go to the documentation of this file.

<?php
/*
 * @author Anakeen
 * @package Dcp\Pu
*/

namespace Dcp\Pu;

require_once 'PU_testcase_dcp_document.php';

class TestSimpleQuery extends TestCaseDcpDocument
{
    
    protected function createDataSearch()
    {
        
        $basics = array(
            "Poire",
            "Pomme",
            "Cerise",
            "Pomme-Banane",
            "Banane"
        );
        foreach ($basics as $socTitle) {
            $d1 = createDoc(self::$dbaccess, "BASE", false);
            $d1->setTitle($socTitle);
            $err = $d1->add();
            if ($err != "") return false;
        }
        return true;
    }
    /**
     * test basic search criteria
     * @param string $query filter
     * @param array $arg filter arg
     * @param integer $expectedCount expected results count
     * @return void
     * @dataProvider dataSimpleQuery
     */
    public function testExecuteSimpleQuery($query, array $arg, $expectedCount)
    {
        $result = array();
        $sql = vsprintf($query, $arg);
        $err = simpleQuery(self::$dbaccess, $sql, $result);
        
        $this->assertEmpty($err, sprintf("Simple query error %s", $sql));
        
        $this->assertEquals($expectedCount, count($result) , sprintf("Count must be %d (found %d) error %s", $expectedCount, count($result) , $sql));
    }
    /**
     * test basic search criteria
     * @param string $query filter
     * @param array $arg filter arg
     * @param array $expectedErrors expected errors
     * @return void
     * @dataProvider dataErrorSimpleQuery
     */
    public function testErrorSimpleQuery($query, array $arg, array $expectedErrors)
    {
        $result = array();
        $sql = vsprintf($query, $arg);
        
        try {
            $err = simpleQuery(self::$dbaccess, $sql, $result);
        }
        catch(\Exception $e) {
            $err = $e->getMessage();
        }
        $this->assertNotEmpty($err, sprintf("No error found in simple query %s", $sql));
        foreach ($expectedErrors as $errors) {
            $this->assertContains($errors, $err, sprintf("Not correct error for %s", $sql));
        }
    }
    /**
     * test return when no results
     * @param $singleResult
     * @param $singleColumn
     * @param $expectedResult
     * @return void
     * @dataProvider dataReturnNothingSimpleQuery
     */
    public function testReturnNothingSimpleQuery($singleResult, $singleColumn, $expectedResult)
    {
        $result = "undefined";
        $sql = "select id from docread where false;";
        simpleQuery(self::$dbaccess, $sql, $result, $singleColumn, $singleResult);
        
        $this->assertTrue(($result === $expectedResult) , sprintf("No the good return : %s, expect : %s", print_r($result, true) , print_r($expectedResult, true)));
    }
    /**
     * test basic search criteria
     * @param string $query filter
     * @param array $arg filter arg
     * @param array $expectedErrors expected errors
     * @return void
     * @dataProvider dataErrorSimpleQuery
     */
    public function testTolerantErrorSimpleQuery($query, array $arg, array $expectedErrors)
    {
        
        $result = array();
        $sql = vsprintf($query, $arg);
        $err = simpleQuery(self::$dbaccess, $sql, $result, false, false, $useStrict = false);
        
        $this->assertNotEmpty($err, sprintf("No error found in simple query %s", $sql));
        foreach ($expectedErrors as $errors) {
            $this->assertContains($errors, $err, sprintf("Not correct error for %s", $sql));
        }
    }
    /**
     * @return array
     */
    public function dataSimpleQuery()
    {
        
        return array(
            array(
                "q" => "select * from users where id=%d",
                "args" => array(
                    self::getAction()->user->id
                ) ,
                "count" => 1
            )
        );
    }
    
    public function dataReturnNothingSimpleQuery()
    {
        
        return array(
            array(
                "singleresult" => false,
                "singlecolumn" => false,
                "result" => array()
            ) ,
            array(
                "singleresult" => false,
                "singlecolumn" => true,
                "result" => array()
            ) ,
            array(
                "singleresult" => true,
                "singlecolumn" => false,
                "result" => array()
            ) ,
            array(
                "singleresult" => true,
                "singlecolumn" => true,
                "result" => false
            )
        );
    }
    /**
     * @return array
     */
    public function dataErrorSimpleQuery()
    {
        
        return array(
            array(
                "q" => "select * from users where id=%s",
                "args" => array(
                    "zut"
                ) ,
                "errors" => array(
                    'DB0100',
                    'zut'
                )
            )
        );
    }
}