Presentations | Recurse Center

\n \n\n\n",[146],"fd2724f4-3e4b-11f0-a867-76b3cceeab13","deno.json","fd2725b2-3e4b-11f0-a867-76b3cceeab13",4,["D",1748715653910],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[154],"fd33f0da-3e4b-11f0-8305-76b3cceeab13",".vtignore","fd33f22e-3e4b-11f0-8305-76b3cceeab13",6,["D",1748715653911],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[161],"fd92803c-3e4b-11f0-8e5a-76b3cceeab13",".gitignore","fd9280f0-3e4b-11f0-8e5a-76b3cceeab13",25,["D",1748715654598],"/node_modules/\n.DS_Store\n",[168],"fd00ded4-3e4b-11f0-ad0a-76b3cceeab13","src","fd00e03c-3e4b-11f0-ad0a-76b3cceeab13",["D",1748715653653],"directory",[175],"60970342-3e4c-11f0-a0c2-76b3cceeab13","shared","6fd1bf83-f547-467d-b1f1-e56d53c4cdcd",30,["D",1748715820732],[181],"b4a5a29a-3e4c-11f0-850f-76b3cceeab13","frontend","c9a8b5b0-0e0b-4e82-99b4-f9a6b44525f3",33,["D",1748715961758],[187],"55abf884-3e4c-11f0-9c59-76b3cceeab13","backend","0942c9c1-ef73-4a8f-a249-4ff2ca238bfc",28,["D",1748715802417],[193],"pulls","branches","forks","envVars",{"_205":63,"_207":63},"connections",{"_205":63,"_206":63},"count","unfilledCount","emptyCount",{"_43":192,"_32":193,"_30":194,"_138":-5,"_41":42,"_40":195,"_140":25,"_38":343,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":344,"_27":345},{"_43":339,"_32":338,"_30":332,"_138":194,"_41":42,"_40":333,"_140":25,"_38":340,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":341,"_27":342},{"_43":329,"_32":330,"_30":331,"_138":332,"_41":42,"_40":333,"_140":25,"_38":334,"_13":63,"_34":35,"_36":335,"_24":49,"_143":-5,"_230":336,"_27":337},{"_43":322,"_32":323,"_30":58,"_138":194,"_41":42,"_40":195,"_140":49,"_38":324,"_13":63,"_34":35,"_36":325,"_24":49,"_143":326,"_230":327,"_27":328},{"_43":186,"_32":187,"_30":188,"_138":-5,"_41":42,"_40":189,"_140":25,"_38":319,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":320,"_27":321},{"_43":312,"_32":313,"_30":314,"_138":188,"_41":42,"_40":189,"_140":25,"_38":315,"_13":63,"_34":35,"_36":316,"_24":49,"_143":-5,"_230":317,"_27":318},{"_43":180,"_32":181,"_30":182,"_138":-5,"_41":42,"_40":183,"_140":25,"_38":309,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":310,"_27":311},{"_43":302,"_32":303,"_30":304,"_138":182,"_41":42,"_40":183,"_140":25,"_38":305,"_13":63,"_34":35,"_36":306,"_24":49,"_143":-5,"_230":307,"_27":308},{"_43":294,"_32":295,"_30":296,"_138":182,"_41":42,"_40":297,"_140":25,"_38":298,"_13":63,"_34":35,"_36":299,"_24":49,"_143":-5,"_230":300,"_27":301},{"_43":174,"_32":175,"_30":176,"_138":-5,"_41":42,"_40":150,"_140":25,"_38":291,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":292,"_27":293},{"_43":284,"_32":285,"_30":286,"_138":176,"_41":42,"_40":287,"_140":25,"_38":288,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":289,"_27":290},{"_43":279,"_32":270,"_30":264,"_138":176,"_41":42,"_40":280,"_140":25,"_38":281,"_13":63,"_34":178,"_36":-5,"_24":49,"_143":-5,"_230":282,"_27":283},{"_43":271,"_32":272,"_30":273,"_138":264,"_41":42,"_40":274,"_140":49,"_38":275,"_13":63,"_34":20,"_36":276,"_24":49,"_143":-5,"_230":277,"_27":278},{"_43":261,"_32":262,"_30":263,"_138":264,"_41":42,"_40":265,"_140":49,"_38":266,"_13":63,"_34":35,"_36":267,"_24":49,"_143":-5,"_230":268,"_27":269},{"_43":253,"_32":254,"_30":255,"_138":176,"_41":42,"_40":256,"_140":49,"_38":257,"_13":63,"_34":35,"_36":258,"_24":49,"_143":-5,"_230":259,"_27":260},{"_43":245,"_32":246,"_30":247,"_138":176,"_41":42,"_40":248,"_140":49,"_38":249,"_13":63,"_34":35,"_36":250,"_24":49,"_143":-5,"_230":251,"_27":252},{"_43":167,"_32":168,"_30":169,"_138":-5,"_41":42,"_40":170,"_140":25,"_38":242,"_13":63,"_34":20,"_36":172,"_24":49,"_143":-5,"_230":243,"_27":244},{"_43":160,"_32":161,"_30":162,"_138":-5,"_41":42,"_40":163,"_140":25,"_38":239,"_13":63,"_34":20,"_36":165,"_24":49,"_143":-5,"_230":240,"_27":241},{"_43":153,"_32":154,"_30":155,"_138":-5,"_41":42,"_40":156,"_140":25,"_38":236,"_13":63,"_34":20,"_36":158,"_24":49,"_143":-5,"_230":237,"_27":238},{"_43":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_140":25,"_38":233,"_13":150,"_34":20,"_36":151,"_24":49,"_143":-5,"_230":234,"_27":235},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":49,"_38":229,"_13":63,"_34":20,"_36":142,"_24":49,"_143":-5,"_230":231,"_27":232},["D",1748715653914],"children",[],[136],["D",1748715916868],[],[146],["D",1748715653910],[],[154],["D",1748715653911],[],[161],["D",1748715654598],[],[168],"fd3bd502-3e4b-11f0-ab8c-76b3cceeab13","app.js","fd3bd5b6-3e4b-11f0-ab8c-76b3cceeab13",8,["D",1748715654033],"\"use strict\";\n\nimport React from \"react\";\nimport ReactDOM from \"react-dom\";\nimport Firebase from \"firebase\";\nimport { createStore } from \"redux\";\nimport { Provider } from \"react-redux\";\nimport reducer from \"./reducer.js\";\nimport * as action from \"./actions.js\";\nimport * as helper from \"./helpers.js\";\nimport { PresentationsApp } from \"./components/presentationsApp.jsx\";\n\nconst ref = new Firebase(\"https://rc-presentations.firebaseio.com/\");\n\n// This is the first day (in UTC) ever of RC presentations.\nconst firstThursday = Date.UTC(\n 2016, // year\n 1, // month (1 = Februrary)\n 25, // day\n 21 // hour. 21:00 UTC is 4:00 PM EST which is the time that presentations\n // begin in NYC\n);\n\nconst oneWeekInMilliseconds = 1000 * 60 * 60 * 24 * 7;\n\n// import css\n// this is helpful for hot-reloding\n// with webpack-dev-server\nimport \"./index.css\";\n\nlet givenDate = helper.parseDateFromURL(location.href);\nif (!givenDate) {\n givenDate = new Date();\n}\n\nconsole.log(givenDate);\n\n// TODO (emily): Move this back to getNextThursUtc() after presentations on 7/5/24.\n// Note: the day of the week of the upcoming presentation determines how all past presentations\n// are displayed. All previous presentation sessions will now be shown as having occurred on a\n// Friday.\nconst upcomingPresentationDay = helper.getNextFridayUtc(givenDate);\n\n// 21:00 UTC is 4:00 PM EST which is the time that presentations begin in NYC.\nupcomingPresentationDay.setUTCHours(21);\nupcomingPresentationDay.setUTCMinutes(0);\nupcomingPresentationDay.setUTCSeconds(0);\nupcomingPresentationDay.setUTCMilliseconds(0);\n\nconsole.log(\"getting presentations since date\", upcomingPresentationDay);\n\n// The presentations for a given day must have been registered between\n// 5:00:01 PM EST one week ago and 5:00:00 EST on that day.\n//\n// We chose 5:00 PM EST as the cutoff because it corresponds to the end of RC\n// core hours. When NYC is in daylight savings time, the cutoff will switch to\n// 6:00 PM EDT. We're okay with this inconsistency in user experience. The benefit\n// is it simplies our implementation -- the code doesn't have to worry about the\n// difference between standard time and daylight savings time.\nconst endOfPresentationDay = new Date(upcomingPresentationDay);\nendOfPresentationDay.setUTCHours(22); // 22:00 UTC is 5:00 PM EST, the time presentations end\nconst oneWeekBeforePresentationDate = endOfPresentationDay.getTime() - oneWeekInMilliseconds;\n\nref\n .child(\"presentations\")\n .orderByChild(\"date\")\n .startAt(oneWeekBeforePresentationDate)\n .endAt(endOfPresentationDay.getTime())\n .once(\"value\", snapshot => {\n ReactDOM.render(\n ,\n document.getElementById(\"presentationsApp\")\n );\n });\n",[],[175,246],"fd42a292-3e4b-11f0-aaf9-76b3cceeab13","actions.js","fd42a328-3e4b-11f0-aaf9-76b3cceeab13",10,["D",1748715654009],"\"use strict\";\n\nimport * as helper from \"./helpers.js\";\n\nexport const UPDATE_ENTRY = (path, value) => {\n return helper.updateEntryInFirebase(path, value);\n};\n",[],[175,254],"fdad787e-3e4b-11f0-83fd-76b3cceeab13","AddPresentation.jsx","fdad7946-3e4b-11f0-83fd-76b3cceeab13","fd1c8c6a-3e4b-11f0-aa01-76b3cceeab13",27,["D",1748715654138],"\"use strict\";\n\nimport React from \"react\";\nimport Firebase from \"firebase\";\nlet ref = new Firebase(\"https://rc-presentations.firebaseio.com/\");\nimport Notice from \"./Notice.jsx\";\n\nimport \"./AddPresentation.css\";\n\nimport { placeholder, maxSignUps } from \"./config.js\";\n\nclass AddPresentation extends React.Component {\n constructor(props) {\n super(props);\n this.state = {\n titleInput: \"\",\n presenterInput: \"\",\n notice: \"\",\n showForm: true\n };\n }\n\n updateInput(label, e) {\n let newInputObj = {};\n newInputObj[label] = e.target.value;\n this.setState(newInputObj);\n }\n\n addEntryInFirebase(e) {\n if (document.getElementsByClassName(\"presentation\").length >= maxSignUps ) {\n e.preventDefault();\n this.displayNotice(\"aw gee, it's all booked!\");\n } else if (this.state.presenterInput.length > 0) {\n ref.child(\"presentations\").push({\n title: this.state.titleInput,\n presenter: this.state.presenterInput,\n date: Firebase.ServerValue.TIMESTAMP\n });\n } else {\n e.preventDefault();\n this.displayNotice(\"Please add your name\", 50000);\n }\n }\n\n displayNotice(msg) {\n this.setState({\n notice: msg\n });\n setTimeout(() => {\n this.setState({\n notice: \"\"\n });\n }, 1000);\n }\n\n componentDidMount(){\n // Add focus to title input for quicker\n // presentation submission\n // document.getElementById('add-presentation-title').focus();\n }\n\n componentWillMount(){\n let formStatus = this.props.numPresentations < maxSignUps ? true : false;\n this.setState({\n showForm: formStatus\n });\n }\n\n render() {\n let entryData = {\n title: this.state.titleInput,\n presenter: this.state.presenterInput,\n lastUpdated: Firebase.ServerValue.TIMESTAMP\n };\n\n return (\n

