Packages

mssqlex

0.0.5
2.0.0-beta.0 1.1.0 1.0.0 0.8.0 0.7.0 0.6.7 0.6.6 0.6.5 0.6.4 0.6.3 0.6.2 0.6.1 0.6.0 0.5.4 0.5.3 0.5.2 0.5.1 0.5.0 0.4.5 0.4.4 0.4.3 0.4.2 0.4.1 0.4.0 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.1 0.1.0 0.0.10 0.0.9 0.0.8 0.0.7 0.0.6 0.0.5 0.0.4 0.0.3 0.0.2 0.0.1

Adapter to Microsoft SQL Server. Using DBConnection and ODBC.

HexDocs

Current section

Files

Jump to
Readme
41 Versions
1 Dependency
Dependants
Files
Activity
mssqlex lib mssqlex query.ex
Raw

lib/mssqlex/query.ex 

defmodule Mssqlex.Query do

  @moduledoc """

  Implementation of `DBConnection.Query` for `Mssqlex`.



  The structure is:

    * `name` - currently not used.

    * `statement` - SQL statement to run using `:odbc`.

  """



  @type t :: %__MODULE__{

    name: iodata,

    statement: iodata,

  }



  defstruct [:name, :statement]

end



defimpl DBConnection.Query, for: Mssqlex.Query do

  @unicode_types [:sql_wchar, :sql_wvarchar, :sql_wlongvarchar]

  def parse(query, _opts), do: query

  def describe(query, _opts), do: query

  def encode(_query, params, _opts) do

    Enum.map(params, fn {type, values} ->

      {type, Enum.map(values, &(encode_type(type, &1)))} end)

  end

  def decode(_query, result, _opts), do: result



  defp encode_type({string_type, _}, value) when string_type in @unicode_types do

    :unicode.characters_to_binary(value, :unicode, {:utf16, :little})

  end

  defp encode_type(_type, value), do: value

end