CODEWITHSUNDEEP
clojurekorma
cap10morgan
cap10morgan

Reputation: 121

How do you make Korma output the SQL it would execute?

I'm trying to get Korma to output the SQL it would execute so I can debug a problem I'm having, but the docs are very terse on how to use the as-sql function. Can anyone give me an example of how to make Korma output the SQL for an INSERT query?

Upvotes: 10

Views: 1577

Answers (2)

shock_one
shock_one

Reputation: 5925

If you want to get the SQL query as a string, there is also sql-only

(println     
    (sql-only
        (select users)))

Upvotes: 8

Arthur Ulfeldt
Arthur Ulfeldt

Reputation: 91534

from: http://sqlkorma.com/api/0.3.0/korma.core.html

dry-run
(dry-run & body)
Wrap around a set of queries to print to the console all SQL that would 
be run and return dummy values instead of executing them.

Upvotes: 12

Related Questions