toot/test-sample.out at main · patrick-gu/toot · GitHub

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
 id |       email        | avatar_url | password_correct
----+--------------------+------------+------------------
  1 | alice2@example.com |            | t
(1 row)

UPDATE 1
 booking_id
------------
          4
(1 row)

INSERT 0 1
 booking_id |     start_time      |      end_time       | student_id | tooter_id
------------+---------------------+---------------------+------------+-----------
          1 | 2025-06-18 10:00:00 | 2025-06-18 10:30:00 |          1 |         2
          2 | 2025-06-19 14:30:00 | 2025-06-19 15:00:00 |          3 |         2
          3 | 2025-06-20 14:00:00 | 2025-06-20 15:00:00 |          1 |         2
          4 | 2025-06-20 14:00:00 | 2025-06-20 15:00:00 |          1 |         2
(4 rows)

 message_id
------------
          4
(1 row)

 chat_id | message_id |          sent_at           |     content      | sender_id | chat_id | message_id | attachment_index |           attachment_url
---------+------------+----------------------------+------------------+-----------+---------+------------+------------------+------------------------------------
       1 |          4 | 2025-07-09 03:41:47.154891 | hello there!     |         1 |       1 |          4 |                0 | https://example.test/help.jpg
       1 |          3 | 2025-07-09 03:37:06.987983 | hello there!     |         1 |       1 |          3 |                0 | https://example.test/help.jpg
       1 |          2 | 2025-06-18 22:56:30        | yes              |         2 |         |            |                  |
       1 |          1 | 2025-06-18 22:56:00        | you are so great |         2 |       1 |          1 |                0 | https://example.com/attachment.pdf
(4 rows)

 posting_id | tooter_id |                          location                          | price |        description
------------+-----------+------------------------------------------------------------+-------+----------------------------
          1 |         2 | (760460.9815979118, -4565785.139177497, 4388203.754904399) | 35.50 | sample pre-created posting
(1 row)

LISTEN
NOTIFY
Asynchronous notification "chat_message" with payload "{"test": "chat message data goes in this payload"}" received from server process with PID 5569.
 tooter_id | price |        description         | name |   avatar   |        lat        |        lng         | posting_id |                  courses
-----------+-------+----------------------------+------+------------+-------------------+--------------------+------------+-------------------------------------------
         2 | 35.50 | sample pre-created posting | bob  | /obama.png | 43.47229850839138 | -80.54382196538836 |          1 | Algorithms and Complexity Database Theory
(1 row)

 posting_id | tooter_id | posted_username |   avatar   |        description         | price |                          location                          |                  courses                  |      rand_key
------------+-----------+-----------------+------------+----------------------------+-------+------------------------------------------------------------+-------------------------------------------+--------------------
          1 |         2 | bob             | /obama.png | sample pre-created posting | 35.50 | (760460.9815979118, -4565785.139177497, 4388203.754904399) | Algorithms and Complexity Database Theory | 0.4164746884530115
(1 row)

 posting_id | tooter_id | posted_username | avatar | description | price | location | courses | rand_key
------------+-----------+-----------------+--------+-------------+-------+----------+---------+----------
(0 rows)