#!/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.')
