Dumbing of Age Patreon Posts

\n This page takes the information you can already get by scrolling\n through the Patreon feed (whether you're subscribed or not) and makes\n it more sortable and kinda searchable.\n

\n \n \n \n {columnHeaders.map((header) => (\n \n ))}\n \n \n \n {posts.map((post) => (\n \n {columnHeaders.map((header) => (\n \n ))}\n \n ))}\n \n

\n {sortableColumns.includes(header)\n ? (\n \n {formatColumnName(header)}{\" \"}\n \n {sortBy === header\n ? (sortDirection === \"asc\" ? \"▲\" : \"▼\")\n : \"\"}\n \n \n )\n : formatColumnName(header)}\n
{getPostCellValue(post, header)}

\n \n \n Search:\n \n \n {!!query && (\n \n \n Clear\n \n \n )}\n \n Go\n \n \n

\n \n Previous\n \n \n Next\n \n

\n {!!lastRun && (\n

\n \n Data updater last ran:{\" \"}\n {new Date(lastRun.started_at).toLocaleString()} UTC\n
\n {!!lastRun.posts_retrieved\n ? (\n <>\n (Retrieved {lastRun.posts_retrieved} posts in{\" \"}\n {lastRun.duration_seconds} seconds)\n \n )\n : <>(Still loading latest comments...)}\n \n

\n )}\n ,\n );\n}\n\n// boilerplate stuff\n\nfunction getPostCellValue(post: Post, header: keyof Post): ReactNode {\n const value = post[header];\n if (header === \"published_at\") {\n return new Date(value).toLocaleDateString();\n } else if (header === \"title\") {\n return {value};\n }\n return value;\n}\n\nfunction formatColumnName(\n columnName: keyof Awaited>[number],\n) {\n if (columnName === \"comment_count\") {\n return \"Comments\";\n } else if (columnName === \"like_count\") {\n return \"Likes\";\n } else if (columnName === \"published_at\") {\n return \"Date\";\n } else if (columnName === \"title\") {\n return \"Post\";\n } else {\n return \"URL\";\n }\n}\n\nfunction Layout({ children }: { children: ReactNode }) {\n return (\n \n \n \n \n \n DOA Patreon Posts Data Table\n \n \n {children}\n \n \n );\n}\n\nfunction html(children: React.ReactNode) {\n return new Response(\n `` +\n renderToString(\n \n {children}\n ,\n ),\n {\n headers: {\n \"content-type\": \"text/html;\",\n },\n },\n );\n}","deleted","label","doa-patreon-comment-tracker",[100],"permalink","https://www.val.town/x/tobeofuse/doa-patreon-comment-table/code/index.tsx","extension","actionData","errors"]