Users management

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":49,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",64,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","20c228c0-277a-11f0-b46e-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/preact */\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { render } from \"npm:preact-render-to-string\";\n\nconst input_type = (type, name) => {\n const displayName = name.replace(\"_\", \" \");\n switch (type) {\n case \"INTEGER\":\n return (\n

\n {displayName}\n \n

\n );\n case \"TIMESTAMP\":\n return (\n

\n {displayName}\n \n

\n );\n }\n return (\n

\n {displayName}\n \n

\n );\n};\n\nconst getDatabaseStructure = async () => {\n let struct = [];\n try {\n const table = await sqlite.execute(\"PRAGMA table_info(users);\");\n const rows = await table.rows;\n const row = rows;\n const arr = Array.from(row);\n arr.forEach(v => {\n const name = v[1];\n const type = v[2];\n if (name === \"id\") return;\n struct.push([name, input_type(type, name)]);\n });\n } catch (e) {\n console.error(e);\n }\n return struct;\n};\n\nasync function getFormData(req: Request) {\n const data = await req.formData();\n return {\n name: data.get(\"name\"),\n age: data.get(\"age\"),\n };\n}\n\nconst css = `\n html {\n font-family: Roboto, \"Open Sans\", sans-serif;\n}\n input {\n display: inline-block;\n padding: 0 16px 0 12px;\n width: 100%;\n line-height: 30px;\n height: 32px;\n border: 1px solid #dddbda;\n border-radius: 4px;\n background-color: #fff;\n color: rgb(8, 7, 7);\n transition: border .1s linear,background-color .1s linear;\n}\n input:focus{\n border-color: #1b96ff;\n color: var(--sds-c-input-text-color-focus);\n box-shadow: rgb(1, 118, 211) 0px 0px 3px 0px;\n}\n button, .add-user_button {\n margin-top: 1rem;\n display: inline-block;\n outline: none;\n cursor: pointer;\n padding: 0 16px;\n background-color: #fff;\n border-radius: 0.25rem;\n border: 1px solid #0070d2;\n color: #0070d2;\n font-size: 13px;\n line-height: 30px;\n font-weight: 400;\n text-align: center;\n}\n button:hover {\n background-color: #f4f6f9;\n}\n .add-user_container {\n max-width: 500px;\n margin: auto;\n .add-user_form{\n display: none;\n }\n .add-user_button {\n display:block;\n }\n}\n .add-user_container.open {\n .add-user_form{\n display: block;\n }\n .add-user_button {\n display:none;\n }\n}\n\n`;\n\nconst js = `\n let addOpen = false;\n const addClass = \" open\";\n const button = document.querySelector(\".add-user_button\");\n const form = document.querySelector(\".add-user_container\");\n button.onclick=()=>{\n addOpen = !addOpen;\n if(addOpen){\n form.className = form.className + addClass;\n }else{\n form.className = form.className.replace(addClass,\"\");\n }\n };\n`;\n\nexport default async function(req: Request) {\n const struct = await getDatabaseStructure();\n return new Response(\n render(\n \n \n Users management\n

Diff · v64