Val Town Code SearchReturn to Val Town

6});
7
8export async function getDatabase(id: string) {
9  // get database
10  try {
11    const database = await notion.databases.retrieve({
12      database_id: id,
13    });
14    return database;
15  } catch (error: any) {
16    return {

1import { Hono } from "npm:hono";
2import { getDatabase } from "../../controllers/getDatabase.ts";
3
4const app = new Hono();
9  // hit the controller to return data
10  try {
11    const data = await getDatabase(id);
12    //
13    console.log(data);

3// Import route modules
4import cobrowse from "./cobrowse.ts";
5import database from "./database.ts";
6import demo from "./demo.ts";
7import page from "./page.ts";
12
13// mount routes
14app.route("/db", database);
15app.route("/page", page);
16app.route("/cobrowse", cobrowse);

7
8export async function getAllInteractionsPages() {
9  const databaseId = Deno.env.get("GLANCE_INTERACTIONS_DB_ID");
10
11  if (!databaseId) {
12    throw new Error(
13      "GLANCE_INTERACTIONS_DB_ID environment variable is not set"
16
17  try {
18    const response = await notion.databases.query({
19      database_id: databaseId,
20    });
21
37
38export async function getAllInteractionsPagesWithPagination() {
39  const databaseId = Deno.env.get("GLANCE_INTERACTIONS_DB_ID");
40
41  if (!databaseId) {
42    throw new Error(
43      "GLANCE_INTERACTIONS_DB_ID environment variable is not set"
51
52    while (hasMore) {
53      const response = await notion.databases.query({
54        database_id: databaseId,
55        start_cursor: startCursor,
56      });

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import itineraryRoutes from "./routes/itinerary.ts";
4import staticRoutes from "./routes/static.ts";
11});
12
13// Initialize database
14await runMigrations();
15

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema setup
19│   │   └── queries.ts       # Itinerary CRUD operations
20│   ├── routes/

21## Further resources
22
23- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a bigger example project, with a SQLite database table, queries, client-side CSS, a favicon, and shared code that runs on both client and server.

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import expenses from "./routes/expenses.ts";
5import goals from "./routes/goals.ts";
15});
16
17// Initialize database on startup
18await runMigrations();
19
69              <p class="text-sm text-blue-800">
70                <strong>API Status:</strong> ✅ Backend is running<br>
71                <strong>Database:</strong> ✅ Initialized<br>
72                <strong>Frontend:</strong> ❌ Not found
73              </p>

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getUser, updateUser, setBudget, getBudgets } from "../database/queries.ts";
3import { getMonthYear } from "../../shared/utils.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getMonthlyReport, getCategorySpending, getUser, getGoals, getBudgets } from "../database/queries.ts";
3import { generateSavingsInsights, generateMotivationalMessage, getMonthYear } from "../../shared/utils.ts";
4