A Client holds connections to a Cassandra cluster, allowing it to be queried. Each Client instance maintains multiple connections to the cluster nodes, provides policies to choose which node to use for each query, and handles retries for failed query (when it makes sense), etc…

Client instances are designed to be long-lived and usually a single instance is enough per application. As a given Client can only be “logged” into one keyspace at a time (where the “logged” keyspace is the one used by query if the query doesn’t explicitly use a fully qualified table name), it can make sense to create one client per keyspace used. This is however not necessary to query multiple keyspaces since it is always possible to use a single session with fully qualified table name in queries.

Global
This class is global

Augments

Events

hostAdd

Emitted when a new host is added to the cluster.

  • Host The host being added.

hostDown

Emitted when a host in the cluster changed status from up to down.

  • host The host that changed the status.

hostRemove

Emitted when a host is removed from the cluster

  • Host The host being removed.

hostUp

Emitted when a host in the cluster changed status from down to up.

  • host The host that changed the status.

Members

HostMap

hosts

Gets an associative array of cluster hosts.

String

keyspace

Gets the name of the active keyspace.

Metadata

metadata

Gets the schema and cluster metadata information.

Constructor

new

Client

(ClientOptions options)

Creates a new instance of Client.

Examples:
Creating a new client instance
const client = new Client({ contactPoints: ['192.168.1.100'] });
client.connect(function (err) {
  if (err) return console.error(err);
  console.log('Connected to cluster with %d host(s): %j', client.hosts.length, client.hosts.keys());
});
Executing a query
// calling #execute() can be made without previously calling #connect(), as internally
// it will ensure it's connected before attempting to execute the query
client.execute('SELECT key FROM system.local', function (err, result) {
  if (err) return console.error(err);
  const row = result.first();
  console.log(row['key']);
});
Executing a query with promise-based API
const result = await client.execute('SELECT key FROM system.local');
const row = result.first();
console.log(row['key']);
Parameters:
Name Type Description
options ClientOptions

The options for this instance.

Methods

batch

(Array<string> or Array<{query, params}> queries, [QueryOptions options], [ResultCallback callback])

Executes batch of queries on an available connection to a host.

If a callback is provided, it will invoke the callback when the execution completes. Otherwise, it will return a Promise.

Parameters:
Name Type Description
queries Array<string> or Array<{query, params}>

The queries to execute as an Array of strings or as an array of object containing the query and params

options optional QueryOptions
callback optional ResultCallback

Executes callback(err, result) when the batch was executed

connect

([function callback])

Tries to connect to one of the contactPoints and discovers the rest the nodes of the cluster.

If a callback is provided, it will invoke the callback when the client is connected. Otherwise, it will return a Promise.

If the Client is already connected, it invokes callback immediately (when provided) or the promise is fulfilled .

Examples:
Callback-based execution
client.connect(function (err) {
  if (err) return console.error(err);
  console.log('Connected to cluster with %d host(s): %j', client.hosts.length, client.hosts.keys());
});
Promise-based execution
await client.connect();
Parameters:
Name Type Description
callback optional function

The callback is invoked when the pool is connected it failed to connect.

eachRow

(String query, [Array or Object params], [QueryOptions options], function rowCallback, [function callback])

Executes the query and calls rowCallback for each row as soon as they are received. Calls final callback after all rows have been sent, or when there is an error.

The query can be prepared (recommended) or not depending on QueryOptions.prepare flag. Retries on multiple hosts if needed.

Examples:
Using per-row callback and arrow functions
client.eachRow(query, params, { prepare: true }, (n, row) => console.log(n, row), err => console.error(err));
Overloads
client.eachRow(query, rowCallback);
client.eachRow(query, params, rowCallback);
client.eachRow(query, params, options, rowCallback);
client.eachRow(query, params, rowCallback, callback);
client.eachRow(query, params, options, rowCallback, callback);
Parameters:
Name Type Description
query String

The query to execute

params optional Array or Object

Array of parameter values or an associative array (object) containing parameter names as keys and its value.

options optional QueryOptions
rowCallback function

Executes rowCallback(n, row) per each row received, where n is the row index and row is the current Row.

callback optional function

Executes callback(err, result) after all rows have been received.

When dealing with paged results, ResultSet#nextPage() method can be used to retrieve the following page. In that case, rowCallback() will be again called for each row and the final callback will be invoked when all rows in the following page has been retrieved.

execute

(String query, [Array or Object params], [QueryOptions options], [ResultCallback callback])

Executes a query on an available connection.

If a callback is provided, it will invoke the callback when the execution completes. Otherwise, it will return a Promise.

The query can be prepared (recommended) or not depending on QueryOptions.prepare flag.

Some executions failures can be handled transparently by the driver, according to the RetryPolicy defined at ClientOptions or QueryOptions level.

Examples:
Callback-based API
const query = 'SELECT name, email FROM users WHERE id = ?';
client.execute(query, [ id ], { prepare: true }, function (err, result) {
  assert.ifError(err);
  const row = result.first();
  console.log('%s: %s', row.name, row.email);
});
Promise-based API, using async/await
const query = 'SELECT name, email FROM users WHERE id = ?';
const result = await client.execute(query, [ id ], { prepare: true });
const row = result.first();
console.log('%s: %s', row.name, row.email);
Parameters:
Name Type Description
query String

The query to execute.

params optional Array or Object

Array of parameter values or an associative array (object) containing parameter names as keys and its value.

options optional QueryOptions

The query options for the execution.

callback optional ResultCallback

Executes callback(err, result) when execution completed. When not defined, the method will return a promise.

getReplicas

(String keyspace, Buffer token)

Gets the host list representing the replicas that contain such partition.

Parameters:
Name Type Description
keyspace String
token Buffer
Returns:
Type Description
Array

getState

()

Gets a snapshot containing information on the connections pools held by this Client at the current time.

The information provided in the returned object only represents the state at the moment this method was called and it’s not maintained in sync with the driver metadata.

Returns:
Type Description

module:metadata~ClientState

shutdown

([function callback])

Closes all connections to all hosts.

If a callback is provided, it will invoke the callback when the client is disconnected. Otherwise, it will return a Promise.

Parameters:
Name Type Description
callback optional function

Optional callback to be invoked when finished closing all connections.

stream

(String query, [Array or Object params], [QueryOptions options], [function callback])

Executes the query and pushes the rows to the result stream as soon as they received. Calls callback after all rows have been sent, or when there is an error.

The stream is a Readable Streams2 object that contains the raw bytes of the field value. It can be piped downstream and provides automatic pause/resume logic (it buffers when not read).

The query can be prepared (recommended) or not depending on QueryOptions.prepare flag. Retries on multiple hosts if needed.

Parameters:
Name Type Description
query String

The query to prepare and execute

params optional Array or Object

Array of parameter values or an associative array (object) containing parameter names as keys and its value

options optional QueryOptions
callback optional function

executes callback(err) after all rows have been received or if there is an error

Returns:
Type Description
types.ResultStream