Clojure - return value from db query

Question

I want to created post as return value just after execute my db query function. Here is one example from my db functions:

(defn add-post-record [post]
   (sql/with-connection
    db
    (sql/insert-record :post post )))

and what i need in my route is something like:

(def post (db/add-post-record {:title title
                             :body body
                             :owner user
                             :isdraft isdraft}))

Then i am gonna use this like: (:id post)

I am so new in clojure. This may be a very simple problem but i am stuck.

thank you.

Assen Kolov · Accepted Answer · 2013-10-22 09:08:59Z

1

I can not test this right now, but reading the documentation of insert-record and with-connection, I think something like:

(defn add-post-record [post]
 (let [keys (sql/with-connection db
              (sql/insert-record :post post ))]
   (merge post keys))

It is not very clear to me what exactly the map returned by insert-record contains, try it out.

answered Oct 22, 2013 at 9:08

Assen Kolov

4,4633 gold badges25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

alioguzhan Over a year ago

i am gonna check this out a few hours later. gonna tell you the result. thanks

Collectives™ on Stack Overflow

Clojure - return value from db query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related