forked from sqlanywhere/activerecord-sqlanywhere-adapter
    
        
        - 
                Notifications
    You must be signed in to change notification settings 
- Fork 8
An adapter that allows ActiveRecord to communicate with SQL Anywhere
License
bjorntrondsen/activerecord-sqlanywhere-adapter
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
=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].
About
An adapter that allows ActiveRecord to communicate with SQL Anywhere
Resources
License
Stars
Watchers
Forks
Releases
No releases published
              Packages 0
        No packages published 
      
              Languages
- Ruby 100.0%