\n { this.state.showForm\n ?

\n );\n }\n}\n\nexport default AddPresentation;\n",[],[175,270,262],"components","fd490858-3e4b-11f0-972e-76b3cceeab13","AddPresentation.css","fd49090c-3e4b-11f0-972e-76b3cceeab13",11,["D",1748715654090],"/* form.add-presentation{\n\n} */\nform.add-presentation h3{\n grid-column: 2 span;\n text-align:left;\n padding-bottom:0.5em;\n}\n\nform.add-presentation label{\n display:block;\n font-size:0.9em;\n text-align:left;\n padding-bottom: 0.5em;\n color:var(--gray);\n}\n\nform.add-presentation input,\nform.add-presentation button{\n /* Shared Form Styles */\n border-width: 0px;\n border-radius: 1rem;\n padding: 0.5em 0.8em;\n font-size: 1.1em;\n}\nform.add-presentation input:focus{\n border-color:1px solid var(--white);\n}\nform.add-presentation button:focus{\n background-color:var(--white);\n border-color:1px solid var(--white);\n}\n\nform.add-presentation input{\n display:block;\n\n position:relative;\n top:0;left:0;\n\n background:none;\n color:var(--text);\n border:1px solid var(--gray);\n border-radius: 1rem;\n width: 100%;\n margin: 0 0 1em 0;\n}\nform.add-presentation button{\n padding:0.5em 1.2em;\n background-color:var(--green);\n color: var(--black);\n transition: all 0.3s ease;\n}\nform.add-presentation button:hover{\n cursor: pointer;\n box-shadow: 0px 0px 10px RGBA(90, 186, 71, 0.60);\n transform: scale(1.05);\n}\nform.add-presentation button:focus:hover{\n box-shadow: 0px 0px 10px RGBA(255, 255, 255, 0.60);\n}\n\n.block-border{\n margin:2rem 0;\n padding: 1rem;\n\n border-radius: 1.5rem;\n border:1px solid var(--gray);\n /* box-shadow: 0px 0px 10px rgba(255,255,255,0.3); */\n\n text-align:left;\n\n /* display:grid;\n grid-template-columns: 2fr 2fr 1fr; */\n}\n\nform.add-presentation .notice{\n display:inline;\n padding-left:1.5rem;\n}\n\nform.add-presentation div.form-grid{\n display:flex-box;\n flex-direction: column;\n flex-wrap: wrap;\n}\n",[],[175,270,272],"fd1c8ada-3e4b-11f0-aa01-76b3cceeab13",3,["D",1748715653838],[220,221],[175,270],"fd110688-3e4b-11f0-85ee-76b3cceeab13","assets","fd110746-3e4b-11f0-85ee-76b3cceeab13",2,["D",1748715653764],[],[175,285],["D",1748715653653],[218,219,222,223],[175],"6b34e77e-3e4c-11f0-9e2b-76b3cceeab13","utils.ts","6b34e85a-3e4c-11f0-9e2b-76b3cceeab13",31,["D",1748715838548],"export function isValidDate(date: Date): boolean {\n return !Number.isNaN(date.getTime());\n}\n\nexport function parseDateFromURL(url: string): Date | false {\n const dateIndex = url.indexOf(\"date=\");\n if (dateIndex === -1) return false;\n \n const dateString = url.slice(dateIndex + 5);\n const date = new Date(parseInt(dateString, 10));\n\n if (!isValidDate(date)) {\n return false;\n } else {\n return date;\n }\n}\n\nexport function isToday(date: number): boolean {\n if (date >= todayUnix() - 1000 * 60 * 60 * 24) {\n return true;\n } else {\n return false;\n }\n}\n\nexport function todayUnix(): number {\n const today = new Date();\n today.setHours(0);\n today.setMinutes(0);\n today.setSeconds(0);\n today.setMilliseconds(0);\n return today.getTime();\n}\n\n// Moves `date` forward until it reaches a Thursday in UTC and then the Thursday date\n// is returned. If `date` UTC already refers to a Thursday, then `date` is returned\n// unchanged.\nexport function getNextThursUtc(date: Date): Date {\n const thurs = 4;\n const thursDate = new Date(date);\n\n while (thursDate.getUTCDay() !== thurs) {\n thursDate.setUTCDate(thursDate.getUTCDate() + 1);\n }\n\n return thursDate;\n}\n\n// Moves `date` forward until it reaches a Friday in UTC and then the Friday date\n// is returned. If `date` UTC already refers to a Friday, then `date` is returned\n// unchanged.\nexport function getNextFridayUtc(date: Date): Date {\n const friday = 5;\n const fridayDate = new Date(date);\n\n while (fridayDate.getUTCDay() !== friday) {\n fridayDate.setUTCDate(fridayDate.getUTCDate() + 1);\n }\n\n return fridayDate;\n}\n\nexport function lastMondayBefore(date: Date): Date {\n const monday = 1;\n const newDate = new Date(date);\n while (newDate.getDay() !== monday) {\n newDate.setDate(newDate.getDate() - 1);\n }\n return newDate;\n}\n\nexport function nextWeek(date: Date): Date {\n const ret = new Date();\n ret.setTime(date.getTime() + 1000 * 60 * 60 * 24 * 7);\n return ret;\n}\n\nexport function nextThursAfter(date: Date): Date {\n const thurs = 4;\n const newDate = new Date(date);\n while (newDate.getDay() !== thurs) {\n newDate.setDate(newDate.getDate() + 1);\n }\n return newDate;\n}\n\nexport function getMonthAbbrev(monthId: string): string {\n const monthIndex = parseInt(monthId.slice(4, 6));\n const monthAbbrevs = [\n \"JAN\", \"FEB\", \"MAR\", \"APR\", \"MAY\", \"JUN\",\n \"JUL\", \"AUG\", \"SEP\", \"OCT\", \"NOV\", \"DEC\"\n ];\n return monthAbbrevs[monthIndex];\n}\n\nexport function displayAsMinutes(timeInSeconds: number): string {\n const minutes = Math.floor(timeInSeconds / 60);\n const seconds = timeInSeconds % 60;\n return `${fixedNumOfDigits(minutes, 2)}:${fixedNumOfDigits(seconds, 2)}`;\n}\n\nexport function fixedNumOfDigits(value: number, numOfDigits: number): string {\n const stringifiedValue = value.toString();\n let finalDisplay = \"\";\n\n if (stringifiedValue.length < numOfDigits) {\n for (let i = 0; i < numOfDigits - stringifiedValue.length; i++) {\n finalDisplay += \"0\";\n }\n finalDisplay += stringifiedValue;\n } else {\n finalDisplay = stringifiedValue;\n }\n\n return finalDisplay;\n}",[],[181,295],"6096f910-3e4c-11f0-a0c2-76b3cceeab13","types.ts","6096fa00-3e4c-11f0-a0c2-76b3cceeab13",["D",1748715820732],"export interface Presentation {\n id: number;\n title: string;\n presenter: string;\n date: number;\n}\n\nexport interface Config {\n maxSignUps: number;\n placeholder: {\n name: string;\n title: string;\n };\n}\n\nexport const config: Config = {\n maxSignUps: 9,\n placeholder: {\n name: \"Carly Rae Jepsen\",\n title: \"How to Do Amazing Things\"\n }\n};",[],[181,303],["D",1748715820732],[215,216],[181],"b4a58e54-3e4c-11f0-850f-76b3cceeab13","index.tsx","b4a5907a-3e4c-11f0-850f-76b3cceeab13",["D",1748715961758],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport { PresentationsApp } from \"./components/App.tsx\";\nimport { parseDateFromURL, getNextFridayUtc } from \"../shared/utils.ts\";\nimport type { Presentation } from \"../shared/types.ts\";\n\n// Get initial data from server-side injection or fetch from API\nconst getInitialData = (): Presentation[] => {\n if (typeof window !== 'undefined' && (window as any).__INITIAL_DATA__) {\n return (window as any).__INITIAL_DATA__;\n }\n return [];\n};\n\n// This is the first day (in UTC) ever of RC presentations.\nconst firstThursday = Date.UTC(\n 2016, // year\n 1, // month (1 = February)\n 25, // day\n 21 // hour. 21:00 UTC is 4:00 PM EST which is the time that presentations begin in NYC\n);\n\nconst oneWeekInMilliseconds = 1000 * 60 * 60 * 24 * 7;\n\nfunction App() {\n const [presentations, setPresentations] = useState(getInitialData());\n const [loading, setLoading] = useState(false);\n\n let givenDate = parseDateFromURL(location.href);\n if (!givenDate) {\n givenDate = new Date();\n }\n\n // TODO (emily): Move this back to getNextThursUtc() after presentations on 7/5/24.\n // Note: the day of the week of the upcoming presentation determines how all past presentations\n // are displayed. All previous presentation sessions will now be shown as having occurred on a\n // Friday.\n const upcomingPresentationDay = getNextFridayUtc(givenDate);\n\n // 21:00 UTC is 4:00 PM EST which is the time that presentations begin in NYC.\n upcomingPresentationDay.setUTCHours(21);\n upcomingPresentationDay.setUTCMinutes(0);\n upcomingPresentationDay.setUTCSeconds(0);\n upcomingPresentationDay.setUTCMilliseconds(0);\n\n const fetchPresentations = async () => {\n setLoading(true);\n try {\n const response = await fetch('/api/presentations');\n const data = await response.json();\n setPresentations(data);\n } catch (error) {\n console.error('Error fetching presentations:', error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n // Only fetch if we don't have initial data\n if (presentations.length === 0) {\n fetchPresentations();\n }\n }, []);\n\n return (\n \n );\n}\n\nconst root = ReactDOM.createRoot(document.getElementById('presentationsApp')!);\nroot.render();",[],[187,313],["D",1748715961758],[213],[187],"55abec2c-3e4c-11f0-9c59-76b3cceeab13","index.ts",["D",1748715802417],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initDatabase, getPresentations, addPresentation, updatePresentation, deletePresentation } from \"./database/queries.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait initDatabase();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main page\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get initial data to avoid extra round-trips\n const presentations = await getPresentations();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes\napp.get(\"/api/presentations\", async c => {\n const presentations = await getPresentations();\n return c.json(presentations);\n});\n\napp.post(\"/api/presentations\", async c => {\n const body = await c.req.json();\n const { title, presenter } = body;\n \n if (!presenter || presenter.trim() === \"\") {\n return c.json({ error: \"Presenter name is required\" }, 400);\n }\n \n const id = await addPresentation(title || \"\", presenter, Date.now());\n return c.json({ id, title, presenter, date: Date.now() });\n});\n\napp.put(\"/api/presentations/:id\", async c => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const { title, presenter } = body;\n \n if (!presenter || presenter.trim() === \"\") {\n return c.json({ error: \"Presenter name is required\" }, 400);\n }\n \n await updatePresentation(parseInt(id), title || \"\", presenter);\n return c.json({ success: true });\n});\n\napp.delete(\"/api/presentations/:id\", async c => {\n const id = c.req.param(\"id\");\n await deletePresentation(parseInt(id));\n return c.json({ success: true });\n});\n\nexport default app.fetch;","present",[],[193,323],"5be48630-3e4c-11f0-a961-76b3cceeab13","queries.ts","5be48702-3e4c-11f0-a961-76b3cceeab13","8a143b6d-64b9-4948-8d28-70796e67a64b",29,["D",1748715812836],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'rc_presentations_v1';\n\nexport interface Presentation {\n id: number;\n title: string;\n presenter: string;\n date: number;\n}\n\nexport async function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL DEFAULT '',\n presenter TEXT NOT NULL,\n date INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport async function getPresentations(): Promise {\n const oneWeekInMilliseconds = 1000 * 60 * 60 * 24 * 7;\n const now = Date.now();\n const oneWeekAgo = now - oneWeekInMilliseconds;\n \n const result = await sqlite.execute(\n `SELECT id, title, presenter, date FROM ${TABLE_NAME} \n WHERE date >= ? AND date <= ?\n ORDER BY date ASC`,\n [oneWeekAgo, now + oneWeekInMilliseconds]\n );\n \n return result.rows.map(row => ({\n id: row[0] as number,\n title: row[1] as string,\n presenter: row[2] as string,\n date: row[3] as number,\n }));\n}\n\nexport async function addPresentation(title: string, presenter: string, date: number): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (title, presenter, date) VALUES (?, ?, ?)`,\n [title, presenter, date]\n );\n \n return result.lastInsertRowId as number;\n}\n\nexport async function updatePresentation(id: number, title: string, presenter: string): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET title = ?, presenter = ? WHERE id = ?`,\n [title, presenter, id]\n );\n}\n\nexport async function deletePresentation(id: number): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE id = ?`,\n [id]\n );\n}",[],[193,338,330],"database","5be49166-3e4c-11f0-a961-76b3cceeab13",["D",1748715812836],[210],[193,338],["D",1748715802417],[209,211],[193],["D",1748715613647],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":49},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_123":383,"_384":385,"_386":387,"_388":49,"_389":49,"_390":49,"_391":25,"_392":-5,"_393":-7,"_394":-7,"_395":63,"_396":49,"_397":49,"_398":-5,"_399":49,"_400":49,"_401":49,"_402":-5},"ENV",{"_354":355,"_356":357,"_358":87,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","9e167d8120a57de5d747867e0b686da51bcc19a4","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Sign Up to Present

All available presentation slots are full.

Diff · v48