Jamdb.Sybase

Erlang driver and Ecto adapter for Sybase ASE Database

Options

Adapter options split in different categories described below. All options can be given via the repository configuration:

config :your_app, YourApp.Repo,
  ...

Connection options

:hostname - Server hostname (Name or IP address of the database server)
:port - Server port (Number of the port where the server listens for requests)
:database - Database (Database name)
:username - Username (Name for the connecting user)
:password - User password (Password for the connecting user)
:parameters - Keyword list of connection parameters
:socket_options - Options to be given to the underlying socket
:timeout - The default timeout to use on queries, defaults to 15000

Pool options

:pool - The connection pool module, defaults to DBConnection.ConnectionPool
:pool_size - The size of the pool, defaults to 1
:idle_interval - The ping interval to validate an idle connection, defaults to 5000

Input parameters

Using query options: [in: [:numeric, :binary]]

Sybase types	Literal syntax in params
`bigint`,`int`,`smallint`,`tinyint`	`:int`, `:integer`
`numeric`, `decimal`	`:numeric`, `:decimal`
`float`, `double`	`:float`, `:double`
`char`, `varchar`, `univarchar`	`:varchar`, `:char`, `:string`
`nchar`, `nvarchar`	`:nvarchar`, `:nchar`
`text`, `unitext`, `image`	`:text`, `:clob`
`binary`, `varbinary`	`:binary`
`long binary`, `long varchar`	`:long`
`money`, `smallmoney`	`:money`
`datetime`, `smalldatetime`	`:datetime`
`date`	`:date`
`time`	`:time`
`bit`	`:bit`

Examples

iex> Ecto.Adapters.SQL.query(YourApp.Repo, "select 1/10, getdate(), newid()", [])
{:ok, %{num_rows: 1, rows: [[0, ~N[2016-08-01 13:14:15], "84be3f476ce14052aed69dbfa57cdd43"]]}}

iex> bin = %Ecto.Query.Tagged{value: <<0xE7,0x99,0xBE>>, type: :binary}
iex> Ecto.Adapters.SQL.query(YourApp.Repo, "insert into tabl values (:1)", [bin])

iex> bin = <<0xE7,0x99,0xBE>>
iex> Ecto.Adapters.SQL.query(YourApp.Repo, "insert into tabl values (:1)", [bin]], [in: [:binary]])