sqlite3 binding of Emacs Lisp
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 4 commits ahead of syohex:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
example
test
.gitignore
Makefile
README.md
sqlite3-core.c
sqlite3.el

README.md

sqlite3.el

sqlite binding of Emacs Lisp inspired by mruby-sqlite3

Sample

(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*"))))

Interfaces

(sqlite3-new &optional db-path)

Create sqlite3 instance. If db-path is omitted, data is stored in memory.

(sqlite3-execute-batch db query &optional bounds)

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.

(sqlite3-execute db query &rest args)

Interface for executing SELECT query.

Rest parameters are bounds and callback. You can its argument as, either '(bounds) or '(callback) or '(bounds callback). callback function is called with database row. `callback' takes two arguments, first argument is row element of list, second argument is field names of list.

(sqlite3-resultset-next resultset)

Return next row.

(sqlite3-resultset-fields resultset)

Return fields name of row.

(sqlite3-resultset-eof resultset)

Return t if there is no more row.