Drag handle to resize panel

\n {isLoadingSchema ? (\n

Loading schema...

\n ) : (\n \n )}\n

\n\n \n\n

\n \n\n \n\n

\n {error && (\n

\n {error}\n

\n )}\n {result && (\n \n )}\n {!error && !result && (\n

\n Run a query to see results here\n

\n )}\n \n \n \n \n \n );\n}\n",[],[259,362],{"_104":370,"_95":371,"_157":372,"_159":260,"_160":142,"_161":101,"_163":22,"_106":373,"_100":122,"_165":179,"_167":374,"_168":22,"_169":-5,"_170":375,"_98":376},"658335c2-c1c5-11f0-ac92-42dde27851f2","index.html","66816ac0-c1bb-11f0-b3a1-42dde27851f2",["D",1763171400423],"\n\n\n \n \n SQLite Explorer\n\n \n \n \n \n\n \n \n \n\n \n \n\n\n

\n \n\n\n",[],[259,371],{"_104":378,"_95":379,"_157":380,"_159":260,"_160":142,"_161":381,"_163":22,"_106":382,"_100":32,"_165":216,"_167":383,"_168":22,"_169":-5,"_170":384,"_98":385},"cd229164-c1bb-11f0-b487-42dde27851f2","main.tsx","cd229286-c1bb-11f0-b487-42dde27851f2",149,["D",1763167279233],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = document.getElementById(\"root\");\n\nif (root) {\n ReactDOM.createRoot(root).render(\n \n \n \n );\n} else {\n console.error(\"Root element not found\");\n}\n",[],[259,379],{"_104":387,"_95":388,"_157":389,"_159":260,"_160":142,"_161":390,"_163":22,"_106":391,"_100":32,"_165":179,"_167":392,"_168":22,"_169":-5,"_170":393,"_98":394},"cd134416-c1bb-11f0-98d3-42dde27851f2","reset.css","cd1344ca-c1bb-11f0-98d3-42dde27851f2",145,["D",1763167279206],"/* Box sizing rules */\n*,\n*::before,\n*::after {\n\tbox-sizing: border-box;\n}\n\n/* Prevent font size inflation */\nhtml {\n\t-moz-text-size-adjust: none;\n\t-webkit-text-size-adjust: none;\n\ttext-size-adjust: none;\n}\n\n/* Remove default margin in favour of better control in authored CSS */\nbody,\nh1,\nh2,\nh3,\nh4,\np,\nfigure,\nblockquote,\ndl,\ndd {\n\tmargin-block-end: 0;\n}\n\n/* Remove list styles on ul, ol elements with a list role, which suggests default styling will be removed */\nul[role=\"list\"],\nol[role=\"list\"] {\n\tlist-style: none;\n}\n\n/* Set core body defaults */\nbody {\n\tmin-height: 100vh;\n\tline-height: 1.5;\n}\n\n/* Set shorter line heights on headings and interactive elements */\nh1,\nh2,\nh3,\nh4,\nbutton,\ninput,\nlabel {\n\tline-height: 1.1;\n}\n\n/* Balance text wrapping on headings */\nh1,\nh2,\nh3,\nh4 {\n\ttext-wrap: balance;\n}\n\n/* A elements that don't have a class get default styles */\na:not([class]) {\n\ttext-decoration-skip-ink: auto;\n\tcolor: currentColor;\n}\n\n/* Make images easier to work with */\nimg,\npicture {\n\tmax-width: 100%;\n\tdisplay: block;\n}\n\n/* Inherit fonts for inputs and buttons */\ninput,\nbutton,\ntextarea,\nselect {\n\tfont: inherit;\n}\n\n/* Make sure textareas without a rows attribute are not tiny */\ntextarea:not([rows]) {\n\tmin-height: 10em;\n}\n\n/* Anything that has been anchored to should have extra scroll margin */\n:target {\n\tscroll-margin-block: 5ex;\n}\n",[],[259,388],{"_104":396,"_95":397,"_157":398,"_159":260,"_160":142,"_161":399,"_163":22,"_106":400,"_100":32,"_165":179,"_167":401,"_168":22,"_169":-5,"_170":402,"_98":403},"cd16abd8-c1bb-11f0-88a0-42dde27851f2","style.css","cd16acaa-c1bb-11f0-88a0-42dde27851f2",146,["D",1763167279230],":root {\n\t--main-font:\n\t\t\"Source Sans 3\", \"Source Sans Pro\", -apple-system, system-ui, sans-serif;\n\t--mono-font: \"Fira Code\", \"M Plus Code Latin\", monospace, monospace;\n\t--rhythm: 1.25rem;\n\t--bg: var(--gray-0);\n\t--fg: var(--gray-12);\n\t--accent: #e2e8f0;\n\t--accent-dark: #cad2da;\n\t--gray-0: #f8fafb;\n\t--gray-5: #b1b6b9;\n\t--gray-12: #121210;\n\t--density: 1;\n\t--font-size: 1rem;\n\t--border-radius: 0.2rem;\n\t--section-border-weight: 1.5px;\n}\n\n* {\n\t--gap: calc(var(--rhythm) * var(--density));\n}\n\nhtml {\n\tfont-size: var(--font-size);\n\tfont-family: var(--main-font);\n\tline-height: var(--rhythm);\n\tcolor: var(--fg);\n\tbackground: var(--bg);\n\twidth: 100%;\n}\n\nbody {\n\tmargin: 0;\n\twidth: 100%;\n}\n\nheader {\n\tborder-bottom: var(--section-border-weight) solid black;\n}\n\nheader > h1 {\n\tmargin-block: 0;\n\tpadding: var(--gap);\n\tposition: relative;\n\ttext-transform: uppercase;\n}\n\nh2 {\n\ttext-transform: uppercase;\n\tmargin-top: 0;\n}\n\n.tables-list {\n\tdisplay: flex;\n\tpadding: 0.5rem;\n\tpadding-right: 1rem;\n\tflex-direction: column;\n}\n\n.tables-list-item {\n\tdisplay: inline-flex;\n\tpadding-left: 0.75rem;\n\tpadding-right: 0.75rem;\n\tjustify-content: flex-start;\n\talign-items: center;\n\tborder-radius: 0.375rem;\n\theight: 2rem;\n\twhite-space: nowrap;\n\tcursor: pointer;\n\tfont-size: calc(var(--font-size) * 1);\n\tline-height: calc(var(--rhythm) * 1);\n}\n\n.tables-list-item a {\n\ttext-decoration: none;\n}\n\n.tables-list-item svg {\n\tmargin-right: 8px;\n}\n\n.tables-list-item:hover {\n\tbackground-color: var(--accent);\n}\n\n.tables-list-item.selected {\n\tbackground-color: var(--accent-dark);\n}\n\n.root-container {\n\tdisplay: flex;\n\tflex-direction: column;\n\theight: 100vh;\n\tmax-height: 100vh;\n\tmax-width: 100%;\n\tbackground: var(--bg);\n}\n\n.sidebar-layout {\n\tdisplay: flex;\n\tflex-direction: row;\n\theight: 100%;\n\twidth: 100%;\n}\n\n.sidebar {\n\twidth: fit-content;\n}\n\n.not-sidebar {\n\tflex: 1;\n\tdisplay: flex;\n\tflex-direction: column;\n\toverflow: auto;\n}\n\n.not-sidebar > div:first-child {\n\tpadding-top: 0.5rem;\n}\n\n.top-container {\n\tdisplay: flex;\n\tflex-direction: column;\n\tmin-height: 12rem;\n}\n\n.not-sidebar > form {\n\tmargin: 0;\n}\n\n.editor {\n\theight: 12rem;\n\tflex-grow: 1;\n\tfont-family: var(--mono-font);\n\twhite-space: wrap;\n\toverflow: auto;\n\tborder-bottom: var(--section-border-weight) solid black;\n}\n\n.button-container {\n\tdisplay: flex;\n\talign-items: center;\n\theight: fit-content;\n\tpadding: 8px;\n}\n\n.button-container button {\n\tfont-size: 1rem;\n\tfont-family: var(--main-font);\n\ttext-transform: capitalize;\n\tdisplay: flex;\n\talign-items: center;\n\tbackground: var(--bg);\n\tborder: solid 1px black;\n\tborder-radius: var(--border-radius);\n}\n\n.button-container button svg {\n\tmargin-right: 0.25rem;\n}\n\n.button-container :not(:first-child) {\n\tmargin-inline-start: 0.75rem;\n}\n\n.button-container button:hover {\n\tbackground-color: var(--accent);\n}\n\n.button-container button:active {\n\tbackground-color: var(--accent-dark);\n}\n\n.button-container button:disabled,\n.button-container button.disabled {\n\topacity: 0.5;\n\tcursor: not-allowed;\n}\n\n.button-container button:disabled:hover,\n.button-container button.disabled:hover {\n\tbackground-color: var(--bg);\n}\n\n.loading {\n\tfont-size: calc(var(--font-size) * 0.95);\n}\n\n.hidden {\n\tdisplay: none;\n}\n\n.bottom-container {\n\tflex-shrink: 0;\n\tpadding: 14px;\n\toverflow: auto; /* code added */\n}\n\n.bottom {\n\tflex: 1;\n}\n\n.separator[data-direction=\"horizontal\"],\n.separator[data-direction=\"vertical\"] {\n\tbackground-color: black;\n\tdisplay: flex;\n\tjustify-content: center;\n\talign-items: center;\n\tposition: relative;\n\ttouch-action: none;\n\tuser-select: none;\n}\n\n.separator[data-direction=\"horizontal\"] {\n\theight: 100%;\n\twidth: var(--section-border-weight);\n}\n\n.separator[data-direction=\"vertical\"] {\n\theight: var(--section-border-weight);\n\twidth: 100%;\n}\n\n.handle {\n\tz-index: 10;\n\tborder: 1px solid #000;\n\tdisplay: flex;\n\tjustify-content: center;\n\talign-items: center;\n\tborder-radius: 0.25rem;\n\tbackground-color: #e2e8f0;\n\theight: 1.25rem;\n\twidth: 1rem;\n}\n\n.resizer[data-direction=\"horizontal\"] > .handle {\n\tcursor: ew-resize;\n}\n\n.resizer[data-direction=\"vertical\"] > .handle {\n\tcursor: ns-resize;\n\ttransform: rotate(90deg);\n}\n\ntable {\n\tdisplay: table;\n\tmargin: 0;\n\tborder-collapse: collapse;\n}\n\ntfoot,\nthead,\ntbody {\n\ttext-align: left;\n}\n\nthead {\n\tposition: sticky;\n\ttop: 0;\n}\n\ntd,\nth {\n\twidth: fit-content;\n\tpadding-right: 1rem;\n}\n\nth {\n\tposition: sticky;\n}\n\ntbody {\n\tborder-block: 1px solid var(--gray-12);\n}\n\n.empty-row {\n\tcolor: var(--bg);\n}\n\n.error {\n\tpadding: 1rem;\n\tcolor: #962020;\n\tfont-weight: bold;\n}\n\n.placeholder {\n\tpadding: 1rem;\n\tcolor: var(--gray-5);\n\tfont-style: italic;\n}\n\n.loading-text {\n\tpadding: 1rem;\n\tcolor: var(--gray-5);\n}\n\n.editor-wrapper {\n\tflex: 1;\n\tborder-bottom: var(--section-border-weight) solid black;\n}\n",[],[259,397],[259],{"_104":406,"_95":407,"_157":408,"_159":-5,"_160":142,"_161":409,"_163":22,"_106":410,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":411,"_98":466},"b34c5836-9968-11f0-8cb1-0224a6c84d84","scripts","b34c58ea-9968-11f0-8cb1-0224a6c84d84",99,["D",1758733541215],[412,421,430,439,448,457],{"_104":413,"_95":414,"_157":415,"_159":408,"_160":142,"_161":416,"_163":22,"_106":417,"_100":122,"_165":216,"_167":418,"_168":22,"_169":-5,"_170":419,"_98":420},"b36f81bc-9968-11f0-8fcf-0224a6c84d84","download.ts","4a71cf14-9966-11f0-b76e-0224a6c84d84",102,["D",1758733541417],"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",[],[407,414],{"_104":422,"_95":423,"_157":424,"_159":408,"_160":142,"_161":425,"_163":22,"_106":426,"_100":178,"_165":216,"_167":427,"_168":22,"_169":-5,"_170":428,"_98":429},"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",[],[407,423],{"_104":431,"_95":432,"_157":433,"_159":408,"_160":142,"_161":434,"_163":22,"_106":435,"_100":178,"_165":216,"_167":436,"_168":22,"_169":-5,"_170":437,"_98":438},"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",[],[407,432],{"_104":440,"_95":441,"_157":442,"_159":408,"_160":142,"_161":443,"_163":22,"_106":444,"_100":122,"_165":216,"_167":445,"_168":22,"_169":-5,"_170":446,"_98":447},"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",[],[407,441],{"_104":449,"_95":450,"_157":451,"_159":408,"_160":142,"_161":452,"_163":22,"_106":453,"_100":178,"_165":216,"_167":454,"_168":22,"_169":-5,"_170":455,"_98":456},"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",[],[407,450],{"_104":458,"_95":459,"_157":460,"_159":408,"_160":142,"_161":461,"_163":22,"_106":462,"_100":122,"_165":216,"_167":463,"_168":22,"_169":-5,"_170":464,"_98":465},"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",[],[407,459],[407],{"_104":468,"_95":469,"_157":470,"_159":-5,"_160":142,"_161":471,"_163":118,"_106":472,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":473,"_98":501},"664aeffe-c1bb-11f0-984e-42dde27851f2","shared","664af0b2-c1bb-11f0-984e-42dde27851f2",126,["D",1763167106768],[474,483,492],{"_104":475,"_95":476,"_157":477,"_159":470,"_160":142,"_161":478,"_163":22,"_106":479,"_100":32,"_165":216,"_167":480,"_168":22,"_169":-5,"_170":481,"_98":482},"66b3bc32-c1bb-11f0-984e-42dde27851f2","exportHelpers.ts","66b3bcdc-c1bb-11f0-984e-42dde27851f2",143,["D",1763167107450],"import { Parser } from \"https://esm.sh/@json2csv/plainjs\";\nimport type { QueryResult } from \"./types.ts\";\n\nexport const sqlToJSON = (result: QueryResult) => {\n const { columns, rows } = result;\n\n return rows.map((row) =>\n columns.reduce((obj, col, index) => {\n obj[col] = row[index];\n return obj;\n }, {} as Record)\n );\n};\n\nexport const sqlToCSV = (result: QueryResult): string => {\n try {\n const { columns } = result;\n const records = sqlToJSON(result);\n return new Parser({ fields: columns }).parse(records);\n } catch (error) {\n return error instanceof Error ? error.message : \"Unknown error occurred\";\n }\n};\n",[],[469,476],{"_104":484,"_95":485,"_157":486,"_159":470,"_160":142,"_161":487,"_163":22,"_106":488,"_100":32,"_165":216,"_167":489,"_168":22,"_169":-5,"_170":490,"_98":491},"66b6e178-c1bb-11f0-815e-42dde27851f2","sqlHelpers.ts","66b6e236-c1bb-11f0-815e-42dde27851f2",144,["D",1763167107462],"import { identify } from \"https://esm.sh/sql-query-identifier@2.7.0\";\nimport type { ParsedStatement } from \"./types.ts\";\n\n/**\n * Parse SQL code into individual statements with their positions\n */\nexport function parseSQLStatements(code: string): ParsedStatement[] {\n return identify(code, {\n dialect: \"sqlite\",\n strict: false,\n });\n}\n\n/**\n * Select the SQL statement at a given cursor position\n */\nexport function selectStatementFromPosition(\n statements: ParsedStatement[],\n position: number\n): ParsedStatement | undefined {\n for (const statement of statements) {\n if (statement.end + 1 >= position) {\n return statement;\n }\n }\n return undefined;\n}\n\n/**\n * Get the SQL statement at the current cursor position\n * If no statement found, returns empty string\n */\nexport function getStatementAtPosition(\n code: string,\n cursorPosition: number\n): string {\n const statements = parseSQLStatements(code);\n const statement = selectStatementFromPosition(statements, cursorPosition);\n return statement?.text || \"\";\n}\n\n/**\n * Generate a default SELECT query for a table or view\n */\nexport function generateDefaultQuery(name: string, type: \"table\" | \"view\"): string {\n return `SELECT * FROM ${name} LIMIT 100;`;\n}\n",[],[469,485],{"_104":493,"_95":494,"_157":495,"_159":470,"_160":142,"_161":496,"_163":22,"_106":497,"_100":32,"_165":216,"_167":498,"_168":22,"_169":-5,"_170":499,"_98":500},"66b04f0c-c1bb-11f0-99b9-42dde27851f2","types.ts","66b04fc0-c1bb-11f0-99b9-42dde27851f2",142,["D",1763167107431],"// Shared TypeScript types for SQLite Explorer\n\nexport type SchemaItemType = \"table\" | \"view\";\n\nexport interface SchemaItem {\n name: string;\n type: SchemaItemType;\n}\n\nexport interface QueryResult {\n columns: string[];\n rows: any[][];\n}\n\nexport interface QueryResponse {\n success: boolean;\n data?: QueryResult;\n error?: string;\n}\n\nexport interface SchemaResponse {\n tables: SchemaItem[];\n views: SchemaItem[];\n}\n\nexport interface ParsedStatement {\n start: number;\n end: number;\n text: string;\n type: string;\n}\n",[],[469,494],[469],{"_104":503,"_95":504,"_157":505,"_159":-5,"_160":142,"_161":506,"_163":22,"_106":507,"_100":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_170":508,"_98":517},"a03eeb4c-98f4-11f0-8eaa-0224a6c84d84","sqliteExplorerApp","e3f0bc5c-7472-49d5-86e8-1eec14ba9a56",5,["D",1758683687630],[509],{"_104":510,"_95":379,"_157":511,"_159":505,"_160":142,"_161":512,"_163":22,"_106":513,"_100":122,"_165":197,"_167":514,"_168":22,"_169":-5,"_170":515,"_98":516},"18c828c2-9967-11f0-a386-0224a6c84d84","a0945fc8-98f4-11f0-bb98-0224a6c84d84",96,["D",1758732852403],"/** @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

sqliteExplorerReact