You're Invited:Meet the Socket Team at BlackHat and DEF CON in Las Vegas, Aug 7-8.RSVP
Socket
Socket
Sign inDemoInstall

@sap/hana-client

Package Overview
Dependencies
Maintainers
1
Versions
80
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@sap/hana-client

Official SAP HANA Node.js Driver


Version published
Weekly downloads
162K
decreased by-3.5%
Maintainers
1
Created
Weekly downloads
 

Package description

What is @sap/hana-client?

@sap/hana-client is an npm package that provides a client interface for connecting to and interacting with SAP HANA databases. It allows developers to execute SQL queries, manage database connections, and handle transactions programmatically.

What are @sap/hana-client's main functionalities?

Connecting to SAP HANA

This feature allows you to establish a connection to an SAP HANA database using the provided connection parameters.

const hana = require('@sap/hana-client');
const conn = hana.createConnection();
const connParams = {
  serverNode: 'myServer:30015',
  uid: 'myUser',
  pwd: 'myPassword'
};
conn.connect(connParams, (err) => {
  if (err) throw err;
  console.log('Connected to SAP HANA');
});

Executing SQL Queries

This feature allows you to execute SQL queries against the connected SAP HANA database and retrieve the results.

const sql = 'SELECT * FROM MY_TABLE';
conn.exec(sql, (err, result) => {
  if (err) throw err;
  console.log(result);
});

Handling Transactions

This feature allows you to manage transactions by explicitly committing or rolling back changes to the database.

conn.setAutoCommit(false);
conn.exec('INSERT INTO MY_TABLE (ID, NAME) VALUES (1, 'John Doe')', (err) => {
  if (err) {
    conn.rollback();
    throw err;
  }
  conn.commit((err) => {
    if (err) throw err;
    console.log('Transaction committed');
  });
});

Other packages similar to @sap/hana-client

Readme

Source

@sap/hana-client

Fully-featured Node.js driver for SAP HANA. It is used to connect, issue SQL queries, and obtain result sets.

Install

npm install @sap/hana-client

Prerequisites

This driver communicates with the native HANA libraries, and thus requires platform-specific native binaries. The official hosted version includes precompiled libraries for Linux, Windows and Mac OS X.

The @sap/hana-client driver supports versions of Node.js 8.11.2 and higher.

Community

SAP Community provides a forum where you can ask and answer questions, and comment and vote on the questions of others and their answers.

See SAP HANA Community Questions for details.

Help Guide

The SAP HANA Node.js Driver help guide and API reference can be found on help.sap.com.

Getting Started

var hana = require('@sap/hana-client');

var conn = hana.createConnection();

var conn_params = {
  serverNode  : 'myserver:30015',
  uid         : 'system',
  pwd         : 'Password123'
};

conn.connect(conn_params, function(err) {
  if (err) throw err;
  conn.exec('SELECT Name, Description FROM Products WHERE id = ?', [301], function (err, result) {
    if (err) throw err;

    console.log('Name: ', result[0].Name, ', Description: ', result[0].Description);
    // output --> Name: Tee Shirt, Description: V-neck
    conn.disconnect();
  })
});

Establish a database connection

Connecting

A database connection object is created by calling createConnection. The connection is established by calling the connection object's connect method, and passing in an object representing connection parameters.

Example: Connecting over TCP/IP
conn.connect({
  host    : 'myserver',
  port    : '30015',
  uid     : 'system',
  pwd     : 'Password123'
});

Disconnecting

conn.disconnect(function(err) {
  if (err) throw err;
  console.log('Disconnected');
});

Direct Statement Execution

Direct statement execution is the simplest way to execute SQL statements. The inputs are the SQL command to be executed, and an optional array of positional arguments. The result is returned using callbacks. The type of returned result depends on the kind of statement.

DDL Statement

In the case of a successful DDL Statement, nothing is returned.

conn.exec('CREATE TABLE Test (id INTEGER PRIMARY KEY, msg VARCHAR(128))', function (err, result) {
  if (err) throw err;
  console.log('Table Test created!');
});

DML Statement

In the case of a DML Statement the number of affectedRows is returned.

conn.exec("INSERT INTO Test VALUES(1, 'Hello')", function (err, affectedRows) {
  if (err) throw err;
  console.log('Number of affected rows:', affectedRows);
});

Query

The exec function is a convenient way to completely retrieve the result of a query. In this case all selected rows are fetched and returned in the callback.

conn.exec("SELECT * FROM Test WHERE id < 5", function (err, rows) {
  if (err) throw err;
  console.log('Rows:', rows);
});

Values in the query can be substitued with JavaScript variables by using ? placeholders in the query, and passing an array of positional arguments.

conn.exec("SELECT * FROM Test WHERE id BETWEEN ? AND ?", [5, 8], function (err, rows) {
  if (err) throw err;
  console.log('Rows:', rows);
});

Prepared Statement Execution

Prepare a Statement

The connection returns a statement object which can be executed multiple times.

conn.prepare('SELECT * FROM Test WHERE id = ?', function (err, stmt){
  if (err) throw err;
  // do something with the statement
});

Execute a Statement

The execution of a prepared statement is similar to the direct statement execution. The first parameter of exec function is an array with positional parameters.

stmt.exec([16], function(err, rows) {
  if (err) throw err;
  console.log("Rows: ", rows);
});

Execute a Batch Statement

The execution of a prepared batch statement is similar to the direct statement execution. The first parameter of execBatch function is an array with positional parameters.

var stmt=conn.prepare("INSERT INTO Customers(ID, NAME) VALUES(?, ?)");
stmt.execBatch([[1, 'Company 1'], [2, 'Company 2']], function(err, rows) {
  if (err) throw err;
  console.log("Rows: ", rows);
});

Execute a Query

The execution of a prepared query is similar to the direct statement execution. The first parameter of execQuery function is an array with positional parameters.

var stmt=conn.prepare("SELECT * FROM Customers WHERE ID >= ? AND ID < ?");
stmt.execQuery([100, 200], function(err, rs) {
  if (err) throw err;
    var rows = [];
    while (rs.next()) {
      rows.push(rs.getValues());
    }
  console.log("Rows: ", rows);
});

Drop Statement

stmt.drop(function(err) {
  if (err) throw err;
});

Transaction Handling

Transactions are automatically commited. Setting autocommit to false implicitly starts a new transaction that must be explicitly committed, or rolled back.

Commit a Transaction

conn.setAutoCommit(false);
// Execute some statements
conn.commit(function(err) {
  if (err) throw err;
  console.log('Transaction commited.');
});

Rollback a Transaction

conn.setAutoCommit(false);
// Execute some statements
conn.rollback(function(err) {
  if (err) throw err;
  console.log('Transaction rolled back.');
});

Resources

Keywords

FAQs

Package last updated on 15 Mar 2021

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc