Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

file 56 lines (35 sloc) 2.502 kb
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
=SQL Anywhere ActiveRecord Driver

This is a SQL Anywhere driver for Ruby ActiveRecord. This driver requires the
native SQL Anywhere Ruby driver. To get the native driver, use:

   gem install sqlanywhere

This driver is designed for use with ActiveRecord 3.0.3 and greater.

This driver is licensed under the Apache License, Version 2.

==Making a Connection

The following code is a sample database configuration object.

  ActiveRecord::Base.configurations = {
    'arunit' => {
      :adapter => 'sqlanywhere',
      :database => 'arunit', #equivalent to the "DatabaseName" parameter
      :server => 'arunit', #equivalent to the "ServerName" parameter
      :username => 'dba', #equivalent to the "UserID" parameter
      :password => 'sql', #equivalent to the "Password" parameter
      :encoding => 'Windows-1252', #equivalent to the "CharSet" parameter
      :commlinks => 'TCPIP()', #equivalent to the "Commlinks" parameter
      :connection_name => 'Rails' #equivalent to the "ConnectionName" parameter
  }

==Running the ActiveRecord Unit Test Suite

1. Open <tt><ACTIVERECORD_INSTALL_DIR>/rakefile</tt> and modify the line:

      for adapter in %w( mysql postgresql sqlite sqlite3 firebird db2 oracle sybase openbase frontbase )

   to include <tt>sqlanywhere</tt>. It should now look like:

      for adapter in %w( mysql postgresql sqlite sqlite3 firebird db2 oracle sybase openbase frontbase sqlanywhere )

2. Create directory to hold the connection definition:
   
      mkdir <ACTIVERECORD_INSTALL_DIR>/test/connections/native_sqlanywhere

3. Copy <tt>test/connection.rb</tt> into the newly created directory.

4. Create the two test databases. These can be created in any directory.

      dbinit -c arunit
      dbinit -c arunit2
      dbsrv11 arunit arunit2

   <b>If the commands cannot be found, make sure you have set up the SQL Anywhere environment variables correctly.</b> For more information review the online documentation here[http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fdbadmin_en11%2Fda-envvar-sect1-3672410.html].

6. Run the unit test suite from the ActiveRecord install directory:

      rake test_sqlanywhere

   <b>If the migration tests fail, make sure you have set up the SQL Anywhere environment variables correctly.</b> For more information review the online documentation here[http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fdbadmin_en11%2Fda-envvar-sect1-3672410.html].
Something went wrong with that request. Please try again.