do_sqlserver

Description

A Microsoft SQL Server adapter for DataObjects,

Features/Problems

This driver implements the DataObjects API for the Microsoft SQL Server relational database.

Problems with MRI implementation (unreleased):

  • Relies on DBI's support for either ADO or ODBC with FreeTDS
  • Has no tests and no data type conversion yet

Synopsis

Examples of usage:

# default port (using SQL Server Express Edition)
DataObjects::Connection.new('sqlserver://user:pass@host/database;instance=SQLEXPRESS')
# port specified (using SQL Server Express Edition)
DataObjects::Connection.new('sqlserver://user:pass@host:1433/database;instance=SQLEXPRESS')

@connection = DataObjects::Connection.new("sqlserver://john:p3$$@localhost:1433/userinfo")
@reader = @connection.create_command('SELECT * FROM users').execute_reader
@reader.next!
  • See also the accompanying CONNECTING.markdown.

Requirements

This driver is provided for the following platforms:

  • JRuby 1.3.1 + (1.4+ recommended).

Code for the following platform is in the repository, but is still under EARLY DEVELOPMENT and is neither RELEASED or SUPPORTED:

  • Ruby MRI (1.8.6/7), 1.9: tested on Linux, Mac OS X and Windows platforms.

Additionally you should have the following prerequisites:

  • data_objects gem
  • do_jdbc gem (shared library), if running on JRuby.
  • dbi gem, if running on MRI.
  • On non-Windows platforms, unixODBC and FreeTDS libraries.

Install

To install the gem:

gem install do_sqlserver

To compile and install from source:

  • For MRI:

    • Installation of do_sqlserver is significantly more involved than for other drivers. Please see the accompanying INSTALL.markdown.
  • 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.

Then:

sudo gem install do_sqlserver

For more information, see the SQL Server driver wiki page: http://wiki.github.com/datamapper/do/sql-server.

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.