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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
# do_postgres
* <http://dataobjects.info>
## Description
A PostgreSQL driver for DataObjects.
## Features/Problems
This driver implements the DataObjects API for the PostgreSQL relational database.
## Synopsis
An example of usage:
```ruby
# default user (postgres, postgres), default port (5432)
DataObjects::Connection.new("postgres://host/database")
# specified user, specified port
DataObjects::Connection.new("postgres://user:pass@host:8888/database")
@connection = DataObjects::Connection.new("postgres://localhost/employees")
@reader = @connection.create_command('SELECT * FROM users').execute_reader
@reader.next!
```
## Requirements
This driver is provided for the following platforms:
* Ruby MRI (1.8.6/7), 1.9: tested on Linux, Mac OS X and Windows platforms.
* JRuby 1.3.1 + (1.4+ recommended).
* Rubinius (experimental).
Additionally you should have the following prerequisites:
* `data_objects` gem
* `do_jdbc` gem (shared library), if running on JRuby.
## Install
To install the gem:
```ruby
gem install do_postgres
```
To compile and install from source:
* Install rake-compiler: `gem install rake-compiler`.
* For MRI/Rubinius extensions:
* Install the `gcc` compiler. On OS X, you should install XCode tools. On
Ubuntu, run `apt-get install build-essential`.
* Install Ruby and PostgreSQL client.
* Install the Ruby and PostgreSQL development headers.
* On Debian-Linux distributions, you can install the following packages
with `apt`: `ruby-dev` `libpostgresql-dev`.
* If you want to cross-compile for Windows:
* Install MinGW:
* On Debian-Linux distributions, you can install the following package
with `apt`: `mingw32`.
* On OS X, this can install the following package with MacPorts: `i386-mingw32-gcc`.
* Run `rake-compiler cross-ruby`.
* Run `rake-compiler update-config`.
* For JRuby extensions:
* Install the Java Development Kit (provided if you are
on a recent version of Mac OS X) from <http://java.sun.com>.
* Install a recent version of JRuby. Ensure `jruby` is in your `PATH` and/or
you have configured the `JRUBY_HOME` environment variable to point to your
JRuby installation.
* Install `data_objects` and `do_jdbc` with `jruby -S rake install`.
* Then, install this driver with `(jruby -S) rake install`.
For more information, see the PostgreSQL driver wiki page:
<http://wiki.github.com/datamapper/do/postgresql>.
## Developers
Follow the above installation instructions. Additionally, you'll need:
* `rspec` gem for running specs.
* `YARD` gem for generating documentation.
See the DataObjects wiki for more comprehensive information on installing and
contributing to the JRuby-variant of this driver:
<http://wiki.github.com/datamapper/do/jruby>.
To run specs:
rake spec
To run specs without compiling extensions first:
rake spec_no_compile
To run individual specs:
rake spec SPEC=spec/connection_spec.rb
## License
This code is licensed under an **MIT (X11) License**. Please see the
accompanying `LICENSE` file.
|
