summaryrefslogtreecommitdiff
path: root/README.md
blob: 401d37d4224d46a079f0cf25628f2c38d3ffe523 (about) (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
# clojure-sql

A DSL for [Clojure][1] to compose queries using the constructs of
[Relational Algebra][2]. The RA constructs are then compiled into an
SQL query to be run on a DBMS. `clojure-sql` doesn't connect to a
database itself, but rather can be configured to perform an action
when a query is dereferenced.

`clojure-sql` provides some utility functions beyond strict RA to
allow for data to be inserted, updated and deleted.

`clojure-sql` provides no mechanism to create database schemas.

[1]: http://clojure.org/
[2]: http://en.wikipedia.org/wiki/Relational_Algebra

## Database support

`clojure-sql` aims to have an extensible compiler. Compilation of
queries is performed by multimethods which dispatch on an arbitrary
(and otherwise unused) `db` parameter. This allows the compilation of
queries to be entirely special-cased per database. By default
`clojure-sql` will produce standard ANSI SQL.

## Usage

    (require '[clojure-sql.core :as s])

    (-> (s/table :users)
        (s/project [:id :username]))
    ; => ["SELECT \"users\".\"id\", \"users\".\"username\" FROM \"users\""]

    (-> (s/table {:users :u})
        (s/project [:id :username])
        (s/rename {:id :uid})
        (s/join (-> (s/table {:people :p})
                    (s/project {:id :pid, :fname :first})
                    (s/select '(= :first "Henry")))
                '(= :uid :pid))
        (s/project [:username]))
    ; => ["SELECT \"u\".\"username\" FROM \"users\" AS \"u\" JOIN \"people\" AS \"p\" ON (\"u\".\"id\" = \"p\".\"id\") WHERE (\"p\".\"fname\" = ?)" "Henry")]
    
    (s/use-jdbc!) ; TODO
    ; => nil


## License

Copyright © 2013 FIXME

Distributed under the Eclipse Public License, the same as Clojure.