Clojurians Log v2

Hi, I have a question for ‘next.jdbc.sql/insert’.

Can I use ‘var’ here by any chance? The query I want to use looks like this.

INSERT INTO test (id)
VALUES (@var := 1)
ON DUPLICATE KEY
    UPDATE id=(@var := id + 1);

Good Morning Clojurians, I am trying to understand how to use next jdbc transactions. In the example code:

(jdbc/with-transaction [tx my-datasource]
  (jdbc/execute! tx ...)
  (jdbc/execute! tx ...)) ; will commit, unless exception thrown

my-datasource should either be a connection or a datasource (or your connection pool). If you want a datasource then you should call (jdbc/get-datasource db-spec). Where db-spec is a hash-map with entries listed https://github.com/seancorfield/next-jdbc/blob/develop/doc/all-the-options.md#datasources-and-connections.

db-spec is the config that describes how to connect to the database, details like username, password, host and so on.

@kslvsunil, ok than what is tx ?

I thought the tx was the datasource since it is required by the jdbc/execute!

tx is just a binding, like your let bindings, the with-transaction is a macro that will create a transaction object from the supplied datasource/connection and bind it to tx. And this tx can be passed to the statements which you want to run inside that transaction.

Found some examples https://grep.app/search?q=with-transaction%20%5Btx

@kslvsunil, ok, wow, never know about the http://grep.app. This is awesome!!!

this feels like a sql question - if the insert helper doesn't do enough for you, just use execute!

I tried to solve it with insert helper, but in the end, I used ‘execute!’ as you said.

@timofey.sitnikov with-transaction is like with-open in Clojure: it introduces a new local binding with either a new connection drawn from the specified datasource, or by starting a transaction on the specified connection (which is why it is recommended to use a datasource there).

Like with-open, it "cleans up" the transaction at the end and closes the connection if it opened one.

I'll try to make that clearer in the docs.

Thanks for your reply.