Guest User

Untitled

a guest
Jul 2nd, 2015
258
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. (defn crud-update [schema]
  2.   (let [table-name (:table-name schema)
  3.         fields (dissoc (:fields schema) :id)
  4.         field-names (map first fields)
  5.         field-names-no-colon (map #(clojure.string/replace-first % ":" "") field-names)
  6.         fields-joined (map vector field-names-no-colon field-names)
  7.         fields-assigned (map #(interpose "=" %) fields-joined)
  8.         updates-line (apply str (interpose ", " fields-assigned))]
  9.     (apply str (str "-- name:update-" table-name "!\n")
  10.            (str "UPDATE " table-name " SET\n")
  11.            (str updates-line "\n")
  12.            (str "WHERE id = :id"))))
  13.  
  14. techstack.util.sql-to-yesql.main> (crud-update x)
  15. "-- name:update-variance!\nUPDATE variance SET\nclojure.lang.LazySeq@e6aa22e2, clojure.lang.LazySeq@3f373d7b, clojure.lang.LazySeq@fc8dfb0\nWHERE id = :id"
  16. techstack.util.sql-to-yesql.main>
Advertisement
Add Comment
Please, Sign In to add comment