emacs-elpa-diffs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[nongnu] elpa/emacsql e900f99091 075/427: Update examples.


From: ELPA Syncer
Subject: [nongnu] elpa/emacsql e900f99091 075/427: Update examples.
Date: Tue, 13 Dec 2022 02:59:29 -0500 (EST)

branch: elpa/emacsql
commit e900f990910e6447966e7ee91f27494b3ff204d9
Author: Christopher Wellons <wellons@nullprogram.com>
Commit: Christopher Wellons <wellons@nullprogram.com>

    Update examples.
---
 README.md  | 13 +++++++++----
 emacsql.el |  9 +++++----
 2 files changed, 14 insertions(+), 8 deletions(-)

diff --git a/README.md b/README.md
index 560959af0f..d189cbbe10 100644
--- a/README.md
+++ b/README.md
@@ -27,15 +27,20 @@ Requires Emacs 24 or later.
 (emacsql db [:create-table people [name (id integer :unique) (salary float)]])
 
 ;; Insert some data:
-(emacsql-insert db 'people ["Jeff"  1000 60000.0]
-                           ["Susan" 1001 64000.0])
+(emacsql db [:insert :into people
+             :values (["Jeff"  1000 60000.0] ["Susan" 1001 64000.0])])
 
 ;; Query the database for results:
-(emacsql db [:select [name id] :from people :where (> salary 62000)])
+(emacsql db [:select [name id]
+             :from people
+             :where (> salary 62000)])
 ;; => (("Susan" 1001))
 
 ;; Queries can be templates, using $1, $2, etc.:
-(emacsql db [:select [name id] :from people :where (> salary $1)] 50000)
+(emacsql db [:select [name id]
+             :from people
+             :where (> salary $1)]
+         50000)
 ;; => (("Jeff" 1000) ("Susan" 1001))
 ```
 
diff --git a/emacsql.el b/emacsql.el
index 5dd6ba7fed..c0fa338734 100644
--- a/emacsql.el
+++ b/emacsql.el
@@ -28,16 +28,16 @@
 ;; Table identifiers can be any lisp object: string, symbol, etc. I
 ;; suggest using a symbol. Use `emacsql-create' to create a table.
 
-;;     (emacsql-create db 'employees [name id salary])
+;;     (emacsql db [:create-table people [name id salary]])
 
 ;; Column constraints can optionally be provided.
 
-;;     (emacsql-create db 'employees [name (id integer) (salary real)])
+;;     (emacsql db [:create-table people [name (id integer :unique) salary]])
 
 ;; Insert values into a table with `emacsql-insert'.
 
-;;     (emacsql-insert db 'employees ["Jeff"  1000 60000.0]
-;;                                   ["Susan" 1001 64000.0])
+;;     (emacsql db [:insert :into people
+;;                  :values (["Jeff"  1000 60000.0] ["Susan" 1001 64000.0])])
 
 ;; Currently all actions are synchronous and Emacs will block until
 ;; SQLite has indicated it is finished processing the last command.
@@ -48,6 +48,7 @@
 ;;     ;; => (("Susan" 1001))
 
 ;; Queries can be templates using $1, $2, etc.:
+
 ;;     (emacsql db
 ;;              [:select [name id] :from employees :where (> salary $1)]
 ;;              50000)



reply via email to

[Prev in Thread] Current Thread [Next in Thread]