#!/usr/bin/env python3 """Eerste start en een tweede start bewaren bestaande dagen en configuratie.""" from pathlib import Path import shutil import sqlite3 import subprocess import tempfile WEB = Path(__file__).resolve().parents[1] ARTIFACTS = WEB / 'tests/artifacts' ARTIFACTS.mkdir(exist_ok=True) with tempfile.TemporaryDirectory(prefix='startup-', dir=ARTIFACTS) as tmp: root = Path(tmp) shutil.copytree(WEB / 'lib', root / 'lib') (root / 'data').mkdir() def startup(): result = subprocess.run( ['php', '-r', 'require $argv[1]; db();', str(root / 'lib/bootstrap.php')], capture_output=True, text=True, check=True, ) assert not result.stderr, result.stderr log = root / 'data/php-errors.log' assert not log.exists() or not log.read_text(), 'Startup emitted PHP errors' startup() config = root / 'data/config.php' assert config.is_file(), 'Eerste start maakt config.php' original = config.read_text() assert all(f"'{key}' => ''" in original for key in ['base_url', 'client_id', 'client_secret']) assert __import__('re').search(r"'key_secret' => '[a-f0-9]{64}'", original), original config.write_text(original.replace("'client_id' => ''", "'client_id' => 'projects.timfalken.com'") + '\n// servercommentaar\n') marked = config.read_text() con = sqlite3.connect(root / 'data/verhalenboek.sqlite') con.execute("INSERT INTO users (id, name, role, theme, font, created) VALUES ('auth:1','tim','admin','system','serif',1)") con.execute("INSERT INTO days (date, title, created, updated) VALUES ('2026-01-01','Bewaard',1,1)") con.execute("INSERT INTO stories (day_id, position, title, created, updated) VALUES (1,1,'Een',1,1)") con.execute("INSERT INTO paragraphs (story_id, position, body) VALUES (1,1,'Blijft staan.')") con.commit() con.execute('DROP TABLE wiki_pages') con.execute('DROP TABLE wiki_categories') con.commit() startup() assert config.read_text() == marked, 'Bestaande config.php blijft byte voor byte staan' tables = [name for (name,) in con.execute("SELECT name FROM sqlite_master WHERE type='table'")] assert 'wiki_categories' in tables and 'wiki_pages' in tables, tables row = con.execute('SELECT date, title FROM days').fetchone() assert row == ('2026-01-01', 'Bewaard'), row assert con.execute('SELECT body FROM paragraphs').fetchone()[0] == 'Blijft staan.' assert 'email' not in [name for _, name, *_ in con.execute('PRAGMA table_info(users)')] con.close() import re stripped = re.sub(r"\n 'key_secret' => '[a-f0-9]{64}',", '', marked, count=1) assert "'key_secret' =>" not in stripped config.write_text(stripped) startup() restored = config.read_text() assert 'servercommentaar' in restored and "'client_id' => 'projects.timfalken.com'" in restored assert re.search(r"'key_secret' => '[a-f0-9]{64}'", restored), restored print('Startup: fresh database, preserved day and preserved config passed.')