2 Commits

Author	SHA1	Message	Date
Petru Paler	25a91c3322	fix: remove trailing newlines from migrations to prevent SQLITE_MISUSE errors ... Python's sqlite3.executescript() has a bug where trailing newlines after the final semicolon create empty statements. When APSW's log_sqlite() is enabled (via apswutils, imported by fastmigrate), these cause visible "API called with NULL prepared statement" errors during interpreter shutdown. - Strip trailing newlines from all 9 existing migration files - Update migration template to end with semicolon, no trailing newline - Document the requirement in CLAUDE.md 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2026-01-01 16:09:06 +00:00
Petru Paler	c08fa476e0	feat: add 30-day egg stats computation service ... Implement compute-on-read egg statistics per spec section 9: - Create egg_stats_30d_by_location table (migration 0007) - Add get_egg_stats service with bird-days calculation - Calculate layer-eligible days (adult female + matching species) - Implement feed proration formula with INTEGER truncation - Cache computed stats with window bounds Verifies E2E test #1 baseline values: - eggs_total_pcs = 12 - feed_total_g = 6000, feed_layers_g = 4615 - cost_per_egg_all = 0.600, cost_per_egg_layers = 0.462 - layer_eligible_bird_days = 10 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-29 09:25:39 +00:00