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
|
<?php
use Prado\Data\TDbColumnCaseMode;
use Prado\Data\TDbCommand;
use Prado\Data\TDbConnection;
use Prado\Data\TDbNullConversionMode;
use Prado\Exceptions\TDbException;
use Prado\TApplication;
if(!defined('TEST_DB_FILE'))
define('TEST_DB_FILE',dirname(__FILE__).'/db/test.db');
if(!defined('TEST_DB_FILE2'))
define('TEST_DB_FILE2',dirname(__FILE__).'/db/test2.db');
/**
* @package System.Data.PDO
*/
class TDbConnectionTest extends PHPUnit_Framework_TestCase
{
private $_connection1;
private $_connection2;
public function setUp()
{
@unlink(TEST_DB_FILE);
@unlink(TEST_DB_FILE2);
// create application just to provide application mode
new TApplication(__DIR__, false ,TApplication::CONFIG_TYPE_PHP);
$this->_connection1=new TDbConnection('sqlite:'.TEST_DB_FILE);
$this->_connection1->Active=true;
$this->_connection1->createCommand('CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(8))')->execute();
$this->_connection2=new TDbConnection('sqlite:'.TEST_DB_FILE2);
}
public function tearDown()
{
$this->_connection1=null;
$this->_connection2=null;
}
public function testActive()
{
$this->assertFalse($this->_connection2->Active);
$this->_connection2->Active=true;
$this->assertTrue($this->_connection2->Active);
$pdo=$this->_connection2->PdoInstance;
$this->assertTrue($pdo instanceof PDO);
// test setting Active repeatedly doesn't re-connect DB
$this->_connection2->Active=true;
$this->assertTrue($pdo===$this->_connection2->PdoInstance);
$this->_connection2->Active=false;
$this->assertFalse($this->_connection2->Active);
try
{
$connection=new TDbConnection('unknown:'.TEST_DB_FILE);
$connection->Active=true;
$this->fail('Expected exception is not raised');
}
catch(TDbException $e)
{
}
}
public function testCreateCommand()
{
$sql='CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(8))';
try
{
$this->_connection2->createCommand($sql);
$this->fail('Expected exception is not raised');
}
catch(TDbException $e)
{
}
$command=$this->_connection1->createCommand($sql);
$this->assertTrue($command instanceof TDbCommand);
}
public function testBeginTransaction()
{
$sql='INSERT INTO foo(id,name) VALUES (1,\'my name\')';
$transaction=$this->_connection1->beginTransaction();
try
{
$this->_connection1->createCommand($sql)->execute();
$this->_connection1->createCommand($sql)->execute();
$this->fail('Expected exception not raised');
$transaction->commit();
}
catch(Exception $e)
{
$transaction->rollBack();
$reader=$this->_connection1->createCommand('SELECT * FROM foo')->query();
$this->assertFalse($reader->read());
}
}
public function testLastInsertID()
{
$sql='INSERT INTO foo(name) VALUES (\'my name\')';
$this->_connection1->createCommand($sql)->execute();
$value=$this->_connection1->LastInsertID;
$this->assertEquals($this->_connection1->LastInsertID,'1');
}
public function testQuoteString()
{
$str="this is 'my' name";
$expectedStr="'this is ''my'' name'";
$this->assertEquals($expectedStr,$this->_connection1->quoteString($str));
}
public function testColumnNameCase()
{
$this->assertEquals(TDbColumnCaseMode::Preserved,$this->_connection1->ColumnCase);
$this->_connection1->ColumnCase=TDbColumnCaseMode::LowerCase;
$this->assertEquals(TDbColumnCaseMode::LowerCase,$this->_connection1->ColumnCase);
}
public function testNullConversion()
{
$this->assertEquals(TDbNullConversionMode::Preserved,$this->_connection1->NullConversion);
$this->_connection1->NullConversion=TDbNullConversionMode::NullToEmptyString;
$this->assertEquals(TDbNullConversionMode::NullToEmptyString,$this->_connection1->NullConversion);
}
}
|
