[{"_1":2,"_176":-5,"_177":-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,"_152":153,"_173":174,"_175":-5},"handle","charmaine","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":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_151":20},"id","bb6ce380-0a77-11f0-93e4-569c3dd06744","createdAt",["D",1743016981026],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","94e5d6c4-8b05-4624-b043-5e79c4343db5","pinPreview",true,"screenshotVersion","likeCount","2019e55b-c541-4c51-bef0-008eef10ef88","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","org",{"_93":94,"_133":130},"avatar","branch",{"_136":137,"_95":43,"_101":138,"_139":102,"_140":141,"_142":143,"_144":108,"_145":146,"_147":148,"_149":96,"_150":94},"version",1,"bb6fb92a-0a77-11f0-93e4-569c3dd06744","projectId","forkedBranchId","c848cfc0-f3f1-11ef-89f6-569c3dd06744","forkedBranchVersion",1844,"forkedProjectPrivacy","forkedProjectId","c8488678-f3f1-11ef-89f6-569c3dd06744","forkedProjectOrgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","projectName","userHandle","isOwned","file",{"_101":154,"_95":155,"_156":157,"_158":159,"_160":138,"_161":137,"_162":115,"_103":163,"_136":32,"_164":165,"_166":167,"_168":20,"_169":-5,"_97":170},"bb71ba36-0a77-11f0-93e4-569c3dd06744","queries.ts","fileId","e4b9644a-b15d-45e3-b589-2148dbdf8616","parentId","ab104bd5-5728-4304-be83-3d9b3f2ea9a4","branchId","branchVersion","latest",["D",1743016981026],"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\";\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 const { id, comments, title, type } = item;\n const res = await sqlite.execute({\n sql: `INSERT INTO ${tableName} VALUES (:id, :comments, :title, :type) RETURNING *`,\n args: { id, comments, title, type },\n });\n return 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 await sqlite.execute({\n sql: `DELETE FROM ${tableName} WHERE id = ?`,\n args: [id],\n });\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 const res = await sqlite.execute({\n sql: `SELECT * FROM ${tableName} WHERE id = ?`,\n args: [id],\n });\n return 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 const res = await sqlite.execute(`SELECT * FROM ${tableName}`);\n return 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 const { id, comments } = item;\n const res = await sqlite.execute({\n sql: \"UPDATE hn_following SET comments = :comments WHERE id = :id RETURNING *\",\n args: { id, comments },\n });\n return sqliteRowsToObject(res);\n}","deleted","label",[171,172,155],"backend","database","permalink","https://www.val.town/x/charmaine/hn_notifier/code/backend/database/queries.ts","extension","actionData","errors"]