Mercurial > hg > monetdb-ruby

annotate README.md @ 35:fedf9356cc5c default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update README.md
author Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
date Tue, 01 Jun 2021 15:13:27 +0200 (2021-06-01)
parents 16bb6d852171
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
29
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
1 # MonetDB-Ruby
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
2
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
3 Ruby driver for MonetDB
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
4
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
5 ## Installation
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
6
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
7 First build a gem file starting from the given gemspec:
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
8
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
9 ```bash
35
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
10 gem build monetdb-sql.gemspec
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
11 ```
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
12 Or:
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
13 ```bash
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
14 make
29
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
15 ```
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
16
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
17 Then install the resulting gem with the command:
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
18
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
19 ```bash
35
fedf9356cc5c Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 34
diff changeset
20 gem install --local monetdb-sql-1.2.gem
29
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
21 ```
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
22
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
23 ## Example
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
24 ```ruby
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
25 require_relative 'MonetDB'
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
26
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
27 conn = MonetDB.new
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
28 conn.connect(user = "monetdb", passwd = "monetdb", lang = "sql", host="127.0.0.1", port = 50000, database_connection_name = "demo", auth_type = "SHA1")
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
29
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
30 result =conn.query("SELECT 1")
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
31
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
32 result.each_record do |record|
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
33 puts record
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
34 end
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
35 ```
f84f521c7ea8 add README
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents:
diff changeset
36
33
c0ae750869de Update README.md
Mitchell Weggemans <mitchell.weggemans@monetdbsolutions.com>
parents: 29
diff changeset
37 A more extensive example can be found in /lib/example.rb