one-time query

[Q-tester]

DB-FILLING> (dbi:with-connection (db-connection :sqlite3
                                                :database-name *db-path*) 
              (dbi:do-sql db-connection
                "CREATE TABLE colors (id integer primary key autoincrement, label text)")
              (let ((query (dbi:prepare db-connection
                                        "INSERT INTO colors(label) VALUES (?)")))
                (map nil
                     (lambda (color)
                       (dbi:execute query
                                    color))
                     (list "Red" "Blue" "Green")))
              (dbi:fetch-all
               (dbi:execute
                (dbi:prepare db-connection "SELECT * FROM colors;"))))
  0: (DBI.DRIVER:EXECUTE #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}> "Red")
  0: DBI.DRIVER:EXECUTE returned #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}>
  0: (DBI.DRIVER:EXECUTE #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}> "Blue")
  0: DBI.DRIVER:EXECUTE returned #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}>
  0: (DBI.DRIVER:EXECUTE #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}> "Green")
  0: DBI.DRIVER:EXECUTE returned #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6A4C39}>
  0: (DBI.DRIVER:EXECUTE #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6B2E11}>)
  0: DBI.DRIVER:EXECUTE returned #<DBD.SQLITE3::<DBD-SQLITE3-QUERY> {B6B2E11}>
((:|id| 1 :|label| "Red"))

[Q-tester]

Maybe I don't understand something. DBI:EXECUTE doesn't for INSERT commands, does it?

[spacebat]

This is the first issue I've run into with this library. I'd like to do a lot of inserts so it seems natural to use a prepared statement rather than do-sql. Will have to figure out why this is.

[fukamachi]

This only happens only with SQLite3 driver. Probably a bug of cl-sqlite's bind-parameter.

[fukamachi]

It wasn't. Hopefully, it has been fixed.

[spacebat]

Fix confirmed, thanks!