[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_149":150,"_172":173,"_174":-5},"handle","nbbaier","name","hn_notifier","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":113,"_114":115,"_116":117,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","c8488678-f3f1-11ef-89f6-569c3dd06744","createdAt",["D",1740540524461],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","61427624-f5f8-11ef-9209-569c3dd06744","pinPreview",true,"screenshotVersion",1859,"likeCount","5f80108f-7ca4-4327-b77b-089dbe4b5a82","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","org",{"_93":94,"_134":131},"avatar","branch",{"_137":138,"_95":43,"_101":139,"_140":102,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"version",1897,"c848cfc0-f3f1-11ef-89f6-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":139,"_158":159,"_160":115,"_103":161,"_137":162,"_163":164,"_165":166,"_167":20,"_168":-5,"_97":169},"f06e6984-1713-11f0-8bb2-569c3dd06744","queries.ts","fileId","4c213242-f5fa-11ef-8ac2-569c3dd06744","parentId","3a08d998-f5fa-11ef-b8e2-569c3dd06744","branchId","branchVersion",1864,"latest",["D",1744403485364],92,"fileType","script","content","import { tableName } from \"https://esm.town/v/nbbaier/hn_notifier/backend/database/migrations.ts\";\nimport type { DBItem } from \"https://esm.town/v/nbbaier/hn_notifier/shared/types.ts\";\nimport sqliteRowsToObject from \"https://esm.town/v/nbbaier/sqliteRowsToObject?v=6\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\n\n/**\n * Follows a Hacker News item by inserting it into the database\n * @param {DBItem} item - The item to follow containing id and comments\n * @returns {Promise} The inserted item\n */\nexport async function follow(item: DBItem): Promise {\n\tconst { id, comments, title, type } = item;\n\tconst res = await sqlite.execute({\n\t\tsql: `INSERT INTO ${tableName} VALUES (:id, :comments, :title, :type) RETURNING *`,\n\t\targs: { id, comments, title, type },\n\t});\n\treturn sqliteRowsToObject(res)[0];\n}\n\n/**\n * Unfollows a Hacker News item by deleting it from the database\n * @param {number} id - The ID of the item to unfollow\n * @returns {Promise}\n */\nexport async function unfollow(id: number): Promise {\n\tawait sqlite.execute({\n\t\tsql: `DELETE FROM ${tableName} WHERE id = ?`,\n\t\targs: [id],\n\t});\n}\n\n/**\n * Retrieves a single item from the database by ID\n * @param {number} id - The ID of the item to retrieve\n * @returns {Promise} The matching item(s)\n */\nexport async function getItem(id: number): Promise {\n\tconst res = await sqlite.execute({\n\t\tsql: `SELECT * FROM ${tableName} WHERE id = ?`,\n\t\targs: [id],\n\t});\n\treturn sqliteRowsToObject(res)[0];\n}\n\n/**\n * Retrieves all items from the database\n * @returns {Promise} Array of all items\n */\nexport async function getAllItems(): Promise {\n\tconst res = await sqlite.execute(`SELECT * FROM ${tableName}`);\n\treturn sqliteRowsToObject(res);\n}\n\n/**\n * Updates the comment count for a specific item\n * @param {DBItem} item - The item with updated comment count\n * @returns {Promise} The updated item\n */\nexport async function updateCommentCount(item: DBItem): Promise {\n\tconst { id, comments } = item;\n\tconst res = await sqlite.execute({\n\t\tsql: \"UPDATE hn_following SET comments = :comments WHERE id = :id RETURNING *\",\n\t\targs: { id, comments },\n\t});\n\treturn sqliteRowsToObject(res);\n}\n","deleted","label",[170,171,152],"backend","database","permalink","https://www.val.town/x/nbbaier/hn_notifier/code/backend/database/queries.ts","extension","actionData","errors"]