knex-hdb

    0.1.2 • Public • Published

    Knex.js HDB

    This library add support for SAP HANA to knex.js. It uses node-hdb as driver.

    Installation

    npm install --save knex-hdb
    

    Usage

    Please read the knex documentation.

    Connect

    Passing a custom client class to knex isn't working. You therefore need to instantiate the client yourself and use the makeknex utility.

    const makeKnex = require('knex/lib/util/make-knex');
    const HDBClient = require('knex-hdb');
     
    var client = new HDBClient({
      host     : 'hostname',
      port     : 30015,
      user     : 'user',
      password : 'secret',
      schema   : 'schema'
    });

    Create a table

    The custom tableType option may be used to specify the table type.

    An increments column will translate to a DEFAULT TO IDENTITY statement. This is only available for 'COLUMN' tables, not for 'ROW' type tables.

    Pass 'utf-8' to a string column to create an NVARCHAR column instead a VARCHAR.

    knex.schema.createTable('accounts', function(table) {
      table.string('id', 32).primary();
      table.string('account_name');
      table.string('full_name', 255, 'utf-8');
      table.index('account_name');
    })

    Build

    To build this project from source, download it from GitHub and then run

    npm install
    npm run build
    

    There will be a new 'lib' folder.

    Todo

    • Unit tests
    • Support for modifying a table
    • Tranactions
    • Upsert support

    This is a very early version and there are likely to be bugs. Please be so kind to report any issues you come across and if possible provide a pull request.

    Install

    npm i knex-hdb

    DownloadsWeekly Downloads

    7

    Version

    0.1.2

    License

    MIT

    Last publish

    Collaborators

    • jasny