sql

All things SQL and JDBC...
2020-07-03T05:51:55.120500Z

I met a strange behavior in jdbc/plan and I don't know if it is wanted or not.

; This is working
(into [] (map #(:table/column %)) (jdbc/plan conn sql-query))

; This is not working
(into [] (map #(:table/column % :nop)) (jdbc/plan conn sql-query))

seancorfield 2020-07-03T05:52:51.121200Z

What is happening in that second case? (I would have expected it to work -- I thought I even had test cases for it)

2020-07-03T05:53:17.121700Z

never mind, it is working, it was a typo in my codebase

seancorfield 2020-07-03T05:53:29.122Z

Haha... OK... glad to hear it!

seancorfield 2020-07-03T05:57:03.122400Z

You know... I don't believe I have a test for that! I'll create an issue

1👍
kwrooijen 2020-07-03T07:26:12.122700Z

Didn't expect my question to spark such an in depth conversation haha. (I just woke up). Thanks a lot for the info! It does sound like I have to manage this for my specific vendor, which is fine. I at least have a good understanding about how I could tackle this issue

2020-07-03T09:09:24.123600Z

Is there a way in honeysql to format a query on multiple lines, so that it is easy to read for a human?

seancorfield 2020-07-03T16:35:23.124500Z

@vincent.cantin No. But that might be an interesting option, possibly for 2.0 so feel free to create an issue for it.

1👍