182### Search Strategy
183
184We conducted a systematic search of PsycINFO, PubMed, and Web of Science databases using the following search terms: ("social media" OR "social networking" OR "Facebook" OR "Instagram" OR "TikTok" OR "Snapchat") AND ("mental health" OR "depression" OR "anxiety" OR "well-being" OR "psychological distress") AND ("adolescent" OR "teenager" OR "youth").`,
185
186 creative: `# The Forgotten Door
23 /\b(function|class|method|algorithm|implementation|interface|API|SDK)\b/i,
24 /\b(code|syntax|compiler|runtime|debug|exception|error|bug|fix)\b/i,
25 /\b(database|query|schema|table|index|key|value|record)\b/i,
26 /\b(hardware|software|firmware|driver|kernel|module|component)\b/i,
27 /\b(Fig\.|Figure|Table|Equation|Algorithm)\s+\d+/i,
126 }
127
128 console.log(`Weather forecast updated in the database.`);
129 return summary;
130}
1// Script to set up the telegram_chats table in SQLite
2// Run this script manually to create the database table
3
4// Import SQLite module
6
7- `index.ts` - Main entry point for the backend API
8- `database/` - Database setup and query functions
9- `routes/` - API route handlers
10
1import { Hono } from "https://esm.sh/hono@3.12.0";
2import { cors } from "https://esm.sh/@hono/cors@0.0.6";
3import { runMigrations } from "./database/migrations.ts";
4import authRoutes from "./routes/auth.ts";
5import trafficRoutes from "./routes/traffic.ts";
7import staticRoutes from "./routes/static.ts";
8
9// Initialize database
10await runMigrations();
11
3 updateUserLocation,
4 getUserLocation
5} from "../database/queries.ts";
6import { verifyToken } from "./auth.ts";
7
39 // Get user from email
40 const email = c.get("email");
41 const { getUserByEmail } = await import("../database/queries.ts");
42 const user = await getUserByEmail(email);
43
58 // Get user from email
59 const email = c.get("email");
60 const { getUserByEmail } = await import("../database/queries.ts");
61 const user = await getUserByEmail(email);
62
4 getRecentTrafficReports,
5 getTrafficReportsNearLocation
6} from "../database/queries.ts";
7import { verifyToken } from "./auth.ts";
8
45 // Get user from email
46 const email = c.get("email");
47 const { getUserByEmail } = await import("../database/queries.ts");
48 const user = await getUserByEmail(email);
49
1import { Hono } from "https://esm.sh/hono@3.12.0";
2import { createUser, getUserByEmail, updateUserLastLogin } from "../database/queries.ts";
3
4// Simple email verification token generation
1# Database Layer
2
3This directory contains the database setup and query functions for the SmartRoutes application.
4
5## Files
6
7- `migrations.ts` - Contains the database schema definitions and migration functions
8- `queries.ts` - Contains typed query functions for interacting with the database
9
10## Database Schema
11
12### Users Table