Files
mtusi2026lab2/scripts/track2/seed.sql
2026-10-08 14:14:20 +03:00

36 lines
1.4 KiB
SQL

\set ON_ERROR_STOP on
SELECT setseed(0.42);
INSERT INTO users (id, username, display_name, password_hash, created_at)
SELECT md5('user' || g)::uuid, 'r_' || g, 'Research user ' || g, 'not-a-real-hash',
timestamptz '2025-12-01 00:00:00Z'
FROM generate_series(1, 2000) g;
CREATE TEMP TABLE plan AS
SELECT c,
CASE WHEN c = 1 THEN 50 WHEN c <= 21 THEN 10 ELSE 2 + c % 2 END AS k,
CASE WHEN c = 1 THEN 60000 WHEN c <= 21 THEN 1500 ELSE 1 + (c * 37) % 19 END AS n
FROM generate_series(1, 2021) c;
INSERT INTO chats (id, title, created_by, created_at)
SELECT md5('chat' || c)::uuid, 'Research chat ' || c, md5('user' || ((c * 7) % 2000 + 1))::uuid,
timestamptz '2026-01-01 00:00:00Z' + c * interval '1 second'
FROM plan;
INSERT INTO chat_members (chat_id, user_id, position)
SELECT md5('chat' || p.c)::uuid, md5('user' || ((p.c * 7 + pos) % 2000 + 1))::uuid, pos
FROM plan p, generate_series(0, p.k - 1) pos;
INSERT INTO messages (id, chat_id, sender_id, text, created_at)
SELECT md5('msg' || p.c || ':' || j)::uuid,
md5('chat' || p.c)::uuid,
md5('user' || ((p.c * 7 + j % p.k) % 2000 + 1))::uuid,
left(repeat(md5(p.c || ':' || j), 1 + floor(power(random(), 4) * 62)::int), 4000),
date_trunc('milliseconds',
timestamptz '2026-01-02 00:00:00Z'
+ (j::float8 / p.n) * interval '180 days'
+ floor(random() * 1000) * interval '1 millisecond')
FROM plan p, generate_series(1, p.n) j;
ANALYZE;