#!/usr/bin/env python3 """Geïsoleerde API-tests. De echte database van de applicatie blijft onaangeroerd.""" import json import os import signal import http.cookiejar import shutil import socket import sqlite3 import subprocess import tempfile import time import urllib.error import urllib.request from pathlib import Path WEB = Path(__file__).resolve().parents[1] ARTIFACTS = WEB / 'tests/artifacts' ARTIFACTS.mkdir(exist_ok=True) checks = 0 def check(value, label): global checks checks += 1 assert value, label def stories(prefix='Verhaal'): return [ {'title': f'{prefix} een', 'paragraphs': ['Eerste alinea.', 'Tweede alinea met één accent.']}, {'title': f'{prefix} twee', 'paragraphs': ['Midden.']}, {'title': f'{prefix} drie', 'paragraphs': ['Slot.']}, ] with tempfile.TemporaryDirectory(prefix='api-', dir=ARTIFACTS) as tmp: root = Path(tmp) for name in ['api.php', 'index.php', 'auth.php', 'callback.php', 'router.php', 'docs.php']: shutil.copy(WEB / name, root / name) shutil.copytree(WEB / 'lib', root / 'lib') (root / 'assets').mkdir() shutil.copy(WEB / 'assets/favicon.svg', root / 'assets/favicon.svg') (root / 'data').mkdir() with socket.socket() as sock: sock.bind(('127.0.0.1', 0)) port = sock.getsockname()[1] base = f'http://127.0.0.1:{port}' log_path = root / 'server.log' log = log_path.open('w') process = subprocess.Popen( ['php', '-d', 'opcache.enable=0', '-S', f'127.0.0.1:{port}', '-t', str(root), str(root / 'router.php')], stdout=log, stderr=log, start_new_session=True, ) class Client: def __init__(self, token=None): self.token = token self.opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(http.cookiejar.CookieJar())) self.csrf = None def request(self, method, path, body=None, expected=200, csrf=True, extra_headers=None): headers = {'Accept': 'application/json'} data = None if body is not None: data = json.dumps(body).encode() headers['Content-Type'] = 'application/json' if self.token: headers['Authorization'] = 'Bearer ' + self.token elif method not in ('GET', 'HEAD') and csrf: headers['X-CSRF-Token'] = self.csrf or '' if extra_headers: headers.update(extra_headers) req = urllib.request.Request(base + '/api.php' + path, data=data, headers=headers, method=method) try: response = self.opener.open(req) except urllib.error.HTTPError as error: response = error with response: raw = response.read().decode() payload = json.loads(raw) check(response.status == expected, f'{method} {path}: verwacht {expected}, kreeg {response.status} {payload}') return payload def me(self): data = self.request('GET', '/me') self.csrf = data['csrf'] return data try: for _ in range(100): try: urllib.request.urlopen(base + '/index.php').close() break except urllib.error.URLError: time.sleep(0.05) else: raise RuntimeError(log_path.read_text()[-2000:]) config_path = root / 'data/config.php' check(config_path.is_file(), 'Eerste pagina maakt config.php') generated = config_path.read_text() check(all(f"'{key}' => ''" in generated for key in ['base_url', 'client_id', 'client_secret']), 'Gegenereerde configvelden zijn leeg') configured = generated.replace("'client_id' => ''", "'client_id' => 'fixture-client'") + '\n// Bewaar deze servercommentaar.\n' config_path.write_text(configured) anonymous = Client() anonymous.request('GET', '/me', expected=401, extra_headers={'Host': 'verhalenboek.test'}) anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Bearer vb_' + 'ab' * 32}) admin = Client() me = admin.me() check(me['user']['name'] == 'test_user_1' and me['user']['admin'] is True and me['local'] is True, 'Eerste lokale gebruiker is beheerder') check('email' not in me['user'], 'Profiel bevat geen e-mail') check(config_path.read_text() == configured, 'Bestaande configuratie blijft byte voor byte staan') loaded = subprocess.check_output( ['php', '-r', 'require $argv[1]; echo json_encode(config());', str(root / 'lib/bootstrap.php')], env={**os.environ, 'VERHALENBOEK_BASE_URL': 'https://example.test', 'VERHALENBOEK_CLIENT_ID': 'environment-client', 'VERHALENBOEK_CLIENT_SECRET': 'fixture-secret'}, text=True, ) check(json.loads(loaded) == {'base_url': 'https://example.test', 'client_id': 'fixture-client', 'client_secret': 'fixture-secret'}, 'Lege velden gebruiken de omgeving; gevulde velden winnen') reader = Client() reader.me() switched = reader.request('POST', '/session/switch', {'user': 'test_user_2'}) reader.csrf = switched['csrf'] check(reader.me()['user']['name'] == 'test_user_2' and reader.me()['user']['admin'] is False, 'Tweede gebruiker is alleen lezer') check(admin.me()['user']['name'] == 'test_user_1', 'Sessies blijven onafhankelijk') reader.request('POST', '/days', {'date': '2026-05-01', 'title': 'Verboden', 'stories': stories()}, expected=403) reader.request('POST', '/keys', {'name': 'nee'}, expected=403) reader.request('GET', '/keys', expected=403) old = admin.csrf admin.csrf = 'fout' admin.request('POST', '/keys', {'name': 'nee'}, expected=403) admin.csrf = old created = admin.request('POST', '/keys', {'name': 'Schrijver'}, expected=201)['key'] token = created['token'] check(token.startswith('vb_') and created['prefix'] == token[:11], 'Nieuwe sleutel toont het geheim één keer') listed = admin.request('GET', '/keys')['keys'] check(token not in json.dumps(listed) and listed[0]['prefix'] == created['prefix'] and 'token' not in listed[0], 'De lijst verbergt het geheim') with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db: stored = db.execute('SELECT token_hash FROM api_keys WHERE id=?', (created['id'],)).fetchone()[0] check(stored != token and len(stored) == 64, 'De database bewaart alleen een hash') bearer = Client(token) check(bearer.request('GET', '/days/latest', expected=404)['error'], 'Nog geen laatste datum') check(bearer.request('GET', '/days/gaps') == {'first': None, 'latest': None, 'missing': [], 'incomplete': []}, 'Lege gaten') bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': stories()[:2]}, expected=422) bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': stories() + [{'title': 'Extra', 'paragraphs': ['Te veel']}]}, expected=422) bearer.request('POST', '/days', {'date': '2026-02-31', 'title': 'Nee', 'stories': stories()}, expected=422) bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': [ {'title': 'Een', 'paragraphs': ['']}, {'title': 'Twee', 'paragraphs': ['Oké']}, {'title': 'Drie', 'paragraphs': ['Oké']}, ]}, expected=422) first = bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'De eerste bladzijde', 'stories': stories('Eerste')}, expected=201) check(first['complete'] is True and first['storyCount'] == 3 and [s['position'] for s in first['stories']] == [1, 2, 3], 'Eén aanroep maakt een volledige dag') check(first['stories'][0]['paragraphs'][1] == 'Tweede alinea met één accent.', 'Unicode blijft intact') bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Dubbel', 'stories': stories()}, expected=409) bearer.request('POST', '/days', {'date': '2026-05-02', 'title': 'De regen op het dak', 'stories': stories('Regen')}, expected=201) bearer.request('POST', '/days', {'date': '2026-05-04', 'title': 'Het licht in de keuken', 'stories': stories('Licht')}, expected=201) check(bearer.request('GET', '/days/latest')['date'] == '2026-05-04', 'Laatste geschreven datum') gaps = bearer.request('GET', '/days/gaps') check(gaps['first'] == '2026-05-01' and gaps['latest'] == '2026-05-04' and gaps['missing'] == ['2026-05-03'] and gaps['incomplete'] == [], 'Ontbrekende dag tussen de eerste en de laatste') middle = bearer.request('GET', '/days/2026-05-02') check(middle['previous'] == '2026-05-01' and middle['next'] == '2026-05-04' and 'read' not in middle, 'Vorige en volgende dag, zonder leesstatus voor een sleutel') kept = bearer.request('PUT', '/days/2026-05-02/stories/2', {'title': 'Nieuwe middag'}) check(kept['stories'][1]['title'] == 'Nieuwe middag' and kept['stories'][1]['paragraphs'] == ['Midden.'], 'Verhaal bewerken bewaart de alinea\'s') broken = bearer.request('DELETE', '/days/2026-05-04/stories/2') check(broken['complete'] is False and [s['position'] for s in broken['stories']] == [1, 3], 'Verwijderd verhaal laat een gat in de plekken') latest = bearer.request('GET', '/days/latest') check(latest['date'] == '2026-05-04' and latest['complete'] is False and latest['storyCount'] == 2, 'De laatste datum blijft, ook als de dag onvolledig is') gaps = bearer.request('GET', '/days/gaps') check(gaps['missing'] == ['2026-05-03'], 'Een onvolledige dag staat niet bij de ontbrekende datums') incomplete = gaps['incomplete'] check(len(incomplete) == 1 and incomplete[0]['date'] == '2026-05-04' and incomplete[0]['missingPositions'] == [2] and incomplete[0]['storyCount'] == 2, 'Onvolledige dag meldt de ontbrekende plek') repaired = bearer.request('POST', '/days/2026-05-04/stories', {'title': 'Terug', 'paragraphs': ['Weer drie.']}, expected=201) check(repaired['complete'] is True and repaired['stories'][1]['position'] == 2, 'Het ontbrekende verhaal vult plek 2') bearer.request('POST', '/days/2026-05-04/stories', {'title': 'Vier', 'paragraphs': ['Nee']}, expected=422) bearer.request('DELETE', '/days/2026-05-02') check(bearer.request('GET', '/days/latest')['date'] == '2026-05-04', 'Verwijderen van een middendag laat de laatste datum staan') check('2026-05-02' in bearer.request('GET', '/days/gaps')['missing'], 'Een verwijderde dag wordt een gat') bearer.request('POST', '/days/2026-05-02/read', expected=403) bearer.request('GET', '/keys', expected=403) bearer.request('DELETE', '/days/2099-01-01', expected=404) check(reader.request('GET', '/days/2026-05-01')['read'] is False, 'Openen via GET markeert de dag nog niet') check(reader.request('POST', '/days/2026-05-01/read')['read'] is True, 'De lezer markeert de dag als gelezen') check(reader.request('POST', '/days/2026-05-01/read')['read'] is True, 'Opnieuw gelezen blijft gelezen') reader_days = reader.request('GET', '/days')['days'] admin_days = admin.request('GET', '/days')['days'] check(next(day for day in reader_days if day['date'] == '2026-05-01')['read'] is True, 'Overzicht van de lezer toont gelezen') check(next(day for day in admin_days if day['date'] == '2026-05-01')['read'] is False, 'De andere gebruiker heeft die dag niet gelezen') check(reader.request('DELETE', '/days/2026-05-01/read')['read'] is False, 'Handmatig ongelezen') reader.request('DELETE', '/days/2026-05-04', expected=403) reader.request('PUT', '/me/settings', {'theme': 'dark', 'font': 'rounded'}) check(reader.me()['user']['theme'] == 'dark' and reader.me()['user']['font'] == 'rounded', 'Instellingen blijven bewaard') check(admin.me()['user']['theme'] == 'system' and admin.me()['user']['font'] == 'serif', 'Instellingen zijn per gebruiker') reader.request('PUT', '/me/settings', {'theme': 'blauw', 'font': 'serif'}, expected=422) export = reader.request('GET', '/me/export') check(export['profile']['name'] == 'test_user_2' and 'email' not in export['profile'] and export['api_keys'] == [], 'Export bevat alleen de eigen gegevens') check(all(item['date'] != '2026-05-01' or item['read_at'] for item in export['reads']) or export['reads'] == [], 'Een ongelezen dag staat niet als gelezen in de export') check(export['reads'] == [], 'Na ongelezen zit de dag niet meer in de export') admin.request('PUT', '/days/2026-05-01', {'title': 'Herziene titel'}) check(admin.request('GET', '/days/2026-05-01')['title'] == 'Herziene titel', 'Beheerder bewerkt een dag in de sessie') admin.request('PUT', '/days/2026-05-01', {'stories': stories()[:1]}, expected=422) revoked = admin.request('DELETE', '/keys/' + str(created['id']))['key'] check(revoked['revoked'] is not None, 'Sleutel intrekken') bearer.request('GET', '/days/latest', expected=401) admin.request('GET', '/days/nope', expected=404) admin.request('PUT', '/days/latest', {'title': 'Nee'}, expected=405) for path in ['/data/config.php', '/data/verhalenboek.sqlite', '/lib/bootstrap.php', '/lib/Storybook.php']: try: urllib.request.urlopen(base + path) check(False, path + ' moet afgeschermd zijn') except urllib.error.HTTPError as error: check(error.code == 403, path + ' geeft ' + str(error.code)) docs = urllib.request.urlopen(base + '/docs.php') body = docs.read().decode() check(docs.status == 200 and 'precies drie verhalen' in body and 'days/latest' in body, 'API-documentatie is bereikbaar') auth_bootstrap = root / 'lib/bootstrap.php' auth_bootstrap.write_text(auth_bootstrap.read_text().replace( " $ch=curl_init('https://auth.timfalken.com'.$path);", " return match($path) {'/api/me'=>['user'=>['id'=>7,'username'=>'oauth_user','email'=>'hidden@example.com']],'/api/logout'=>['ok'=>true],'/api/session/extend'=>['expires_in'=>86400],default=>['access_token'=>'fixture-token','expires_in'=>86400]};\n $ch=curl_init('https://auth.timfalken.com'.$path);", )) config_path.write_text(config_path.read_text().replace("'client_secret' => ''", "'client_secret' => 'fixture-secret'")) class NoRedirect(urllib.request.HTTPRedirectHandler): def redirect_request(self, req, fp, code, msg, headers, newurl): return None oauth = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(http.cookiejar.CookieJar()), NoRedirect()) def redirect(path): try: oauth.open(base + path) raise AssertionError('redirect verwacht') except urllib.error.HTTPError as error: check(error.code == 302, 'OAuth redirect: ' + error.read().decode()) return error.headers['Location'] from urllib.parse import parse_qs, urlsplit login = redirect('/auth.php') oauth_state = parse_qs(urlsplit(login).query)['state'][0] check('client_id=fixture-client' in login and 'redirect_uri=' in login and login.startswith('https://auth.timfalken.com/oauth/authorize?'), 'Login gaat naar de account-dienst') callback = redirect('/callback.php?state=' + oauth_state + '&code=fixture') check(urlsplit(callback).path == '/', 'OAuth komt terug op het boek') with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db: row = db.execute("SELECT id, name, role FROM users WHERE id='auth:7'").fetchone() columns = [name for _, name, *_ in db.execute('PRAGMA table_info(users)')] check(row == ('auth:7', 'oauth_user', 'user'), 'OAuth-gebruiker gebruikt het numerieke id en wordt geen beheerder') check('email' not in columns and 'hidden@example.com' not in json.dumps(row), 'E-mail wordt niet opgeslagen') print(f'API: {checks} assertions passed.') except Exception: log.flush() print(log_path.read_text()[-4000:]) raise finally: os.killpg(process.pid, signal.SIGTERM) process.wait(timeout=5) log.close()