[{"_1":2,"_173":-5,"_174":-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","d481f3d28ac6dd3f9b89bb10f2a0c9798df3020a","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,"_147":148,"_170":171,"_172":-5},"handle","Cess","name","skillswapapappforcommunityskillexchange","path","backend/routes/community.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":116,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_146":20},"id","f5940a7c-3fa4-11f0-aa05-76b3cceeab13","createdAt",["D",1748863817576],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","a37c0b00-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"aa51fa98-a743-4468-8b23-b215c685353a","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd5MjRkTHcyazFycGoycnREVHZIWXlnZGkifQ","org",{"_93":94,"_132":129},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",24,"f5948dd0-3fa4-11f0-aa05-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":150,"_151":152,"_153":154,"_155":137,"_156":157,"_158":159,"_103":160,"_135":32,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"aad010e8-3fa5-11f0-b9d5-76b3cceeab13","community.ts","fileId","aad011b0-3fa5-11f0-b9d5-76b3cceeab13","parentId","ed53dd82-7867-47c9-aeda-ec124e3d2fff","branchId","branchVersion",9,"latest",true,["D",1748864121630],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createCommunityPost, \n getCommunityPosts, \n createCommunityComment, \n getPostComments,\n likePost \n} from \"../database/queries.ts\";\nimport type { CommunityPost, CommunityComment, ApiResponse } from \"../../shared/types.ts\";\n\nconst community = new Hono();\n\n// Create a new community post\ncommunity.post(\"/posts\", async (c) => {\n try {\n const postData = await c.req.json();\n \n // Validate required fields\n if (!postData.user_id || !postData.user_name || !postData.title || !postData.content) {\n return c.json({ \n success: false, \n error: \"user_id, user_name, title, and content are required\" \n }, 400);\n }\n\n // Validate post type\n const validTypes = ['question', 'success_story', 'tip', 'general'];\n if (postData.type && !validTypes.includes(postData.type)) {\n return c.json({ \n success: false, \n error: `Type must be one of: ${validTypes.join(', ')}` \n }, 400);\n }\n\n const post = await createCommunityPost({\n user_id: postData.user_id,\n user_name: postData.user_name,\n title: postData.title.trim(),\n content: postData.content.trim(),\n type: postData.type || 'general',\n skill_tags: postData.skill_tags || []\n });\n\n return c.json>({ \n success: true, \n data: post \n });\n } catch (error) {\n console.error(\"Error creating community post:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create post\" \n }, 500);\n }\n});\n\n// Get community posts with pagination and filtering\ncommunity.get(\"/posts\", async (c) => {\n try {\n const type = c.req.query(\"type\");\n const limit = parseInt(c.req.query(\"limit\") || \"20\");\n const offset = parseInt(c.req.query(\"offset\") || \"0\");\n\n // Validate limit and offset\n if (limit < 1 || limit > 100) {\n return c.json({ \n success: false, \n error: \"Limit must be between 1 and 100\" \n }, 400);\n }\n\n if (offset < 0) {\n return c.json({ \n success: false, \n error: \"Offset must be non-negative\" \n }, 400);\n }\n\n // Validate type if provided\n const validTypes = ['question', 'success_story', 'tip', 'general'];\n if (type && !validTypes.includes(type)) {\n return c.json({ \n success: false, \n error: `Type must be one of: ${validTypes.join(', ')}` \n }, 400);\n }\n\n const posts = await getCommunityPosts(type, limit, offset);\n\n return c.json>({ \n success: true, \n data: posts \n });\n } catch (error) {\n console.error(\"Error fetching community posts:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch posts\" \n }, 500);\n }\n});\n\n// Get comments for a specific post\ncommunity.get(\"/posts/:postId/comments\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const comments = await getPostComments(postId);\n\n return c.json>({ \n success: true, \n data: comments \n });\n } catch (error) {\n console.error(\"Error fetching comments:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch comments\" \n }, 500);\n }\n});\n\n// Create a comment on a post\ncommunity.post(\"/posts/:postId/comments\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const commentData = await c.req.json();\n \n // Validate required fields\n if (!commentData.user_id || !commentData.user_name || !commentData.content) {\n return c.json({ \n success: false, \n error: \"user_id, user_name, and content are required\" \n }, 400);\n }\n\n const comment = await createCommunityComment({\n post_id: postId,\n user_id: commentData.user_id,\n user_name: commentData.user_name,\n content: commentData.content.trim()\n });\n\n return c.json>({ \n success: true, \n data: comment \n });\n } catch (error) {\n console.error(\"Error creating comment:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create comment\" \n }, 500);\n }\n});\n\n// Like a post\ncommunity.post(\"/posts/:postId/like\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const success = await likePost(postId);\n if (!success) {\n return c.json({ \n success: false, \n error: \"Post not found\" \n }, 404);\n }\n\n return c.json({ \n success: true \n });\n } catch (error) {\n console.error(\"Error liking post:\", error);\n return c.json({ \n success: false, \n error: \"Failed to like post\" \n }, 500);\n }\n});\n\n// Get trending topics/skills\ncommunity.get(\"/trending\", async (c) => {\n try {\n // In a real app, this would analyze post content and skill tags\n // For now, we'll return mock trending data\n const trendingTopics = [\n { name: \"JavaScript\", posts: 45, growth: \"+12%\" },\n { name: \"Remote Work Tips\", posts: 38, growth: \"+8%\" },\n { name: \"Language Learning\", posts: 32, growth: \"+15%\" },\n { name: \"Photography\", posts: 28, growth: \"+5%\" },\n { name: \"Cooking\", posts: 25, growth: \"+20%\" },\n { name: \"Data Science\", posts: 22, growth: \"+10%\" },\n { name: \"Guitar\", posts: 20, growth: \"+7%\" },\n { name: \"Public Speaking\", posts: 18, growth: \"+25%\" }\n ];\n\n return c.json({ \n success: true, \n data: trendingTopics \n });\n } catch (error) {\n console.error(\"Error fetching trending topics:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch trending topics\" \n }, 500);\n }\n});\n\n// Get community statistics\ncommunity.get(\"/stats\", async (c) => {\n try {\n // In a real app, these would be calculated from the database\n const stats = {\n totalPosts: 1247,\n totalComments: 3891,\n activeUsers: 342,\n questionsAnswered: 89,\n successStories: 156,\n tipsShared: 203,\n topContributors: [\n { name: \"Sarah Chen\", posts: 23, helpful_votes: 145 },\n { name: \"Mike Rodriguez\", posts: 19, helpful_votes: 132 },\n { name: \"Emma Thompson\", posts: 17, helpful_votes: 98 },\n { name: \"David Kim\", posts: 15, helpful_votes: 87 },\n { name: \"Lisa Johnson\", posts: 14, helpful_votes: 76 }\n ]\n };\n\n return c.json({ \n success: true, \n data: stats \n });\n } catch (error) {\n console.error(\"Error fetching community stats:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch community statistics\" \n }, 500);\n }\n});\n\n// Search posts by content or skill tags\ncommunity.get(\"/search\", async (c) => {\n try {\n const query = c.req.query(\"q\");\n const type = c.req.query(\"type\");\n \n if (!query || query.trim().length < 2) {\n return c.json({ \n success: false, \n error: \"Search query must be at least 2 characters\" \n }, 400);\n }\n\n // In a real app, this would use full-text search\n // For now, we'll return a simple response\n const searchResults = [\n {\n id: 1,\n title: \"How to get started with JavaScript?\",\n content: \"I'm new to programming and want to learn JavaScript...\",\n type: \"question\",\n user_name: \"John Doe\",\n skill_tags: [\"JavaScript\", \"Programming\"],\n likes: 12,\n created_at: new Date().toISOString()\n }\n ];\n\n return c.json({ \n success: true, \n data: searchResults \n });\n } catch (error) {\n console.error(\"Error searching posts:\", error);\n return c.json({ \n success: false, \n error: \"Failed to search posts\" \n }, 500);\n }\n});\n\nexport default community;","deleted","label",[168,169,150],"backend","routes","permalink","https://www.val.town/x/Cess/skillswapapappforcommunityskillexchange/code/backend/routes/community.ts","extension","actionData","errors"]