SQLite Parameter-Bindung: Muster A (zwei Argumente) vs. Muster B (Objekt-Form)

\" +\n \"

Ergebnis Muster A - sqlite.execute(sql, [werte]) (bisher von uns genutzt)

\" +\n \"

Erwarteter Wert: \" + escapeHtml(testValueTwoArgs) +\n \"

\" +\n \"

Tatsaechlich in der DB gefunden: \" +\n escapeHtml(String(foundValueTwoArgs)) + \"

\" +\n \"

\" +\n (twoArgsWorked ? \"FUNKTIONIERT\" : \"KAPUTT - Wert kam NICHT an\") +\n \"

\" +\n (selectTwoArgsError\n ? \"

SELECT-Fehler: \" +\n escapeHtml(selectTwoArgsError) + \"

\"\n : \"\") +\n \"

Ergebnis Muster B - sqlite.execute({ sql, args }) (laut aktueller Doku korrekt)

\" +\n \"

Erwarteter Wert: \" + escapeHtml(testValueObjectArgs) +\n \"

\" +\n \"

Tatsaechlich in der DB gefunden: \" +\n escapeHtml(String(foundValueObjectArgs)) + \"

\" +\n \"

\" +\n (objectArgsWorked ? \"FUNKTIONIERT\" : \"KAPUTT - Wert kam NICHT an\") +\n \"

\" +\n (selectObjectArgsError\n ? \"

SELECT-Fehler: \" +\n escapeHtml(selectObjectArgsError) + \"

\"\n : \"\") +\n \"

Rohe Insert-Schritte (Log)

\" +\n \"

\" +\n    escapeHtml(safeStringify(stepLog)) +\n    \"

\" +\n \"

Letzte 10 Zeilen der Tabelle (roh, ungemappt)

\" +\n \"

\" +\n    escapeHtml(safeStringify(recentRows)) +\n    \"

\" +\n \"\";\n\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted","label",[107],"pulls","branches",1,"forks","envVars",{"_130":42,"_132":42},"connections",{"_130":42,"_131":42},"count","unfilledCount","emptyCount",{"_18":106,"_20":107,"_108":36,"_109":-5,"_110":68,"_111":66,"_112":38,"_22":134,"_65":114,"_115":116,"_117":118,"_119":26,"_120":-5,"_135":136,"_84":137},["D",1784925642891],"children",[],[107],["D",1784925563692],{"_16":17,"_82":31},{"_16":17,"_77":31,"_78":31,"_33":34,"_79":80,"_81":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_102":175,"_176":177,"_178":179,"_180":26,"_181":26,"_182":26,"_183":38,"_184":-5,"_185":-7,"_186":-7,"_187":42,"_188":26,"_189":26,"_190":-5,"_191":26,"_192":26,"_193":26,"_194":-5},"ENV",{"_146":147,"_148":149,"_150":67,"_151":152,"_153":154,"_155":156,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Search