Files
jakob 676e55eeb6 db: add failing tests for connection URL, migration splitting, backup/restore
Tests define the db module API:
- connection_url() builds the sqlx URL with percent-encoded
  credentials; with/without the database name
- split_statements() splits SQL on semicolons outside strings and
  line comments (the embedded migration is applied statement by
  statement, since DDL cannot run in a rollbackable transaction)
- the embedded migration is Documentation/schema.sql (version 1),
  carrying the seven domain tables only; schema_migrations is
  created by the application
- backup_command() shells out to mariadb-dump (mysqldump fallback)
  with --single-transaction, password via MYSQL_PWD, never argv
- restore_command() pipes the dump (which carries CREATE DATABASE /
  USE) into the mariadb client
- backup_filename() is timestamped per cli.md
2026-09-08 21:38:48 +02:00
..