Location: PHPKode > projects > Pluf > pluf-master/tests/Pluf_SQL/PlufSQLTest.php
<?php
/* -*- tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
# ***** BEGIN LICENSE BLOCK *****
# This file is part of Plume Framework, a simple PHP Application Framework.
# Copyright (C) 2001-2007 Loic d'Anterroches and contributors.
#
# Plume Framework is free software; you can redistribute it and/or modify
# it under the terms of the GNU Lesser General Public License as published by
# the Free Software Foundation; either version 2.1 of the License, or
# (at your option) any later version.
#
# Plume Framework is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Lesser General Public License for more details.
#
# You should have received a copy of the GNU Lesser General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
#
# ***** END LICENSE BLOCK ***** */

error_reporting(E_ALL | E_STRICT);

$path = dirname(__FILE__).'/../../src/';
set_include_path(get_include_path().PATH_SEPARATOR.$path);

require_once 'PHPUnit/Framework/TestCase.php';
require_once 'PHPUnit/Framework/IncompleteTestError.php';

require_once 'Pluf.php';

class PlufSQLTest extends PHPUnit_Framework_TestCase {
    
    protected function setUp()
    {
        Pluf::start(dirname(__FILE__).'/../conf/pluf.config.php');
        $this->db = Pluf::db();
    }

    protected function tearDown()
    {
    }

    public function testSimpleSQLAnd()
    {
        $sql = Pluf::factory('Pluf_SQL');
        $sql->Q('blablo=%s', 'bli');
        $this->assertEquals('blablo=\'bli\'', $sql->gen());
    }

    public function testSQLAndOr()
    {
        $sql1 = Pluf::factory('Pluf_SQL');
        $sql1->Q('title=%s', 'my title');
        $sql2 = Pluf::factory('Pluf_SQL');
        $sql2->Q('description=%s', '%par example');
        $sql3 = Pluf::factory('Pluf_SQL');
        $sql3->Q('status=%s', '1');
        $sql4 = Pluf::factory('Pluf_SQL');
        $sql4->Q('keywords=%s', "tag'gi`ng");
        $sql1->SAnd($sql2);
        $sql3->SAnd($sql4);
        $sql1->SOr($sql3);
        if ($this->db->engine == 'SQLite') {
            $res = "((title='my title') AND (description='%par example'))";
            $res .= " OR ((status='1') AND (keywords='tag''gi`ng'))";
        } else {
            $res = "((title='my title') AND (description='%par example'))";
            $res .= " OR ((status='1') AND (keywords='tag\'gi`ng'))";
        }
        $this->assertEquals($res, $sql1->gen());
    }

    public function testChainSQLAndOr()
    {
        $sql1 = new Pluf_SQL('title=%s', 'my title');
        $sql2 = Pluf::factory('Pluf_SQL');
        $sql1->Q('description=%s', '%par example')->Q('keywords=%s', "tag'gi`ng");
        $sql3 = Pluf::factory('Pluf_SQL');
        $sql3->Q('status=%s', '1');
        $sql1->SOr($sql3);
        if ($this->db->engine == 'SQLite') {
            $res = "(title='my title' AND description='%par example' AND keywords='tag''gi`ng')";
            $res .= " OR (status='1')";
        } else {
            $res = "(title='my title' AND description='%par example' AND keywords='tag\''gi`ng')";
            $res .= " OR (status='1')";
        }
        $this->assertEquals($res, $sql1->gen());
    }

    public function testORSQLKeywords()
    {
        $query = 'key1 key2   key3';
        $fields = array('title', 'description');
        $lastsql = Pluf::factory('Pluf_SQL');
        $keywords = $lastsql->keywords($query);
        foreach ($keywords as $key) {
            $sql = Pluf::factory('Pluf_SQL');
            foreach ($fields as $field) {
                $sqlor = Pluf::factory('Pluf_SQL');
                $sqlor->Q($field.' LIKE %s', '%'.$key.'%');
                $sql->SOr($sqlor);
            }
            $lastsql->SAnd($sql);
        }
        $res = "(((title LIKE '%key1%') OR (description LIKE '%key1%')) AND ((title LIKE '%key2%') OR (description LIKE '%key2%'))) AND ((title LIKE '%key3%') OR (description LIKE '%key3%'))";
        $this->assertEquals($res, $lastsql->gen());
    }
}

?>
Return current item: Pluf