Val Town Code SearchReturn to Val Town

136                    <div>
137                        <h3 class="text-xl font-medium text-blue-300">4. Storage</h3>
138                        <p class="mt-1">The generated blog is saved in a database so you can access it later using the same link.</p>
139                    </div>
140                </div>

11});
12
13// Sample data - in a real app, this would come from a database
14const sampleGalleryItems: GalleryItem[] = [
15  {

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

5from datetime import datetime, timedelta
6
7from database.connection import get_db_connection, prepare_json_field, parse_json_field
8from database.models import (
9    Store, StoreCreate, Product, ProductCreate, Transaction, TransactionCreate,
10    Category, CategoryCreate, FinancialHealth, DashboardData, ApiResponse,

6from datetime import datetime
7
8# Database configuration
9DB_CONFIG = {
10    'host': os.getenv('MYSQL_HOST', 'localhost'),
12    'user': os.getenv('MYSQL_USER', 'root'),
13    'password': os.getenv('MYSQL_PASSWORD', ''),
14    'database': os.getenv('MYSQL_DATABASE', 'storefront_builder'),
15    'charset': 'utf8mb4',
16    'collation': 'utf8mb4_unicode_ci'
17}
18
19class DatabaseConnection:
20    def __init__(self):
21        self.connection = None
71            return False
72
73# Global database connection instance
74db = DatabaseConnection()
75
76async def get_db_connection():
79    return db
80
81async def init_database():
82    """Initialize database and create tables if they don't exist"""
83    try:
84        # First, create database if it doesn't exist
85        temp_config = DB_CONFIG.copy()
86        temp_config.pop('database', None)
87        
88        temp_connection = mysql.connector.connect(**temp_config)
89        temp_cursor = temp_connection.cursor()
90        
91        temp_cursor.execute(f"CREATE DATABASE IF NOT EXISTS {DB_CONFIG['database']} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci")
92        temp_cursor.close()
93        temp_connection.close()
94        
95        # Now connect to the database and create tables
96        await db.connect()
97        
99        await create_tables()
100        
101        print("Database initialized successfully!")
102        
103    except Error as e:
104        print(f"Error initializing database: {e}")
105        raise e
106

6import json
7from pathlib import Path
8from database.connection import get_db_connection, init_database
9from routes.api import router as api_router
10
20)
21
22# Initialize database on startup
23@app.on_event("startup")
24async def startup_event():
25    await init_database()
26
27# Include API routes

22- **Frontend:** HTML5, CSS3, Vanilla JavaScript
23- **Backend:** Python with FastAPI framework
24- **Database:** MySQL with real-time updates
25- **Animations:** GSAP, Three.js, Matter.js
26- **Styling:** TailwindCSS with custom animations
31```
32├── backend/
33│   ├── database/
34│   │   ├── models.py        # Database models
35│   │   ├── connection.py    # MySQL connection
36│   │   └── migrations.py    # Schema definitions

186  
187  try {
188    // Initialize database table
189    await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
190      id INTEGER PRIMARY KEY AUTOINCREMENT,

170  
171  try {
172    // Initialize database table
173    await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
174      id INTEGER PRIMARY KEY AUTOINCREMENT,
670  
671  try {
672    // Initialize database table
673    await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
674      id INTEGER PRIMARY KEY AUTOINCREMENT,

31### Backend
32- Hono framework for API routes
33- SQLite database for data persistence
34- RESTful API design
35- File handling for document uploads
36- Session management
37
38### Database Schema
39- Applications table for PAN applications
40- Documents table for uploaded files