#!/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) self.last_headers = {key.lower(): value for key, value in response.headers.items()} 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() missing = anonymous.request('GET', '/me', expected=401, extra_headers={'Host': 'verhalenboek.test'}) check('geen Authorization-header' in missing['how_to_authenticate'] and missing['hint'] == missing['how_to_authenticate'] and 'docs.php' in missing['how_to_authenticate'], '401 zonder header legt authenticatie uit') check(anonymous.last_headers.get('www-authenticate') == 'Bearer', '401 stuurt WWW-Authenticate: Bearer') malformed = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Basic abc', 'Host': 'verhalenboek.test'}) check('verkeerde formaat' in malformed['how_to_authenticate'] and 'docs.php' in malformed['hint'], 'Verkeerde Authorization-vorm krijgt een eigen uitleg') short = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Bearer vb_kort', 'Host': 'verhalenboek.test'}) check(short['error'].startswith('De API-sleutel heeft het verkeerde formaat') and 'verkeerde formaat' in short['how_to_authenticate'], 'Een te korte sleutel is het verkeerde formaat') unknown = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Bearer vb_' + 'ab' * 32}) check(unknown['error'] == 'Deze API-sleutel is onbekend.' and 'onbekend of ingetrokken' in unknown['how_to_authenticate'], 'Onbekende sleutel krijgt de afwijs-uitleg') 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, ) loaded_config = json.loads(loaded) check(loaded_config['base_url'] == 'https://example.test' and loaded_config['client_id'] == 'fixture-client' and loaded_config['client_secret'] == 'fixture-secret', 'Lege velden gebruiken de omgeving; gevulde velden winnen') check(__import__('re').fullmatch(r'[a-f0-9]{64}', loaded_config['key_secret']) is not None, 'key_secret blijft de gegenereerde serverwaarde') 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') forbidden = reader.request('POST', '/days', {'date': '2026-05-01', 'title': 'Verboden', 'stories': stories()}, expected=403) check('API-sleutel of als beheerder' in forbidden['how_to_authenticate'] and 'docs.php' in forbidden['hint'] and 'www-authenticate' not in reader.last_headers, '403 voor een lezer legt de sleutel uit, zonder WWW-Authenticate') keys_forbidden = reader.request('GET', '/keys', expected=403) check('ingelogde beheerder' in keys_forbidden['how_to_authenticate'] and 'docs.php' in keys_forbidden['hint'], 'Sleutels bekijken mag alleen de beheerder') reader.request('POST', '/keys', {'name': 'nee'}, expected=403) old = admin.csrf admin.csrf = 'fout' csrf_denied = admin.request('POST', '/keys', {'name': 'nee'}, expected=403) check('how_to_authenticate' not in csrf_denied and csrf_denied['error'] == 'Ongeldige sessie. Laad de pagina opnieuw.', 'Een CSRF-fout blijft een kale 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') 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') revealed = admin.request('GET', '/keys/' + str(created['id']))['key'] check(revealed['token'] == token and 'token_cipher' not in revealed, 'De beheerder kan de volledige sleutel opnieuw opvragen') reader.request('GET', '/keys/' + str(created['id']), expected=403) with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db: stored_hash, stored_cipher = db.execute('SELECT token_hash, token_cipher FROM api_keys WHERE id=?', (created['id'],)).fetchone() check(stored_hash != token and len(stored_hash) == 64 and token not in stored_cipher and stored_cipher != '', 'De database bewaart een hash en cijfertekst, geen platte sleutel') 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_keys = bearer.request('GET', '/keys', expected=403) check('ingelogde beheerder' in bearer_keys['how_to_authenticate'] and token not in json.dumps(bearer_keys), 'Een sleutel mag andere sleutels niet uitlezen') 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 and 'token' not in revoked, 'Sleutel intrekken toont het geheim niet') still = admin.request('GET', '/keys/' + str(created['id']))['key'] check(still['token'] == token and still['revoked'] is not None, 'Een ingetrokken sleutel blijft zichtbaar voor de beheerder') rejected = bearer.request('GET', '/days/latest', expected=401) check(rejected['error'] == 'Deze API-sleutel is ingetrokken.' and 'onbekend of ingetrokken' in rejected['how_to_authenticate'] and bearer.last_headers.get('www-authenticate') == 'Bearer', 'Ingetrokken sleutel krijgt 401 met uitleg') 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 and 'how_to_authenticate' in body and 'WWW-Authenticate' in body, 'API-documentatie legt authenticatie uit') 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()