-- 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;