{\n const id = generateId();\n \n // Get max sort order\n const orderResult = await sqlite.execute(`\n SELECT COALESCE(MAX(sort_order), -1) + 1 as next_order\n FROM ${SECTIONS_TABLE}\n WHERE user_id = ?\n `, [userId]);\n const sortOrder = orderResult.rows[0].next_order as number;\n \n await sqlite.execute(`\n INSERT INTO ${SECTIONS_TABLE} (id, user_id, name, sort_order)\n VALUES (?, ?, ?, ?)\n `, [id, userId, name, sortOrder]);\n \n return {\n id,\n userId,\n name,\n sortOrder,\n isHidden: false,\n createdAt: new Date().toISOString(),\n updatedAt: new Date().toISOString(),\n };\n}\n\nexport async function updateSection(id: string, userId: string, updates: { name?: string; sortOrder?: number; isHidden?: boolean }): Promise {\n const setClauses: string[] = ['updated_at = CURRENT_TIMESTAMP'];\n const params: (string | number)[] = [];\n \n if (updates.name !== undefined) {\n setClauses.push('name = ?');\n params.push(updates.name);\n }\n if (updates.sortOrder !== undefined) {\n setClauses.push('sort_order = ?');\n params.push(updates.sortOrder);\n }\n if (updates.isHidden !== undefined) {\n setClauses.push('is_hidden = ?');\n params.push(updates.isHidden ? 1 : 0);\n }\n \n params.push(id, userId);\n \n await sqlite.execute(`\n UPDATE ${SECTIONS_TABLE}\n SET ${setClauses.join(', ')}\n WHERE id = ? AND user_id = ?\n `, params);\n}\n\nexport async function deleteSection(id: string, userId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SECTIONS_TABLE} WHERE id = ? AND user_id = ?`, [id, userId]);\n}\n\n// ============ GOAL QUERIES ============\n\nexport async function getGoalsByUser(userId: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, user_id, section_id, name, sort_order, is_hidden, created_at, updated_at\n FROM ${GOALS_TABLE}\n WHERE user_id = ?\n ORDER BY sort_order ASC\n `, [userId]);\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.user_id as string,\n sectionId: row.section_id as string,\n name: row.name as string,\n sortOrder: row.sort_order as number,\n isHidden: Boolean(row.is_hidden),\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n }));\n}\n\nexport async function createGoal(userId: string, sectionId: string, name: string): Promise {\n const id = generateId();\n \n // Get max sort order within the section\n const orderResult = await sqlite.execute(`\n SELECT COALESCE(MAX(sort_order), -1) + 1 as next_order\n FROM ${GOALS_TABLE}\n WHERE section_id = ?\n `, [sectionId]);\n const sortOrder = orderResult.rows[0].next_order as number;\n \n await sqlite.execute(`\n INSERT INTO ${GOALS_TABLE} (id, user_id, section_id, name, sort_order)\n VALUES (?, ?, ?, ?, ?)\n `, [id, userId, sectionId, name, sortOrder]);\n \n return {\n id,\n userId,\n sectionId,\n name,\n sortOrder,\n isHidden: false,\n createdAt: new Date().toISOString(),\n updatedAt: new Date().toISOString(),\n };\n}\n\nexport async function updateGoal(id: string, userId: string, updates: { name?: string; sectionId?: string; sortOrder?: number; isHidden?: boolean }): Promise {\n const setClauses: string[] = ['updated_at = CURRENT_TIMESTAMP'];\n const params: (string | number)[] = [];\n \n if (updates.name !== undefined) {\n setClauses.push('name = ?');\n params.push(updates.name);\n }\n if (updates.sectionId !== undefined) {\n setClauses.push('section_id = ?');\n params.push(updates.sectionId);\n }\n if (updates.sortOrder !== undefined) {\n setClauses.push('sort_order = ?');\n params.push(updates.sortOrder);\n }\n if (updates.isHidden !== undefined) {\n setClauses.push('is_hidden = ?');\n params.push(updates.isHidden ? 1 : 0);\n }\n \n params.push(id, userId);\n \n await sqlite.execute(`\n UPDATE ${GOALS_TABLE}\n SET ${setClauses.join(', ')}\n WHERE id = ? AND user_id = ?\n `, params);\n}\n\nexport async function deleteGoal(id: string, userId: string): Promise {\n await sqlite.execute(`DELETE FROM ${GOALS_TABLE} WHERE id = ? AND user_id = ?`, [id, userId]);\n}\n\n// ============ ENTRY QUERIES ============\n\nexport async function getEntriesByDateRange(userId: string, startDate: string, endDate: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, user_id, goal_id, date, color, value, created_at, updated_at\n FROM ${ENTRIES_TABLE}\n WHERE user_id = ? AND date >= ? AND date <= ?\n ORDER BY date ASC\n `, [userId, startDate, endDate]);\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.user_id as string,\n goalId: row.goal_id as string,\n date: row.date as string,\n color: row.color as 'red' | 'yellow' | 'green',\n value: row.value as string | null,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n }));\n}\n\nexport async function upsertEntry(userId: string, goalId: string, date: string, color: 'red' | 'yellow' | 'green', value: string | null): Promise {\n const id = generateId();\n \n await sqlite.execute(`\n INSERT INTO ${ENTRIES_TABLE} (id, user_id, goal_id, date, color, value)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(goal_id, date) DO UPDATE SET\n color = excluded.color,\n value = excluded.value,\n updated_at = CURRENT_TIMESTAMP\n `, [id, userId, goalId, date, color, value]);\n \n // Return the entry (either newly created or updated)\n const result = await sqlite.execute(`\n SELECT id, user_id, goal_id, date, color, value, created_at, updated_at\n FROM ${ENTRIES_TABLE}\n WHERE goal_id = ? AND date = ?\n `, [goalId, date]);\n \n const row = result.rows[0];\n return {\n id: row.id as string,\n userId: row.user_id as string,\n goalId: row.goal_id as string,\n date: row.date as string,\n color: row.color as 'red' | 'yellow' | 'green',\n value: row.value as string | null,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function deleteEntry(goalId: string, date: string, userId: string): Promise {\n await sqlite.execute(`\n DELETE FROM ${ENTRIES_TABLE} \n WHERE goal_id = ? AND date = ? AND user_id = ?\n `, [goalId, date, userId]);\n}\n\n","deleted","label",[175,176,157],"backend","database","permalink","https://www.val.town/x/shapedlines/mosaic/code/backend/database/queries.ts","extension","actionData","errors"]