api   blog   github     login / sign up

ClojureDocs(beta)

Clojure Contrib

Namespaces

 
doc source examples comments
1.2.0 permalink Arrow_down_16x16

update-or-insert-values

clojure.contrib.sql

  • (update-or-insert-values table where-params record)
Updates values on selected rows in a table, or inserts a new row when no
existing row matches the selection criteria. where-params is a vector
containing a string providing the (optionally parameterized) selection
criteria followed by values for any parameters. record is a map from
strings or keywords (identifying columns) to updated values.
© Rich Hickey. All rights reserved. Eclipse Public License 1.0

0 Examples top

Log in to add / edit an example.

See Also top

Log in to add a see also.

Plus_12x12 Minus_12x12 Source clojure/contrib/sql.clj:182 top 

(defn update-or-insert-values
  "Updates values on selected rows in a table, or inserts a new row when no
  existing row matches the selection criteria. where-params is a vector
  containing a string providing the (optionally parameterized) selection
  criteria followed by values for any parameters. record is a map from
  strings or keywords (identifying columns) to updated values."
  [table where-params record]
  (transaction
   (let [result (update-values table where-params record)]
     (if (zero? (first result))
       (insert-values table (keys record) (vals record))
       result))))
© Rich Hickey. All rights reserved. Eclipse Public License 1.0
Vars in clojure.contrib.sql/update-or-insert-values: insert-values transaction defn first keys let vals zero?
Used in 0 other vars

Comments top

No comments for update-or-insert-values. Log in to add a comment.

 
ClojureDocs uses some elements of HTML5 / CSS3, and is best viewed in an up-to-date gecko / webkit -based browser.

© 2010 Zachary Kim http://zacharykim.com