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",[113],"pulls",1,"forks","envVars",{"_135":54,"_137":54},"connections",{"_135":54,"_136":54},"count","unfilledCount","emptyCount",{"_20":112,"_13":113,"_114":48,"_115":-5,"_116":21,"_117":30,"_118":50,"_22":139,"_29":120,"_121":122,"_123":124,"_125":38,"_126":-5,"_140":141,"_89":142},["D",1784925642891],"children",[],[113],["D",1784925563692],{"_11":12,"_87":43},{"_11":12,"_82":43,"_83":43,"_45":46,"_84":85,"_86":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_108":180,"_181":182,"_183":184,"_185":38,"_186":38,"_187":38,"_188":50,"_189":-5,"_190":-7,"_191":-7,"_192":54,"_193":38,"_194":38,"_195":-5,"_196":38,"_197":38,"_198":38,"_199":-5},"ENV",{"_151":152,"_153":154,"_155":26,"_156":157,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179},"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"]

Branches1

Branches
1