Val Town Code SearchReturn to Val Town

3import type { Todo, CreateTodoRequest, UpdateTodoRequest } from "../../shared/types.ts";
4
5export async function getAllTodos(): Promise<Todo[]> {
6  const result = await sqlite.execute(`
7    SELECT * FROM ${TABLE_NAME} 
13}
14
15export async function getTodoById(id: number): Promise<Todo | null> {
16  const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);
17  return result.rows[0] as Todo || null;
18}
19
20export async function createTodo(todo: CreateTodoRequest): Promise<Todo> {
21  const result = await sqlite.execute(`
22    INSERT INTO ${TABLE_NAME} (title, description, priority)
38}
39
40export async function updateTodo(id: number, updates: UpdateTodoRequest): Promise<Todo | null> {
41  const fields: string[] = [];
42  const values: any[] = [];
75}
76
77export async function updateTodoAIPriority(id: number, aiPriority: number, aiReasoning: string): Promise<void> {
78  await sqlite.execute(`
79    UPDATE ${TABLE_NAME} 
83}
84
85export async function deleteTodo(id: number): Promise<boolean> {
86  const result = await sqlite.execute(`DELETE FROM ${TABLE_NAME} WHERE id = ?`, [id]);
87  return result.changes > 0;

305        
306        <script>
307          async function clearUsers() {
308            if (confirm('Are you sure you want to clear all users?')) {
309              const response = await fetch('/debug/clear-users', { method: 'POST' });
471});
472
473// Helper functions
474async function initializeDatabase() {
475  // Users table
476  await sqlite.execute(`
529}
530
531async function hashPassword(password: string): Promise<string> {
532  // Simple hash for demo - use bcrypt in production
533  const encoder = new TextEncoder();
538}
539
540async function verifyPassword(password: string, hash: string): Promise<boolean> {
541  const passwordHash = await hashPassword(password);
542  return passwordHash === hash;
543}
544
545function generateRandomPassword(): string {
546  return Math.random().toString(36).slice(-8);
547}
548
549async function getUserById(userId: number) {
550  const result = await sqlite.execute(
551    "SELECT * FROM users WHERE id = ?",
557}
558
559async function getCurrentUser(c: any) {
560  const userId = getCookie(c, "user_id");
561  if (!userId) return null;
564}
565
566async function generateAIResponse(messages: any[], initialChallenge: string) {
567  const genAI = new GoogleGenerativeAI(Deno.env.get("GEMINI_API_KEY") || "");
568  const model = genAI.getGenerativeModel({ model: "gemini-2.0-flash-exp" });
626}
627
628function extractCategory(text: string, question: string): string | null {
629  // Simple category extraction based on keywords
630  const categories = {

326        });
327
328        function showLoginForm() {
329            console.log('showLoginForm called'); // Debug
330            const modal = document.getElementById('loginModal');
338        }
339
340        function hideLoginForm() {
341            const modal = document.getElementById('loginModal');
342            if (modal) {

9}
10
11export default function TodoList({ todos, onUpdate, onDelete }: TodoListProps) {
12  const [editingId, setEditingId] = useState<number | null>(null);
13  const [editTitle, setEditTitle] = useState("");

6}
7
8export default function TodoForm({ onAdd }: TodoFormProps) {
9  const [title, setTitle] = useState("");
10  const [description, setDescription] = useState("");

258
259    <script>
260        // Login Modal Functions
261        function showLoginModal() {
262            document.getElementById('loginModal').classList.remove('hidden');
263        }
264
265        function hideLoginModal() {
266            document.getElementById('loginModal').classList.add('hidden');
267            document.getElementById('loginError').classList.add('hidden');

5import TodoList from "./TodoList.tsx";
6
7export default function App() {
8  const [todos, setTodos] = useState<Todo[]>([]);
9  const [loading, setLoading] = useState(true);

3const TABLE_NAME = 'todos_v1';
4
5export async function runMigrations() {
6  // Create todos table
7  await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (

EmailCron1weekCron.tsx1 match

@vyatka•Updated 1 hour ago

3
4// Cron handler
5export default async function cronValHandler(interval: Interval) {
6  // Action
7  const now = new Date();

85
86// Initialize the website
87document.addEventListener('DOMContentLoaded', function() {
88    initializePortfolio();
89    initializeMobileMenu();
94
95// Mobile Menu Toggle
96function initializeMobileMenu() {
97    mobileMenuBtn.addEventListener('click', function() {
98        mobileMenu.classList.toggle('hidden');
99        const icon = mobileMenuBtn.querySelector('i');
105    const mobileLinks = mobileMenu.querySelectorAll('a');
106    mobileLinks.forEach(link => {
107        link.addEventListener('click', function() {
108            mobileMenu.classList.add('hidden');
109            const icon = mobileMenuBtn.querySelector('i');
114}
115
116// Portfolio Functions
117function initializePortfolio() {
118    renderPortfolioItems('all');
119    
120    filterBtns.forEach(btn => {
121        btn.addEventListener('click', function() {
122            const filter = this.getAttribute('data-filter');
123            
132}
133
134function renderPortfolioItems(filter) {
135    const filteredItems = filter === 'all' 
136        ? portfolioItems 
145}
146
147function createPortfolioItem(item, index) {
148    const div = document.createElement('div');
149    div.className = 'portfolio-item';
173
174// Scroll Animations
175function initializeScrollAnimations() {
176    const observerOptions = {
177        threshold: 0.1,
179    };
180    
181    const observer = new IntersectionObserver(function(entries) {
182        entries.forEach(entry => {
183            if (entry.isIntersecting) {
194
195// Smooth Scrolling for Navigation Links
196function initializeSmoothScrolling() {
197    document.querySelectorAll('a[href^="#"]').forEach(anchor => {
198        anchor.addEventListener('click', function(e) {
199            e.preventDefault();
200            const target = document.querySelector(this.getAttribute('href'));
211
212// Contact Form
213function initializeContactForm() {
214    contactForm.addEventListener('submit', async function(e) {
215        e.preventDefault();
216        
252
253// Notification System
254function showNotification(message, type = 'info') {
255    const notification = document.createElement('div');
256    notification.className = `fixed top-4 right-4 z-50 p-4 rounded-lg shadow-lg max-w-sm transform translate-x-full transition-transform duration-300 ${
288
289// Parallax Effect for Hero Section
290window.addEventListener('scroll', function() {
291    const scrolled = window.pageYOffset;
292    const parallaxElements = document.querySelectorAll('.floating-shape');
299
300// Add active navigation highlighting
301window.addEventListener('scroll', function() {
302    const sections = document.querySelectorAll('section[id]');
303    const navLinks = document.querySelectorAll('.nav-link');
321
322// Preload images for better performance
323function preloadImages() {
324    portfolioItems.forEach(item => {
325        const img = new Image();