Justin van der Merwe justinvdm

Active Record Conversion Audit

Task Narrative

We need a comprehensive, up-to-date checklist of all code that still needs refactoring to use the Active Record pattern. An existing conversion plan lives at apps/web/src/models/active-record-conversion.md (created 2026-03-02). Our job is to verify whether that plan is still current, identify any gaps (new tables, new files), and produce a single authoritative checklist suitable for handing off to Kindling.

Synthesized Context

Active Record library: apps/web/src/lib/active-record/ (base Record, Collection, Relation classes)
Secure layer: apps/web/src/models/base/secure-record.ts (adds SecureModel + SecureCollection with auto-scoping, permissions, FK ownership validation)

	#!/bin/bash
	set -euo pipefail

	# A script to commit with an AI-generated message and push.
	#
	# Usage:
	# ad
	#
	# Environment Variables:
	# NO_AI: If set to "true", it will use a fallback commit message

	const http = require('http');

	const markup = `
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width,initial-scale=1">
	<title>rarily rar rar</title>
	<script defer src="/head.js"></script>

	// !!! NOTE !!!
	// This is not meant to be a comparison to show which library is
	// universally faster. In fact, it is quite likely that faker and
	// chance have functions that perform better than the equivalents in
	// fictional. The 'seed each' benchmarks below are probably also
	// misuse of faker and chance. The intention of these benchmarks was
	// to investigate and show why seeding as a way of mapping
	// identifiers to generated values isn't viable, and why hashing is a
	// promising solution
	const Benchmark = require("benchmark");

	const Benchmark = require("benchmark");

	displayIntro()

	const N = 1000;

	const A = 'a'
	const B = 'b'
	const C = 'c'

	const diff = (() => {
	const toString = Function.prototype.toString;
	const objectString = toString.call(Object);

	return function diff(a, b, opts) {
	opts = {
	printShallow: false,
	...opts,
	};

	function slowOp(factor) {
	const n = 999999 * factor;
	let i = -1;

	while (++i < n) {
	Math.pow(23, i % 3);
	}
	}

	const http = require("http");

	const CSS_DELAY = 5000;

	const html = `
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width,initial-scale=1">

	const assert = require("assert");

	class V {
	constructor(v) {
	this.v = v;
	}
	}

	suite("fn-create-overhead", () => {
	const { N = 100000 } = require("./conf");