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",134,"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 inputType = (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, inputType(type, name)]);\n });\n } catch (e) {\n console.error(e);\n }\n return struct;\n};\n\nasync function getUsersList() {\n const list = await sqlite.execute(`\n SELECT id, first_name, last_name, email, membership_until \n FROM users ORDER BY membership_until ASC\n `);\n return list.rows;\n}\n\nasync function getFormData(req: Request, structure) {\n if (req.method !== \"POST\") return await getUsersList();\n const data = await req.formData();\n if (data.get(\"action\") === \"submit\") {\n let namesList = \"\";\n let dataList = \"\";\n structure.forEach(v => {\n const name = v[0];\n if (namesList.length > 1) {\n namesList += \", \";\n dataList += \", \";\n }\n namesList += name;\n const getVal = name === \"membership_until\"\n ? Number(Date.parse(data.get(name) as string) / 1000)\n : data.get(name);\n dataList += `'${getVal}'`;\n });\n const query = `INSERT INTO users (${namesList})\n VALUES(${dataList});`;\n await sqlite.execute(query);\n }\n if (data.get(\"action\") === \"update-date\") {\n const query = `\n UPDATE users \n SET membership_until=${Number(Date.parse(data.get(\"timestamp\") as string) / 1000)}\n WHERE id=${data.get(\"id\")};\n `;\n await sqlite.execute(query);\n }\n if (data.get(\"action\") === \"delete\") {\n const query = `\n DELETE FROM users WHERE id=${data.get(\"id\")};\n `;\n await sqlite.execute(query);\n }\n return await getUsersList();\n}\n\nconst css = `\n html {\n font-family: Roboto, \"Open Sans\", sans-serif;\n background: #eceaea;\n}\nh1 {\n text-align: center;\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 margin-right: 0.25rem;\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.users-table {\n max-width: 750px;\n margin: auto;\n table {\n width: 100%;\n border-collapse: separate;\n border-bottom: 1px solid #e5e5e5;\n td {\n background: white;\n padding: 4px;\n &.icon {\n width: 47px;\n }\n }\n }\n button {\n margin: 0;\n }\n}\n\n`;\n\nconst js = `\n let addOpen = false;\n const addClass = \" open\";\n const addButton = document.querySelector(\".add-user_button\");\n const cancelButton = document.querySelector(\".cancel-add-user\");\n const form = document.querySelector(\".add-user_container\");\n const cancel = ()=>{\n addOpen = !addOpen;\n if(addOpen){\n form.className = form.className + addClass;\n }else{\n form.className = form.className.replace(addClass,\"\");\n }\n };\n addButton.onclick = cancel;\n cancelButton.onclick = (e) => {\n e.preventDefault();\n cancel();\n }\n`;\n\nconst UserRow = ({ user }) => {\n const [id, name, surname, email, timestamp] = user;\n return (\n \n {name} {surname}\n {email}\n

Diff · v134