Clojurians Log v2

Is there an option for execute so that the key isn't :count(*) (which doesn't seem to be a valid keyword), without changing the query?

1. You can construct the keyword from a string:

(keyword "count(*)")
:count(*)

(-> result first (get COUNT_KEYWORD))

(-> result second first)

can you give the count a name? count(*) as cnt

if your query has no other columns, just take the first row and the first map entry, and its value :

(-> result first first val)

count(*) is what JDBC returns for the column label if there is no alias. next.jdbc is a *very* thin wrapper here 🙂

@igrishaev minor note: you can ffirst instead of first first

Another option: (plan/select-one! ds (comp first vals) ["select count(*) from user"]) 🙂

why not specify a column alias explicitly, like SELECT count(*) AS 'frob/count' FROM mytable? (the AS is optional, btw and the column alias quoting might be different, depending on the SQL dialect)

In this case I cannot control the query