Val Town Code SearchReturn to Val Town

2import { sqlite } from "https://esm.town/v/std/sqlite";
3
4export default async function(req: Request): Promise<Response> {
5  const TABLE_NAME = "lab_login_users_with_times";
6  const body = await req.json();

2import { sqlite } from "https://esm.town/v/std/sqlite";
3
4export default async function(req: Request): Promise<Response> {
5  const TABLE_NAME = "lab_login_users_with_times";
6

2import { fetchJSON } from "https://esm.town/v/stevekrouse/fetchJSON";
3
4export async function dailyDadJoke() {
5  let { setup, punchline } = await fetchJSON("https://official-joke-api.appspot.com/random_joke");
6  return email({

6);
7
8export async function uptimeCheck(url: string) {
9  let ok = true;
10  let reason: string;

33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
35- [x] add export to CSV, and JSON (CSV and JSON helper functions written in [this val](https://www.val.town/v/nbbaier/sqliteExportHelpers). Thanks to @pomdtr for merging the initial version!)
36- [x] add listener for cmd+enter to submit query

3import { sqlite } from "https://esm.town/v/std/sqlite";
4
5export default async function(req: Request): Promise<Response> {
6  const body = await req.json();
7  let { username, password } = body;

6);
7
8export async function uptimeCheck(url: string) {
9  let reason: string, status: number, end: number;
10  let ok = true;

5import { renderToString } from "npm:react-dom/server";
6
7function StatusRow({ rows }) {
8  return (
9    <div className="w-full flex flex-col space-y-2">
28}
29
30function StatusSection({ url, rows }) {
31  const sectionRows = rows.filter(row => row[0] === url);
32  const percentUp = Math.round((sectionRows.filter(row => row[1]).length / sectionRows.length) * 100);
44}
45
46export default async function(req: Request): Promise<Response> {
47  const { rows } = await sqlite.execute(
48    "select url, ok, duration, timestamp from uptime order by timestamp desc limit 200",

3import { sqlite } from "https://esm.town/v/std/sqlite";
4
5export default async function(req: Request): Promise<Response> {
6  const TABLE_NAME = "lab_login_users_with_times";
7  const body = await req.json();

2import { sqlite } from "https://esm.town/v/std/sqlite";
3
4export default async function(req: Request): Promise<Response> {
5  const TABLE_NAME = "lab_login_users_with_times";
6  const body = await req.json();