Files
2026-10-23 18:10:07 +03:00

60 lines
2.2 KiB
PL/PgSQL

-- Fixtures for lab3 track1: 200 users, 100 chats, 10000 messages.
-- Idempotent: чистит и наполняет заново. Пароль у всех — 'fixture-password-000'.
BEGIN;
TRUNCATE messages, idempotency_keys, sessions, chat_members, chats, users
RESTART IDENTITY CASCADE;
-- 200 users.
INSERT INTO users (id, username, display_name, password_hash, created_at)
SELECT
gen_random_uuid(),
'fixture_' || lpad(i::text, 4, '0'),
'Fixture User ' || i,
-- фиктивный Argon2id-хеш: 32-байтная соль и 32-байтный ключ (не валиден
-- для входа, но не мешает нагрузке — мы не логинемся этими юзерами).
'$argon2id$v=19$m=19456,t=2,p=1$AAAAAAAAAAAAAAAAAAAAAA$AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA',
now() - (i || ' seconds')::interval
FROM generate_series(1, 200) AS i;
-- 100 chats, каждый по 2 участника из первых 100 users.
INSERT INTO chats (id, title, created_at)
SELECT
gen_random_uuid(),
'Fixture chat ' || i,
now() - (i || ' minutes')::interval
FROM generate_series(1, 100) AS i;
-- Каждый чат: два участника (user_i, user_{i+100}).
INSERT INTO chat_members (chat_id, user_id)
SELECT c.id, u.id
FROM (SELECT id, row_number() OVER (ORDER BY created_at) AS rn FROM chats) c
JOIN (SELECT id, row_number() OVER (ORDER BY created_at) AS rn FROM users) u
ON u.rn IN (c.rn, c.rn + 100)
WHERE c.rn <= 100;
-- 10000 messages: по 100 на чат, отправлены первым участником.
INSERT INTO messages (id, chat_id, sender_id, text, created_at)
SELECT
gen_random_uuid(),
c.chat_id,
c.sender_id,
'fixture message ' || c.n,
now() - ((10000 - (c.chat_idx * 100 + c.n)) || ' seconds')::interval
FROM (
SELECT
cm.chat_id,
cm.user_id AS sender_id,
row_number() OVER () AS chat_idx,
gs.n
FROM chat_members cm
JOIN LATERAL generate_series(1, 100) gs(n) ON true
WHERE cm.user_id IN (
SELECT user_id FROM (
SELECT user_id, row_number() OVER (PARTITION BY chat_id ORDER BY user_id) AS p
FROM chat_members
) x WHERE p = 1
)
) c;
COMMIT;