Drag handle to resize panel

\n\t\t\t\t\n\t\t\t

\n\n\t\t\t

\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\n\t\t\t\t\n\t\t\t\t\tloading...\n\t\t\t\t\n\t\t\t

\n\t\t\n\t);\n};\n",[],[150,169],{"_102":178,"_95":179,"_151":180,"_153":152,"_154":136,"_155":181,"_157":158,"_104":182,"_99":183,"_160":173,"_162":184,"_163":22,"_164":-5,"_165":185,"_98":186},"b37eb466-9968-11f0-b5da-0224a6c84d84","icons.tsx","a4a40a6e-98f4-11f0-a0e0-0224a6c84d84",104,["D",1758733541543],2,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nconst iconSize = \"1.125rem\";\n\nexport function RunSVG() {\n\treturn (\n\t\t\n\t\t\t\n\t\t\n\t);\n}\n\nexport function TableSVG() {\n\treturn (\n\t\t\n\t\t\t\n\t\t\n\t);\n}\n\nexport function ViewSVG() {\n\treturn (\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\n\t);\n}\n",[],[150,179],{"_102":188,"_95":189,"_151":190,"_153":152,"_154":136,"_155":191,"_157":158,"_104":192,"_99":32,"_160":173,"_162":193,"_163":22,"_164":-5,"_165":194,"_98":195},"b398a2cc-9968-11f0-b5da-0224a6c84d84","separator.tsx","b398a376-9968-11f0-b5da-0224a6c84d84",108,["D",1758733541709],"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport type { FC } from \"https://esm.sh/hono@4.9.8/dist/types/jsx/base\";\n\nexport const Separator: FC = (props) => {\n\tconst isResizer = props.isResizer;\n\tif (isResizer) {\n\t\treturn (\n\t\t\t\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t\tDrag handle to resize panel\n\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t

\n\t\t\t\n\t\t);\n\t}\n\treturn (\n\t\t\n\t);\n};\n",[],[150,189],{"_102":197,"_95":198,"_151":199,"_153":152,"_154":136,"_155":200,"_157":158,"_104":201,"_99":32,"_160":173,"_162":202,"_163":22,"_164":-5,"_165":203,"_98":204},"b388863a-9968-11f0-bc7c-0224a6c84d84","table-list.tsx","b38886e4-9968-11f0-bc7c-0224a6c84d84",106,["D",1758733541612],"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport type { FC } from \"https://esm.sh/hono@latest/jsx\";\nimport { TableSVG, ViewSVG } from \"./icons.tsx\";\n\nexport const TablesList: FC = (props) => {\n\treturn (\n\t\t

\n\t\t\t{props.tables.map((item) => {\n\t\t\t\treturn (\n\t\t\t\t\t\n\t\t\t\t\t\t{item.type === \"table\" ? : }\n\t\t\t\t\t\t{item.name}\n\t\t\t\t\t

\n\t\t\t\t);\n\t\t\t})}\n\t\t\n\t);\n};\n",[],[150,198],{"_102":206,"_95":207,"_151":208,"_153":152,"_154":136,"_155":209,"_157":158,"_104":210,"_99":32,"_160":173,"_162":211,"_163":22,"_164":-5,"_165":212,"_98":213},"b38ee584-9968-11f0-a103-0224a6c84d84","table.tsx","b38ee746-9968-11f0-a103-0224a6c84d84",107,["D",1758733541654],"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport type { FC } from \"https://esm.sh/hono@4.9.8/dist/types/jsx/base\";\n\nexport const Table: FC = (props) => {\n\tconst headers = props.headers as string[];\n\tconst rows = props.rows as string[][];\n\n\tconst createRows = (rows, headers) => {\n\t\tif (rows.every((subArray) => subArray.length === 0)) {\n\t\t\tconst emptyRow = headers.map((header) => {\n\t\t\t\treturn (\n\t\t\t\t\t\n\t\t\t\t\t\t{header}\n\t\t\t\t\t\n\t\t\t\t);\n\t\t\t});\n\n\t\t\treturn {emptyRow};\n\t\t}\n\n\t\treturn rows.map((row) => (\n\t\t\t\n\t\t\t\t{row.map((cell) => (\n\t\t\t\t\t{cell}\n\t\t\t\t))}\n\t\t\t\n\t\t));\n\t};\n\n\tconst tableRows = createRows(rows, headers);\n\n\treturn (\n\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t{headers.map((header) => (\n\t\t\t\t\t\t\n\t\t\t\t\t))}\n\t\t\t\t\n\t\t\t\n\t\t\t{tableRows}\n\t\t

{header}

