Add more records to test the endpoint with

1 files changed, 91 insertions, 0 deletions

diff --git a/postgres/init.sql b/postgres/init.sql
index ae86fca0..190a705c 100644
--- a/postgres/init.sql
+++ b/postgres/init.sql
@@ -13,6 +13,11 @@ INSERT INTO users VALUES (
     current_timestamp
 );
 
+INSERT INTO users VALUES (
+    1,
+    current_timestamp
+);
+
 CREATE TABLE channels (
     id varchar,
     name varchar,
@@ -25,6 +30,36 @@ INSERT INTO channels VALUES(
 );
 
 INSERT INTO channels VALUES(
+    '11',
+    'help-apple'
+);
+
+INSERT INTO channels VALUES(
+    '12',
+    'help-cherry'
+);
+
+INSERT INTO channels VALUES(
+    '21',
+    'ot0-hello'
+);
+
+INSERT INTO channels VALUES(
+    '22',
+    'ot1-world'
+);
+
+INSERT INTO channels VALUES(
+    '31',
+    'voice-chat-0'
+);
+
+INSERT INTO channels VALUES(
+    '32',
+    'code-help-voice-0'
+);
+
+INSERT INTO channels VALUES(
     '1234',
     'zebra'
 );
@@ -53,3 +88,59 @@ INSERT INTO messages VALUES(
     now() + INTERVAL '10 minutes,',
     '1234'
 );
+
+INSERT INTO messages VALUES(
+    2,
+    0,
+    false,
+    now(),
+    '11'
+);
+
+INSERT INTO messages VALUES(
+    3,
+    0,
+    false,
+    now(),
+    '12'
+);
+
+INSERT INTO messages VALUES(
+    4,
+    1,
+    false,
+    now(),
+    '21'
+);
+
+INSERT INTO messages VALUES(
+    5,
+    1,
+    false,
+    now(),
+    '22'
+);
+
+INSERT INTO messages VALUES(
+    6,
+    1,
+    false,
+    now(),
+    '31'
+);
+
+INSERT INTO messages VALUES(
+    7,
+    1,
+    false,
+    now(),
+    '32'
+);
+
+INSERT INTO messages VALUES(
+    8,
+    1,
+    true,
+    now(),
+    '32'
+);