Function: emacsql-with-connection

emacsql-with-connection is a macro defined in emacsql.el.

Signature

(emacsql-with-connection CONNECTION-SPEC &rest BODY)

Documentation

Open an EmacSQL connection, evaluate BODY, and close the connection.

CONNECTION-SPEC establishes a single binding.

  (emacsql-with-connection (db (emacsql-sqlite "company.db"))
    (emacsql db [:create-table foo [x]])
    (emacsql db [:insert :into foo :values ([1] [2] [3])])
    (emacsql db [:select * :from foo]))

Source Code

;; Defined in ~/.emacs.d/elpa/emacsql-20261001.1544/emacsql.el
;;; Useful macros

(defmacro emacsql-with-connection (connection-spec &rest body)
  "Open an EmacSQL connection, evaluate BODY, and close the connection.
CONNECTION-SPEC establishes a single binding.

  (emacsql-with-connection (db (emacsql-sqlite \"company.db\"))
    (emacsql db [:create-table foo [x]])
    (emacsql db [:insert :into foo :values ([1] [2] [3])])
    (emacsql db [:select * :from foo]))"
  (declare (indent 1))
  `(let ((,(car connection-spec) ,(cadr connection-spec)))
     (unwind-protect
         (progn ,@body)
       (emacsql-close ,(car connection-spec)))))