sqlanywhere Goto Github PK
Name: SQL Anywhere
Type: Organization
Location: Waterloo, Canada
Name: SQL Anywhere
Type: Organization
Location: Waterloo, Canada
=SQL Anywhere Ruby Driver This is a native SQL Anywhere driver for Ruby. This library wraps the functionality provided by the SQL Anywhere DBCAPI library. This driver is intended to be a base-level library to be used by interface libraries such as Ruby-DBI and ActiveRecord. This driver can be used with SQL Anywhere 10 and later versions. This driver is licensed under the Apache License, Version 2. The official code repository is located on GitHub. The repository can be cloned with: git clone git://github.com/sqlanywhere/sqlanywhere.git ==Build Instructions ===Requirements * C Compiler * Ruby * RubyGem Package manager ===All Platforms To build the library (.so), use: rake To build and install the gem, use: rake gem rake install The other rake tasks are rake clean -> Cleans up all temp files (ex *.~) rake clobber -> Cleans up all built files (ex *.gem, *.o, *.so) ===Additional Install Notes for Windows The popular One-Click Ruby Installer for Windows (RubyInstaller) is built using Microsoft Visual C++ 6.0. Since problems can arise by combining binaries from different compilers, we advise you use this compiler. If you want to use a more recent version of the MS C++ compiler, you will need to make a few changes: 1. Open the file: <RUBY DIR>\lib\ruby\1.8\i386-mswin32\config.h, and comment out the first three lines so they look like: //#if _MSC_VER != 1200 //#error MSC version unmatch //#endif This removes the check for C++ Version 6.0 2. Open <tt>rakefile</tt> and set: APPLY_MANIFEST = true This will add the manifest to the compiled binaries. By default, rake will attempt to use Microsoft <tt>nmake</tt> when building under Windows. To use another make program, set: USE_NMAKE_ON_WIN = FALSE ==Running Unit Tests 1. Change to the the <tt>test</tt> directory cd test 2. Create a testing database: dbinit test 3. Start the testing database: dbeng12 test.db 4. Create the test schema: dbisql -c "eng=test;uid=dba;pwd=sql" test.sql 5. Run the unit tests: ruby sqlanywhere_test.rb <b>If the tests fail to run, 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.html#1200/en/dbadmin/da-envvar.html]. ==Sample This script makes a connection, prints <tt>Successful Ruby Connection</tt> to the SQL Anywhere console, then disconnects. # load the SQLAnywhere gem begin require 'rubygems' gem 'sqlanywhere' unless defined? SQLAnywhere require 'sqlanywhere' end end # create an interface api = SQLAnywhere::SQLAnywhereInterface.new() # initialize the interface (loads the DLL/SO) SQLAnywhere::API.sqlany_initialize_interface( api ) # initialize our api object api.sqlany_init() # create a connection conn = api.sqlany_new_connection() # establish a connection api.sqlany_connect(conn, "uid=dba;pwd=sql") # execute a query without a result set api.sqlany_execute_immediate(conn, "MESSAGE 'Successful Ruby Connection'") # disconnect from the database api.sqlany_disconnect(conn) # free the connection resources api.sqlany_free_connection(conn) # free resources the api object uses api.sqlany_fini() # close the interface SQLAnywhere::API.sqlany_finalize_interface( api )
An adapter that allows ActiveRecord to communicate with SQL Anywhere
DataNucleus DBMS adapter classes for SQL Anywhere
A driver that allows Ruby/DBI to communicate with SQL Anywhere
hibernate dialects for SQL Anywhere
LuaSQL is a simple interface from Lua to a DBMS.
SAP SQL Anywhere Database Client for Node
OpenJPA RDBMS adapter for SQL Anywhere
OpenShift Cartridge for MobiLink
OpenShift Cartridge for SQL Anywhere Server
SQLAlchemy driver for SAP Sybase SQL Anywhere
Django driver for SAP Sybase SQL Anywhere
Python driver for SAP Sybase SQL Anywhere
A low-lever driver that allows Ruby code to interface with SQL Anywhere databases
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.