Get methods

gistfile1.clj

(def get-all-nominees "select * from nominees")

(defn get-sql 
  "Generic select statement functionality"
  [sql-stmt]
  (with-connection db
    (sql/with-query-results results sql-stmt
      (doall results))))

(defn get-nominees
  ([] (get-sql [get-all-nominees]))
  ([year] (get-sql [(str get-all-nominees " where year=?") year])))

(defn get-winners
  ([] (get-sql [(str get-all-nominees " where winner=1")]))
  ([year] (get-sql [(str get-all-nominees " where winner=1 and year=?") year])))