1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
<?php
include 'helpers/config.php';
use ActiveRecord\Column;
use ActiveRecord\DateTime;
use ActiveRecord\DatabaseException;
class ColumnTest extends SnakeCase_PHPUnit_Framework_TestCase
{
public function set_up()
{
$this->column = new Column();
try {
$this->conn = ActiveRecord\ConnectionManager::get_connection(ActiveRecord\Config::instance()->get_default_connection());
} catch (DatabaseException $e) {
$this->mark_test_skipped('failed to connect using default connection. '.$e->getMessage());
}
}
public function assert_mapped_type($type, $raw_type)
{
$this->column->raw_type = $raw_type;
$this->assert_equals($type,$this->column->map_raw_type());
}
public function assert_cast($type, $casted_value, $original_value)
{
$this->column->type = $type;
$value = $this->column->cast($original_value,$this->conn);
if ($original_value != null && ($type == Column::DATETIME || $type == Column::DATE))
$this->assert_true($value instanceof DateTime);
else
$this->assert_same($casted_value,$value);
}
public function test_map_raw_type_dates()
{
$this->assert_mapped_type(Column::DATETIME,'datetime');
$this->assert_mapped_type(Column::DATE,'date');
}
public function test_map_raw_type_integers()
{
$this->assert_mapped_type(Column::INTEGER,'integer');
$this->assert_mapped_type(Column::INTEGER,'int');
$this->assert_mapped_type(Column::INTEGER,'tinyint');
$this->assert_mapped_type(Column::INTEGER,'smallint');
$this->assert_mapped_type(Column::INTEGER,'mediumint');
$this->assert_mapped_type(Column::INTEGER,'bigint');
}
public function test_map_raw_type_decimals()
{
$this->assert_mapped_type(Column::DECIMAL,'float');
$this->assert_mapped_type(Column::DECIMAL,'double');
$this->assert_mapped_type(Column::DECIMAL,'numeric');
$this->assert_mapped_type(Column::DECIMAL,'dec');
}
public function test_map_raw_type_strings()
{
$this->assert_mapped_type(Column::STRING,'string');
$this->assert_mapped_type(Column::STRING,'varchar');
$this->assert_mapped_type(Column::STRING,'text');
}
public function test_map_raw_type_default_to_string()
{
$this->assert_mapped_type(Column::STRING,'bajdslfjasklfjlksfd');
}
public function test_map_raw_type_changes_integer_to_int()
{
$this->column->raw_type = 'integer';
$this->column->map_raw_type();
$this->assert_equals('int',$this->column->raw_type);
}
public function test_cast()
{
$datetime = new DateTime('2001-01-01');
$this->assert_cast(Column::INTEGER,1,'1');
$this->assert_cast(Column::INTEGER,1,'1.5');
$this->assert_cast(Column::DECIMAL,1.5,'1.5');
$this->assert_cast(Column::DATETIME,$datetime,'2001-01-01');
$this->assert_cast(Column::DATE,$datetime,'2001-01-01');
$this->assert_cast(Column::DATE,$datetime,$datetime);
$this->assert_cast(Column::STRING,'bubble tea','bubble tea');
}
public function test_cast_leave_null_alone()
{
$types = array(
Column::STRING,
Column::INTEGER,
Column::DECIMAL,
Column::DATETIME,
Column::DATE);
foreach ($types as $type) {
$this->assert_cast($type,null,null);
}
}
public function test_empty_and_null_date_strings_should_return_null()
{
$column = new Column();
$column->type = Column::DATE;
$this->assert_equals(null,$column->cast(null,$this->conn));
$this->assert_equals(null,$column->cast('',$this->conn));
}
public function test_empty_and_null_datetime_strings_should_return_null()
{
$column = new Column();
$column->type = Column::DATETIME;
$this->assert_equals(null,$column->cast(null,$this->conn));
$this->assert_equals(null,$column->cast('',$this->conn));
}
}
?>
|