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
<?php
/**
class Doctrine_DataDict_Sqlite_TestCase extends Doctrine_UnitTestCase {
private $dict;
private $columns;
public function prepareData() { }
public function prepareTables() {
$this->dbh->query("CREATE TABLE test (col_null NULL,
col_int INTEGER NOT NULL,
col_real REAL,
col_text TEXT DEFAULT 'default' NOT NULL,
col_blob BLOB)");
$this->dict = new Doctrine_DataDict_Sqlite($this->dbh);
$this->columns = $this->dict->listTableColumns('test');
}
public function testListTables() {
$result = $this->dict->listTables();
}
public function testIntegerType() {
$this->assertEqual($this->columns['col_int']->isUnique(), false);
$this->assertEqual($this->columns['col_int']->isNotNull(), true);
$this->assertEqual($this->columns['col_int']->defaultValue(), null);
$this->assertEqual($this->columns['col_int']->isPrimaryKey(), false);
$this->assertEqual($this->columns['col_int']->getType(), 'INTEGER');
$this->assertEqual($this->columns['col_int']->getName(), 'col_int');
}
public function testNullType() {
$this->assertEqual($this->columns['col_null']->isUnique(), false);
$this->assertEqual($this->columns['col_null']->isNotNull(), false);
$this->assertEqual($this->columns['col_null']->defaultValue(), null);
$this->assertEqual($this->columns['col_null']->isPrimaryKey(), false);
$this->assertEqual($this->columns['col_null']->getType(), 'numeric');
$this->assertEqual($this->columns['col_null']->getName(), 'col_null');
}
public function testTextType() {
$this->assertEqual($this->columns['col_text']->isUnique(), false);
$this->assertEqual($this->columns['col_text']->isNotNull(), true);
$this->assertEqual($this->columns['col_text']->defaultValue(), 'default');
$this->assertEqual($this->columns['col_text']->isPrimaryKey(), false);
$this->assertEqual($this->columns['col_text']->getType(), 'TEXT');
$this->assertEqual($this->columns['col_text']->getName(), 'col_text');
}
public function testBlobType() {
$this->assertEqual($this->columns['col_blob']->isUnique(), false);
$this->assertEqual($this->columns['col_blob']->isNotNull(), false);
$this->assertEqual($this->columns['col_blob']->defaultValue(), null);
$this->assertEqual($this->columns['col_blob']->isPrimaryKey(), false);
$this->assertEqual($this->columns['col_blob']->getType(), 'BLOB');
$this->assertEqual($this->columns['col_blob']->getName(), 'col_blob');
}
public function testRealType() {
$this->assertEqual($this->columns['col_real']->isUnique(), false);
$this->assertEqual($this->columns['col_real']->isNotNull(), false);
$this->assertEqual($this->columns['col_real']->defaultValue(), null);
$this->assertEqual($this->columns['col_real']->isPrimaryKey(), false);
$this->assertEqual($this->columns['col_real']->getType(), 'REAL');
$this->assertEqual($this->columns['col_real']->getName(), 'col_real');
}
}
*/