Re: setting foreign and primary key with contrib.sql ? how to setup db with un and pw?

[Stephen C. Gilardi]

On Jan 6, 2009, at 1:37 PM, ssecorp wrote:

(def db {:classname "org.apache.derby.jdbc.EmbeddedDriver"
        :subprotocol "derby"
        :subname "C:/clojure/progs/netflix/netflix.db"
        :create true})

would I add this to set username and password?
;;       :user "ninja"
;;       :password "kalle"})

Yes

(defn create-reviews-table []
 (sql/create-table :reviews
                    [:customerid :int]
                    [:movieid :int]
                    [:reviewdate "DATE"]
                    [:grade :int]))

how would I set foreign and primary key?

Does this not work?

        (defn create-reviews-table []
         (sql/create-table :reviews
                            [:customerid :int "primary key"]
                            [:movieid :int "foreign key"]
                            [:reviewdate "DATE"]
                            [:grade :int]))



--Steve

All the items in a column spec after the column name are included in the sql to create the column separated by spaces. I see from reviewing the create-table syntax just now that sql/create- table doesn't currently allow "table-level-constraints". I'll have to look at that.

smime.p7s
Description: S/MIME cryptographic signature