Tds

MSSQL / TDS Database driver for Elixir.

Work in Progress...

Usage

Add Tds as a dependency in your mix.exs file.

def deps do
  [{:tds, "~> 0.1"} ]
end

After you are done, run mix deps.get in your shell to fetch and compile Tds. Start an interactive Elixir shell with iex -S mix.

iex> {:ok, pid} = Tds.Connection.start_link([hostname: "localhost", username: "test_user", password: "test_password", database: "test_db", port: 4000])
{:ok, #PID<0.69.0>}
iex> Tds.Connection.query!(pid, "SELECT 'Some Awesome Text' AS MyColumn", [])
%Tds.Result{columns: ["MyColumn"], rows: [{"Some Awesome Text"}], num_rows: 1}}
iex> Tds.Connection.query!(pid, "INSERT INTO MyTable (MyColumn) VALUES (@my_value)", [%Tds.Parameter{name: "@my_value", value: "My Actual Value"}])
%Tds.Result{columns: nil, rows: nil, num_rows: 1}}

Features

• Automatic decoding and encoding of Elixir values to and from MSSQL's binary format
• Supports TDS Version 7.3, 7.4

Connecting to SQL Instances

In order to connect to a SQL instance, you must assign a static port to the TCP adaptor of the instance in the SQL Configuration Manager. You can then use this port as part of the connection options.

Data representation

TDS             Elixir
----------      ------
NULL            nil
bool            true | false
char            "é"
int             42
float           42.0
text            "text"
binary          <<42>>
numeric         #Decimal<42.0> *
date            {2013, 10, 12}
time            {0, 37, 14}
datetime          {{2013, 10, 12}, {0, 37, 14}}
uuid            <<160,238,188,153,156,11,78,248,187,109,107,185,189,56,10,17>>

All data types will be supported, unsupported types currently are udt, xml

Contributing

To contribute you need to compile Tds from source and test it:

$ git clone https://github.com/livehelpnow/tds.git
$ cd tds
$ mix test

The tests require an addition to your hosts file to connect to your sql server database.