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
|
<?php
class DbBasicTest extends \PHPUnit\Framework\TestCase
{
private $test_domain;
public function setUp(): void
{
$db = db_connect();
$test_domain = 'test' . uniqid() . '.com';
$this->test_domain = $test_domain;
$db->exec("DELETE FROM domain WHERE domain = '$test_domain'");
}
public function testInsertDeleteDomain()
{
$domain = $this->test_domain;
$username = 'testusername' . uniqid();
$this->assertEquals(
1,
db_insert(
'domain',
array(
'domain' => $domain,
'description' => 'test',
'transport' => '',
'password_expiry' => 99
)
)
);
$this->assertEquals(1,
db_insert(
'mailbox',
array(
'username' => $username,
'password' => 'blah',
'name' => 'blah',
'maildir' => 'blah',
'local_part' => 'blah',
'domain' => $domain
)
)
);
$this->assertEquals(1,
db_update(
'mailbox',
'username',
$username,
array('name' => 'blah updated')
)
);
$ret = db_query_one("SELECT * FROM mailbox WHERE username = :username", array('username' => $username));
$this->assertTrue(!empty($ret));
$this->assertTrue(is_array($ret));
$this->assertEquals($ret['name'], 'blah updated');
$this->assertEquals(0, db_delete('mailbox', 'username', 'blahblahinvalid'));
$this->assertEquals(1, db_delete('mailbox', 'username', $username));
$this->assertEquals(1, db_delete('domain', 'domain', $domain));
}
}
/* vim: set expandtab softtabstop=4 tabstop=4 shiftwidth=4: */
|
