Hello Team,

I am new to clojure and I wanted to write a function where input from map 
keys are passed as parameter as input to the sql query.

(def query-body1 "
select first_name, last_name
from ${table_name}
where 
  person_id=${person_id}
order by ${id}
")


(def query-body2 "
select first_name, last_name
from ${table_name}
where 
  person_id=${person_id},
  and first_name=${first_name},
  and last_name=${last_name},
order by ${id}
")

(functiona-name query-body1  (:table_name "Employee", :person_id 123, id: 
"ABC"))

(functiona-name query-body2 (:table_name "Employee", :person_id 123, 
:first_name "John", :last_name "David", id: "ABC"))

output should be 
select first_name, last_name
from Employee
where 
  person_id=123,
  and first_name=John,
  and last_name=David,
order by ${id}

How can I achieve this?

Thanks,
Ganesh N

-- 
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your 
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to clojure+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/clojure/3695bf0e-95df-4bce-b4a1-575c110c7994n%40googlegroups.com.

Reply via email to