{\n const id = crypto.randomUUID();\n const now = new Date().toISOString();\n \n const form: Form = {\n id,\n title: formData.title,\n description: formData.description,\n fields: formData.fields.map(field => ({\n ...field,\n id: crypto.randomUUID()\n })),\n settings: formData.settings,\n createdAt: now,\n updatedAt: now\n };\n\n await sqlite.execute(\n `INSERT INTO ${FORMS_TABLE} (id, title, description, fields, settings, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n form.id,\n form.title,\n form.description || null,\n JSON.stringify(form.fields),\n JSON.stringify(form.settings),\n form.createdAt,\n form.updatedAt\n ]\n );\n\n return form;\n}\n\nexport async function getForm(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${FORMS_TABLE} WHERE id = ?`,\n [id]\n );\n\n if (result.length === 0) return null;\n\n const row = result[0];\n return {\n id: row.id as string,\n title: row.title as string,\n description: row.description as string || undefined,\n fields: JSON.parse(row.fields as string),\n settings: JSON.parse(row.settings as string),\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string\n };\n}\n\nexport async function getAllForms(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${FORMS_TABLE} ORDER BY created_at DESC`\n );\n\n return result.map(row => ({\n id: row.id as string,\n title: row.title as string,\n description: row.description as string || undefined,\n fields: JSON.parse(row.fields as string),\n settings: JSON.parse(row.settings as string),\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string\n }));\n}\n\nexport async function updateForm(id: string, updates: Partial): Promise {\n const existingForm = await getForm(id);\n if (!existingForm) return null;\n\n const updatedForm: Form = {\n ...existingForm,\n ...updates,\n fields: updates.fields ? updates.fields.map(field => ({\n ...field,\n id: field.id || crypto.randomUUID()\n })) : existingForm.fields,\n updatedAt: new Date().toISOString()\n };\n\n await sqlite.execute(\n `UPDATE ${FORMS_TABLE} \n SET title = ?, description = ?, fields = ?, settings = ?, updated_at = ?\n WHERE id = ?`,\n [\n updatedForm.title,\n updatedForm.description || null,\n JSON.stringify(updatedForm.fields),\n JSON.stringify(updatedForm.settings),\n updatedForm.updatedAt,\n id\n ]\n );\n\n return updatedForm;\n}\n\nexport async function deleteForm(id: string): Promise {\n // Delete all responses first\n await sqlite.execute(`DELETE FROM ${RESPONSES_TABLE} WHERE form_id = ?`, [id]);\n \n // Delete the form\n const result = await sqlite.execute(`DELETE FROM ${FORMS_TABLE} WHERE id = ?`, [id]);\n return result.length > 0;\n}\n\nexport async function createFormResponse(formId: string, data: Record, ipAddress?: string): Promise {\n const id = crypto.randomUUID();\n const submittedAt = new Date().toISOString();\n\n const response: FormResponse = {\n id,\n formId,\n data,\n submittedAt,\n ipAddress\n };\n\n await sqlite.execute(\n `INSERT INTO ${RESPONSES_TABLE} (id, form_id, data, submitted_at, ip_address)\n VALUES (?, ?, ?, ?, ?)`,\n [id, formId, JSON.stringify(data), submittedAt, ipAddress || null]\n );\n\n return response;\n}\n\nexport async function getFormResponses(formId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESPONSES_TABLE} WHERE form_id = ? ORDER BY submitted_at DESC`,\n [formId]\n );\n\n return result.map(row => ({\n id: row.id as string,\n formId: row.form_id as string,\n data: JSON.parse(row.data as string),\n submittedAt: row.submitted_at as string,\n ipAddress: row.ip_address as string || undefined\n }));\n}\n\nexport async function getFormStats(formId: string): Promise {\n const responses = await getFormResponses(formId);\n \n return {\n totalResponses: responses.length,\n lastSubmission: responses.length > 0 ? responses[0].submittedAt : undefined\n };\n}","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/kyumz/Forms/code/backend/database/queries.ts","extension","actionData","errors"]