CAST supports Azure Cosmos DB via its NoSQL for Java extension. Details about the support provided for Java source code is explained below.
Supported Client Libraries
| Library | Version | Supported |
|---|---|---|
| Azure Cosmos DB Java SDK for SQL API | Up to: 4.32.0 |
|
| Azure Cosmos DB Async Java SDK for SQL API |
| |
| Azure Cosmos DB Java SDK v4 | |
Supported Operations
| Operations | Method Supported |
|---|---|
| Insert | |
| Update | |
| Select | |
| Delete |
Above mentioned methods are supported for both Synchronous and Asynchronous clients.
Objects
| Icon | Description |
|---|---|
| Java CosmosDB Database |
| Java CosmosDB Collection |
| Java Unknown CosmosDB Database |
| Java Unknown CosmosDB Collection |
Links
Links are created for transaction and function point needs:
| Link type | Source and destination of link | Methods Supported |
|---|---|---|
| belongsTo | From Java CosmosDB Collection object to Java CosmosDB Database object | |
| useLink | Between the caller Java Method objects and Java CosmosDB Collection object |
|
| useInsertLink |
| |
| useUpdateLink |
| |
useSelectLink |
| |
| useDeleteLink |
|
What results can you expect?
Once the analysis/snapshot generation is completed, you can view the results in the normal manner (for example via CAST Enlighten). Some examples are shown below.
Cosmos DB Client Creation
Insert Data Operation
public static Family andersenFamily = new Family();
public void TestCreateDocument() throws DocumentClientException {
// Insert your Java objects as documents
System.out.println("Creating doc");
andersenFamily.setId("Andersen.1");
andersenFamily.setLastName("Andersen");
this.client.createDocument("/dbs/familydb/colls/familycoll", andersenFamily, new RequestOptions(), true);
System.out.println("Done Creating doc");
}
@Override
public Single<OutcomingAccountStatus> createStatus(IncomingCreateAccountStatus incoming) {
Mono<YapeAccountStatus> createYapeAccountStatus =
defer(() -> {
YapeAccountStatus yapeAccountStatus = new YapeAccountStatus();
yapeAccountStatus.setId(generateId());
yapeAccountStatus.setIdYapeAccount(incoming.getIdYapeAccount());
yapeAccountStatus.setStatus(incoming.getStatus());
yapeAccountStatus.setCreationDate(incoming.getCreationDate());
return cosmosAsyncDatabase.getContainer(CONTAINER_YAPE_ACCOUNT_STATUS)
.createItem(yapeAccountStatus,
new PartitionKey(yapeAccountStatus.getIdYapeAccount()),
new CosmosItemRequestOptions())
.retryWhen(noLongerAvailable)
.map(itemResponse -> yapeAccountStatus);
}
Select Operation
public void TestQueryDocuments() {
System.out.println("Querying db...");
FeedResponse<Document> queryResults = this.client.queryDocuments("/dbs/familydb/colls/familycoll",
"SELECT * FROM Family WHERE Family.id = 'Andersen.1'", null);
System.out.println("Running SQL query...");
for (Document family : queryResults.getQueryIterable()) {
System.out.println(String.format("\tRead %s", family));
}
}
public void TestReadDocument() throws DocumentClientException {
this.client.readDocument("/dbs/familydb/colls/familycoll/docs/Andersen.1", null);
}
public void TestReadDocuments() throws DocumentClientException {
this.client.readDocuments("/dbs/familydb", null);
}
private Mono<YapeAccountStatus> getLastStatusMono(String idYapeAccount) {
SqlQuerySpec sqsGetLastStatusQuery = SqlBuilder.create()
.query("select top 1 s.status from s where s.idYapeAccount = @idYapeAccount "
+ "and s.status != @statusDeleted order by s.creationDate desc")
.parameters(
new SqlParameter("@idYapeAccount", idYapeAccount),
new SqlParameter("@statusDeleted", AccountStatus.DELETED.getCode()))
.buildSqlQuerySpec();
CosmosQueryRequestOptions options = new CosmosQueryRequestOptions();
options.setPartitionKey(new PartitionKey(idYapeAccount));
return cosmosAsyncDatabase.getContainer(CONTAINER_YAPE_ACCOUNT_STATUS)
.queryItems(sqsGetLastStatusQuery, options, YapeAccountStatus.class)
.singleOrEmpty()
.retryWhen(noLongerAvailable);
}
Update Operation
public void TestReplaceDocument() throws DocumentClientException {
// Update a property
andersenFamily.setLastName("Petersons");
this.client.replaceDocument("/dbs/familydb/colls/familycoll/docs/Andersen.1", andersenFamily, null);
}
private Mono<BlockedResources> replaceItem(BlockedResources blockedResources, CosmosItemRequestOptions options) {
return getBlockedResourcesContainer().replaceItem(blockedResources, blockedResources.getId(),
new PartitionKey(blockedResources.getResource()), options)
.retryWhen(noLongerAvailable)
.doOnSuccess(itemResponse -> blockedResources.set_etag(itemResponse.getETag()))
.map(itemResponse -> blockedResources);
}
Delete Operation
public void TestDeleteDocument() throws DocumentClientException {
this.client.deleteDocument("", null);
}
Support for Collection based methods are provided, for example:
- createCollection
- deleteCollection
- readCollection
Limitations
Major limitations
No support for Cassandra API, MongoDB API, Gremlin API, Table API or other APIs built by Microsoft for accessing an Azure Cosmos DB service. See the API reference here:
Minor limitations
Database and collection names are resolved as known objects when a connection string is passed to the client directly:
Example: This connection string is passed to client - "/dbs/familydb/colls/familycoll"
Database and collection are marked as Unknown when Database Collection and document objects are passed as an argument in CRUD methods.
Runtime Ambiguities are not resolved:
Example: Different databases are accessed in if/else cases based on some conditions