[{"_1":2,"_171":-5,"_172":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4207e8ad4ddbe7f6e8b804339ca1b2ec4ab76c50","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_168":169,"_170":-5},"handle","lilac","name","simanon","path","booklib","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","bd53a1ac-3f9c-11f0-9492-76b3cceeab13","createdAt",["D",1748860287228],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","cdbb4b90-3f9b-11f0-b6e9-ab0b2f88b858","pinnedFileId","2c6fc034-3f9d-11f0-8f57-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","5c8ea7df-75c5-4258-a7e0-517d59a50b1d","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d3JBYlV0WFppYk54bk9hNHdYSlRET25rRiJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",17,"bd53ee78-3f9c-11f0-9492-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":99,"_153":154,"_155":-5,"_156":140,"_157":139,"_158":116,"_104":159,"_138":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_98":167},"65423452-3fa0-11f0-9390-76b3cceeab13","fileId","bd55bc26-3f9c-11f0-9492-76b3cceeab13","parentId","branchId","branchVersion","latest",["D",1748861857456],2,"fileType","script","content","export interface Book {\n id?: number;\n title: string;\n author: string;\n genre?: string;\n description?: string;\n isbn?: string;\n pages?: number;\n publishedYear?: number;\n status: \"want-to-read\" | \"currently-reading\" | \"read\";\n rating?: number; // 1-5 stars\n notes?: string;\n dateAdded: string;\n dateRead?: string;\n}\n\nexport interface BookFilters {\n search?: string;\n status?: Book[\"status\"];\n genre?: string;\n rating?: number;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = \"books_library_v1\";\n\nexport async function createBooksTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n author TEXT NOT NULL,\n genre TEXT,\n description TEXT,\n isbn TEXT,\n pages INTEGER,\n publishedYear INTEGER,\n status TEXT NOT NULL DEFAULT 'want-to-read',\n rating INTEGER CHECK (rating >= 1 AND rating <= 5),\n notes TEXT,\n dateAdded TEXT NOT NULL,\n dateRead TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n console.log(`Created table: ${TABLE_NAME}`);\n}\n\nexport { TABLE_NAME };\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Book, BookFilters } from \"../../shared/types.ts\";\nimport { TABLE_NAME } from \"./migrations.ts\";\n\nexport async function getAllBooks(filters: BookFilters = {}): Promise {\n let query = `SELECT * FROM ${TABLE_NAME}`;\n const params: any[] = [];\n const conditions: string[] = [];\n\n // Add search filter\n if (filters.search) {\n conditions.push(`(title LIKE ? OR author LIKE ? OR genre LIKE ?)`);\n const searchTerm = `%${filters.search}%`;\n params.push(searchTerm, searchTerm, searchTerm);\n }\n\n // Add status filter\n if (filters.status) {\n conditions.push(`status = ?`);\n params.push(filters.status);\n }\n\n // Add genre filter\n if (filters.genre) {\n conditions.push(`genre = ?`);\n params.push(filters.genre);\n }\n\n // Add rating filter\n if (filters.rating) {\n conditions.push(`rating = ?`);\n params.push(filters.rating);\n }\n\n if (conditions.length > 0) {\n query += ` WHERE ${conditions.join(\" AND \")}`;\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as Book[];\n}\n\nexport async function getBookById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n\n return result.rows.length > 0 ? result.rows[0] as Book : null;\n}\n\nexport async function createBook(book: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (\n title, author, genre, description, isbn, pages, publishedYear,\n status, rating, notes, dateAdded, dateRead\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n book.title,\n book.author,\n book.genre || null,\n book.description || null,\n book.isbn || null,\n book.pages || null,\n book.publishedYear || null,\n book.status,\n book.rating || null,\n book.notes || null,\n book.dateAdded,\n book.dateRead || null,\n ],\n );\n\n const newBook = await getBookById(result.lastInsertRowId!);\n return newBook!;\n}\n\nexport async function updateBook(id: number, book: Partial): Promise {\n const fields: string[] = [];\n const params: any[] = [];\n\n // Build dynamic update query\n Object.entries(book).forEach(([key, value]) => {\n if (key !== \"id\" && value !== undefined) {\n fields.push(`${key} = ?`);\n params.push(value);\n }\n });\n\n if (fields.length === 0) {\n return getBookById(id);\n }\n\n // Add updated_at timestamp\n fields.push(\"updated_at = CURRENT_TIMESTAMP\");\n params.push(id);\n\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET ${fields.join(\", \")} WHERE id = ?`,\n params,\n );\n\n return getBookById(id);\n}\n\nexport async function deleteBook(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n\n return result.changes > 0;\n}\n\nexport async function getGenres(): Promise {\n const result = await sqlite.execute(\n `SELECT DISTINCT genre FROM ${TABLE_NAME} WHERE genre IS NOT NULL AND genre != '' ORDER BY genre`,\n );\n\n return result.rows.map(row => row.genre as string);\n}\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { BookFilters } from \"../../shared/types.ts\";\nimport { createBook, deleteBook, getAllBooks, getBookById, getGenres, updateBook } from \"../database/queries.ts\";\n\nconst books = new Hono();\n\n// Get all books with optional filters\nbooks.get(\"/\", async (c) => {\n try {\n const filters: BookFilters = {\n search: c.req.query(\"search\"),\n status: c.req.query(\"status\") as any,\n genre: c.req.query(\"genre\"),\n rating: c.req.query(\"rating\") ? parseInt(c.req.query(\"rating\")!) : undefined,\n };\n\n // Remove undefined values\n Object.keys(filters).forEach(key => {\n if (filters[key as keyof BookFilters] === undefined) {\n delete filters[key as keyof BookFilters];\n }\n });\n\n const allBooks = await getAllBooks(filters);\n return c.json({ success: true, data: allBooks });\n } catch (error) {\n console.error(\"Error fetching books:\", error);\n return c.json({ success: false, error: \"Failed to fetch books\" }, 500);\n }\n});\n\n// Get available genres\nbooks.get(\"/genres\", async (c) => {\n try {\n const genres = await getGenres();\n return c.json({ success: true, data: genres });\n } catch (error) {\n console.error(\"Error fetching genres:\", error);\n return c.json({ success: false, error: \"Failed to fetch genres\" }, 500);\n }\n});\n\n// Get a specific book\nbooks.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid book ID\" }, 400);\n }\n\n const book = await getBookById(id);\n if (!book) {\n return c.json({ success: false, error: \"Book not found\" }, 404);\n }\n\n return c.json({ success: true, data: book });\n } catch (error) {\n console.error(\"Error fetching book:\", error);\n return c.json({ success: false, error: \"Failed to fetch book\" }, 500);\n }\n});\n\n// Create a new book\nbooks.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n\n // Validate required fields\n if (!body.title || !body.author) {\n return c.json({\n success: false,\n error: \"Title and author are required\",\n }, 400);\n }\n\n // Set default values\n const bookData = {\n ...body,\n status: body.status || \"want-to-read\",\n dateAdded: body.dateAdded || new Date().toISOString(),\n };\n\n const newBook = await createBook(bookData);\n return c.json({ success: true, data: newBook }, 201);\n } catch (error) {\n console.error(\"Error creating book:\", error);\n return c.json({ success: false, error: \"Failed to create book\" }, 500);\n }\n});\n\n// Update a book\nbooks.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid book ID\" }, 400);\n }\n\n const body = await c.req.json();\n\n // If status is being changed to 'read', set dateRead\n if (body.status === \"read\" && !body.dateRead) {\n body.dateRead = new Date().toISOString();\n }\n\n const updatedBook = await updateBook(id, body);\n if (!updatedBook) {\n return c.json({ success: false, error: \"Book not found\" }, 404);\n }\n\n return c.json({ success: true, data: updatedBook });\n } catch (error) {\n console.error(\"Error updating book:\", error);\n return c.json({ success: false, error: \"Failed to update book\" }, 500);\n }\n});\n\n// Delete a book\nbooks.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid book ID\" }, 400);\n }\n\n const deleted = await deleteBook(id);\n if (!deleted) {\n return c.json({ success: false, error: \"Book not found\" }, 404);\n }\n\n return c.json({ success: true, data: { message: \"Book deleted successfully\" } });\n } catch (error) {\n console.error(\"Error deleting book:\", error);\n return c.json({ success: false, error: \"Failed to delete book\" }, 500);\n }\n});\n\nexport default books;\n/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();","deleted","label",[99],"permalink","https://www.val.town/x/lilac/simanon/code/booklib","extension","actionData","errors"]