Clojurians Log v2

@achikin did you ever solve that HugSQL issue?

@admay Sorry for not answering you. I gave up and found the other way.

Let me give you more details on the issue.

No worries man! That’d be great, I’m putting together a big of an internal HugSQL guide for my team and can always use more material

@achikin uploaded a file: https://clojurians.slack.com/files/U3A7Z18JZ/F8R7AA2J3/-.sql

The issue is that :date_start could possibly be nil

So I tried to wrap it up into when like this

And this fails with various errors.

My general goal was to reuse that huge select statement with various conditions, but it appears that snippets are not as straightforward as I expected.

So I ended up passing (java.util.Date. 0) instead of nil in request params and that works well, but that's not a general solution for my issue.

select
<lots of joined tables here>
where
some condition
/*~ (if (:ids params) */
and id in (:v*:ids)
/*~*/
and some condition
and some condition
/*~ ) ~*/
--~ (when (:date_start params) "and date >= :date_start")