Skip to content

KonnexionsGmbH/OraLixir

master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
lib
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

OraLixir

Build Status

An ecto adapter for Oracle using oranif.

Installation

If available in Hex, the package can be installed by adding oracle to your list of dependencies in mix.exs:

defp deps do
  [
    {:oralixir, git: "https://github.com/KonnexionsGmbH/OraLixir"}
  ]
end

Documentation can be generated with ExDoc and published on HexDocs. Once published, the docs can be found at https://hexdocs.pm/oralixir.

Examples

Start connection using the default configuration (UNIX domain socket):

iex> {:ok, pid} = OraLixir.start_link([])
{:ok, #PID<0.69.0>}

Start connection using the default configuration (UNIX domain socket):

iex> OraLixir.prepare_execute(pid, "name", "SELECT 'string', 1, sysdate FROM DUAL", [], [])
{:ok,
  %OraLixir.Query{
    numCols: 3,
    query_str: "SELECT 'string', 1, sysdate FROM DUAL",
    statement: #Reference<0.4128640180.1299578898.122555>
  },
  %OraLixir.Result{
    columns: [
      %{
        name: '\'STRING\'',
        nullOk: true,
        typeInfo: %{
          clientSizeInBytes: 6,
          dbSizeInBytes: 6,
          defaultNativeTypeNum: :DPI_NATIVE_TYPE_BYTES,
          fsPrecision: 0,
          objectType: :featureNotImplemented,
          ociTypeCode: 96,
          oracleTypeNum: :DPI_ORACLE_TYPE_CHAR,
          precision: 0,
          scale: 0,
          sizeInChars: 6
        }
      },
      %{
        name: '1',
        nullOk: true,
        typeInfo: %{
          clientSizeInBytes: 0,
          dbSizeInBytes: 0,
          defaultNativeTypeNum: :DPI_NATIVE_TYPE_DOUBLE,
          fsPrecision: 0,
          objectType: :featureNotImplemented,
          ociTypeCode: 2,
          oracleTypeNum: :DPI_ORACLE_TYPE_NUMBER,
          precision: 0,
          scale: -127,
          sizeInChars: 0
        }
      },
      %{
        name: 'SYSDATE',
        nullOk: true,
        typeInfo: %{
          clientSizeInBytes: 0,
          dbSizeInBytes: 0,
          defaultNativeTypeNum: :DPI_NATIVE_TYPE_TIMESTAMP,
          fsPrecision: 0,
          objectType: :featureNotImplemented,
          ociTypeCode: 12,
          oracleTypeNum: :DPI_ORACLE_TYPE_DATE,
          precision: 0,
          scale: 0,
          sizeInChars: 0
        }
      }
    ],
    rows: [
      [
        "string",
        1.0,
        %{
          day: 6,
          fsecond: 0,
          hour: 17,
          minute: 57,
          month: 10,
          second: 18,
          tzHourOffset: 0,
          tzMinuteOffset: 0,
          year: 2019
        }
      ]
    ]
  }}

iex> OraLixir.prepare_stream(pid, "SELECT sysdate, 1, 'first row' FROM DUAL", [], [])
{:ok,
[
  [
    %{
      day: 6,
      fsecond: 0,
      hour: 18,
      minute: 4,
      month: 10,
      second: 48,
      tzHourOffset: 0,
      tzMinuteOffset: 0,
      year: 2019
    },
    1.0,
    "first row"
  ],
  :halt
]}

About

Oracle driver for Elixir

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages