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);
198```
199โโโ backend/
200โ โโโ database/
201โ โ โโโ migrations.ts # Schema definitions
202โ โ โโโ queries.ts # DB query functions
257 ```
258
259### Database Patterns
260- Run migrations on startup or comment out for performance
261- Change table names when modifying schemas rather than altering
14 console.log("New dental form submission:", { name, phone });
15
16 // Optional: Trigger Twilio, store in database, etc.
17
18 return new Response(
3import { Hono } from "https://esm.sh/hono@3.11.7";
4import { readFile } from "https://esm.town/v/std/utils@85-main/index.ts";
5import { runMigrations, seedSampleData } from "./database/migrations.ts";
6import { PropertyQueries } from "./database/queries.ts";
7import authRoutes from "./routes/auth.ts";
8import listingsRoutes from "./routes/listings.ts";
17});
18
19// Initialize database on startup
20let dbInitialized = false;
21async function initializeDatabase() {
22 if (!dbInitialized) {
23 console.log("Initializing database...");
24 await runMigrations();
25
31
32 dbInitialized = true;
33 console.log("Database initialized successfully!");
34 }
35}
37// Health check endpoint
38app.get('/api/health', async (c) => {
39 await initializeDatabase();
40
41 return c.json({
95app.get('/api/stats', async (c) => {
96 try {
97 await initializeDatabase();
98
99 // Get basic statistics
142app.get('/', async (c) => {
143 try {
144 await initializeDatabase();
145
146 let html = await readFile("/frontend/index.html", import.meta.url);
8 InspectionQueries,
9 UserQueries
10} from "../database/queries.ts";
11import { requireAuth } from "./auth.ts";
12import type {
4import { sign, verify } from "https://esm.sh/hono@3.11.7/jwt";
5import { setCookie, getCookie, deleteCookie } from "https://esm.sh/hono@3.11.7/cookie";
6import { UserQueries } from "../database/queries.ts";
7import type { AuthResponse, LoginForm, RegisterForm } from "../../shared/types.ts";
8import { isValidEmail, isValidNigerianPhone, validatePassword } from "../../shared/utils.ts";
1// Database query functions for Enugu Rents
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
1// Database migrations for Enugu Rents
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
5// Run all migrations
6export async function runMigrations() {
7 console.log("Running database migrations...");
8
9 await createUsersTable();
13 await createInspectionRequestsTable();
14
15 console.log("Database migrations completed successfully!");
16}
17
17```
18โโโ backend/
19โ โโโ database/
20โ โ โโโ migrations.ts # Database schema setup
21โ โ โโโ queries.ts # Database query functions
22โ โโโ routes/
23โ โ โโโ auth.ts # Authentication routes
73- **Frontend**: React 18.2.0 with TypeScript
74- **Backend**: Hono framework
75- **Database**: SQLite
76- **Styling**: TailwindCSS
77- **Icons**: Lucide React icons
9- [ ] make it one click to branch off like old jp townie demos
10- [ ] opentownie as a pr bot
11- [ ] give it the ability to see its own client-side and server-side logs by building a middleware that shoves them into a SQL light database date and then give it a tool to access them
12- [ ] do a browser use or screenshot thing to give it access to its own visual output
13- [ ] Have it default to creating a new branch off main