AI-Horde/sql_statements/5.1.16.txt.license at main - AI-Horde - Gitea: Git with a cup of tea

dilim/AI-Horde

0 Fork 0

mirror of https://github.com/Haidra-Org/AI-Horde.git synced 2026-11-06 05:17:31 +00:00

Files

T

tazlin aef5f44d15 feat(kudos): partition the event tables by created and convert in place

- kudos_ledger and kudos_stat_events are range-partitioned on created with (id, created) primary keys, so retention removes whole partitions by age
- KudosPartitioning and ensure_kudos_event_partitions create upcoming partitions with the autovacuum storage parameters; init_db and the test fixtures call it after create_all
- The retention catalog, stat rollup, quarantine, ledger checkpoint, daily statement and idempotency key models and their enums are declared alongside the event tables, so one migration and the ORM build the same schema
- kudos_db gains a session-level retention advisory lock taken on a dedicated autocommit connection
- sql_statements/5.1.16.txt creates the retention tables, backfills idempotency keys inside the online window and converts the existing tables in place by attaching each as a legacy partition behind a validated range CHECK
- tests/integration/test_kudos_retention_migration.py checks the conversion, reruns, refusal guards and ORM parity with the migration

2026-11-03 12:29:05 -05:00

4 lines

95 B

Plaintext

Raw Permalink Blame History

	`SPDX-FileCopyrightText: Tazlin <tazlin@haidra.net>`

	`SPDX-License-Identifier: AGPL-3.0-or-later`