Hey everyone -I'm trying to simply retrieve a bool out of my database like so:

(defn- check-privilages
  "Checks if the userID is an admin"
  [id]
  (let [[query] (sql/query @db-spec
      [ "SELECT IsAdmin From Users
        WHERE UserID=?
        LIMIT 1"
        id])]
    (println
      (true? (:users/isadmin query)))
    (assoc id :is-admin 
      (true? (:users/isadmin query)))))

org.postgresql.util.PSQLException: No hstore extension installed.
	at org.postgresql.jdbc.PgPreparedStatement.setMap(PgPreparedStatement.java:465)
	at org.postgresql.jdbc.PgPreparedStatement.setObject(PgPreparedStatement.java:948)
	at next.jdbc.prepare$eval5154$fn__5155.invokePrim(prepare.clj:36)
	at next.jdbc.prepare$eval5154$fn__5155.invoke(prepare.clj)

any ideas?

I'm calling it like so :

id (check-privilages (:identity request))]

You're treating id as a hash map (the assoc). Is it numeric or a hash map? If it is a hash map, then you'll need to extract just the ID value in the sql/query call where id is a parameter @ashley

The call to .setMap in the stacktrace suggests id is a hash map...

oh my gosh you're right, I forgot to destructure it. Been doing some heavy refactoring! Let me try again

Also, BTW, if could replace (let [[query] (sql/query ,,,)] ,,,) with (let [query (jdbc/execute-one! ,,,)] ,,,) (and I'd probably use result or row instead of query.

It is, its the identity of request to my server. I used to pass in the ID, but now I'm passing in the entire identity map, so that this function can elevate privileges for the current API call

always helps to have fresh eyes when you've been working with the same code for hours

yeah, I've been using the sql-friendly functions like insert! rather than execute-one!. Is query not a good convention then?

@seancorfield are you still on vacation? What ar eyou doing on here? 😛

Got back from the UK Tuesday. Working, working, working now 🙂

did you enjoy your time here? 🙂