sqlite binding of Emacs Lisp inspired by mruby-sqlite3
(require 'sqlite3) (progn (with-current-buffer (get-buffer-create "*sqlite*") (erase-buffer)) (let ((db (sqlite3-new "example/example.db"))) (sqlite3-execute-batch db "CREATE TABLE foo(id integer primary key, editor text);") (sqlite3-execute-batch db "INSERT INTO foo(editor) values(?)" ["Vim"]) (sqlite3-execute-batch db "INSERT INTO foo(editor) values(?)" ["Emacs"]) (sqlite3-execute-batch db "INSERT INTO foo(editor) values(?)" ["Atom"]) (sqlite3-execute-batch db "INSERT INTO foo(editor) values(?)" ["Notepad"]) (sqlite3-execute db "SELECT * FROM foo" (lambda (row fields) (let ((id (car row)) (editor (cadr row))) (with-current-buffer (get-buffer "*sqlite*") (insert (format "@@ ID=%d, Editor=%s\n" id editor)))))) (pop-to-buffer (get-buffer "*sqlite*"))))Create sqlite3 instance. If db-path is omitted, data is stored in memory.
Execute SQL query for db database. First argument db must be sqlite3 instance. If you use placeholders in query, then you must pass bounds too.
Interface for executing SELECT query. If you pass callback argument, callback is called with SELECT results. callback takes 2 arguments, row and fields. row is value, fields are column names. If callback is not specified, this function returns resultset instance.
You can specify placeholders of query by passing cons query argument like '("SELECT * FROM sample WHERE name = ?" . ["Alice"]).
Return next row.
Return fields name of row.
Return t if there is no more row.