BlueGit

projects-timfalken-com verhalenboek

Files

verhalenboek / web / tests / integration.py

integration.py

fix: accept PATCH as a partial update for wiki pages and categories
timfa project_87242033_bot_b167a9be22027ad5a4b431d0ad8426c6 · pushed by timfa · 5 weeks ago
f9b146ac History
integration.py 40.7 KiB Download Raw
1#!/usr/bin/env python3
2"""Geïsoleerde API-tests. De echte database van de applicatie blijft onaangeroerd."""
3import json
4import os
5import signal
6import http.cookiejar
7import shutil
8import socket
9import sqlite3
10import subprocess
11import tempfile
12import time
13import urllib.error
14import urllib.request
15from pathlib import Path
16
17WEB = Path(__file__).resolve().parents[1]
18ARTIFACTS = WEB / 'tests/artifacts'
19ARTIFACTS.mkdir(exist_ok=True)
20checks = 0
21
22def check(value, label):
23 global checks
24 checks += 1
25 assert value, label
26
27def stories(prefix='Verhaal'):
28 return [
29 {'title': f'{prefix} een', 'paragraphs': ['Eerste alinea.', 'Tweede alinea met één accent.']},
30 {'title': f'{prefix} twee', 'paragraphs': ['Midden.']},
31 {'title': f'{prefix} drie', 'paragraphs': ['Slot.']},
32 ]
33
34with tempfile.TemporaryDirectory(prefix='api-', dir=ARTIFACTS) as tmp:
35 root = Path(tmp)
36 for name in ['api.php', 'index.php', 'auth.php', 'callback.php', 'router.php', 'docs.php']:
37 shutil.copy(WEB / name, root / name)
38 shutil.copytree(WEB / 'lib', root / 'lib')
39 (root / 'assets').mkdir()
40 shutil.copy(WEB / 'assets/favicon.svg', root / 'assets/favicon.svg')
41 (root / 'data').mkdir()
42 with socket.socket() as sock:
43 sock.bind(('127.0.0.1', 0))
44 port = sock.getsockname()[1]
45 base = f'http://127.0.0.1:{port}'
46 log_path = root / 'server.log'
47 log = log_path.open('w')
48 process = subprocess.Popen(
49 ['php', '-d', 'opcache.enable=0', '-S', f'127.0.0.1:{port}', '-t', str(root), str(root / 'router.php')],
50 stdout=log, stderr=log, start_new_session=True,
51 )
52
53 class Client:
54 def __init__(self, token=None):
55 self.token = token
56 self.opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(http.cookiejar.CookieJar()))
57 self.csrf = None
58
59 def request(self, method, path, body=None, expected=200, csrf=True, extra_headers=None):
60 headers = {'Accept': 'application/json'}
61 data = None
62 if body is not None:
63 data = json.dumps(body).encode()
64 headers['Content-Type'] = 'application/json'
65 if self.token:
66 headers['Authorization'] = 'Bearer ' + self.token
67 elif method not in ('GET', 'HEAD') and csrf:
68 headers['X-CSRF-Token'] = self.csrf or ''
69 if extra_headers:
70 headers.update(extra_headers)
71 req = urllib.request.Request(base + '/api.php' + path, data=data, headers=headers, method=method)
72 try:
73 response = self.opener.open(req)
74 except urllib.error.HTTPError as error:
75 response = error
76 with response:
77 raw = response.read().decode()
78 payload = json.loads(raw)
79 self.last_headers = {key.lower(): value for key, value in response.headers.items()}
80 check(response.status == expected, f'{method} {path}: verwacht {expected}, kreeg {response.status} {payload}')
81 return payload
82
83 def me(self):
84 data = self.request('GET', '/me')
85 self.csrf = data['csrf']
86 return data
87
88 try:
89 for _ in range(100):
90 try:
91 urllib.request.urlopen(base + '/index.php').close()
92 break
93 except urllib.error.URLError:
94 time.sleep(0.05)
95 else:
96 raise RuntimeError(log_path.read_text()[-2000:])
97
98 config_path = root / 'data/config.php'
99 check(config_path.is_file(), 'Eerste pagina maakt config.php')
100 generated = config_path.read_text()
101 check(all(f"'{key}' => ''" in generated for key in ['base_url', 'client_id', 'client_secret']), 'Gegenereerde configvelden zijn leeg')
102 configured = generated.replace("'client_id' => ''", "'client_id' => 'fixture-client'") + '\n// Bewaar deze servercommentaar.\n'
103 config_path.write_text(configured)
104
105 anonymous = Client()
106 missing = anonymous.request('GET', '/me', expected=401, extra_headers={'Host': 'verhalenboek.test'})
107 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')
108 check(anonymous.last_headers.get('www-authenticate') == 'Bearer', '401 stuurt WWW-Authenticate: Bearer')
109 malformed = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Basic abc', 'Host': 'verhalenboek.test'})
110 check('verkeerde formaat' in malformed['how_to_authenticate'] and 'docs.php' in malformed['hint'], 'Verkeerde Authorization-vorm krijgt een eigen uitleg')
111 short = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Bearer vb_kort', 'Host': 'verhalenboek.test'})
112 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')
113 unknown = anonymous.request('GET', '/days/latest', expected=401, extra_headers={'Authorization': 'Bearer vb_' + 'ab' * 32})
114 check(unknown['error'] == 'Deze API-sleutel is onbekend.' and 'onbekend of ingetrokken' in unknown['how_to_authenticate'], 'Onbekende sleutel krijgt de afwijs-uitleg')
115
116 admin = Client()
117 me = admin.me()
118 check(me['user']['name'] == 'test_user_1' and me['user']['admin'] is True and me['local'] is True, 'Eerste lokale gebruiker is beheerder')
119 check('email' not in me['user'], 'Profiel bevat geen e-mail')
120 check(config_path.read_text() == configured, 'Bestaande configuratie blijft byte voor byte staan')
121 loaded = subprocess.check_output(
122 ['php', '-r', 'require $argv[1]; echo json_encode(config());', str(root / 'lib/bootstrap.php')],
123 env={**os.environ, 'VERHALENBOEK_BASE_URL': 'https://example.test', 'VERHALENBOEK_CLIENT_ID': 'environment-client', 'VERHALENBOEK_CLIENT_SECRET': 'fixture-secret'},
124 text=True,
125 )
126 loaded_config = json.loads(loaded)
127 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')
128 check(__import__('re').fullmatch(r'[a-f0-9]{64}', loaded_config['key_secret']) is not None, 'key_secret blijft de gegenereerde serverwaarde')
129
130 reader = Client()
131 reader.me()
132 switched = reader.request('POST', '/session/switch', {'user': 'test_user_2'})
133 reader.csrf = switched['csrf']
134 check(reader.me()['user']['name'] == 'test_user_2' and reader.me()['user']['admin'] is False, 'Tweede gebruiker is alleen lezer')
135 check(admin.me()['user']['name'] == 'test_user_1', 'Sessies blijven onafhankelijk')
136
137 from urllib.parse import quote
138 roster = admin.request('GET', '/users')['users']
139 check(any(user['id'] == 'local:test_user_1' and user['name'] == 'test_user_1' and user['admin'] is True for user in roster), 'De beheerder ziet zichzelf')
140 check(any(user['id'] == 'local:test_user_2' and user['admin'] is False and 'email' not in user and 'theme' not in user for user in roster), 'De beheerder ziet de lezer, zonder privéinstellingen')
141 reader_users = reader.request('GET', '/users', expected=403)
142 check('Gebruikers beheren' in reader_users['how_to_authenticate'] and 'docs.php' in reader_users['hint'], 'Een lezer ziet de gebruikerslijst niet')
143 reader.request('PUT', '/users/' + quote('local:test_user_1', safe=''), {'admin': False}, expected=403)
144 promoted = admin.request('PUT', '/users/' + quote('local:test_user_2', safe=''), {'admin': True})['user']
145 check(promoted['admin'] is True and promoted['id'] == 'local:test_user_2', 'Een lezer wordt beheerder')
146 check(reader.me()['user']['admin'] is True, 'De gepromoveerde sessie is meteen beheerder')
147 self_denied = admin.request('PUT', '/users/' + quote('local:test_user_1', safe=''), {'admin': False}, expected=403)
148 check('eigen' in self_denied['error'] and admin.me()['user']['admin'] is True, 'Een beheerder kan zichzelf niet degraderen')
149 admin.request('PUT', '/users/' + quote('local:test_user_1', safe=''), {'admin': 'ja'}, expected=422)
150 admin.request('PUT', '/users/' + quote('auth:99', safe=''), {'admin': True}, expected=404)
151 demoted = admin.request('PUT', '/users/' + quote('local:test_user_2', safe=''), {'admin': False})['user']
152 check(demoted['admin'] is False and reader.me()['user']['admin'] is False, 'Een andere beheerder wordt weer lezer')
153
154 forbidden = reader.request('POST', '/days', {'date': '2026-05-01', 'title': 'Verboden', 'stories': stories()}, expected=403)
155 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')
156 keys_forbidden = reader.request('GET', '/keys', expected=403)
157 check('ingelogde beheerder' in keys_forbidden['how_to_authenticate'] and 'docs.php' in keys_forbidden['hint'], 'Sleutels bekijken mag alleen de beheerder')
158 reader.request('POST', '/keys', {'name': 'nee'}, expected=403)
159 old = admin.csrf
160 admin.csrf = 'fout'
161 csrf_denied = admin.request('POST', '/keys', {'name': 'nee'}, expected=403)
162 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')
163 admin.csrf = old
164
165 created = admin.request('POST', '/keys', {'name': 'Schrijver'}, expected=201)['key']
166 token = created['token']
167 check(token.startswith('vb_') and created['prefix'] == token[:11], 'Nieuwe sleutel toont het geheim')
168 listed = admin.request('GET', '/keys')['keys']
169 check(token not in json.dumps(listed) and listed[0]['prefix'] == created['prefix'] and 'token' not in listed[0], 'De lijst verbergt het geheim')
170 revealed = admin.request('GET', '/keys/' + str(created['id']))['key']
171 check(revealed['token'] == token and 'token_cipher' not in revealed, 'De beheerder kan de volledige sleutel opnieuw opvragen')
172 reader.request('GET', '/keys/' + str(created['id']), expected=403)
173 with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db:
174 stored_hash, stored_cipher = db.execute('SELECT token_hash, token_cipher FROM api_keys WHERE id=?', (created['id'],)).fetchone()
175 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')
176
177 bearer = Client(token)
178 check(bearer.request('GET', '/days/latest', expected=404)['error'], 'Nog geen laatste datum')
179 check(bearer.request('GET', '/days/gaps') == {'first': None, 'latest': None, 'missing': [], 'incomplete': []}, 'Lege gaten')
180 bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': stories()[:2]}, expected=422)
181 bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': stories() + [{'title': 'Extra', 'paragraphs': ['Te veel']}]}, expected=422)
182 bearer.request('POST', '/days', {'date': '2026-02-31', 'title': 'Nee', 'stories': stories()}, expected=422)
183 bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Mei', 'stories': [
184 {'title': 'Een', 'paragraphs': ['']},
185 {'title': 'Twee', 'paragraphs': ['Oké']},
186 {'title': 'Drie', 'paragraphs': ['Oké']},
187 ]}, expected=422)
188 first = bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'De eerste bladzijde', 'stories': stories('Eerste')}, expected=201)
189 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')
190 check(first['stories'][0]['paragraphs'][1] == 'Tweede alinea met één accent.', 'Unicode blijft intact')
191 bearer.request('POST', '/days', {'date': '2026-05-01', 'title': 'Dubbel', 'stories': stories()}, expected=409)
192 bearer.request('POST', '/days', {'date': '2026-05-02', 'title': 'De regen op het dak', 'stories': stories('Regen')}, expected=201)
193 bearer.request('POST', '/days', {'date': '2026-05-04', 'title': 'Het licht in de keuken', 'stories': stories('Licht')}, expected=201)
194 check(bearer.request('GET', '/days/latest')['date'] == '2026-05-04', 'Laatste geschreven datum')
195 gaps = bearer.request('GET', '/days/gaps')
196 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')
197
198 middle = bearer.request('GET', '/days/2026-05-02')
199 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')
200 kept = bearer.request('PUT', '/days/2026-05-02/stories/2', {'title': 'Nieuwe middag'})
201 check(kept['stories'][1]['title'] == 'Nieuwe middag' and kept['stories'][1]['paragraphs'] == ['Midden.'], 'Verhaal bewerken bewaart de alinea\'s')
202 broken = bearer.request('DELETE', '/days/2026-05-04/stories/2')
203 check(broken['complete'] is False and [s['position'] for s in broken['stories']] == [1, 3], 'Verwijderd verhaal laat een gat in de plekken')
204 latest = bearer.request('GET', '/days/latest')
205 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')
206 gaps = bearer.request('GET', '/days/gaps')
207 check(gaps['missing'] == ['2026-05-03'], 'Een onvolledige dag staat niet bij de ontbrekende datums')
208 incomplete = gaps['incomplete']
209 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')
210 repaired = bearer.request('POST', '/days/2026-05-04/stories', {'title': 'Terug', 'paragraphs': ['Weer drie.']}, expected=201)
211 check(repaired['complete'] is True and repaired['stories'][1]['position'] == 2, 'Het ontbrekende verhaal vult plek 2')
212 bearer.request('POST', '/days/2026-05-04/stories', {'title': 'Vier', 'paragraphs': ['Nee']}, expected=422)
213 bearer.request('DELETE', '/days/2026-05-02')
214 check(bearer.request('GET', '/days/latest')['date'] == '2026-05-04', 'Verwijderen van een middendag laat de laatste datum staan')
215 check('2026-05-02' in bearer.request('GET', '/days/gaps')['missing'], 'Een verwijderde dag wordt een gat')
216 bearer.request('POST', '/days/2026-05-02/read', expected=403)
217 bearer_keys = bearer.request('GET', '/keys', expected=403)
218 check('ingelogde beheerder' in bearer_keys['how_to_authenticate'] and token not in json.dumps(bearer_keys), 'Een sleutel mag andere sleutels niet uitlezen')
219 bearer_users = bearer.request('PUT', '/users/' + quote('local:test_user_2', safe=''), {'admin': True}, expected=403)
220 check('Gebruikers beheren' in bearer_users['how_to_authenticate'] and reader.me()['user']['admin'] is False, 'Een API-sleutel kan niemand beheerder maken')
221 bearer.request('DELETE', '/days/2099-01-01', expected=404)
222
223 check(reader.request('GET', '/days/2026-05-01')['read'] is False, 'Openen via GET markeert de dag nog niet')
224 check(reader.request('POST', '/days/2026-05-01/read')['read'] is True, 'De lezer markeert de dag als gelezen')
225 check(reader.request('POST', '/days/2026-05-01/read')['read'] is True, 'Opnieuw gelezen blijft gelezen')
226 reader_overview = reader.request('GET', '/days?today=2030-01-01')
227 reader_days = reader_overview['days']
228 admin_overview = admin.request('GET', '/days?today=2030-01-01')
229 admin_days = admin_overview['days']
230 check(next(day for day in reader_days if day['date'] == '2026-05-01')['read'] is True, 'Overzicht van de lezer toont gelezen')
231 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')
232 check(reader_overview['lastRead'] == '2026-05-01' and admin_overview['lastRead'] is None, 'lastRead hoort bij de lezer die de dag opende')
233 friend_dots = admin.request('GET', '/friend-reads')['days']
234 check(friend_dots.get('2026-05-01') == [{'id': 'local:test_user_2', 'name': 'test_user_2', 'avatar_url': None}], 'Het vriendrondje toont de andere lokale lezer op de gelezen dag')
235 check('2026-05-04' not in friend_dots, 'Een dag die de vriend niet las krijgt geen rondje')
236 check(reader.request('GET', '/friend-reads')['days'] == {}, 'Zonder leesrecord van de ander blijft de rij leeg')
237 bearer.request('GET', '/friend-reads', expected=403)
238 reader.request('POST', '/friend-reads', {}, expected=405)
239 check(reader_overview['week']['start'] == '2026-05-04' and reader_overview['week']['end'] == '2026-05-10' and reader_overview['week']['label'] == '4–10 mei 2026', 'Standaardweek is de week van de vroegste ongelezen dag')
240 check(reader_overview['week']['hasPrevious'] is True and reader_overview['week']['hasNext'] is False and reader_overview['week']['previous'] == '2026-04-27', 'De week van de ongelezen dag houdt vorige week als die een dagrecord heeft')
241 check([day['date'] for day in reader_overview['weekDays']] == ['2026-05-04'], 'De zichtbare week laat dagen buiten maandag–zondag weg')
242 check([day['date'] for day in reader_overview['days']] == ['2026-05-01', '2026-05-04'], 'De volledige lijst blijft naast de week staan')
243 chosen = reader.request('GET', '/days?week=2026-05-06')
244 check(chosen['week']['start'] == '2026-05-04' and chosen['week']['previous'] == '2026-04-27' and chosen['week']['next'] == '2026-05-11' and chosen['week']['hasPrevious'] is True and chosen['week']['hasNext'] is False, 'Een gekozen datum normaliseert naar maandag en kent vorige en volgende week')
245 check([day['date'] for day in chosen['weekDays']] == ['2026-05-04'] and chosen['week']['label'] == '4–10 mei 2026', 'Volgende week toont alleen haar eigen dagen')
246 earlier = reader.request('GET', '/days?week=' + chosen['week']['previous'])
247 check(earlier['week']['start'] == '2026-04-27' and earlier['week']['hasPrevious'] is False and earlier['week']['hasNext'] is True and [day['date'] for day in earlier['weekDays']] == ['2026-05-01'], 'Vorige week keert terug naar de eerste week en verbergt de knop ervoor')
248 check(reader.request('GET', '/days?week=2026-10-07')['week']['label'] == '5–11 oktober 2026', 'Lege gekozen week houdt het label')
249 check(reader.request('GET', '/days?week=2026-01-01')['week'] == {
250 'start': '2025-12-29', 'end': '2026-01-04', 'previous': '2025-12-22', 'next': '2026-01-05',
251 'label': '29 december 2025 – 4 januari 2026',
252 'hasPrevious': False, 'hasNext': False,
253 }, 'Week over de jaargrens')
254 reader.request('GET', '/days?week=2026-02-31', expected=422)
255 check(admin_overview['week']['start'] == '2026-04-27', 'Zonder leesgeschiedenis opent de week van de vroegste ongelezen dag, niet today en niet de nieuwste dag')
256 reader.request('POST', '/days/2026-05-04/read')
257 all_read = reader.request('GET', '/days?today=2030-01-01')
258 check(all_read['lastRead'] == '2026-05-04' and all_read['week']['start'] == '2026-05-04', 'Zijn alle dagen gelezen, dan geldt de laatst gelezen dag')
259 check(reader.request('GET', '/days?week=2026-05-01')['week']['start'] == '2026-04-27', 'Een gekozen week blijft gelden als alles gelezen is')
260 reader.request('DELETE', '/days/2026-05-04/read')
261 check(reader.request('DELETE', '/days/2026-05-01/read')['read'] is False, 'Handmatig ongelezen')
262 check('2026-05-01' not in admin.request('GET', '/friend-reads')['days'], 'Ongelezen haalt het vriendrondje weg')
263 after_unread = reader.request('GET', '/days?today=2030-01-01')
264 check(after_unread['lastRead'] is None and after_unread['week']['start'] == '2026-04-27', 'Na het wissen van de leeshandeling geldt de vroegste ongelezen dag')
265 bearer.request('POST', '/days', {'date': '2026-06-01', 'title': 'Voor het gat', 'stories': stories('Juni')}, expected=201)
266 bearer.request('POST', '/days', {'date': '2026-06-15', 'title': 'Losse week', 'stories': stories('Los')}, expected=201)
267 bearer.request('POST', '/days', {'date': '2026-07-06', 'title': 'Na het gat', 'stories': stories('Juli')}, expected=201)
268 before_gap = reader.request('GET', '/days?week=2026-06-01')
269 isolated = reader.request('GET', '/days?week=2026-06-15')
270 after_gap = reader.request('GET', '/days?week=2026-07-06')
271 check(before_gap['week']['hasNext'] is False and before_gap['week']['next'] == '2026-06-08', 'Een gat verbergt volgende week, ook als later nog dagen zijn')
272 check(isolated['week']['start'] == '2026-06-15' and isolated['week']['hasPrevious'] is False and isolated['week']['hasNext'] is False, 'Een losse week tussen gaten verbergt beide knoppen')
273 check(after_gap['week']['hasPrevious'] is False and after_gap['week']['hasNext'] is False and after_gap['week']['previous'] == '2026-06-29', 'De laatste week na een gat verbergt vorige en volgende week')
274 bare = bearer.request('POST', '/days', {'date': '2026-06-08', 'title': 'Alleen het record', 'stories': stories('Kaal')}, expected=201)
275 for position in (1, 2, 3):
276 bearer.request('DELETE', '/days/2026-06-08/stories/' + str(position))
277 check(bare['storyCount'] == 3 and reader.request('GET', '/days/2026-06-08')['storyCount'] == 0 and reader.request('GET', '/days?week=2026-06-01')['week']['hasNext'] is True, 'Een dagrecord zonder verhalen vult de volgende week')
278 reader.request('DELETE', '/days/2026-05-04', expected=403)
279 reader.request('PUT', '/me/settings', {'theme': 'dark', 'font': 'rounded'})
280 check(reader.me()['user']['theme'] == 'dark' and reader.me()['user']['font'] == 'rounded', 'Instellingen blijven bewaard')
281 check(admin.me()['user']['theme'] == 'system' and admin.me()['user']['font'] == 'serif', 'Instellingen zijn per gebruiker')
282 reader.request('PUT', '/me/settings', {'theme': 'blauw', 'font': 'serif'}, expected=422)
283 export = reader.request('GET', '/me/export')
284 check(export['profile']['name'] == 'test_user_2' and 'email' not in export['profile'] and export['api_keys'] == [], 'Export bevat alleen de eigen gegevens')
285 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')
286 check(export['reads'] == [], 'Na ongelezen zit de dag niet meer in de export')
287
288 def page_html(client):
289 response = client.opener.open(base + '/')
290 try:
291 body = response.read().decode()
292 check(response.status == 200, 'Startpagina')
293 return body
294 finally:
295 response.close()
296
297 empty_reader = page_html(reader)
298 empty_admin = page_html(admin)
299 check('data-nav="/wiki"' not in empty_reader and 'Instellingen' in empty_reader, 'Een lezer ziet geen wiki-tabblad zolang er geen pagina is')
300 check(empty_admin.index('>Overzicht<') < empty_admin.index('>Wiki<') < empty_admin.index('>Instellingen<'), 'Een beheerder ziet de wiki ook als die leeg is')
301 check('data-nav="/beheer"' in empty_admin and 'data-nav="/sleutels"' not in empty_admin and '>Sleutels<' not in empty_admin, 'Sleutels is geen apart tabblad meer')
302 check(reader.me()['wiki'] is False and admin.me()['wiki'] is True, 'GET /me zegt of deze gebruiker de wiki ziet')
303 check(reader.request('GET', '/wiki/categories') == {'categories': []}, 'Een lezer mag de wiki lezen')
304 reader_wiki = reader.request('POST', '/wiki/categories', {'title': 'Verboden'}, expected=403)
305 check('API-sleutel of als beheerder' in reader_wiki['how_to_authenticate'] and 'www-authenticate' not in reader.last_headers, 'Een lezer mag de wiki niet schrijven')
306 reader.request('DELETE', '/wiki/pages/bas', expected=403)
307 plekken = bearer.request('POST', '/wiki/categories', {'title': 'Plekken'}, expected=201)
308 check(plekken['slug'] == 'plekken' and plekken['pages'] == [], 'Een sleutel maakt een categorie')
309 bearer.request('POST', '/wiki/categories', {'title': 'Plekken'}, expected=409)
310 bearer.request('POST', '/wiki/categories', {'title': 'Nieuw'}, expected=422)
311 vriendjes = admin.request('POST', '/wiki/categories', {'title': 'Vriendjes'}, expected=201)
312 check(vriendjes['slug'] == 'vriendjes', 'Een beheerder maakt een categorie in de sessie')
313 speeltjes = bearer.request('POST', '/wiki/categories', {'title': 'Speeltjes'}, expected=201)
314 check([item['slug'] for item in bearer.request('GET', '/wiki/categories')['categories']] == ['plekken', 'vriendjes', 'speeltjes'], 'Categorieën komen op volgorde terug')
315 check('data-nav="/wiki"' not in page_html(reader) and reader.me()['wiki'] is False, 'Alleen categorieën maken de wiki nog niet zichtbaar voor een lezer')
316 plein = bearer.request('POST', '/wiki/pages', {
317 'title': 'Het oude plein',
318 'slug': 'oude-plein',
319 'category': 'plekken',
320 'content': 'Achter de huizen.\n\n## De boom\n\nEen boom.\n\n## De bank\n\nZie [[#de-boom]].',
321 }, expected=201)
322 check([chapter['anchor'] for chapter in plein['chapters']] == ['inleiding', 'de-boom', 'de-bank'], 'De pagina antwoordt met hoofdstukken en ankers')
323 shown_reader = page_html(reader)
324 check('data-nav="/wiki"' in shown_reader and shown_reader.index('>Overzicht<') < shown_reader.index('>Wiki<') < shown_reader.index('>Instellingen<'), 'Een lezer ziet de wiki zodra er een pagina is')
325 check(reader.me()['wiki'] is True, 'GET /me toont de wiki aan de lezer')
326 check(plein['chapters'][2]['blocks'][0]['inlines'][1]['anchor'] == 'de-boom' and plein['chapters'][2]['blocks'][0]['inlines'][1]['broken'] is False, 'Hoofdstuk op dezelfde pagina')
327 kist = bearer.request('POST', '/wiki/pages', {
328 'title': 'Speelgoedkist',
329 'slug': 'speelgoedkist',
330 'category': 'speeltjes',
331 'content': '## Deksel\n\nDe deksel. [[bas#wie-hij-is|Bas]] [[geen-pagina]] <script>alert(1)</script>',
332 }, expected=201)
333 kist_parts = kist['chapters'][0]['blocks'][0]['inlines']
334 kist_links = [part for part in kist_parts if part['type'] == 'link']
335 check(kist_links[0]['text'] == 'Bas' and kist_links[0]['broken'] is True and kist_links[1]['text'] == 'geen-pagina' and kist_links[1]['broken'] is True and kist_links[1]['page'] is None, 'Kapotte verwijzingen blijven in het antwoord')
336 check(any(part['type'] == 'text' and '<script>alert(1)</script>' in part['text'] for part in kist_parts), 'HTML in de wiki blijft tekst')
337 bas = bearer.request('POST', '/wiki/pages', {
338 'title': 'Bas',
339 'category': 'vriendjes',
340 'content': '## Wie hij is\n\nBas speelt op het [[oude-plein|oude plein]] en bij de [[speelgoedkist#deksel|kist]].\n\n## Samen\n\nKlaar.',
341 }, expected=201)
342 check(bas['slug'] == 'bas', 'Slug uit de titel')
343 links = [part for block in bas['chapters'][0]['blocks'] for part in block['inlines'] if part['type'] == 'link']
344 check(links[0]['page'] == 'oude-plein' and links[0]['anchor'] is None and links[0]['text'] == 'oude plein' and links[0]['broken'] is False, 'Link naar een andere pagina')
345 check(links[1]['page'] == 'speelgoedkist' and links[1]['anchor'] == 'deksel' and links[1]['broken'] is False, 'Link naar een hoofdstuk op een andere pagina')
346 opmaak = bearer.request('POST', '/wiki/pages', {
347 'title': 'Opmaak',
348 'slug': 'opmaak',
349 'category': 'plekken',
350 'content': 'Inleiding.\n\n## Lijst\n\n- **vet** en [[oude-plein|plein]]\n - *cursief*\n\nZie [site](https://example.com).\n\nNiet [x](javascript:alert(1)).',
351 }, expected=201)
352 check([chapter['anchor'] for chapter in opmaak['chapters']] == ['inleiding', 'lijst'], 'Markdown laat de hoofdstukken staan')
353 md_list = opmaak['chapters'][1]['blocks'][0]
354 check(md_list['type'] == 'list' and md_list['ordered'] is False and len(md_list['items']) == 1, 'Markdownlijst via de API')
355 first = md_list['items'][0]['blocks'][0]['inlines']
356 check(first[0]['type'] == 'strong' and first[0]['inlines'][0]['text'] == 'vet', 'Vet in een lijstpunt')
357 check(first[2]['type'] == 'link' and first[2]['page'] == 'oude-plein' and first[2]['broken'] is False and first[2]['text'] == 'plein', 'Verwijzing in een lijstpunt')
358 nested = md_list['items'][0]['blocks'][1]
359 check(nested['type'] == 'list' and nested['items'][0]['blocks'][0]['inlines'][0]['type'] == 'em', 'Geneste cursieve lijst')
360 site = opmaak['chapters'][1]['blocks'][1]['inlines'][1]
361 check(site['type'] == 'url' and site['href'] == 'https://example.com' and site['inlines'][0]['text'] == 'site', 'Externe link')
362 unsafe = opmaak['chapters'][1]['blocks'][2]['inlines'][0]['text']
363 check('javascript:alert(1)' in unsafe and all(part['type'] != 'url' for part in opmaak['chapters'][1]['blocks'][2]['inlines']), 'Een javascript-url wordt geen link')
364 check(bearer.request('GET', '/wiki/pages/bas')['title'] == 'Bas', 'Een pagina ophalen op slug')
365 found = bearer.request('GET', '/wiki/pages?q=deksel&category=speeltjes')['pages']
366 check([page['slug'] for page in found] == ['speelgoedkist'] and 'content' not in found[0], 'Zoeken in de tekst, gefilterd op categorie, zonder de lopende tekst')
367 check([page['slug'] for page in bearer.request('GET', '/wiki/pages?q=BANK')['pages']] == ['oude-plein'], 'Zoeken negeert hoofdletters')
368 bearer.request('GET', '/wiki/pages?category=onbekend', expected=404)
369 bearer.request('POST', '/wiki/pages', {'title': 'Nee', 'category': 'vriendjes', 'content': '##\n\nLeeg'}, expected=422)
370 before_patch = bearer.request('GET', '/wiki/pages/bas')
371 patched = bearer.request('PATCH', '/wiki/pages/bas', {'title': 'Bas de patch'})
372 check(
373 patched['title'] == 'Bas de patch'
374 and patched['slug'] == before_patch['slug']
375 and patched['content'] == before_patch['content']
376 and patched['category'] == before_patch['category']
377 and patched['position'] == before_patch['position'],
378 'PATCH op een pagina wijzigt alleen de titel',
379 )
380 longer = before_patch['content'] + '\n\n## Extra\n\nNog een zin.'
381 text_only = bearer.request('PATCH', '/wiki/pages/bas', {'content': longer})
382 check(
383 text_only['title'] == 'Bas de patch'
384 and text_only['content'] == longer
385 and text_only['slug'] == 'bas'
386 and text_only['category']['slug'] == 'vriendjes'
387 and any(chapter['anchor'] == 'extra' for chapter in text_only['chapters']),
388 'PATCH op de tekst laat titel, slug en categorie staan',
389 )
390 moved_page = bearer.request('PATCH', '/wiki/pages/opmaak', {'category': 'speeltjes'})
391 check(moved_page['category']['slug'] == 'speeltjes' and moved_page['title'] == 'Opmaak' and moved_page['slug'] == 'opmaak', 'PATCH verhuist alleen de categorie')
392 bearer.request('PATCH', '/wiki/pages/opmaak', {'category': 'plekken'})
393 renamed_page = bearer.request('PATCH', '/wiki/pages/opmaak', {'slug': 'opmaak-twee'})
394 check(renamed_page['slug'] == 'opmaak-twee' and renamed_page['title'] == 'Opmaak' and renamed_page['category']['slug'] == 'plekken', 'PATCH wijzigt alleen de slug')
395 bearer.request('PATCH', '/wiki/pages/opmaak-twee', {'slug': 'opmaak'})
396 restored = bearer.request('PATCH', '/wiki/pages/bas', {'title': before_patch['title'], 'content': before_patch['content']})
397 check(
398 restored['title'] == before_patch['title']
399 and restored['content'] == before_patch['content']
400 and [chapter['anchor'] for chapter in restored['chapters']] == [chapter['anchor'] for chapter in before_patch['chapters']],
401 'PATCH zet titel en tekst terug zonder de rest te raken',
402 )
403 bearer.request('PATCH', '/wiki/pages/bas', {}, expected=422)
404 bearer.request('PATCH', '/wiki/pages/bas', {'nope': True}, expected=422)
405 bearer.request('PATCH', '/wiki/pages/geen-pagina', {'title': 'Nee'}, expected=404)
406 reader.request('PATCH', '/wiki/pages/bas', {'title': 'Nee'}, expected=403)
407 cat_before = bearer.request('GET', '/wiki/categories/plekken')
408 cat_patched = bearer.request('PATCH', '/wiki/categories/plekken', {'title': 'Plekken en paden'})
409 check(
410 cat_patched['title'] == 'Plekken en paden'
411 and cat_patched['slug'] == 'plekken'
412 and cat_patched['position'] == cat_before['position']
413 and [page['slug'] for page in cat_patched['pages']] == [page['slug'] for page in cat_before['pages']],
414 'PATCH op een categorie wijzigt alleen de titel',
415 )
416 cat_moved = bearer.request('PATCH', '/wiki/categories/speeltjes', {'position': 1})
417 check(cat_moved['position'] == 1 and cat_moved['slug'] == 'speeltjes' and cat_moved['title'] == 'Speeltjes', 'PATCH op een categorie wijzigt alleen de positie')
418 bearer.request('PATCH', '/wiki/categories/plekken', {'title': cat_before['title']})
419 bearer.request('PATCH', '/wiki/categories/plekken', {}, expected=422)
420 bearer.request('PATCH', '/wiki/categories/onbekend', {'title': 'Nee'}, expected=404)
421 reader.request('PATCH', '/wiki/categories/plekken', {'title': 'Nee'}, expected=403)
422 bearer.request('PATCH', '/days/2026-05-01', {'title': 'Nee'}, expected=405)
423 bearer.request('PATCH', '/days/2026-05-01/stories/1', {'title': 'Nee'}, expected=405)
424 bearer.request('PATCH', '/wiki/pages', {'title': 'Nee'}, expected=405)
425 bearer.request('PATCH', '/wiki/categories', {'title': 'Nee'}, expected=405)
426 bearer.request('PATCH', '/me/settings', {'theme': 'dark'}, expected=405)
427 edited = admin.request('PUT', '/wiki/pages/bas', {'title': 'Bas de vriend'})
428 check(edited['title'] == 'Bas de vriend' and edited['slug'] == 'bas' and edited['content'] == before_patch['content'], 'Een beheerder bewerkt een pagina; PUT laat de tekst staan')
429 reader.request('PUT', '/wiki/pages/bas', {'title': 'Nee'}, expected=403)
430 bearer.request('DELETE', '/wiki/categories/vriendjes', expected=409)
431 check(bearer.request('DELETE', '/wiki/pages/bas') == {'ok': True, 'slug': 'bas'}, 'Pagina verwijderen')
432 check(bearer.request('DELETE', '/wiki/pages/opmaak') == {'ok': True, 'slug': 'opmaak'}, 'Opmaakpagina verwijderen')
433 check(bearer.request('DELETE', '/wiki/categories/vriendjes') == {'ok': True, 'slug': 'vriendjes'}, 'Lege categorie verwijderen')
434 bearer.request('GET', '/wiki/pages/bas', expected=404)
435 bearer.request('PUT', '/wiki/categories', {'title': 'Nee'}, expected=405)
436 bearer.request('DELETE', '/wiki/pages/oude-plein')
437 bearer.request('DELETE', '/wiki/pages/speelgoedkist')
438 bearer.request('DELETE', '/wiki/categories/plekken')
439 bearer.request('DELETE', '/wiki/categories/speeltjes')
440 check(reader.request('GET', '/wiki/categories') == {'categories': []}, 'De wiki is weer leeg')
441 hidden_again = page_html(reader)
442 check('data-nav="/wiki"' not in hidden_again and reader.me()['wiki'] is False and admin.me()['wiki'] is True, 'Zonder pagina\'s verdwijnt het tabblad voor de lezer en blijft het voor de beheerder')
443
444 admin.request('PUT', '/days/2026-05-01', {'title': 'Herziene titel'})
445 check(admin.request('GET', '/days/2026-05-01')['title'] == 'Herziene titel', 'Beheerder bewerkt een dag in de sessie')
446 admin.request('PUT', '/days/2026-05-01', {'stories': stories()[:1]}, expected=422)
447 revoked = admin.request('DELETE', '/keys/' + str(created['id']))['key']
448 check(revoked['revoked'] is not None and 'token' not in revoked, 'Sleutel intrekken toont het geheim niet')
449 still = admin.request('GET', '/keys/' + str(created['id']))['key']
450 check(still['token'] == token and still['revoked'] is not None, 'Een ingetrokken sleutel blijft zichtbaar voor de beheerder')
451 rejected = bearer.request('GET', '/days/latest', expected=401)
452 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')
453 admin.request('GET', '/days/nope', expected=404)
454 admin.request('PUT', '/days/latest', {'title': 'Nee'}, expected=405)
455
456 for path in ['/data/config.php', '/data/verhalenboek.sqlite', '/lib/bootstrap.php', '/lib/Storybook.php']:
457 try:
458 urllib.request.urlopen(base + path)
459 check(False, path + ' moet afgeschermd zijn')
460 except urllib.error.HTTPError as error:
461 check(error.code == 403, path + ' geeft ' + str(error.code))
462
463 docs = urllib.request.urlopen(base + '/docs.php')
464 body = docs.read().decode()
465 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')
466 check('[[pagina-slug#hoofdstuk|tekst]]' in body and '/wiki/pages' in body and 'inleiding' in body and 'broken' in body and 'minstens één pagina' in body, 'API-documentatie legt de wiki, de verwijzingen en het tabblad uit')
467 days_docs, wiki_docs = body.split('<h2>Wiki</h2>', 1)
468 check('PATCH' not in days_docs and wiki_docs.count('PATCH') == 4 and wiki_docs.count('PUT en PATCH doen hetzelfde.') == 2, 'API-documentatie belooft PATCH alleen voor wiki-pagina\'s en categorieën')
469 check('Ongeordende lijst' in body and '**vet**' in body and 'rel="noopener"' in body and 'mailto' in body, 'API-documentatie legt Markdown uit')
470 check('#/sleutels' not in body and '#/beheer' in body and 'onderaan Beheer' in body, 'API-documentatie wijst sleutels naar Beheer')
471
472 auth_bootstrap = root / 'lib/bootstrap.php'
473 auth_bootstrap.write_text(auth_bootstrap.read_text().replace(
474 " $ch=curl_init('https://auth.timfalken.com'.$path);",
475 " 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);",
476 ))
477 config_path.write_text(config_path.read_text().replace("'client_secret' => ''", "'client_secret' => 'fixture-secret'"))
478
479 class NoRedirect(urllib.request.HTTPRedirectHandler):
480 def redirect_request(self, req, fp, code, msg, headers, newurl):
481 return None
482
483 oauth = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(http.cookiejar.CookieJar()), NoRedirect())
484
485 def redirect(path):
486 try:
487 oauth.open(base + path)
488 raise AssertionError('redirect verwacht')
489 except urllib.error.HTTPError as error:
490 check(error.code == 302, 'OAuth redirect: ' + error.read().decode())
491 return error.headers['Location']
492
493 from urllib.parse import parse_qs, urlsplit
494 login = redirect('/auth.php')
495 oauth_state = parse_qs(urlsplit(login).query)['state'][0]
496 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')
497 callback = redirect('/callback.php?state=' + oauth_state + '&code=fixture')
498 check(urlsplit(callback).path == '/', 'OAuth komt terug op het boek')
499 with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db:
500 row = db.execute("SELECT id, name, role FROM users WHERE id='auth:7'").fetchone()
501 columns = [name for _, name, *_ in db.execute('PRAGMA table_info(users)')]
502 check(row == ('auth:7', 'oauth_user', 'user'), 'OAuth-gebruiker gebruikt het numerieke id en wordt geen beheerder')
503 check('email' not in columns and 'hidden@example.com' not in json.dumps(row), 'E-mail wordt niet opgeslagen')
504
505 print(f'API: {checks} assertions passed.')
506 except Exception:
507 log.flush()
508 print(log_path.read_text()[-4000:])
509 raise
510 finally:
511 os.killpg(process.pid, signal.SIGTERM)
512 process.wait(timeout=5)
513 log.close()