1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {
1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {
3import React, { useEffect, useState } from "https://esm.sh/react@18.2.0";
4
5// Simulated database for stored XSS
6const storedComments: { id: number; text: string }[] = [];
7
1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {
1export async function storeTask(task) {
2 console.log(Storing task in database: \);
3 // Here you would use Val Town's storage APIs
4 return { success: true, id: task.id || crypto.randomUUID() };
701 const SCHEMA_VERSION = 2;
702
703 // Set up database tables
704 await sqlite.execute(`
705 CREATE TABLE IF NOT EXISTS ${KEY}_students_${SCHEMA_VERSION} (
1import createFileTree from "https://esm.town/v/nbbaier/createFileTree";
2import { tableName } from "https://esm.town/v/nbbaier/hn_notifier/backend/database/migrations.ts";
3import * as db from "https://esm.town/v/nbbaier/hn_notifier/backend/database/queries.ts";
4import type { DBItem } from "https://esm.town/v/nbbaier/hn_notifier/shared/types.ts";
5import sqliteRowsToObject from "https://esm.town/v/nbbaier/sqliteRowsToObject";
30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {
13## A Few Honkin' Notes
14
15### database migrations need love and care 🫂
16
17Not totally sure how to generate and apply drizzle migrations yet!