forked from mtusi2026/mtusi2026lab2
41 lines
1.8 KiB
SQL
41 lines
1.8 KiB
SQL
\set ON_ERROR_STOP on
|
|
\set author '''00000000-0000-7000-8000-00000000a001'''
|
|
\set big '''00000000-0000-7000-8000-00000000c001'''
|
|
\set epoch '''2026-01-01T00:00:00Z'''
|
|
|
|
INSERT INTO users (id, username, display_name, password_hash, created_at)
|
|
VALUES (:author, 'seed_author', 'Синтетический автор', '$argon2id$v=19$m=19456,t=2,p=1$c2VlZA$c2VlZA', :epoch)
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
INSERT INTO chats (id, title, created_at)
|
|
SELECT ('00000000-0000-7000-8000-00000000c' || lpad(to_hex(chat), 3, '0'))::uuid,
|
|
'Синтетический чат ' || chat, :epoch
|
|
FROM generate_series(1, 21) AS chat
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
INSERT INTO chat_members (chat_id, user_id, position, chat_created_at)
|
|
SELECT id, :author, 1, created_at FROM chats WHERE title LIKE 'Синтетический чат %'
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
INSERT INTO messages (id, chat_id, sender_id, text, created_at)
|
|
SELECT ('00000000-0000-7000-8001-' || lpad(to_hex(n), 12, '0'))::uuid, :big, :author,
|
|
'синтетическое сообщение ' || n, :epoch::timestamptz + n * interval '1 second'
|
|
FROM generate_series(1, 20000) AS n
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
INSERT INTO messages (id, chat_id, sender_id, text, created_at)
|
|
SELECT ('00000000-0000-7000-8002-' || lpad(to_hex(chat * 1000 + n), 12, '0'))::uuid,
|
|
('00000000-0000-7000-8000-00000000c' || lpad(to_hex(chat), 3, '0'))::uuid, :author,
|
|
'фоновое сообщение ' || n, :epoch::timestamptz + n * interval '1 second'
|
|
FROM generate_series(2, 21) AS chat, generate_series(1, 500) AS n
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
UPDATE chats
|
|
SET last_message_at = (SELECT max(created_at) FROM messages WHERE messages.chat_id = chats.id)
|
|
WHERE title LIKE 'Синтетический чат %';
|
|
|
|
ANALYZE;
|
|
|
|
SELECT count(*) FILTER (WHERE chat_id = :big) AS big_chat_messages, count(*) AS all_messages
|
|
FROM messages;
|