Source

Fountain-JDBC / README

Shantanu Kumar eb881ba 

Shantanu Kumar c3fe858 
Shantanu Kumar eb881ba 





Shantanu Kumar 3094343 
Shantanu Kumar eb881ba 



















Shantanu Kumar 4ddfae1 
Shantanu Kumar eb881ba 
Shantanu Kumar 4ddfae1 
Shantanu Kumar dafe19d 
Shantanu Kumar 4ddfae1 
Shantanu Kumar eb881ba 
Shantanu Kumar 184d3dc 
Shantanu Kumar eb881ba 
Shantanu Kumar 4ddfae1 




Shantanu Kumar eb881ba 
Shantanu Kumar 4ddfae1 



Shantanu Kumar eb881ba 


Shantanu Kumar 4ddfae1 





Shantanu Kumar c3fe858 
Shantanu Kumar 4ddfae1 
Shantanu Kumar c3fe858 
Shantanu Kumar 4ddfae1 




















































Shantanu Kumar 24bc518 
Shantanu Kumar 4ddfae1 























-*- markdown -*-

# Fountain-JDBC v0.2

Fountain-JDBC is a Clojure wrapper for Spring-JDBC (a component to deal with JDBC
in Spring framework.) The current scope is:

* Parameterized SQL statements
* Database metadata assisted Inserts
* Transactions (1. programmatic, 2. predicate based, 3. rule based)


## Usage

Maven/Leiningen dependency details are here: [http://clojars.org/org.bituf/fountain-jdbc](http://clojars.org/org.bituf/fountain-jdbc)

Examples for usage can be found in the tutorial below:


## Building/Installation

You will need Maven 2 to build from sources. Execute the following:

    $ mvn clean package  # packages up a JAR in "target" dir
    $ mvn install        # to install to your local Maven repo
    $ mvn clojure:gendoc # generate Clojure API documentation


## License

   Copyright (C) 2011 Shantanu Kumar (kumar[dot]shantanu[at]gmail[dot]com)

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this software except in compliance with the License.
   You may obtain a copy of the License at

   [http://www.apache.org/licenses/LICENSE-2.0](http://www.apache.org/licenses/LICENSE-2.0)

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.


# Documentation

You can include Fountain-JDBC to your project by including its namespace:

    (use 'org.bituf.fountain.jdbc)


## Quickstart

Create a new project and include the following dependencies:


    [org.bituf/clj-dbcp "0.5"]
    [org.bituf/oss-jdbc "0.4"]
    [org.bituf/fountain-jdbc "0.2"]

Define the CRUD functions as follows:

    ;; filename fooapp/src/fooapp/dbcrud.clj
    (ns fooapp.dbcrud
      (:require
        [org.bituf.fountain.jdbc :as jd]))
    
    (def sql-ct "CREATE TABLE sample
                       (sample_id INT         NOT NULL PRIMARY KEY AUTO_INCREMENT,
                        name      VARCHAR(30) NOT NULL,
                        age       INT)")
    
    (defn create-table
      []
      (jd/update sql-ct))
    
    (defn insert-new
      [m] {:pre [(map? m)]}
      (let [sji (jd/make-sji :sample
                  :gencols :sample-id)]
        (jd/insert-give-id sji m)))
    
    (defn find-by-id
      [id]
      (jd/query-for-map
        "SELECT * FROM sample WHERE sample_id = :id"
        {:id id}))
    
    (defn update-age-by-id
      [id new-age]
      (jd/update
        "UPDATE sample SET age = :age WHERE sample_id = :id"
        {:age new-age
         :id  id}))
    
    (defn delete-by-id
      [id]
      (jd/update
        "DELETE FROM sample WHERE sample_id = :id"
        {:id id}))


Now create another file that you can use for integration:

    ;; filename fooapp/src/fooapp/dbaction.clj
    (ns fooapp.dbaction
      (:require [fooapp.dbcrud :as crud]
        [org.bituf.clj-dbcp      :as dbcp]
        [org.bituf.clj-dbspec    :as spec]
        [org.bituf.fountain.jdbc :as jd]))
    
    ;; define datasource for supported database using Clj-DBCP
    (def ds (dbcp/mysql-datasource "localhost" "dbname" "dbuser" "password"))
    
    (defn do-action "Wrap f using DBSpec middleware and execute it"
      [f] {:pre [(fn? f)]}
      (let [g (spec/wrap-dbspec (spec/make-dbspec ds)
        (jd/wrap-sjt f))]
        (g)))

Once you are done with these, you can go to the REPL and execute commands as follows:

    user=> (require ['fooapp.dbcrud :as 'cr])
    nil
    user=> (require ['fooapp.dbaction :as 'ac])
    nil
    user=> (ac/do-action cr/create-table)
    CREATE TABLE...(rest of the message truncated)
    user=> (ac/do-action #(cr/insert-new {:name "Harry" :age 30}))
    Returning generated...(rest of msg truncated)

You got the drift. You need to pass a function to do-action be executed in the
context of data source etc.


## Reference

Please check The Bitumen Framework Handbook [https://bitbucket.org/kumarshantanu/bituf-handbook/src](https://bitbucket.org/kumarshantanu/bituf-handbook/src)
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.