\n\t);\n};\n",[],[150,207],[150],{"_102":216,"_95":217,"_151":218,"_153":-5,"_154":136,"_155":219,"_157":158,"_104":220,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":221,"_98":277},"b34c5836-9968-11f0-8cb1-0224a6c84d84","scripts","b34c58ea-9968-11f0-8cb1-0224a6c84d84",99,["D",1758733541215],[222,232,241,250,259,268],{"_102":223,"_95":224,"_151":225,"_153":218,"_154":136,"_155":226,"_157":158,"_104":227,"_99":228,"_160":173,"_162":229,"_163":22,"_164":-5,"_165":230,"_98":231},"b36f81bc-9968-11f0-8fcf-0224a6c84d84","download.ts","4a71cf14-9966-11f0-b76e-0224a6c84d84",102,["D",1758733541417],1,"console.log(\"download script loaded!\");\n\nimport { identify } from \"https://esm.sh/sql-query-identifier@2.7.0\";\n\nconst editor = document.getElementById(\"editordiv\");\nconst csvBtn = document.getElementById(\"download-csv\");\nconst jsonBtn = document.getElementById(\"download-json\");\n\nfunction selectStatementFromPosition(statements, pos) {\n\tfor (const statement of statements) {\n\t\tif (statement.end + 1 >= pos) return statement;\n\t}\n\treturn undefined;\n}\n\nfunction getCode(): string {\n\t// @ts-expect-error needed\n\tconst code = editor.code;\n\n\tconst statements = identify(code, {\n\t\tdialect: \"sqlite\",\n\t\tstrict: false,\n\t});\n\n\t// @ts-expect-error needed\n\tconst position = editor.view.state.selection.main.head;\n\tconst statement = selectStatementFromPosition(statements, position);\n\n\tif (!statement) {\n\t\treturn \"\";\n\t}\n\n\treturn statement.text;\n}\n\ncsvBtn.addEventListener(\"click\", () => {\n\tconsole.log(\"csv clicked\");\n\tconst query = getCode();\n\tglobalThis.location.href = `/download/csv?query=${encodeURIComponent(query)}`;\n});\n\njsonBtn.addEventListener(\"click\", () => {\n\tconsole.log(\"json clicked\");\n\tconst query = getCode();\n\tglobalThis.location.href = `/download/json?query=${encodeURIComponent(query)}`;\n});\n",[],[217,224],{"_102":233,"_95":234,"_151":235,"_153":218,"_154":136,"_155":236,"_157":158,"_104":237,"_99":183,"_160":173,"_162":238,"_163":22,"_164":-5,"_165":239,"_98":240},"b3846d8e-9968-11f0-8fcf-0224a6c84d84","enable-buttons.tsx","a35d42a6-98f4-11f0-a542-0224a6c84d84",105,["D",1758733541545],"console.log(\"button enable script loaded!\");\n\nconst editor = document.getElementById(\"editordiv\");\nconst csvBtn = document.getElementById(\"download-csv\");\nconst jsonBtn = document.getElementById(\"download-json\");\nconst runBtn = document.getElementById(\"run\");\n\nconst buttons = [csvBtn, jsonBtn, runBtn];\n\nfunction checkForText() {\n\t// @ts-expect-error needed\n\tif (editor.view.state.doc.toString().trim() === \"\") {\n\t\tbuttons.forEach((btn: HTMLButtonElement) => {\n\t\t\tbtn.disabled = true;\n\t\t});\n\t} else {\n\t\tbuttons.forEach((btn: HTMLButtonElement) => {\n\t\t\tbtn.disabled = false;\n\t\t});\n\t}\n}\n\neditor.addEventListener(\"code-change\", () => {\n\t// @ts-expect-error needed\n\tif (editor.view.state.doc.toString().trim() === \"\") {\n\t\tbuttons.forEach((btn: HTMLButtonElement) => {\n\t\t\tbtn.disabled = true;\n\t\t});\n\t} else {\n\t\tbuttons.forEach((btn: HTMLButtonElement) => {\n\t\t\tbtn.disabled = false;\n\t\t});\n\t}\n});\n\ndocument.addEventListener(\"DOMContentLoaded\", () => {\n\t// Initial check\n\tcheckForText();\n});\n",[],[217,234],{"_102":242,"_95":243,"_151":244,"_153":218,"_154":136,"_155":245,"_157":158,"_104":246,"_99":183,"_160":173,"_162":247,"_163":22,"_164":-5,"_165":248,"_98":249},"b361d152-9968-11f0-b0b8-0224a6c84d84","get-code.tsx","a4526268-98f4-11f0-9dc3-0224a6c84d84",100,["D",1758733541354],"console.log(\"getCode() function loaded\");\n\nimport htmx from \"https://esm.sh/htmx.org\";\nimport { identify } from \"https://esm.sh/sql-query-identifier@2.7.0\";\n\nfunction selectStatementFromPosition(statements, pos) {\n\tfor (const statement of statements) {\n\t\tif (statement.end + 1 >= pos) return statement;\n\t}\n\treturn undefined;\n}\n\nfunction getCode() {\n\tconst editor = htmx.find(\"#editordiv\");\n\t// @ts-expect-error needed\n\tconst code = editor.code;\n\n\tconst statements = identify(code, {\n\t\tdialect: \"sqlite\",\n\t\tstrict: false,\n\t});\n\t// @ts-expect-error needed\n\tconst position = editor.view.state.selection.main.head;\n\tconst statement = selectStatementFromPosition(statements, position);\n\n\tif (!statement) {\n\t\treturn \"\";\n\t}\n\n\treturn statement.text;\n}\n\nglobalThis.getCode = getCode;\n\nexport const getCodeScript = undefined;\n",[],[217,243],{"_102":251,"_95":252,"_151":253,"_153":218,"_154":136,"_155":254,"_157":158,"_104":255,"_99":228,"_160":173,"_162":256,"_163":22,"_164":-5,"_165":257,"_98":258},"b368a86a-9968-11f0-99ba-0224a6c84d84","resize.tsx","5cd5bcce-9966-11f0-8788-0224a6c84d84",101,["D",1758733541396],"console.log(\"resizing script loaded!\");\n\nconst resizable = (resizer) => {\n\tconst direction = resizer.getAttribute(\"data-direction\") || \"horizontal\";\n\tconst prevSibling = resizer.previousElementSibling;\n\tconst nextSibling = resizer.nextElementSibling;\n\n\tlet x = 0;\n\tlet y = 0;\n\tlet prevSiblingHeight = 0;\n\tlet prevSiblingWidth = 0;\n\n\tconst mouseDownHandler = (e) => {\n\t\tconst parent = e.currentTarget.parentElement;\n\t\tconst direction = parent.getAttribute(\"data-direction\") || \"horizontal\";\n\n\t\tconsole.log(\"Resizing direction:\", direction);\n\n\t\tx = e.clientX;\n\t\ty = e.clientY;\n\t\tconst rect = prevSibling.getBoundingClientRect();\n\t\tprevSiblingHeight = rect.height;\n\t\tprevSiblingWidth = rect.width;\n\n\t\tdocument.addEventListener(\"mousemove\", mouseMoveHandler);\n\t\tdocument.addEventListener(\"mouseup\", mouseUpHandler);\n\t};\n\n\tconst mouseMoveHandler = (e) => {\n\t\tconst dx = e.clientX - x;\n\t\tconst dy = e.clientY - y;\n\n\t\tswitch (direction) {\n\t\t\tcase \"vertical\": {\n\t\t\t\tconst h =\n\t\t\t\t\t((prevSiblingHeight + dy) * 100) /\n\t\t\t\t\tresizer.parentNode.getBoundingClientRect().height;\n\t\t\t\tprevSibling.style.height = `${h}%`;\n\t\t\t\tbreak;\n\t\t\t}\n\t\t\tdefault: {\n\t\t\t\tconst w =\n\t\t\t\t\t((prevSiblingWidth + dx) * 100) /\n\t\t\t\t\tresizer.parentNode.getBoundingClientRect().width;\n\t\t\t\tprevSibling.style.width = `${w}%`;\n\t\t\t\tbreak;\n\t\t\t}\n\t\t}\n\n\t\tconst cursor = direction === \"horizontal\" ? \"col-resize\" : \"row-resize\";\n\t\tresizer.style.cursor = cursor;\n\t\tdocument.body.style.cursor = cursor;\n\n\t\tprevSibling.style.userSelect = \"none\";\n\t\tprevSibling.style.pointerEvents = \"none\";\n\n\t\tnextSibling.style.userSelect = \"none\";\n\t\tnextSibling.style.pointerEvents = \"none\";\n\t};\n\n\tconst mouseUpHandler = () => {\n\t\tresizer.style.removeProperty(\"cursor\");\n\t\tdocument.body.style.removeProperty(\"cursor\");\n\n\t\tprevSibling.style.removeProperty(\"user-select\");\n\t\tprevSibling.style.removeProperty(\"pointer-events\");\n\n\t\tnextSibling.style.removeProperty(\"user-select\");\n\t\tnextSibling.style.removeProperty(\"pointer-events\");\n\n\t\tdocument.removeEventListener(\"mousemove\", mouseMoveHandler);\n\t\tdocument.removeEventListener(\"mouseup\", mouseUpHandler);\n\t};\n\n\tresizer\n\t\t.querySelector(\".handle\")\n\t\t.addEventListener(\"mousedown\", mouseDownHandler);\n};\n\ndocument.querySelectorAll(\".resizer\").forEach((ele) => {\n\tresizable(ele);\n});\n",[],[217,252],{"_102":260,"_95":261,"_151":262,"_153":218,"_154":136,"_155":263,"_157":158,"_104":264,"_99":183,"_160":173,"_162":265,"_163":22,"_164":-5,"_165":266,"_98":267},"b375a15a-9968-11f0-b0b8-0224a6c84d84","save-query.tsx","a254413e-98f4-11f0-a109-0224a6c84d84",103,["D",1758733541408],"console.log(\"table selection script loaded!\");\n\nif (typeof Deno === \"undefined\") {\n\tconst tables = document.querySelectorAll(\".tables-list-item\");\n\tconst editor = document.getElementById(\"editordiv\");\n\n\ttables.forEach((table) => {\n\t\ttable.addEventListener(\"click\", () => {\n\t\t\tconst tableName = table.id;\n\n\t\t\tlet statement: string; // = `SELECT * FROM ${tableName}`;\n\t\t\tif (localStorage.getItem(`saved-${tableName}`) !== null) {\n\t\t\t\tstatement = localStorage.getItem(`saved-${tableName}`);\n\t\t\t} else {\n\t\t\t\tstatement = `SELECT * FROM ${tableName}`;\n\t\t\t}\n\n\t\t\teditor.innerText = statement;\n\t\t});\n\t});\n}\n\nexport const saveQueryScript = undefined;\n",[],[217,261],{"_102":269,"_95":270,"_151":271,"_153":218,"_154":136,"_155":272,"_157":158,"_104":273,"_99":228,"_160":173,"_162":274,"_163":22,"_164":-5,"_165":275,"_98":276},"b3d23762-9968-11f0-8a61-0224a6c84d84","table-select.tsx","4a6d7af4-9966-11f0-a6a4-0224a6c84d84",115,["D",1758733541429],"console.log(\"table selection script loaded!\");\n\nif (typeof Deno === \"undefined\") {\n\tconst tables = document.querySelectorAll(\".tables-list-item\");\n\tconst editor = document.getElementById(\"editordiv\");\n\n\ttables.forEach((table) => {\n\t\ttable.addEventListener(\"click\", () => {\n\t\t\tconst tableName = table.id;\n\n\t\t\tlet statement: string; // = `SELECT * FROM ${tableName}`;\n\t\t\tif (localStorage.getItem(`saved-${tableName}`) !== null) {\n\t\t\t\tstatement = localStorage.getItem(`saved-${tableName}`);\n\t\t\t} else {\n\t\t\t\tstatement = `SELECT * FROM ${tableName}`;\n\t\t\t}\n\n\t\t\t// @ts-expect-error needed\n\t\t\teditor.code = statement;\n\t\t});\n\t});\n}\n\nexport const tableSelectScript = undefined;\n",[],[217,270],[217],{"_102":279,"_95":280,"_151":281,"_153":-5,"_154":136,"_155":282,"_157":158,"_104":283,"_99":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":284,"_98":295},"a03eeb4c-98f4-11f0-8eaa-0224a6c84d84","sqliteExplorerApp","e3f0bc5c-7472-49d5-86e8-1eec14ba9a56",5,["D",1758683687630],[285],{"_102":286,"_95":287,"_151":288,"_153":281,"_154":136,"_155":289,"_157":158,"_104":290,"_99":228,"_160":291,"_162":292,"_163":22,"_164":-5,"_165":293,"_98":294},"18c828c2-9967-11f0-a386-0224a6c84d84","main.tsx","a0945fc8-98f4-11f0-bb98-0224a6c84d84",96,["D",1758732852403],"http","/** @jsxImportSource npm:hono/jsx **/\n\nimport { modifyFetchHandler } from \"https://esm.town/v/andreterron/codeOnValTown?v=50\";\nimport { iframeHandler } from \"https://esm.town/v/nbbaier/iframeHandler\";\nimport { resetStyle } from \"https://esm.town/v/nbbaier/resetStyle\";\nimport {\n\tEditorSection,\n\tSeparator,\n\tTable,\n\tTablesList,\n} from \"https://esm.town/v/nbbaier/sqliteStudioComponents\";\nimport { sqliteStyle } from \"https://esm.town/v/nbbaier/sqliteStyle\";\nimport { passwordAuth } from \"https://esm.town/v/pomdtr/password_auth\";\nimport { verifyToken } from \"https://esm.town/v/pomdtr/verifyToken\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Hono } from \"npm:hono\";\nimport type { FC } from \"npm:hono/jsx\";\nimport { jsxRenderer } from \"npm:hono/jsx-renderer\";\nimport papa from \"npm:papaparse\";\n\nconst HTML: FC = ({ children }) => {\n\treturn (\n\t\t\n\t\t\t\n\t\t\t\tSQLite Explorer\n\t\t\t\t\n\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t

nbbaier

project-sqlite