honeysql 2023-03-22 | Slack Archive

Noah Bogart15:03:09

I have a v1 insert-into with `query-values` that formats to "insert into temp_table (with "rows" as (select * from ...) ...)": `(-> (insert-into :temp-table) (query-values (-> (with [:rows (-> (select :*) (from :other) ...)]) ...))`, and i want to transform this to v2. reading the docs, i feel like it should be `(-> (insert-into [:temp-table (-> (with [:rows (-> (select :*) (from :other) ...)]))] ...))` but that doesn't give me the right output.

Noah Bogart15:03:00

Hmm, seems i need to leave off the vector from the insert-into call

Noah Bogart16:03:26

#Also sent to the channel

opened a github issue about this misunderstanding (and related misunderstandings) https://github.com/seancorfield/honeysql/issues/480

seancorfield18:03:32

I'm not sure if I understand where the root of the confusion is, so I asked a question there to clarify...

👍 2

Noah Bogart16:03:26

replied to a thread:I have a v1 insert-into with `query-values` that formats to "insert into temp_table (with "rows" as (select * from ...) ...)": `(-> (insert-into :temp-table) (query-values (-> (with [:rows (-> (select :*) (from :other) ...)]) ...))`, and i want to transform this to v2. reading the docs, i feel like it should be `(-> (insert-into [:temp-table (-> (with [:rows (-> (select :*) (from :other) ...)]))] ...))` but that doesn't give me the right output.

opened a github issue about this misunderstanding (and related misunderstandings) https://github.com/seancorfield/honeysql/issues/480

2023-03-22

Channels