fix a sqlite bug (#18669)

1 files changed, 15 insertions, 0 deletions

diff --git a/lib/std/private/dbutils.nim b/lib/std/private/dbutils.nim
new file mode 100644
index 000000000..0ae3b3702
--- /dev/null
+++ b/lib/std/private/dbutils.nim
@@ -0,0 +1,15 @@
+import db_common
+
+
+template dbFormatImpl*(formatstr: SqlQuery, dbQuote: proc (s: string): string, args: varargs[string]): string =
+  var res = ""
+  var a = 0
+  for c in items(string(formatstr)):
+    if c == '?':
+      if a == args.len:
+        dbError("""The number of "?" given exceeds the number of parameters present in the query.""")
+      add(res, dbQuote(args[a]))
+      inc(a)
+    else:
+      add(res, c)
+  res