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

Recommend this page to a friend!
  Classes of Emmanuel Antico  >  eMapper  >  tests/eMapper/SQLite/Result/ScalarMapper/DateTimeTypeTest.php  >  Download  
File: tests/eMapper/SQLite/Result/ScalarMapper/DateTimeTypeTest.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: 5,156 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
eMapper\Type\Handler\DatetimeTypeHandler;

/**
 * Tests Scalar type mapper with date/time values
 * @author emaphp
 * @group sqlite
 * @group result
 * @group datetime
 */
class DateTimeTypeTest extends SQLiteTest {
    public function
testDatetime() {
       
$mapper = new ScalarTypeMapper(new DatetimeTypeHandler(new \DateTimeZone('America/Argentina/Buenos_Aires')));
       
$result = self::$conn->query("SELECT date('NOW')");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result));
       
$this->assertInstanceOf('DateTime', $value);
       
$this->assertRegExp('/([\d]{4})-([\d]{2})-([\d]{2}) ([\d]{2}):([\d]{2}):([\d]{2})/', $value->format('Y-m-d H:i:s'));
       
$result->finalize();
   
       
$result = self::$conn->query("SELECT last_login FROM users WHERE user_id = 1");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result));
       
$this->assertInstanceOf('DateTime', $value);
       
$this->assertEquals('2013-08-10 19:57:15', $value->format('Y-m-d H:i:s'));
       
$result->finalize();
       
       
$result = self::$conn->query("SELECT * FROM users WHERE user_id = 3");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result), 'last_login');
       
$this->assertInstanceOf('DateTime', $value);
       
$this->assertEquals('2013-02-16 20:00:33', $value->format('Y-m-d H:i:s'));
       
$result->finalize();
       
       
$result = self::$conn->query("SELECT last_login FROM users ORDER BY user_id ASC");
       
$value = $mapper->mapList(new SQLiteResultIterator($result));
       
$this->assertInternalType('array', $value);
       
$this->assertCount(5, $value);
   
       
$values = array();
   
        foreach (
$value as $dt) {
           
$this->assertInstanceOf('DateTime', $dt);
           
$values[] = $dt->format('Y-m-d H:i:s');
        }
   
       
$this->assertEquals(array('2013-08-10 19:57:15', '2013-01-06 12:34:10', '2013-02-16 20:00:33', '2013-03-26 10:01:45', '2013-05-22 14:23:32'), $values);
       
$result->finalize();
   
       
$result = self::$conn->query("SELECT * FROM users ORDER BY user_id DESC");
       
$value = $mapper->mapList(new SQLiteResultIterator($result), 'last_login');
       
$this->assertInternalType('array', $value);
       
$this->assertCount(5, $value);
   
       
$values = array();
   
        foreach (
$value as $dt) {
           
$this->assertInstanceOf('DateTime', $dt);
           
$values[] = $dt->format('Y-m-d H:i:s');
        }
   
       
$this->assertEquals(array('2013-05-22 14:23:32', '2013-03-26 10:01:45', '2013-02-16 20:00:33', '2013-01-06 12:34:10', '2013-08-10 19:57:15'), $values);
       
$result->finalize();
    }
   
    public function
testDatetimeColumn() {
       
$mapper = new ScalarTypeMapper(new DatetimeTypeHandler(new \DateTimeZone('America/Argentina/Buenos_Aires')));
       
$result = self::$conn->query("SELECT * FROM sales WHERE sale_id = 2");
       
$value = $mapper->mapResult(new SQLiteResultIterator($result), 'sale_date');
   
       
$this->assertInstanceOf('\DateTime', $value);
       
$this->assertEquals('2013-05-17 14:22:50', $value->format('Y-m-d H:i:s'));
   
       
$result->finalize();
    }
   
    public function
testDatetimeList() {
       
$mapper = new ScalarTypeMapper(new DatetimeTypeHandler(new \DateTimeZone('America/Argentina/Buenos_Aires')));
       
$result = self::$conn->query("SELECT birth_date FROM users ORDER BY user_id ASC");
       
$values = $mapper->mapList(new SQLiteResultIterator($result));
   
       
$this->assertInternalType('array', $values);
       
$this->assertCount(5, $values);
   
       
$this->assertInstanceOf('\DateTime', $values[0]);
       
$this->assertEquals('1987-08-10', $values[0]->format('Y-m-d'));
   
       
$this->assertInstanceOf('\DateTime', $values[1]);
       
$this->assertEquals('1976-03-03', $values[1]->format('Y-m-d'));
   
       
$this->assertInstanceOf('\DateTime', $values[2]);
       
$this->assertEquals('1967-11-21', $values[2]->format('Y-m-d'));
   
       
$this->assertInstanceOf('\DateTime', $values[3]);
       
$this->assertEquals('1980-12-07', $values[3]->format('Y-m-d'));
   
       
$this->assertInstanceOf('\DateTime', $values[4]);
       
$this->assertEquals('1977-03-16', $values[4]->format('Y-m-d'));
   
       
$result->finalize();
    }
   
    public function
testDatetimeColumnList() {
       
$mapper = new ScalarTypeMapper(new DatetimeTypeHandler(new \DateTimeZone('America/Argentina/Buenos_Aires')));
       
$result = self::$conn->query("SELECT * FROM users ORDER BY user_id ASC");
       
$values = $mapper->mapList(new SQLiteResultIterator($result), 'last_login');
   
       
$this->assertInternalType('array', $values);
       
$this->assertCount(5, $values);
   
       
$this->assertInstanceOf('\DateTime', $values[0]);
       
$this->assertEquals('2013-08-10 19:57:15', $values[0]->format('Y-m-d H:i:s'));
   
       
$this->assertInstanceOf('\DateTime', $values[1]);
       
$this->assertEquals('2013-01-06 12:34:10', $values[1]->format('Y-m-d H:i:s'));
   
       
$this->assertInstanceOf('\DateTime', $values[2]);
       
$this->assertEquals('2013-02-16 20:00:33', $values[2]->format('Y-m-d H:i:s'));
   
       
$this->assertInstanceOf('\DateTime', $values[3]);
       
$this->assertEquals('2013-03-26 10:01:45', $values[3]->format('Y-m-d H:i:s'));
   
       
$this->assertInstanceOf('\DateTime', $values[4]);
       
$this->assertEquals('2013-05-22 14:23:32', $values[4]->format('Y-m-d H:i:s'));
   
   
       
$result->finalize();
    }
}

?>


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