PHP Classes

File: tests/eMapper/SQLite/Mapper/ScalarMapper/BooleanTypeTest.php

Recommend this page to a friend!
  Classes of Emmanuel Antico   eMapper   ???   Download  
File: tests/eMapper/SQLite/Mapper/ScalarMapper/???
Role: Unit test script
Content typex: text/plain
Description: Unit test script
Class: eMapper
Database abstraction layer that maps data types
Author: By
Last change:
Date: 11 years ago
Size: 4,935 bytes
 

Contents

Class file image Download
<?php
namespace eMapper\SQLite\Mapper\ScalarMapper;

use eMapper\SQLite\SQLiteTest;

/**
 * Test SQLiteMapper with boolean values
 * @author emaphp
 * @group sqlite
 * @group mapper
 * @group boolean
 */
class BooleanTypeTest extends SQLiteTest {
    public function testBoolean() {
        $result = self::$mapper->type('boolean')->query("SELECT NULL");
        $this->assertNull($result);
       
        $value = self::$mapper->type('b')->query("SELECT refurbished FROM products WHERE product_id = 1");
        $this->assertFalse($value);
   
        $value = self::$mapper->type('boolean')->query("SELECT * FROM products WHERE product_id = 5");
        $this->assertTrue($value);
   
        $result = self::$mapper->type('bool')->query("SELECT 'T'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('bool')->query("SELECT 'F'");
        $this->assertInternalType('boolean', $result);
        $this->assertFalse($result);
   
        $result = self::$mapper->type('b')->query("SELECT 't'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT 'f'");
        $this->assertInternalType('boolean', $result);
        $this->assertFalse($result);
   
        $result = self::$mapper->type('b')->query("SELECT 'true'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT 'false'");
        $this->assertInternalType('boolean', $result);
        $this->assertFalse($result);
   
        $result = self::$mapper->type('b')->query("SELECT 'TRUE'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT 'FALSE'");
        $this->assertInternalType('boolean', $result);
        $this->assertFalse($result);
   
        $result = self::$mapper->type('b')->query("SELECT 0");
        $this->assertInternalType('boolean', $result);
        $this->assertFalse($result);
   
        $result = self::$mapper->type('b')->query("SELECT 1");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT user_id FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT user_name FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT birth_date FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT last_login FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT newsletter_time FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT avatar FROM users WHERE user_name = 'jdoe'");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT price FROM products WHERE product_id = 1");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT rating FROM products WHERE product_id = 1");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT manufacture_year FROM products WHERE product_id = 1");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
   
        $result = self::$mapper->type('b')->query("SELECT discount FROM sales WHERE sale_id = 1");
        $this->assertInternalType('boolean', $result);
        $this->assertTrue($result);
    }
   
    public function testBooleanColumn() {
        $value = self::$mapper->type('bool', 'refurbished')->query("SELECT * FROM products WHERE product_id = 1");
   
        $this->assertInternalType('boolean', $value);
        $this->assertFalse($value);
    }
   
    public function testBooleanList() {
        $values = self::$mapper->type('bool[]')->query("SELECT refurbished FROM products ORDER BY product_id ASC");
   
        $this->assertInternalType('array', $values);
        $this->assertCount(5, $values);
   
        $this->assertFalse($values[0]);
        $this->assertFalse($values[1]);
        $this->assertFalse($values[2]);
        $this->assertFalse($values[3]);
        $this->assertTrue($values[4]);
    }
   
    public function testBooleanColumnList() {
        $values = self::$mapper->type('bool[]', 'refurbished')->query("SELECT * FROM products ORDER BY product_id ASC");
   
        $this->assertInternalType('array', $values);
        $this->assertCount(5, $values);
   
        $this->assertFalse($values[0]);
        $this->assertFalse($values[1]);
        $this->assertFalse($values[2]);
        $this->assertFalse($values[3]);
        $this->assertTrue($values[4]);
    }
}

?>