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!
6import usersApi from "./app/users.ts";
7import { db } from "./db/client.ts";
8import { migrateDatabase } from "./db/migrate.ts";
9
10// Migrate database on startup to make sure the proper table exists to store users
11// NOTE - Please comment on the template project if you have ideas on how to do migrations more cleanly on Valtown
12await migrateDatabase();
13
14const app = new Hono<AppType>();
15
16/**
17 * Middleware for setting up the database and storing it on the Hono app's context
18 */
19app.use(async (c, next) => {
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> {
5Fork of [nbbaier/sqliteDump](https://val.town/v/nbbaier/sqliteDump) with a web interface.
6
7> A utility function that generates SQL statements to dump the data and schema of tables in a SQLite database.
8
9## Usage
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> {