CassandraDB Activities

Activities that access and perform operations on CassandraDB

Cassandra DB Scope

Handles the authentication to CassandraDB.

Inputs:

• ConnectionString - The connection string used to access the database
• DatabaseName - The name of the database that you are trying to access
• HostName - The host of the database
• Password - The password used to log in to the database
• Port - The port used in the connection to the database
• Username - The username used to log in to the database

Outputs:

• OutSession - Returns the session that contains the connection to the database

Execute Non-Query

Executes a non-query statement.

Inputs:

• **Statement - Used for general purposes, other than select. For example Insert, Update or Delete.**Insert into KeyspaceName.TableName(ColumnName1, ColumnName2, ColumnName3 . . . .)
  values (Column1Value, Column2Value, Column3Value . . . .)
  Update KeyspaceName.TableName
  Set ColumnName1=new Column1Value,
       ColumnName2=new Column2Value,
       ColumnName3=new Column3Value,
       ...
  Where ColumnName=ColumnValue
  Delete from KeyspaceName.TableName
  Where ColumnName1=ColumnValue

Outputs:

• Result - A string that shows the status of the transaction performed.

Select

Executes a Select on a CassandraDB and returns the result.

Inputs:

• Statement - A query string, for example:Select ColumnNames from KeyspaceName.TableName Where ColumnName1=Column1Value AND
  ColumnName2=Column2Value

Outputs:

• Result - A data table containing the result of the select query

Create Keyspace

Creates a new keyspace.

Inputs:

• Keyspace Name -  A string representing the name of the keyspace to be created
• Strategy Class - A string representing the replication class
• SubOptions - A dictionary in which key is the name of sub-options, value is a value for that sub-option. For example, here you can specify the replication_factor.

Outputs: N/A

Get Keyspace Name

Gets the name of the current keyspace.

Inputs: N/A

Outputs:

• Keyspace Name - Returns the name of currently used keyspace.

Change Keyspace

Changes the current keyspace.

Inputs:

• Keyspace Name - A string representing the name of the keyspace to change into.

Outputs: N/A

Delete Keyspace

Deletes a keyspace.

Inputs:

• Keyspace Name - A string representing the name of the keyspace to be deleted.

Outputs: N/A

Get Cluster

Returns the cluster information and the state.

Inputs: N/A

Outputs:

• Cluster - A Cluster variable representing the cluster information and the state.

You can perform different operations on CassandraDB, such as: - Authenticate in CassandraDB - Change Keyspace - Create Keyspace - Delete Keyspace - Execute Non-Query - Get Cluster - Get Keyspace Name - Select