date: 2026-11-06T08:36:05.225136+00:00 commit: b063c8780eabf63cdb9da3802f82440750308d6b
$ sh -c 'python3 evidence/final-validation/network_regressions.py && python3 evidence/final-validation/storage_audit.py'
{
  "checks": [
    {
      "case": "non_ascii_basic",
      "raw_hex": "42617369632080",
      "status": 401,
      "instance": "8062857b40ae"
    },
    {
      "case": "non_ascii_basic",
      "raw_hex": "426173696320ff",
      "status": 401,
      "instance": "a89ed03a52aa"
    },
    {
      "case": "non_ascii_basic",
      "raw_hex": "426173696320c3a9",
      "status": 401,
      "instance": "8062857b40ae"
    },
    {
      "case": "non_ascii_basic",
      "raw_hex": "42617369632059577870593255366332566a636d5630ff",
      "status": 401,
      "instance": "a89ed03a52aa"
    },
    {
      "case": "nul_basic_display_title",
      "position": "'\\x00'",
      "status": [
        401,
        400,
        201,
        400
      ],
      "instance": "8062857b40ae"
    },
    {
      "case": "nul_basic_display_title",
      "position": "'\\x00abc'",
      "status": [
        401,
        400,
        201,
        400
      ],
      "instance": "a89ed03a52aa"
    },
    {
      "case": "nul_basic_display_title",
      "position": "'abc\\x00def'",
      "status": [
        401,
        400,
        201,
        400
      ],
      "instance": "8062857b40ae"
    },
    {
      "case": "nul_basic_display_title",
      "position": "'abc\\x00'",
      "status": [
        401,
        400,
        201,
        400
      ],
      "instance": "a89ed03a52aa"
    },
    {
      "case": "nul_message_corrected_retry",
      "position": "'\\x00'",
      "instances": [
        "a89ed03a52aa",
        "8062857b40ae"
      ],
      "status": [
        400,
        201,
        201
      ],
      "copies": 1
    },
    {
      "case": "nul_message_corrected_retry",
      "position": "'\\x00abc'",
      "instances": [
        "8062857b40ae",
        "a89ed03a52aa"
      ],
      "status": [
        400,
        201,
        201
      ],
      "copies": 1
    },
    {
      "case": "nul_message_corrected_retry",
      "position": "'abc\\x00def'",
      "instances": [
        "a89ed03a52aa",
        "8062857b40ae"
      ],
      "status": [
        400,
        201,
        201
      ],
      "copies": 1
    },
    {
      "case": "nul_message_corrected_retry",
      "position": "'abc\\x00'",
      "instances": [
        "8062857b40ae",
        "a89ed03a52aa"
      ],
      "status": [
        400,
        201,
        201
      ],
      "copies": 1
    },
    {
      "case": "nul_access",
      "status": [
        404,
        404
      ]
    },
    {
      "case": "logout_after_replacement",
      "status": [
        204,
        401,
        401,
        401,
        401
      ]
    }
  ],
  "instances": [
    "8062857b40ae",
    "a89ed03a52aa"
  ],
  "pass": true
}
docker compose run --rm migrate
 Container hlpipe-lab3-validation-20261106-postgres-1  Running
{"before": {"users": 149, "sessions": 94, "chats": 41, "members": 80, "messages": 21870, "keys": 21870, "version": "0002_idempotency_keys"}, "after": {"users": 149, "sessions": 94, "chats": 41, "members": 80, "messages": 21870, "keys": 21870, "version": "0002_idempotency_keys"}, "unchanged": true}
id|uuid||not null||plain|||
username|text||not null||extended|||
display_name|text||not null||extended|||
password_hash|text||not null||extended|||
created_at|timestamp with time zone||not null||plain|||
token_hash|bytea||not null||extended|||
user_id|uuid||not null||plain|||
created_at|timestamp with time zone||not null||plain|||
expires_at|timestamp with time zone||not null||plain|||
id|uuid||not null||plain|||
title|text||not null||extended|||
created_at|timestamp with time zone||not null||plain|||
last_message_at|timestamp with time zone||||plain|||
chat_id|uuid||not null||plain|||
user_id|uuid||not null||plain|||
position|smallint||not null||plain|||
chat_created_at|timestamp with time zone||not null||plain|||
id|uuid||not null||plain|||
chat_id|uuid||not null||plain|||
sender_id|uuid||not null||plain|||
text|text||not null||extended|||
created_at|timestamp with time zone||not null||plain|||
chat_id|uuid||not null||plain|||
user_id|uuid||not null||plain|||
key|text||not null||extended|||
fingerprint|bytea||not null||extended|||
message_id|uuid||not null||plain|||
created_at|timestamp with time zone||not null||plain|||
version_num|character varying(32)||not null||extended|||
t
32|94

exit: 0
