On Wed, May 20, 2009 at 11:17:14AM +0000, Gabriele Modena wrote:

Update of /cvsroot/monetdb/clients/src/ruby In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30426

Modified Files: Changelog README TODO ruby-monetdb-sql-0.1.gem Added Files: activerecord-monetdb-adapter-0.1.gem activerecord-monetdb-adapter-0.1.gemspec Log Message: Fixed bugs that prevented the correct working of activerecords' migration; The activerecord connector now supports insertion, update and alter table operations; Type casting is working in activerecord; Added a rubygem and rakefile for activerecord-monetdb-adapter; Added a new usage example for activerecord to the README file; Added an example directory to the cvs tree; The driver now correctly works with merovingian.

^^^^^^^^^^

Shouldn't this checkin then have gone to the May2009 release branch?

See `man cvs` and/or pages 8 - 16 of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf for information about how to use CVS branches in genral and/or with MonetDB in particular. Don't hesitate to ask if you have questions.

Please check with Sjoerd, whether a(n execptional!) back-port is desired; if so, see the above references (or ask) how to do this using CVS commands, only. If required, I can help.

Stefan

U Changelog Index: Changelog =================================================================== RCS file: /cvsroot/monetdb/clients/src/ruby/Changelog,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- Changelog 9 May 2009 14:49:30 -0000 1.2 +++ Changelog 20 May 2009 11:17:12 -0000 1.3 @@ -1,3 +1,13 @@ +* Mon 18 May 2009 15:22:31 CEST +Fixed bugs that prevented the correct working of activerecords' migration; +The activerecord connector now supports insertion, update and alter table operations; +Type casting is working in activerecord; +Added a rubygem and rakefile for activerecord-monetdb-adapter; +Added a new usage example for activerecord to the README file; +Added an example directory to the cvs tree; +The driver now correctly works with merovingian.

• Sat 9 May 2009 15:58:36 CEST

Fixed bugs with the query processing in the standalone driver; Added INSERT and UPDATE methods in the activerecord connector.

