| 1 | #!/usr/bin/env python3 |
| 2 | """Geïsoleerde API-tests. De echte database van de applicatie blijft onaangeroerd.""" |
| 3 | import json |
| 4 | import os |
| 5 | import signal |
| 6 | import http.cookiejar |
| 7 | import shutil |
| 8 | import socket |
| 9 | import sqlite3 |
| 10 | import subprocess |
| 11 | import tempfile |
| 12 | import time |
| 13 | import urllib.error |
| 14 | import urllib.request |
| 15 | from pathlib import Path |
| 16 | |
| 17 | WEB = Path(__file__).resolve().parents[1] |
| 18 | ARTIFACTS = WEB / 'tests/artifacts' |
| 19 | ARTIFACTS.mkdir(exist_ok=True) |
| 20 | checks = 0 |
| 21 | |
| 22 | def check(value, label): |
| 23 | global checks |
| 24 | checks += 1 |
| 25 | assert value, label |
| 26 | |
| 27 | def 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 | |
| 34 | with 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(reader.me()['wiki'] is False and admin.me()['wiki'] is True, 'GET /me zegt of deze gebruiker de wiki ziet') |
| 302 | check(reader.request('GET', '/wiki/categories') == {'categories': []}, 'Een lezer mag de wiki lezen') |
| 303 | reader_wiki = reader.request('POST', '/wiki/categories', {'title': 'Verboden'}, expected=403) |
| 304 | 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') |
| 305 | reader.request('DELETE', '/wiki/pages/bas', expected=403) |
| 306 | plekken = bearer.request('POST', '/wiki/categories', {'title': 'Plekken'}, expected=201) |
| 307 | check(plekken['slug'] == 'plekken' and plekken['pages'] == [], 'Een sleutel maakt een categorie') |
| 308 | bearer.request('POST', '/wiki/categories', {'title': 'Plekken'}, expected=409) |
| 309 | bearer.request('POST', '/wiki/categories', {'title': 'Nieuw'}, expected=422) |
| 310 | vriendjes = admin.request('POST', '/wiki/categories', {'title': 'Vriendjes'}, expected=201) |
| 311 | check(vriendjes['slug'] == 'vriendjes', 'Een beheerder maakt een categorie in de sessie') |
| 312 | speeltjes = bearer.request('POST', '/wiki/categories', {'title': 'Speeltjes'}, expected=201) |
| 313 | check([item['slug'] for item in bearer.request('GET', '/wiki/categories')['categories']] == ['plekken', 'vriendjes', 'speeltjes'], 'Categorieën komen op volgorde terug') |
| 314 | 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') |
| 315 | plein = bearer.request('POST', '/wiki/pages', { |
| 316 | 'title': 'Het oude plein', |
| 317 | 'slug': 'oude-plein', |
| 318 | 'category': 'plekken', |
| 319 | 'content': 'Achter de huizen.\n\n## De boom\n\nEen boom.\n\n## De bank\n\nZie [[#de-boom]].', |
| 320 | }, expected=201) |
| 321 | check([chapter['anchor'] for chapter in plein['chapters']] == ['inleiding', 'de-boom', 'de-bank'], 'De pagina antwoordt met hoofdstukken en ankers') |
| 322 | shown_reader = page_html(reader) |
| 323 | 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') |
| 324 | check(reader.me()['wiki'] is True, 'GET /me toont de wiki aan de lezer') |
| 325 | 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') |
| 326 | kist = bearer.request('POST', '/wiki/pages', { |
| 327 | 'title': 'Speelgoedkist', |
| 328 | 'slug': 'speelgoedkist', |
| 329 | 'category': 'speeltjes', |
| 330 | 'content': '## Deksel\n\nDe deksel. [[bas#wie-hij-is|Bas]] [[geen-pagina]] <script>alert(1)</script>', |
| 331 | }, expected=201) |
| 332 | kist_parts = kist['chapters'][0]['blocks'][0]['inlines'] |
| 333 | kist_links = [part for part in kist_parts if part['type'] == 'link'] |
| 334 | 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') |
| 335 | check(any(part['type'] == 'text' and '<script>alert(1)</script>' in part['text'] for part in kist_parts), 'HTML in de wiki blijft tekst') |
| 336 | bas = bearer.request('POST', '/wiki/pages', { |
| 337 | 'title': 'Bas', |
| 338 | 'category': 'vriendjes', |
| 339 | 'content': '## Wie hij is\n\nBas speelt op het [[oude-plein|oude plein]] en bij de [[speelgoedkist#deksel|kist]].\n\n## Samen\n\nKlaar.', |
| 340 | }, expected=201) |
| 341 | check(bas['slug'] == 'bas', 'Slug uit de titel') |
| 342 | links = [part for block in bas['chapters'][0]['blocks'] for part in block['inlines'] if part['type'] == 'link'] |
| 343 | 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') |
| 344 | check(links[1]['page'] == 'speelgoedkist' and links[1]['anchor'] == 'deksel' and links[1]['broken'] is False, 'Link naar een hoofdstuk op een andere pagina') |
| 345 | check(bearer.request('GET', '/wiki/pages/bas')['title'] == 'Bas', 'Een pagina ophalen op slug') |
| 346 | found = bearer.request('GET', '/wiki/pages?q=deksel&category=speeltjes')['pages'] |
| 347 | 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') |
| 348 | check([page['slug'] for page in bearer.request('GET', '/wiki/pages?q=BANK')['pages']] == ['oude-plein'], 'Zoeken negeert hoofdletters') |
| 349 | bearer.request('GET', '/wiki/pages?category=onbekend', expected=404) |
| 350 | bearer.request('POST', '/wiki/pages', {'title': 'Nee', 'category': 'vriendjes', 'content': '##\n\nLeeg'}, expected=422) |
| 351 | edited = admin.request('PUT', '/wiki/pages/bas', {'title': 'Bas de vriend'}) |
| 352 | check(edited['title'] == 'Bas de vriend' and edited['slug'] == 'bas', 'Een beheerder bewerkt een pagina') |
| 353 | reader.request('PUT', '/wiki/pages/bas', {'title': 'Nee'}, expected=403) |
| 354 | bearer.request('DELETE', '/wiki/categories/vriendjes', expected=409) |
| 355 | check(bearer.request('DELETE', '/wiki/pages/bas') == {'ok': True, 'slug': 'bas'}, 'Pagina verwijderen') |
| 356 | check(bearer.request('DELETE', '/wiki/categories/vriendjes') == {'ok': True, 'slug': 'vriendjes'}, 'Lege categorie verwijderen') |
| 357 | bearer.request('GET', '/wiki/pages/bas', expected=404) |
| 358 | bearer.request('PUT', '/wiki/categories', {'title': 'Nee'}, expected=405) |
| 359 | bearer.request('DELETE', '/wiki/pages/oude-plein') |
| 360 | bearer.request('DELETE', '/wiki/pages/speelgoedkist') |
| 361 | bearer.request('DELETE', '/wiki/categories/plekken') |
| 362 | bearer.request('DELETE', '/wiki/categories/speeltjes') |
| 363 | check(reader.request('GET', '/wiki/categories') == {'categories': []}, 'De wiki is weer leeg') |
| 364 | hidden_again = page_html(reader) |
| 365 | 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') |
| 366 | |
| 367 | admin.request('PUT', '/days/2026-05-01', {'title': 'Herziene titel'}) |
| 368 | check(admin.request('GET', '/days/2026-05-01')['title'] == 'Herziene titel', 'Beheerder bewerkt een dag in de sessie') |
| 369 | admin.request('PUT', '/days/2026-05-01', {'stories': stories()[:1]}, expected=422) |
| 370 | revoked = admin.request('DELETE', '/keys/' + str(created['id']))['key'] |
| 371 | check(revoked['revoked'] is not None and 'token' not in revoked, 'Sleutel intrekken toont het geheim niet') |
| 372 | still = admin.request('GET', '/keys/' + str(created['id']))['key'] |
| 373 | check(still['token'] == token and still['revoked'] is not None, 'Een ingetrokken sleutel blijft zichtbaar voor de beheerder') |
| 374 | rejected = bearer.request('GET', '/days/latest', expected=401) |
| 375 | 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') |
| 376 | admin.request('GET', '/days/nope', expected=404) |
| 377 | admin.request('PUT', '/days/latest', {'title': 'Nee'}, expected=405) |
| 378 | |
| 379 | for path in ['/data/config.php', '/data/verhalenboek.sqlite', '/lib/bootstrap.php', '/lib/Storybook.php']: |
| 380 | try: |
| 381 | urllib.request.urlopen(base + path) |
| 382 | check(False, path + ' moet afgeschermd zijn') |
| 383 | except urllib.error.HTTPError as error: |
| 384 | check(error.code == 403, path + ' geeft ' + str(error.code)) |
| 385 | |
| 386 | docs = urllib.request.urlopen(base + '/docs.php') |
| 387 | body = docs.read().decode() |
| 388 | 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') |
| 389 | 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') |
| 390 | |
| 391 | auth_bootstrap = root / 'lib/bootstrap.php' |
| 392 | auth_bootstrap.write_text(auth_bootstrap.read_text().replace( |
| 393 | " $ch=curl_init('https://auth.timfalken.com'.$path);", |
| 394 | " 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);", |
| 395 | )) |
| 396 | config_path.write_text(config_path.read_text().replace("'client_secret' => ''", "'client_secret' => 'fixture-secret'")) |
| 397 | |
| 398 | class NoRedirect(urllib.request.HTTPRedirectHandler): |
| 399 | def redirect_request(self, req, fp, code, msg, headers, newurl): |
| 400 | return None |
| 401 | |
| 402 | oauth = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(http.cookiejar.CookieJar()), NoRedirect()) |
| 403 | |
| 404 | def redirect(path): |
| 405 | try: |
| 406 | oauth.open(base + path) |
| 407 | raise AssertionError('redirect verwacht') |
| 408 | except urllib.error.HTTPError as error: |
| 409 | check(error.code == 302, 'OAuth redirect: ' + error.read().decode()) |
| 410 | return error.headers['Location'] |
| 411 | |
| 412 | from urllib.parse import parse_qs, urlsplit |
| 413 | login = redirect('/auth.php') |
| 414 | oauth_state = parse_qs(urlsplit(login).query)['state'][0] |
| 415 | 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') |
| 416 | callback = redirect('/callback.php?state=' + oauth_state + '&code=fixture') |
| 417 | check(urlsplit(callback).path == '/', 'OAuth komt terug op het boek') |
| 418 | with sqlite3.connect(root / 'data/verhalenboek.sqlite') as db: |
| 419 | row = db.execute("SELECT id, name, role FROM users WHERE id='auth:7'").fetchone() |
| 420 | columns = [name for _, name, *_ in db.execute('PRAGMA table_info(users)')] |
| 421 | check(row == ('auth:7', 'oauth_user', 'user'), 'OAuth-gebruiker gebruikt het numerieke id en wordt geen beheerder') |
| 422 | check('email' not in columns and 'hidden@example.com' not in json.dumps(row), 'E-mail wordt niet opgeslagen') |
| 423 | |
| 424 | print(f'API: {checks} assertions passed.') |
| 425 | except Exception: |
| 426 | log.flush() |
| 427 | print(log_path.read_text()[-4000:]) |
| 428 | raise |
| 429 | finally: |
| 430 | os.killpg(process.pid, signal.SIGTERM) |
| 431 | process.wait(timeout=5) |
| 432 | log.close() |
projects-timfalken-com verhalenboek