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
|
<?php
/**
* Copyright (c) 2012 Bart Visscher <bartv@thisnet.nl>
* This file is licensed under the Affero General Public License version 3 or
* later.
* See the COPYING-README file.
*/
class Test_DB extends UnitTestCase {
protected static $schema_file = 'static://test_db_scheme';
protected $test_prefix;
public function setUp() {
$dbfile = OC::$SERVERROOT.'/tests/data/db_structure.xml';
$r = '_'.OC_Util::generate_random_bytes('4').'_';
$content = file_get_contents( $dbfile );
$content = str_replace( '*dbprefix*', '*dbprefix*'.$r, $content );
file_put_contents( self::$schema_file, $content );
$this->test_prefix = $r;
$this->table1 = $this->test_prefix.'contacts_addressbooks';
$this->table2 = $this->test_prefix.'contacts_cards';
}
public function tearDown() {
unlink(self::$schema_file);
}
protected function setUpDB() {
OC_DB::disconnect();
OC_DB::createDbFromStructure(self::$schema_file);
}
protected function tearDownDB() {
OC_DB::removeDBStructure(self::$schema_file);
}
// every thing in one test, phpunit messes with MDB2
// also setUpDB and tearDownDB only once, otherwise sqlite doesn't finish
public function testDBCompatibility() {
$this->setUpDB();
$this->doTestQuotes();
$this->doTestNOW();
$this->doTestUNIX_TIMESTAMP();
$this->tearDownDB();
}
public function doTestQuotes() {
//$this->setUpDB();
$query = OC_DB::prepare('SELECT `fullname` FROM *PREFIX*'.$this->table2.' WHERE `uri` = ?');
$result = $query->execute(array('uri_1'));
$this->assertTrue($result);
$row = $result->fetchRow();
$this->assertFalse($row);
$query = OC_DB::prepare('INSERT INTO *PREFIX*'.$this->table2.' (`fullname`,`uri`) VALUES (?,?)');
$result = $query->execute(array('fullname test', 'uri_1'));
$this->assertTrue($result);
$query = OC_DB::prepare('SELECT `fullname`,`uri` FROM *PREFIX*'.$this->table2.' WHERE `uri` = ?');
$result = $query->execute(array('uri_1'));
$this->assertTrue($result);
$row = $result->fetchRow();
$this->assertArrayHasKey('fullname', $row);
$this->assertEqual($row['fullname'], 'fullname test');
$row = $result->fetchRow();
$this->assertFalse($row);
//$this->tearDownDB();
}
public function doTestNOW() {
//$this->setUpDB();
$query = OC_DB::prepare('INSERT INTO *PREFIX*'.$this->table2.' (`fullname`,`uri`) VALUES (NOW(),?)');
$result = $query->execute(array('uri_2'));
$this->assertTrue($result);
$query = OC_DB::prepare('SELECT `fullname`,`uri` FROM *PREFIX*'.$this->table2.' WHERE `uri` = ?');
$result = $query->execute(array('uri_2'));
$this->assertTrue($result);
//$this->tearDownDB();
}
public function doTestUNIX_TIMESTAMP() {
//$this->setUpDB();
$query = OC_DB::prepare('INSERT INTO *PREFIX*'.$this->table2.' (`fullname`,`uri`) VALUES (UNIX_TIMESTAMP(),?)');
$result = $query->execute(array('uri_3'));
$this->assertTrue($result);
$query = OC_DB::prepare('SELECT `fullname`,`uri` FROM *PREFIX*'.$this->table2.' WHERE `uri` = ?');
$result = $query->execute(array('uri_3'));
$this->assertTrue($result);
//$this->tearDownDB();
}
}
|
