DatabaseTest.php — Event Tickets with Ticket Scanner 2.9.3

event-tickets-with-ticket-scanner / tests / DatabaseTest.php

event-tickets-with-ticket-scanner / tests Last commit date

DatabaseTest.php

251 lines

1	<?php
2	/**
3	* Integration tests for the database layer (codes, lists CRUD).
4	*/
5
6	class DatabaseTest extends WP_UnitTestCase {
7
8	private $db;
9	private sasoEventtickets_Core $core;
10
11	public function set_up(): void {
12	parent::set_up();
13	$main = sasoEventtickets::Instance();
14	$this->db = $main->getDB();
15	$this->core = $main->getCore();
16	}
17
18	// ── Table names ────────────────────────────────────────────
19
20	public function test_getTabelle_codes(): void {
21	global $wpdb;
22	$expected = $wpdb->prefix . 'saso_eventtickets_codes';
23	$this->assertSame($expected, $this->db->getTabelle('codes'));
24	}
25
26	public function test_getTabelle_lists(): void {
27	global $wpdb;
28	$expected = $wpdb->prefix . 'saso_eventtickets_lists';
29	$this->assertSame($expected, $this->db->getTabelle('lists'));
30	}
31
32	public function test_getTabelle_authtokens(): void {
33	global $wpdb;
34	$expected = $wpdb->prefix . 'saso_eventtickets_authtokens';
35	$this->assertSame($expected, $this->db->getTabelle('authtokens'));
36	}
37
38	public function test_getTables_returns_all_tables(): void {
39	$tables = $this->db->getTables();
40	$this->assertIsArray($tables);
41	// getTables() returns indexed array of table short names
42	$this->assertContains('codes', $tables);
43	$this->assertContains('lists', $tables);
44	$this->assertContains('authtokens', $tables);
45	$this->assertContains('seatingplans', $tables);
46	$this->assertContains('seats', $tables);
47	}
48
49	// ── Lists CRUD ─────────────────────────────────────────────
50
51	public function test_insert_and_retrieve_list(): void {
52	$listName = 'PHPUnit Test List ' . uniqid();
53	$id = $this->db->insert('lists', [
54	'name' => $listName,
55	'aktiv' => 1,
56	'meta' => '{}',
57	]);
58	$this->assertGreaterThan(0, $id);
59
60	$list = $this->core->getListById($id);
61	$this->assertSame($listName, $list['name']);
62	$this->assertEquals(1, $list['aktiv']);
63	}
64
65	public function test_update_list(): void {
66	$id = $this->db->insert('lists', [
67	'name' => 'Before Update ' . uniqid(),
68	'aktiv' => 1,
69	'meta' => '{}',
70	]);
71	$newName = 'After Update ' . uniqid();
72	$this->db->update('lists', ['name' => $newName], ['id' => $id]);
73
74	$list = $this->core->getListById($id);
75	$this->assertSame($newName, $list['name']);
76	}
77
78	// ── Codes CRUD ─────────────────────────────────────────────
79
80	public function test_insert_and_retrieve_code(): void {
81	// First create a list
82	$listId = $this->db->insert('lists', [
83	'name' => 'Code Test List ' . uniqid(),
84	'aktiv' => 1,
85	'meta' => '{}',
86	]);
87
88	$code = 'PHPUNIT' . strtoupper(uniqid());
89	$metaObj = $this->core->getMetaObject();
90	$metaJson = $this->core->json_encode_with_error_handling($metaObj);
91
92	$codeId = $this->db->insert('codes', [
93	'code' => $code,
94	'code_display' => $code,
95	'cvv' => '1234',
96	'meta' => $metaJson,
97	'aktiv' => 1,
98	'redeemed' => 0,
99	'list_id' => $listId,
100	'order_id' => 0,
101	]);
102	$this->assertGreaterThan(0, $codeId);
103
104	// Retrieve by code
105	$retrieved = $this->core->retrieveCodeByCode($code);
106	$this->assertSame($code, $retrieved['code']);
107	$this->assertEquals($listId, $retrieved['list_id']);
108	$this->assertEquals(0, $retrieved['redeemed']);
109	}
110
111	public function test_retrieve_code_by_id(): void {
112	$listId = $this->db->insert('lists', [
113	'name' => 'ById Test ' . uniqid(),
114	'aktiv' => 1,
115	'meta' => '{}',
116	]);
117
118	$code = 'BYID' . strtoupper(uniqid());
119	$codeId = $this->db->insert('codes', [
120	'code' => $code,
121	'code_display' => $code,
122	'cvv' => '5678',
123	'meta' => '{}',
124	'aktiv' => 1,
125	'redeemed' => 0,
126	'list_id' => $listId,
127	'order_id' => 0,
128	]);
129
130	$retrieved = $this->core->retrieveCodeById($codeId);
131	$this->assertSame($code, $retrieved['code']);
132	}
133
134	public function test_getCodesSize_increments(): void {
135	$sizeBefore = $this->db->getCodesSize();
136
137	$listId = $this->db->insert('lists', [
138	'name' => 'Size Test ' . uniqid(),
139	'aktiv' => 1,
140	'meta' => '{}',
141	]);
142
143	$this->db->insert('codes', [
144	'code' => 'SIZE' . strtoupper(uniqid()),
145	'code_display' => '',
146	'cvv' => '',
147	'meta' => '{}',
148	'aktiv' => 1,
149	'redeemed' => 0,
150	'list_id' => $listId,
151	'order_id' => 0,
152	]);
153
154	$sizeAfter = $this->db->getCodesSize();
155	$this->assertEquals($sizeBefore + 1, $sizeAfter);
156	}
157
158	public function test_getCodesByOrderId_returns_matching(): void {
159	$listId = $this->db->insert('lists', [
160	'name' => 'Order Test ' . uniqid(),
161	'aktiv' => 1,
162	'meta' => '{}',
163	]);
164
165	$orderId = 99999;
166	$code1 = 'ORD1' . strtoupper(uniqid());
167	$code2 = 'ORD2' . strtoupper(uniqid());
168
169	$this->db->insert('codes', [
170	'code' => $code1,
171	'code_display' => $code1,
172	'cvv' => '',
173	'meta' => '{}',
174	'aktiv' => 1,
175	'redeemed' => 0,
176	'list_id' => $listId,
177	'order_id' => $orderId,
178	]);
179	$this->db->insert('codes', [
180	'code' => $code2,
181	'code_display' => $code2,
182	'cvv' => '',
183	'meta' => '{}',
184	'aktiv' => 1,
185	'redeemed' => 0,
186	'list_id' => $listId,
187	'order_id' => $orderId,
188	]);
189
190	$codes = $this->core->getCodesByOrderId($orderId);
191	$this->assertCount(2, $codes);
192	$foundCodes = array_column($codes, 'code');
193	$this->assertContains($code1, $foundCodes);
194	$this->assertContains($code2, $foundCodes);
195	}
196
197	public function test_update_code_redeemed_flag(): void {
198	$listId = $this->db->insert('lists', [
199	'name' => 'Redeem Flag Test ' . uniqid(),
200	'aktiv' => 1,
201	'meta' => '{}',
202	]);
203
204	$code = 'REDF' . strtoupper(uniqid());
205	$codeId = $this->db->insert('codes', [
206	'code' => $code,
207	'code_display' => $code,
208	'cvv' => '',
209	'meta' => '{}',
210	'aktiv' => 1,
211	'redeemed' => 0,
212	'list_id' => $listId,
213	'order_id' => 0,
214	]);
215
216	// Mark as redeemed
217	$this->db->update('codes', ['redeemed' => 1], ['id' => $codeId]);
218
219	$retrieved = $this->core->retrieveCodeById($codeId);
220	$this->assertEquals(1, $retrieved['redeemed']);
221	}
222
223	// ── reinigen_in (input sanitization) ───────────────────────
224
225	public function test_reinigen_in_trims(): void {
226	$this->assertSame('hello', $this->db->reinigen_in(' hello '));
227	}
228
229	public function test_reinigen_in_length_limit(): void {
230	$result = $this->db->reinigen_in('abcdefghij', 5);
231	$this->assertSame(5, strlen($result));
232	}
233
234	public function test_reinigen_in_html_entities(): void {
235	$result = $this->db->reinigen_in('<script>alert(1)</script>', 0, 0, 0, 1);
236	$this->assertStringNotContainsString('<script>', $result);
237	}
238
239	// ── insert validation ──────────────────────────────────────
240
241	public function test_insert_throws_on_empty_fields(): void {
242	$this->expectException(Exception::class);
243	$this->db->insert('codes', []);
244	}
245
246	public function test_update_throws_on_empty_where(): void {
247	$this->expectException(Exception::class);
248	$this->db->update('codes', ['aktiv' => 1], []);
249	}
250	}
251