forked from mtusi2026/mtusi2026lab2
36 lines
1.2 KiB
Bash
Executable File
36 lines
1.2 KiB
Bash
Executable File
#!/bin/sh
|
|
set -eu
|
|
cd "$(dirname "$0")/.."
|
|
|
|
docker compose exec -T postgres psql -U messenger -d messenger -v ON_ERROR_STOP=1 <<'SQL'
|
|
INSERT INTO users (id, username, display_name, password_hash)
|
|
VALUES ('aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa', 'plan_user', 'Plan user', 'not-used')
|
|
ON CONFLICT (id) DO NOTHING;
|
|
|
|
INSERT INTO chats (id, title)
|
|
VALUES ('bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb', 'Plan history')
|
|
ON CONFLICT (id) DO NOTHING;
|
|
|
|
INSERT INTO chat_members (chat_id, user_id)
|
|
VALUES ('bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb', 'aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa')
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
INSERT INTO messages (id, chat_id, sender_id, text, created_at)
|
|
SELECT
|
|
('00000000-0000-4000-8000-' || lpad(item::text, 12, '0'))::uuid,
|
|
'bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb',
|
|
'aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa',
|
|
'plan message ' || item,
|
|
'2026-01-01T00:00:00Z'::timestamptz + item * interval '1 microsecond'
|
|
FROM generate_series(1, 10000) AS item
|
|
ON CONFLICT (id) DO NOTHING;
|
|
|
|
ANALYZE messages;
|
|
EXPLAIN (ANALYZE, BUFFERS)
|
|
SELECT id, chat_id, sender_id, text, created_at
|
|
FROM messages
|
|
WHERE chat_id = 'bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb'
|
|
ORDER BY created_at, id
|
|
LIMIT 50;
|
|
SQL
|