CassandraDB Activities

by Internal Labs

0

435

CassandraDB Activities

by Internal Labs

0

Custom Activity

435

carouselImage0

Summary

Summary


Overview

Overview

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.

Features

Features


Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Internal Labs

Visit Publisher's Page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.2

Updated

12 Jun 2020

Works with

Studio 2019.4.3 or newer

Certification

Silver Certified

Tags

MongoDB
cassandra
cassandraDB
database
insert
non-relational
query
select
Update

Application

Java

Support

UiPath Community Support

Similar Listings