This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2022-08-23
Channels
- # babashka (104)
- # beginners (23)
- # calva (15)
- # cider (2)
- # clojure (29)
- # clojure-europe (14)
- # clojure-nl (2)
- # clojure-norway (3)
- # clojure-spec (4)
- # clojure-switzerland (1)
- # cursive (3)
- # datomic (6)
- # emacs (17)
- # etaoin (2)
- # expound (1)
- # fulcro (4)
- # graphql (4)
- # honeysql (7)
- # introduce-yourself (2)
- # jackdaw (5)
- # malli (3)
- # meander (19)
- # nbb (3)
- # off-topic (35)
- # pathom (6)
- # pedestal (4)
- # polylith (31)
- # rdf (11)
- # re-frame (8)
- # reitit (6)
- # shadow-cljs (8)
- # specter (4)
- # squint (15)
- # vim (6)
Hi, in honeysql 1.0.461, does :except
get converted to minus
in an Oracle 18 context? Thank you
HoneySQL 1.x knows nothing about dialects so if it supports :except
at all it would always produce EXCEPT
-- but I don't think it supports that?
Ah, yeah, looks like :except
support was added in 0.9.10 back in March 2020. And it's a pretty simple formatter:
(defmethod format-clause :except [[_ maps] _]
(binding [*subquery?* false]
(string/join " EXCEPT " (map to-sql maps))))
Are you getting some strange behavior?
No sir, this was just a question that came up. I looked at this line, trying to answer it https://github.com/seancorfield/honeysql/blob/v1/src/honeysql/helpers.cljc#L381 but apparently that isn't the same place you pointed out
Ah, yes, the build-clause
stuff is how the helpers were handled in v1, and they build a data structure -- nothing more -- which is then turned into SQL via format-clause
which is what I linked to.