-
-
Notifications
You must be signed in to change notification settings - Fork 34
/
Copy pathdb.yml.debugger.golden
74 lines (74 loc) · 2.52 KB
/
db.yml.debugger.golden
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
-----START QUERY-----
DROP TABLE IF EXISTS users;
-----END QUERY-----
-----START QUERY RESULT-----
rows affected: 0
-----END QUERY RESULT-----
-----START QUERY-----
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
password TEXT NOT NULL,
email TEXT UNIQUE NOT NULL,
created NUMERIC NOT NULL,
updated NUMERIC
)
-----END QUERY-----
-----START QUERY RESULT-----
rows affected: 0
-----END QUERY RESULT-----
-----START QUERY-----
INSERT INTO users (username, password, email, created) VALUES ('alice', 'passw0rd', 'alice@example.com', datetime('2017-12-05'))
-----END QUERY-----
-----START QUERY RESULT-----
rows affected: 1
last insert id: 1
-----END QUERY RESULT-----
-----START QUERY-----
INSERT INTO users (username, password, email, created) VALUES ('bob', 'passw0rd', 'bob@example.com', datetime('2022-02-22'))
-----END QUERY-----
-----START QUERY RESULT-----
rows affected: 1
last insert id: 2
-----END QUERY RESULT-----
-----START QUERY-----
SELECT * FROM users;
-----END QUERY-----
-----START QUERY RESULT-----
+----+----------+----------+-------------------+---------------------+---------+
| id | username | password | email | created | updated |
+----+----------+----------+-------------------+---------------------+---------+
| 1 | alice | passw0rd | alice@example.com | 2017-12-05 00:00:00 | <nil> |
| 2 | bob | passw0rd | bob@example.com | 2022-02-22 00:00:00 | <nil> |
+----+----------+----------+-------------------+---------------------+---------+
(2 rows)
-----END QUERY RESULT-----
-----START QUERY-----
INSERT INTO users (username, password, email, created) VALUES ('charlie', 'passw0rd', 'charlie@example.com', datetime('2022-02-22'))
-----END QUERY-----
-----START QUERY RESULT-----
rows affected: 1
last insert id: 3
-----END QUERY RESULT-----
-----START QUERY-----
SELECT * FROM users WHERE id = 3
-----END QUERY-----
-----START QUERY RESULT-----
+----+----------+----------+---------------------+---------------------+---------+
| id | username | password | email | created | updated |
+----+----------+----------+---------------------+---------------------+---------+
| 3 | charlie | passw0rd | charlie@example.com | 2022-02-22 00:00:00 | <nil> |
+----+----------+----------+---------------------+---------------------+---------+
(1 row)
-----END QUERY RESULT-----
-----START QUERY-----
SELECT COUNT(*) AS c FROM users
-----END QUERY-----
-----START QUERY RESULT-----
+---+
| c |
+---+
| 3 |
+---+
(1 row)
-----END QUERY RESULT-----