8dbbe95a-81a3-4782-b0fc-990e0bd5e890.png

RPA Developer

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

**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.

Activities that access and perform operations on CassandraDB

ユーザー情報