about summary refs log tree commit diff stats
path: root/classes/Handler/GetinfoHandler.php
diff options
context:
space:
mode:
authorfox <fox@fakecake.org>2026-06-15 22:12:27 +0300
committerfox <fox@fakecake.org>2026-06-15 22:12:27 +0300
commit789758a094d4885432f165c0c8a419adeb55906c (patch)
treeb5e4229ed2119bcfc0b59cf3f634fd8fa503cf0c /classes/Handler/GetinfoHandler.php
parent3a87066a7cf645eb8f8ddbc5d031afe753516de9 (diff)
parent7d5e7b0f95992650189b73c6160264db6b658bde (diff)
downloadthe-epube-789758a094d4885432f165c0c8a419adeb55906c.tar.gz
the-epube-789758a094d4885432f165c0c8a419adeb55906c.tar.xz
Merge branch 'dev' into 'master'
remove dedicated getinfo handler because list may operate on IDs; add some...

See merge request git/the-epube!56
Diffstat (limited to 'classes/Handler/GetinfoHandler.php')
-rw-r--r--classes/Handler/GetinfoHandler.php38
1 files changed, 0 insertions, 38 deletions
diff --git a/classes/Handler/GetinfoHandler.php b/classes/Handler/GetinfoHandler.php
deleted file mode 100644
index ee4a69a..0000000
--- a/classes/Handler/GetinfoHandler.php
+++ /dev/null
@@ -1,38 +0,0 @@
-<?php
-
-namespace Handler;
-
-use AuthRequired;
-use Config;
-use Request;
-use RequestHandlerInterface;
-use Response;
-use PDO;
-use Sanitizer;
-
-class GetinfoHandler implements RequestHandlerInterface, AuthRequired
-{
-    public function handle(Request $request): Response
-    {
-        $id = (int) $request->getAttribute('id');
-        $caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB));
-
-        $sth = $caldb->prepare("SELECT books.*, s.name AS series_name,
-            (SELECT text FROM comments WHERE book = books.id) AS comment,
-            (SELECT id FROM data WHERE book = books.id AND format = 'EPUB' LIMIT 1) AS epub_id FROM books
-            LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
-            LEFT JOIN series AS s ON (bsl.series = s.id)
-            WHERE books.id = ?");
-        $sth->execute([$id]);
-
-        if ($row = $sth->fetch()) {
-            $row['comment'] = Sanitizer::sanitize($row['comment'] ?? "");
-
-            return (new Response())->withBody(json_encode($row));
-        }
-
-        return (new Response())
-            ->withStatus(404)
-            ->withBody(json_encode(["error" => "Not found."]));
-    }
-}