do i need to do something special to use hugsql snippets with conman? Parameters are never passed to the snippet. Debugging found that db connection is passed instead the parameters map.

this is the state on sqlvec-fn* when calling a snippet (search-snip {:tenant-id 1698}):

Class: clojure.lang.PersistentArrayMap
Contents: 
  0. [ psql [ "FROM   trd_product p, trd_contract c\nWHERE  p.productid = c.productid AND\n       p.tenantid = " { :type :v, :name :tenant-id } ] ]
  1. [ options {} ]
  2. [ y hugsql.core$sqlvec_fn_STAR_$y__64066@2084d943 ]
  3. [ param-data { :datasource HikariDataSource (HikariPool-21) } ]
  4. [ opts { :tenant-id 1698 } ]

@jmayaalv That definitely looks like a bug, because sqlvec functions should not take a db connection at all.

Ah, maybe it is the usage of sqlvec function vs a :snip. Conman should handle snippets just fine. How is search-snip defined in your SQL file?

this is the snippet:

-- :snip search-snip
FROM   trd_product p, trd_contract c
WHERE  p.productid = c.productid AND
       p.tenantid = :tenant-id

It might be worth putting this in as a bug so we can get to the bottom of it. HugSQL passes metadata along indicating that the function is a snippet, and conman uses that to handle snippets differently. Feel free to put in an issue on HugSQL, and we'll try to reproduce the issue: https://github.com/layerware/hugsql/issues

thanks @curtis.summers. i will

btw, Thank you for Hugsql 🙂 It’s great 🙂

You're welcome! 🙂

a work around is to call: (edge-ui.db.core/search-snip {:tenant-id 1698} nil)

the output is: ["From trd_product p, trd_contract c\nWHERE p.productid = c.productid AND\n p.tenantid = ?" 1698]