forked from propelorm/Propel
/
DatabaseTest.php
146 lines (124 loc) · 4.17 KB
/
DatabaseTest.php
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<?php
/*
* $Id: TableTest.php 1965 2010-09-21 17:44:12Z francois $
* This file is part of the Propel package.
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*
* @license MIT License
*/
require_once dirname(__FILE__) . '/../../../../generator/lib/model/Database.php';
require_once dirname(__FILE__) . '/../../../tools/helpers/DummyPlatforms.php';
/**
* Tests for Database model class.
*
* @version $Revision$
* @package generator.model
*/
class DatabaseTest extends PHPUnit_Framework_TestCase
{
public function providerForTestHasTable()
{
$database = new Database();
$table = new Table('Foo');
$database->addTable($table);
return array(
array($database, $table)
);
}
public function testTableInheritsSchema()
{
$database = new Database();
$database->setPlatform(new SchemaPlatform());
$database->setSchema("Foo");
$table = new Table("Bar");
$database->addTable($table);
$this->assertTrue($database->hasTable("Foo.Bar"));
$this->assertFalse($database->hasTable("Bar"));
$database = new Database();
$database->setPlatform(new NoSchemaPlatform());
$database->addTable($table);
$this->assertFalse($database->hasTable("Foo.Bar"));
$this->assertTrue($database->hasTable("Bar"));
}
/**
* @dataProvider providerForTestHasTable
*/
public function testHasTable($database, $table)
{
$this->assertTrue($database->hasTable('Foo'));
$this->assertFalse($database->hasTable('foo'));
$this->assertFalse($database->hasTable('FOO'));
}
/**
* @dataProvider providerForTestHasTable
*/
public function testHasTableCaseInsensitive($database, $table)
{
$this->assertTrue($database->hasTable('Foo', true));
$this->assertTrue($database->hasTable('foo', true));
$this->assertTrue($database->hasTable('FOO', true));
}
/**
* @dataProvider providerForTestHasTable
*/
public function testGetTable($database, $table)
{
$this->assertEquals($table, $database->getTable('Foo'));
$this->assertNull($database->getTable('foo'));
$this->assertNull($database->getTable('FOO'));
}
/**
* @dataProvider providerForTestHasTable
*/
public function testGetTableCaseInsensitive($database, $table)
{
$this->assertEquals($table, $database->getTable('Foo', true));
$this->assertEquals($table, $database->getTable('foo', true));
$this->assertEquals($table, $database->getTable('FOO', true));
}
public function testAddTableDoesNotModifyTableNamespaceWhenDatabaseHasNoNamespace()
{
$db = new Database();
$t1 = new Table('t1');
$db->addTable($t1);
$this->assertEquals('', $t1->getNamespace());
$t2 = new Table('t2');
$t2->setNamespace('Bar');
$db->addTable($t2);
$this->assertEquals('Bar', $t2->getNamespace());
}
public function testAddTableAddsDatabaseNamespaceToTheTable()
{
$db = new Database();
$db->setNamespace('Foo');
$t1 = new Table('t1');
$db->addTable($t1);
$this->assertEquals('Foo', $t1->getNamespace());
$t2 = new Table('t2');
$t2->setNamespace('Bar');
$db->addTable($t2);
$this->assertEquals('Foo\\Bar', $t2->getNamespace());
}
public function testAddTableSkipsDatabaseNamespaceWhenTableNamespaceIsAbsolute()
{
$db = new Database();
$db->setNamespace('Foo');
$t1 = new Table('t1');
$t1->setNamespace('\\Bar');
$db->addTable($t1);
$this->assertEquals('Bar', $t1->getNamespace());
}
public function testAddTableWithSameNameOnDifferentSchema()
{
$db = new Database();
$db->setPlatform(new SchemaPlatform());
$t1 = new Table('t1');
$db->addTable($t1);
$this->assertEquals('t1', $t1->getName());
$t1b = new Table('t1');
$t1b->setSchema('bis');
$db->addTable($t1b);
$this->assertEquals('bis.t1', $t1b->getName());
}
}