forked from mtusi2026/mtusi2026lab3
60 lines
2.2 KiB
PL/PgSQL
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; |