Dynamic Model Builder

Dynamic Model Builder

\n \n {status.message && (\n

\n {status.message}\n

\n )}\n\n setModelName(e.target.value.replace(/[^a-zA-Z0-9_]/g, ''))}\n style={{ width: '100%', padding: '8px', marginBottom: '10px' }}\n />\n \n

\n setCurrentField({\n ...currentField, \n name: e.target.value.replace(/[^a-zA-Z0-9_]/g, '')\n })}\n style={{ flex: 1, padding: '8px' }}\n />\n \n \n

\n\n

Current Fields:

\n {fields.map((field, index) => (\n

\n {field.name} ({field.type})\n \n

\n ))}\n

\n\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"settingWebAppWithUserModelInterface\";\n\n // Ensure models table exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_models (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n fields TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle POST requests\n if (request.method === 'POST') {\n try {\n const body = await request.json();\n \n // Validate request\n if (body.action !== 'create-model') {\n return new Response(JSON.stringify({ \n success: false,\n message: 'Invalid action' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n const { modelName, fields } = body;\n\n // Validate inputs\n if (!modelName || !fields || fields.length === 0) {\n return new Response(JSON.stringify({ \n success: false,\n message: 'Model name and fields are required' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Sanitize model name\n const sanitizedModelName = modelName.replace(/[^a-zA-Z0-9_]/g, '').toLowerCase();\n\n // Validate and sanitize fields\n const sanitizedFields = fields.map(f => ({\n name: f.name.replace(/[^a-zA-Z0-9_]/g, ''),\n type: f.type\n })).filter(f => {\n const reservedNames = ['id', 'ID', '_id', 'created_at', 'updated_at'];\n return !reservedNames.includes(f.name);\n });\n\n // Prevent duplicate field names\n const uniqueFields = Array.from(new Set(sanitizedFields.map(f => f.name)))\n .map(name => sanitizedFields.find(f => f.name === name)!)\n .slice(0, 20); // Limit to 20 fields to prevent abuse\n\n // Create dynamic table\n const tableFields = uniqueFields.map(f => {\n return `${f.name} ${\n f.type === 'string' ? 'TEXT' : \n f.type === 'number' ? 'REAL' : \n f.type === 'boolean' ? 'INTEGER' : \n f.type === 'date' ? 'DATETIME' : 'TEXT'\n }`;\n }).join(', ');\n\n // Execute table creation with explicit id column\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_${sanitizedModelName} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n ${tableFields}\n )\n `);\n\n // Store model definition\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${KEY}_models (name, fields) VALUES (?, ?)\n `, [sanitizedModelName, JSON.stringify(uniqueFields)]);\n\n return new Response(JSON.stringify({ \n success: true,\n message: `Model ${sanitizedModelName} created successfully!`,\n modelName: sanitizedModelName,\n fields: uniqueFields\n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n\n } catch (error) {\n console.error('Model creation error:', error);\n return new Response(JSON.stringify({ \n success: false,\n message: error instanceof Error ? error.message : 'An unexpected error occurred' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Render the main page\n return new Response(`\n \n \n Dynamic Model Builder\n \n \n \n \n

\n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/davidho123/settingWebAppWithUserModelInterface/code/main.tsx","extension","actionData","errors"]