Inserting binary data into BLOB column in sqlite fails with "unhandled exception: unrecognized token"

[sgmihai]

Just like the error here: nim-lang/db_connector#12
Code to reproduce:

import asyncdispatch, httpclient, json
import allographer/[connection, schema_builder, query_builder]

proc createTable(myDb: Rdb) {.async.} =
  myDb.create([
    table("mytable", [
      Column.uuid("id"),
      Column.binary("blob").nullable()
    ])
  ])

proc main() {.async.} =
  let myDb = dbOpen(Sqlite3, "mydb.db", maxConnections=10, timeout=30)
  await createTable(myDb)

  let binFile = newHttpClient().getContent("https://cdimage.debian.org/debian-cd/current/amd64/bt-cd/debian-11.7.0-amd64-netinst.iso.torrent")
  let data = %*{
    "id": 1,
    "blob": binFile
    }
  
  myDb.table("mytable").insert(data).await

waitFor main()

[sgmihai]

I found this commit that was not merged for some reason. 6 year old problem, very sad for nim:
nim-lang/Nim@6fa82a5

[itsumura-h]

@sgmihai
I wrote a low-level sample code. It works fine 💪

https://github.com/itsumura-h/nim-allographer/blob/235-inserting-binary-data-into-blob-column-in-sqlite-fails-with-unhandled-exception-unrecognized-token/example/sqlite_binary.nim

[sgmihai]

Thank you, I will try to implement it.
But what about fixing it in allographer ?

[itsumura-h]

@sgmihai
I have not yet made changes to allogrpher itself. I will work on it later. Please wait for a few days.