date: 2026-10-28T17:14:42Z  commit: 6468ee2
== применение к пустому volume
$ make reset-data && make up
$ docker compose logs --no-log-prefix migrate
{"version":"0001_init","event":"migration.applied","level":"info","ts":"2026-10-28T17:14:47.224527Z"}
{"reason":"applied","event":"migration.completed","level":"info","ts":"2026-10-28T17:14:47.224610Z"}
$ psql -c "SELECT (SELECT count(*) FROM users) users, (SELECT count(*) FROM sessions) sessions, (SELECT count(*) FROM chats) chats, (SELECT count(*) FROM chat_members) members, (SELECT count(*) FROM messages) messages, (SELECT count(*) FROM schema_migrations) versions"
 users | sessions | chats | members | messages | versions 
-------+----------+-------+---------+----------+----------
     0 |        0 |     0 |       0 |        0 |        1
(1 row)

$ psql -c "SELECT version, left(checksum, 12) AS checksum, applied_at FROM schema_migrations"
  version  |   checksum   |          applied_at          
-----------+--------------+------------------------------
 0001_init | 9a13618f078a | 2026-10-28 17:14:47.21836+00
(1 row)

== повторный запуск на заполненной БД
$ make test
python3 tests/smoke.py --base-url "http://localhost:18082" 
PASS: lab2 public API scenario; infrastructure and grading evidence remain separate.
$ psql -c "SELECT (SELECT count(*) FROM users) users, (SELECT count(*) FROM sessions) sessions, (SELECT count(*) FROM chats) chats, (SELECT count(*) FROM chat_members) members, (SELECT count(*) FROM messages) messages, (SELECT count(*) FROM schema_migrations) versions"
 users | sessions | chats | members | messages | versions 
-------+----------+-------+---------+----------+----------
     3 |        2 |     1 |       2 |        2 |        1
(1 row)

$ make migrate
{"reason":"up to date","event":"migration.completed","level":"info","ts":"2026-10-28T17:14:50.421856Z"}
$ psql -c "SELECT (SELECT count(*) FROM users) users, (SELECT count(*) FROM sessions) sessions, (SELECT count(*) FROM chats) chats, (SELECT count(*) FROM chat_members) members, (SELECT count(*) FROM messages) messages, (SELECT count(*) FROM schema_migrations) versions"
 users | sessions | chats | members | messages | versions 
-------+----------+-------+---------+----------+----------
     3 |        2 |     1 |       2 |        2 |        1
(1 row)

