File: tests/eMapper/SQLite/Result/ScalarMapper/CustomTypeTest.php

Recommend this page to a friend!
  Classes of Emmanuel Antico  >  eMapper  >  tests/eMapper/SQLite/Result/ScalarMapper/CustomTypeTest.php  >  Download  
File: tests/eMapper/SQLite/Result/ScalarMapper/CustomTypeTest.php
Role: Unit test script
Content type: text/plain
Description: Unit test script
Class: eMapper
Database abstraction layer that maps data types
Author: By
Last change:
Date: 6 years ago
Size: 4,444 bytes
 

Contents

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

use
eMapper\SQLite\SQLiteTest;
use
eMapper\Engine\SQLite\Result\SQLiteResultIterator;
use
eMapper\Result\Mapper\ScalarTypeMapper;
use
Acme\Type\RGBColorTypeHandler;

/**
 * Tests ScalarTyperMapper with a custom type handler
 * @author emaphp
 * @group sqlite
 * @group result
 * @group column
 */
class CustomTypeTest extends SQLiteTest {
    public function
testCustomType() {
       
$mapper = new ScalarTypeMapper(new RGBColorTypeHandler());
       
$result = self::$conn->query("SELECT 'FF00ff'");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result));
   
       
$this->assertInstanceOf('Acme\RGBColor', $value);
       
$this->assertEquals(255, $value->red);
       
$this->assertEquals(0, $value->green);
       
$this->assertEquals(255, $value->blue);
       
$result->finalize();
   
       
$result = self::$conn->query("SELECT color FROM products WHERE product_id = 1");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result));
       
$this->assertInstanceOf('Acme\RGBColor', $value);
       
$this->assertEquals(225, $value->red);
       
$this->assertEquals(26, $value->green);
       
$this->assertEquals(26, $value->blue);
       
$result->finalize();
   
       
$result = self::$conn->query("SELECT color FROM products ORDER BY product_id ASC");
       
$values = $mapper->mapList(new SQLiteResultIterator($result));
       
$this->assertInternalType('array', $values);
       
$this->assertCount(5, $values);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[0]);
       
$this->assertEquals(225, $values[0]->red);
       
$this->assertEquals(26, $values[0]->green);
       
$this->assertEquals(26, $values[0]->blue);
       
$result->finalize();
    }
   
    public function
testCustomTypeColumn() {
       
$mapper = new ScalarTypeMapper(new RGBColorTypeHandler());
       
$result = self::$conn->query("SELECT * FROM products WHERE product_id = 1");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result), 'color');
   
       
$this->assertInstanceOf('Acme\RGBColor', $value);
       
$this->assertEquals(225, $value->red);
       
$this->assertEquals(26, $value->green);
       
$this->assertEquals(26, $value->blue);
   
       
$result->finalize();
    }
   
    public function
testCustomTypeList() {
       
$mapper = new ScalarTypeMapper(new RGBColorTypeHandler());
       
$result = self::$conn->query("SELECT color FROM products ORDER BY product_id ASC");
       
$values = $mapper->mapList(new SQLiteResultIterator($result));
   
       
$this->assertInternalType('array', $values);
       
$this->assertCount(5, $values);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[0]);
       
$this->assertEquals(225, $values[0]->red);
       
$this->assertEquals(26, $values[0]->green);
       
$this->assertEquals(26, $values[0]->blue);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[1]);
       
$this->assertEquals(12, $values[1]->red);
       
$this->assertEquals(27, $values[1]->green);
       
$this->assertEquals(217, $values[1]->blue);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[2]);
       
$this->assertEquals(112, $values[2]->red);
       
$this->assertEquals(124, $values[2]->green);
       
$this->assertEquals(4, $values[2]->blue);
   
       
$this->assertNull($values[3]);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[4]);
       
$this->assertEquals(0, $values[4]->red);
       
$this->assertEquals(167, $values[4]->green);
       
$this->assertEquals(235, $values[4]->blue);
   
       
$result->finalize();
    }
   
    public function
testCustomTypeColumnList() {
       
$mapper = new ScalarTypeMapper(new RGBColorTypeHandler());
       
$result = self::$conn->query("SELECT * FROM products ORDER BY product_id ASC");
       
$values = $mapper->mapList(new SQLiteResultIterator($result), 'color');
   
       
$this->assertInternalType('array', $values);
       
$this->assertCount(5, $values);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[0]);
       
$this->assertEquals(225, $values[0]->red);
       
$this->assertEquals(26, $values[0]->green);
       
$this->assertEquals(26, $values[0]->blue);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[1]);
       
$this->assertEquals(12, $values[1]->red);
       
$this->assertEquals(27, $values[1]->green);
       
$this->assertEquals(217, $values[1]->blue);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[2]);
       
$this->assertEquals(112, $values[2]->red);
       
$this->assertEquals(124, $values[2]->green);
       
$this->assertEquals(4, $values[2]->blue);
   
       
$this->assertNull($values[3]);
   
       
$this->assertInstanceOf('Acme\RGBColor', $values[4]);
       
$this->assertEquals(0, $values[4]->red);
       
$this->assertEquals(167, $values[4]->green);
       
$this->assertEquals(235, $values[4]->blue);
   
       
$result->finalize();
    }
}

?>


For more information send a message to info at phpclasses dot org.