Files

13 lines
1.6 KiB
Plaintext

chat with unknown member -> 400; rows with this title: 0; chats without members: 0; chats insert counter: 13 -> 14
PASS: chat row was inserted and then rolled back together with members
direct INSERT of a message from a non-member -> exit code 1: ERROR: insert or update on table "messages" violates foreign key constraint "messages_chat_id_sender_id_fkey"
PASS: the database itself rejects a message from a non-member
stored password: $argon2id$v=19$m=12288,t=3,p=1$... (length 97)
PASS: password is stored as Argon2id hash
unique constraint on users: UNIQUE (username)
PASS: username is unique in the database
applied migrations: 001_init.sql; restarting api
after restart: 001_init.sql; log: Migrations applied: none (schema is up to date)
PASS: migrations are applied once, restart does nothing
5 passed, 0 failed