Explore composable features about hugsql HOT 7 CLOSED

We might could have SQL snippets identified in the SQL file with a -- :snippet special comment (as opposed to -- :name), or using some inline snippet notation within a regular query. A Snippet Parameter Type would integrate snippet function results passed as parameter data into the regular query functions.

from hugsql.

Hey, that is great. Ideally I would have one snippet for 'restrict by X' another for 'restrict by Y', 'restrict by Z' etc. and a fully formed query. I could then 'attach' the relevant 'snippets' to the query based on the runtime data. If they only restrict by 'Y' then I 'attach' the 'restrict by X' snippet to the query?

For clarity - in my current Honey SQL implementation I have something like the following:

(defn restrict-by-x [filter m] (if (:x filter) (add-where m [:= :x (:x filter)]) m)
(defn restrict-by-y [filter m] (if (:y filter) (add-where m [:= :y (:y filter)]) m)
(defn restrict-by-z [filter m] (if (:z filter) (add-where m [:= :z (:z filter)]) m)

(defn filter->sql [filter] 
  (-> (base-query filter)
        (restrict-by-x filter)
        (restrict-by-y filter)
        (restrict-by-z filter))

No, of course I don't really do that, but I hope it clarifies the intent :-)

from hugsql.

+1 for snippet

from hugsql.

As of 0.4.0, we have Clojure Expressions and Snippets to compose your SQL. Check'em out!

from hugsql.

Hello guys,

I'm not sure how the snippets work:

-- :snip test-snip
select * from store.contents

-- :name test-contents :? :*
:snip:test-snip limit 10

The following error is shown: Parameter Mismatch: :test-snip parameter data not found

The sql queries are parsed by means of: hugsql/map-of-db-fns-from-string.

I am pretty sure I am missing something, but I do not know what it is.

from hugsql.

Snippets create functions in your namespace that you must provide in your larger query function's parameters:

(test-contents db {:test-snip (test-snip)}

Read through https://www.hugsql.org/#using-snippets for more, and check out https://www.hugsql.org/#using-expressions for runtime composability.

from hugsql.

Thanks for the quick answer, but I can't get it working.
Should I do any ns-resolve with the name of the snippet in order to resolve it? I have tried (ns-resolve 'mynamespace (symbol "test-snip")) but I get a nil.

from hugsql.