-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathRawQueryTest.php
More file actions
57 lines (51 loc) · 1.9 KB
/
Copy pathRawQueryTest.php
File metadata and controls
57 lines (51 loc) · 1.9 KB
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
<?php
use Pipe\SQL;
beforeAll(function () {
db()->connect("127.0.0.1", "root", "pass", "test");
});
it("cat run raw queries", function () {
db()->raw("DROP TABLE IF EXISTS users");
db()->raw("CREATE TABLE `users` (
`id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(100) NOT NULL,
`password` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`deleted` tinyint(1) NOT NULL
)");
db()->raw("INSERT INTO `users` (`name`, `password`, `created_at`, `updated_at`, `deleted`)
VALUES
('2mark', 'pa4$', now(), now(), '0'),
('3mark', 'pa4$', now(), now(), '0'),
('4mark', 'pa4$', now(), now(), '0'),
('5mark', 'pa4$', now(), now(), '0'),
('6mark', 'pa4$', now(), now(), '0'),
('7mark', 'pa4$', now(), now(), '0')
");
$r = db()->raw("select * from users");
expect($r->stmt->fetchAll())->toBeArray()->toHaveCount(6);
});
it("cat run raw queries and fetch first", function () {
db()->raw("DROP TABLE IF EXISTS users");
db()->raw("CREATE TABLE `users` (
`id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(100) NOT NULL,
`password` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`deleted` tinyint(1) NOT NULL
)");
db()->raw("INSERT INTO `users` (`name`, `password`, `created_at`, `updated_at`, `deleted`)
VALUES
('2mark', 'pa4$', now(), now(), '0'),
('3mark', 'pa4$', now(), now(), '0'),
('4mark', 'pa4$', now(), now(), '0'),
('5mark', 'pa4$', now(), now(), '0'),
('6mark', 'pa4$', now(), now(), '0'),
('7mark', 'pa4$', now(), now(), '0')
");
$r = db()->raw("select * from users")->stmt->fetch();
expect($r)->toBeObject();
expect($r->id)->toEqual(1);
expect($r->name)->toEqual("2mark");
});