blob: 4937d96fefd380a9c49b8019a5521550a4fd5dbe (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
;; Copyright (c) Stephen C. Gilardi. All rights reserved. The use and
;; distribution terms for this software are covered by the Common Public
;; License 1.0 (http://opensource.org/licenses/cpl.php) which can be found
;; in the file CPL.TXT at the root of this distribution. By using this
;; software in any fashion, you are agreeing to be bound by the terms of
;; this license. You must not remove this notice, or any other, from this
;; software.
;;
;; test.clj
;;
;; test/example for clojure.contrib.sql.test
;;
;; scgilardi (gmail)
;; Created 13 September 2008
(ns clojure.contrib.sql.test
(:use clojure.contrib.sql))
(Class/forName "org.apache.derby.jdbc.EmbeddedDriver")
(defn db []
(connection "derby" "/tmp/clojure.contrib.sql.test.db;create=true"))
(defn db-write []
(with-connection con (db)
(try
(drop-table con "fruit")
(catch Exception e))
(create-table con "fruit"
"name varchar(32)"
"appearance varchar(32)"
"cost int"
"grade real")
(insert-rows con "fruit"
["Apple" "red" 59 87]
["Banana" "yellow" 29 92.2]
["Peach" "fuzzy" 139 90.0]
["Orange" "juicy" 89 88.6])
(insert-values con "fruit" ["name" "cost"]
["Mango" 722]
["Feijoa" 441])))
(defn db-read []
(with-connection con (db)
(with-results rec con
"select * from fruit"
(println rec))))
(defn db-grade-a []
(with-connection con (db)
(with-results rec con
"select name, cost from fruit where grade >= 90"
(println rec))))
(defn db-exception []
(with-connection con (db)
(insert-values con "fruit" ["name" "appearance"]
["Grape" "yummy"]
["Pear" "bruised"])
(throw (Exception. "an exception"))))
|
