prepare("SELECT bookid, total_pages, pagination FROM epube_pagination WHERE bookid = ?"); $sth->execute([$bookid]); return $sth->fetch() ?: null; } private function deletePagination(int $bookid): void { $pdo = \Db::pdo(); $sth = $pdo->prepare("DELETE FROM epube_pagination WHERE bookid = ?"); $sth->execute([$bookid]); } // ── Authentication ─────────────────────────────────────────────────────── public function test_getpagination_requires_authentication(): void { [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'getpagination', 'id' => 2, ]); $this->assertEquals(401, $status); $this->assertArrayHasKey('error', $body); } public function test_storepagination_requires_authentication(): void { [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => 2, 'payload' => '{"page":1}', ]); $this->assertEquals(401, $status); $this->assertArrayHasKey('error', $body); } public function test_deletepagination_requires_authentication(): void { [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'deletepagination', 'id' => 2, ]); $this->assertEquals(401, $status); $this->assertArrayHasKey('error', $body); } // ── storepagination ────────────────────────────────────────────────────── public function test_storepagination_creates_new_record(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); // Real Calibre 'data' row id from the fixture metadata.db $bookid = 5; $this->deletePagination($bookid); $payload = '{"page":12,"cfi":"epubcfi(/6/14[]/4:123)"}'; [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => $bookid, 'payload' => $payload, ]); $this->assertEquals(200, $status); // Verify DB record was created $record = $this->getPagination($bookid); $this->assertNotNull($record); $this->assertEquals($bookid, $record['bookid']); $this->assertEquals($payload, $record['pagination']); $this->assertEquals(100, (int)$record['total_pages']); } public function test_storepagination_updates_existing_record(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); // Real Calibre 'data' row id from the fixture metadata.db $bookid = 6; $this->deletePagination($bookid); // Create initial record $pdo = \Db::pdo(); $sth = $pdo->prepare("INSERT INTO epube_pagination (bookid, pagination, total_pages) VALUES (?, ?, ?)"); $sth->execute([$bookid, '{"page":5}', 50]); $newPayload = '{"page":25,"cfi":"epubcfi(/6/20[]/4:456)"}'; [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => $bookid, 'payload' => $newPayload, ]); $this->assertEquals(200, $status); // Verify DB was updated (total_pages stays 100) $record = $this->getPagination($bookid); $this->assertNotNull($record); $this->assertEquals($newPayload, $record['pagination']); $this->assertEquals(100, (int)$record['total_pages']); } public function test_storepagination_with_zero_id(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => 0, 'payload' => '{"page":1}', ]); $this->assertEquals(200, $status); // With id=0, the if ($bookid) check fails → no-op } public function test_storepagination_with_empty_payload(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); $bookid = 8; $this->deletePagination($bookid); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => $bookid, 'payload' => '', ]); $this->assertEquals(200, $status); // With empty payload, the if ($payload) check fails → no-op // Verify no record was created $record = $this->getPagination($bookid); $this->assertNull($record); } public function test_storepagination_rejects_nonexistent_book(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); // Valid payload, but no such row in Calibre books/data tables $bookid = 99990; $this->deletePagination($bookid); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => $bookid, 'payload' => '{"page":1}', ]); $this->assertEquals(200, $status); // Verify no record was created for a book that does not exist $record = $this->getPagination($bookid); $this->assertNull($record); } // ── getpagination ──────────────────────────────────────────────────────── public function test_getpagination_returns_stored_data(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); // Real Calibre 'data' row id from the fixture metadata.db $bookid = 9; $this->deletePagination($bookid); $payload = '{"page":42,"cfi":"epubcfi(/6/30[]/4:789)"}'; $this->post($this->apiUrl, [ 'op' => 'storepagination', 'id' => $bookid, 'payload' => $payload, ]); [$status, $body, $headers] = $this->post($this->apiUrl, [ 'op' => 'getpagination', 'id' => $bookid, ], false); $this->assertEquals(200, $status); $this->assertEquals($payload, $body); } public function test_getpagination_with_no_record(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); $this->deletePagination(99999); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'getpagination', 'id' => 99999, ]); $this->assertEquals(404, $status); $this->assertEquals('File not found.', $body['error']); } public function test_getpagination_with_zero_id(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'getpagination', 'id' => 0, ]); $this->assertEquals(404, $status); $this->assertEquals('File not found.', $body['error']); } public function test_getpagination_with_negative_id(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'getpagination', 'id' => -1, ]); $this->assertEquals(404, $status); $this->assertEquals('File not found.', $body['error']); } // ── deletepagination ───────────────────────────────────────────────────── public function test_deletepagination_removes_record(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); $bookid = 99994; $this->deletePagination($bookid); // Create record first $pdo = \Db::pdo(); $sth = $pdo->prepare("INSERT INTO epube_pagination (bookid, pagination, total_pages) VALUES (?, ?, ?)"); $sth->execute([$bookid, '{"page":1}', 100]); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'deletepagination', 'id' => $bookid, ]); $this->assertEquals(200, $status); // Verify record was deleted $record = $this->getPagination($bookid); $this->assertNull($record); } public function test_deletepagination_with_no_record(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); $this->deletePagination(99999); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'deletepagination', 'id' => 99999, ]); $this->assertEquals(404, $status); $this->assertEquals('Not found.', $body['error']); } public function test_deletepagination_with_zero_id(): void { // Login [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'perform-login', 'user' => 'test', 'password' => 'test', ]); $this->assertEquals(200, $status); [$status, $body] = $this->post($this->apiUrl, [ 'op' => 'deletepagination', 'id' => 0, ]); $this->assertEquals(404, $status); $this->assertEquals('Not found.', $body['error']); } }