[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[nongnu] elpa/emacsql 213bb71b7a 152/427: Add :having expander.
From: |
ELPA Syncer |
Subject: |
[nongnu] elpa/emacsql 213bb71b7a 152/427: Add :having expander. |
Date: |
Tue, 13 Dec 2022 02:59:37 -0500 (EST) |
branch: elpa/emacsql
commit 213bb71b7a1a6bbacd8e6b4e3955a6cd7788b58f
Author: Christopher Wellons <wellons@nullprogram.com>
Commit: Christopher Wellons <wellons@nullprogram.com>
Add :having expander.
---
README.md | 5 +++--
emacsql.el | 4 ++++
2 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/README.md b/README.md
index d6d22ed5fa..bd92bb97f1 100644
--- a/README.md
+++ b/README.md
@@ -200,12 +200,13 @@ Provides `FROM`.
[... :from [(as (:select ...) s1) (as (:select ...) s2)]]
```
-#### :where `<expr>`
+#### :where `<expr>`, :having `<expr>`
-Provides `WHERE`.
+Provides `WHERE` and `HAVING`.
```el
[... :where (< count 10)]
+[... :having (= size 10)]
```
#### :group-by `<expr>`
diff --git a/emacsql.el b/emacsql.el
index 0056f4050c..f9de57cc91 100644
--- a/emacsql.el
+++ b/emacsql.el
@@ -609,6 +609,10 @@ definitions for return from a `emacsql-defexpander'."
(emacsql-with-vars "WHERE "
(expr expr)))
+(emacsql-defexpander :having (expr)
+ (emacsql-with-vars "HAVING "
+ (expr expr)))
+
(emacsql-defexpander :group-by (expr)
(emacsql-with-vars "GROUP BY "
(expr expr)))
- [nongnu] elpa/emacsql 58e31aa3a9 079/427: Add :update and :set expanders., (continued)
- [nongnu] elpa/emacsql 58e31aa3a9 079/427: Add :update and :set expanders., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql c9aab20d47 082/427: Add in operator (special case operator)., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 25f9817064 094/427: Add work-in-progress note back., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 03295cba37 119/427: Add ORDER BY expanders., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql d1c0904564 120/427: Fix missing quotes., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 4718ff4e89 122/427: Simplify all the expanders with new local functions., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 54247e4b5e 127/427: Add another insertion unit test., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql aa9283ca0a 132/427: Allow sub-selects with :from., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql c236aa8437 144/427: Remove extra space., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 75ea77c9a0 149/427: Add an "as" operator, greatly simplifying :from., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 213bb71b7a 152/427: Add :having expander.,
ELPA Syncer <=
- [nongnu] elpa/emacsql 8123020ca7 153/427: Make and and or operators variadic., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 76bf0c34dc 038/427: Add rudimentary :where expander., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql afe64ca63a 040/427: Fix emacsql-add-expander example., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 72145a1627 045/427: Allow for multi-arity keyword expanders., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql f54142f1eb 062/427: Argument list checking in emacsql-format., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 86687b6ba3 067/427: Flesh out more README., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql a306de980a 070/427: Add :delete keyword., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql afa9aa5194 072/427: Add :into expander., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql 8f59fe6e80 073/427: Add a vector escape., ELPA Syncer, 2022/12/13
- [nongnu] elpa/emacsql eb3283990e 077/427: Drop emacsql-create., ELPA Syncer, 2022/12/13