bind!() fails against named parameters

[yuttie]

using SQLite
db = SQLite.DB("test.sqlite")
SQLite.execute!(db, "CREATE TABLE IF NOT EXISTS tbl(a  INTEGER);")
stmt = SQLite.Stmt(db, "INSERT INTO tbl (a) VALUES (@a);")
SQLite.bind!(stmt, "@a", 1)

This code produces the following output:

$ julia bug.jl
ERROR: LoadError: MethodError: `bind!` has no method matching bind!(::SQLite.Stmt, ::Int32, ::Int64)
Closest candidates are:
  bind!(::SQLite.Stmt, !Matched::AbstractString, ::Any)
  bind!(::SQLite.Stmt, !Matched::Int64, ::Int64)
  bind!(::SQLite.Stmt, !Matched::Int64, ::Any)
  ...
 in bind! at /home/someone/.julia/v0.4/SQLite/src/SQLite.jl:122
while loading /home/someone/bug.jl, in expression starting on line 5

It seems that the function sqlite3_bind_parameter_index() returns an Int32 value as a translated index for the named parameter @a, and thus the function bind!() rejects the argument.

I think we need to convert the translated index into an Int64 value or make bind!() accept an Int32 index as the second argument.

[felipenoris]

There you go...

[yuttie]

I confirmed that commit fixes my error.
Thanks!

[lucasprocessi]

I'm getting an error on a similar example, while executing the Stmt.

using SQLite
db = SQLite.DB("tests.sqlite")
DBInterface.execute(db, "CREATE TABLE IF NOT EXISTS t1 (a INTEGER)")
s = SQLite.Stmt(db, "INSERT INTO t1 (a) VALUES (@a)")
SQLite.bind!(s, "@a", 1)
SQLite.execute(s)

Error info:

ERROR: AssertionError: you must provide values for all query placeholders
Stacktrace:
 [1] bind! at C:\Users\lucas\.julia\packages\SQLite\LjMUn\src\SQLite.jl:188 [inlined]
 [2] execute(::SQLite.Stmt, ::Tuple{}) at C:\Users\lucas\.julia\packages\SQLite\LjMUn\src\SQLite.jl:312
 [3] execute(::SQLite.Stmt) at C:\Users\lucas\.julia\packages\SQLite\LjMUn\src\SQLite.jl:311
 [4] top-level scope at REPL[8]:1

[quinnj]

Hmmm, perhaps we need to update the docs here; the correct way to bind the parameter here is to do

SQLite.execute(s, (a=1,))