--- NEW FILE: activerecord-monetdb-adapter-0.1.gemspec --- Gem::Specification.new do |s| s.required_ruby_version = '>= 1.8.0' s.name = %q{activerecord-monetdb-adapter} s.version = "0.1" s.date = %q{2009-05-18} s.authors = ["G Modena"] s.email = %q{gm@cwi.nl} s.summary = %q{ActiveRecord Connector for MonetDB} s.homepage = %q{http://monetdb.cwi.nl/%7D s.description = %q{ActiveRecord Connector for MonetDB built on top of the pure Ruby database driver} s.files = [ "adapter/active_record/connection_adapters/monetdb_adapter.rb" ] s.has_rdoc = true s.require_path = './lib' s.add_dependency(%q<activerecord>, [">= 2.3.2"]) s.add_dependency(%q<ruby-monetdb-sql>, [">= 0.1"]) end

U ruby-monetdb-sql-0.1.gem Index: ruby-monetdb-sql-0.1.gem =================================================================== RCS file: /cvsroot/monetdb/clients/src/ruby/ruby-monetdb-sql-0.1.gem,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 Binary files /tmp/cvs9arhWX and /tmp/cvsfjZs3J differ

--- NEW FILE: activerecord-monetdb-adapter-0.1.gem --- (This appears to be a binary file; contents omitted.)

U README Index: README =================================================================== RCS file: /cvsroot/monetdb/clients/src/ruby/README,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- README 7 May 2009 15:06:41 -0000 1.3 +++ README 20 May 2009 11:17:12 -0000 1.4 @@ -2,7 +2,6 @@ This directory contains the a ruby interface to monetdb5 written in pure ruby.

lib/MonetDB.rb lib/MonetDBConnection.rb lib/MonetDBStatements.rb @@ -16,54 +15,8 @@

doc/: rubydoc in HTML format

-== ActiveRecord adapter == -Active Record connects business objects and database tables to create a persistable domain model where logic and data are presented in one wrapping. It‘s an implementation of the object-relational mapping (ORM) pattern.

-Required files: -adapter/lib/active_record/monetdb_adapter.rb

-At the moment connection and SELECT queries are supported.

-Usage example follows:

-require 'active_record'

-ActiveRecord::Base.establish_connection(

•    :adapter => "monetdb",  
  

•    :host => "localhost",  
  

•    :database => "demo"  
  

-)

-# map the tables schema to a class -class Tables < ActiveRecord::Base -end

-# return the first result of the query SELECT * from tables -puts Tables.find(:first)

-== Rubygem ==

-The standalone ruby driver can be distributed as a ruby gem. -A gem file is already available; however, it can be generated -starting from the ruby-monetdb-sql-0.1.gemspec file:

-$ gem build ruby-monetdb-sql-0.1.gemspec

-To install the file run the command:

-$ gem install ruby-monetdb-sql-0.1.gem

-Documentation in ri and html format will be generated and installed as well

== Usage == -To use the driver import the 'MonetDB' class and 'rubygems' (in case you installed it using gems).

-* Processing Statements that Return a Result Set +To use the standalone driver import the 'MonetDB' class and 'rubygems' (in case you installed it using gems).

A typical sequence of events is as follows: Invoke query using the database handle to send the statement to the server and get back a result set object. @@ -104,3 +57,85 @@ db.close

See lib/demo.rb and the MonetDBDatar class documentation for more examples.

+== ActiveRecord connector adapter == +Active Record connects business objects and database tables to create a persistable domain model where logic and data are presented in one wrapping. It‘s an implementation of the object-relational mapping (ORM) pattern.

+Required files:

+adapter/lib/active_record/monetdb_adapter.rb

+Usage example follows: +require 'active_record'

+ActiveRecord::Base.logger = Logger.new(STDERR) +ActiveRecord::Base.colorize_logging = true

+ActiveRecord::Base.establish_connection(

•    :adapter => "monetdb",
  

•    :host => "localhost",
  

•    :database => "demo"
  

+)

+# Create a new table +class AddTests < ActiveRecord::Migration

• def self.up
• create_table :tests do |table|

•    table.column :name, :string
  

•    table.column :surname, :string
  

• end
• end
• def self.down
• drop_table :tests
• end

+end

+AddTests.up

+# Migration: add a column name with a default value +class AddAge < ActiveRecord::Migration

• def self.up
• add_column :tests, :age, :smallint, :default => 18
• end
• def self.down
• remove_column :tests, :age
• end

+end

+class Test < ActiveRecord::Base +end

+# Insert an entry in the table +Test.create(:name => 'X', :surname => 'Y')

+# add a column +AddAge.up

+# return the first result of the query SELECT * from tables +row = Test.find(:first) +printf "SELECT * from tests LIMIT 1:\n" +printf "Name: %s, Surname: %s, Age: %s\n", row.name, row.surname, row.age

+# Drop the table +AddTests.down

+== Rubygem ==

+The standalone ruby driver can be distributed as a ruby gem. +A gem file is already available; however, it can be generated +starting from the ruby-monetdb-sql-0.1.gemspec file:

+$ gem build ruby-monetdb-sql-0.1.gemspec

+To install the file run the command:

+$ gem install ruby-monetdb-sql-0.1.gem

+Documentation in ri and html format will be generated and installed as well

U TODO Index: TODO =================================================================== RCS file: /cvsroot/monetdb/clients/src/ruby/TODO,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- TODO 7 May 2009 15:06:41 -0000 1.2 +++ TODO 20 May 2009 11:17:12 -0000 1.3 @@ -1,5 +1,15 @@ +* implement PROTOCOL 9 login changes

• improve activerecord driver

• profiling and performance tuning

• improve type conversion (do conversion "on demand" as in jdbc driver)

• improve tests

• code and documentation cleanup

+* fix syntax errors with ruby 1.9

+* OSM on rails demo

---

Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Monetdb-checkins mailing list Monetdb-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-checkins