English
Summary
Activities that access and perform operations on CassandraDB
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.
Benefits
Published: 2020-06-12T10:02:26+00:00 | Updated: 2020-12-18T00:00:09+00:00
Trusted Source
License
Apache 2.0
Code Language
Visual Basic
Tags
MongoDB
cassandra
cassandraDB
database
insert
non-relational
query
select
Update
Compatibility
Studio 2019.4.3 or newer
Dependencies
CassandraCSharpDriver Lz4net
Support
UiPath Community SupportSimilar Listings
