PHP Classes

File: tests/unit/Sql/JoinTest.php

Recommend this page to a friend!
  Classes of Haseeb Ahmad Basil   PHP Skeleton Framework   ???   Download  
File: tests/unit/Sql/???
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Skeleton Framework
Extensive Web application development framework
Author: By
Last change:
Date: 9 years ago
Size: 1,290 bytes
 

Contents

Class file image Download
<?php

class Sql_JoinTest extends UnitTestCase {
   
    function setUp() {
    }
   
    function TearDown() {
    }
   
    function testSql_JoinConstructorNoParams() {
        $Sql_Join = new A_Sql_Join();
        $this->assertEqual($Sql_Join->render(), ""); // requires two tables
    }
   
    function testSql_JoinConstructorOneTable() {
        $Sql_Join = new A_Sql_Join('bar');
        $this->assertEqual($Sql_Join->render(), " INNER JOIN bar"); // requires two tables
    }
   
    function testSql_JoinConstructorTwoTables() {
        $Sql_Join = new A_Sql_Join('bar', 'foo');
        $this->assertEqual($Sql_Join->render(), " INNER JOIN bar");
    }
   
    function testSql_JoinConstructorTwoTablesAndType() {
        $Sql_Join = new A_Sql_Join('bar', 'foo', 'LEFT');
        $this->assertEqual($Sql_Join->render(), " LEFT JOIN bar");
    }
   
    function testSql_JoinConstructorTwoTablesAndTypeAndOn() {
        $Sql_Join = new A_Sql_Join('bar', 'foo', 'LEFT');
        $Sql_Join->on('foo_id', 'id');
        $this->assertEqual($Sql_Join->render(), " LEFT JOIN bar ON (bar.foo_id = foo.id)");
    }
   
    function testSql_JoinConstructorNoParamsJoinTwoTablesAndTypeAndOn() {
        $Sql_Join = new A_Sql_Join();
        $Sql_Join->join('bar', 'foo')->on('foo_id', 'id');
        $this->assertEqual($Sql_Join->render(), " INNER JOIN bar ON (bar.foo_id = foo.id)");
    }
   
}