Actually it should read:
(sql/defentity mytable
(:pk <<< YOUR PRIMARY KEY AS A KEYWORD>>>)
(sql/table <<<YOUR TABLE NAME AS A KEYWORD>>>)
(sql/database devdb))
(sql/select mytable (sql/fields :id) (sql/where {:id 1}))
On Nov 4, 3:21 pm, Base <[email protected]> wrote:
> Did you mean to define the select within the defentity?
>
> (sql/defentity mytable (sql/select mytable (sql/fields :id) (sql/
> where {:id 1})))
>
> I does this work?
>
> (sql/defentity mytable
> (:pk <<< YOUR PRIMARY KEY AS A KEYWORD>>>)
> (table <<<YOUR TABLE NAME AS A KEYWORD>>>)
> (database devdb))
>
> (sql/select mytable (sql/fields :id) (sql/where {:id 1}))
>
> On Nov 4, 10:44 am, AndyK <[email protected]> wrote:
>
>
>
>
>
>
>
> > I believe I have setup korma correctly with
> > (require '[korma.db :as db])
> > (require '[korma.core :as sql])
> > (db/defdb devdb (db/mysql {:db "mydb" :host "localhost" :user
> > "me" :password "mypass"}))
> > (sql/defentity mytable
> > (sql/select mytable (sql/fields :id) (sql/where {:id 1})))
>
> > But I'm getting
> > SQLException:
> > Message: Connections could not be acquired from the underlying
> > database!
> > SQLState: null
> > Error Code: 0
>
> > (db/get-connection devdb) returns a clojure.lang.PersistentHashMap -
> > is that right? or should it be the underlying java.sql.Connection?
>
> > I have the mysql driver in my classpath, am able to Class/forName the
> > driver, create a connection, and query on the connection - all
> > manually. Korma looks pretty cool and I'd like to be using, any ideas?
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
