Spring Boot and RESTful API(4)Cassandra Spring Data

Spring Boot and RESTful API(4)Cassandra Spring Data

Possible Data Structure
>CREATE KEYSPACE jobsmonitor WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
>use jobsmonitor;
>CREATE TABLE jobcounthistory(
source_id text,
record_date TIMESTAMP,
new_active_count int,
new_admin_count int,
old_active_count int,
old_admin_count int,
PRIMARY KEY ( source_id, record_date )
) WITH CLUSTERING ORDER BY (record_date DESC);


Possible query is as follow:
select * from jobcounthistory where source_id = 'asdfasf';
select * from jobcounthistory where source_id = 'asdf' and record_date > '2017-06-11';

>CREATE TABLE jobcountdiff(
date text,
diff int,
record_date TIMESTAMP,
source_id text,
PRIMARY KEY ( date, diff, record_date )
) WITH CLUSTERING ORDER BY (diff ASC, record_date DESC);


Possible Query is as follow:
select * from jobcountdiff where date = '2017-06-15';
select * from jobcountdiff where date = '2017-06-15' and diff > 10;

Code and Setup
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-cassandra</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
</dependency>

Configuration in application.yaml
logging:
    level:
         debug
spring:
    profiles:
        active:
             dev
    data:
        solr:
            host:
                 http://localhost:8983/solr/ 
        cassandra:
            keyspace-name:jobsmonitor
            contact-points: localhost

Domain Class
package com.sillycat.jobsmonitorapi.domain;

import java.util.Date;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.springframework.cassandra.core.Ordering;
import org.springframework.cassandra.core.PrimaryKeyType;
import org.springframework.data.cassandra.mapping.Column;
import org.springframework.data.cassandra.mapping.PrimaryKeyColumn;
import org.springframework.data.cassandra.mapping.Table;

@Table("jobcounthistory")
public class JobCountHistory {

    @PrimaryKeyColumn(name = "source_id", ordinal = 0, type = PrimaryKeyType.PARTITIONED)
    private String sourceID;

    @PrimaryKeyColumn(name = "record_date", ordinal = 1, type = PrimaryKeyType.CLUSTERED, ordering = Ordering.DESCENDING)
    private Date recordDate;

    @Column("new_active_count")
    private Integer newActiveCount;

    @Column("new_admin_count")
    private Integer newAdminCount;

    @Column("old_active_count")
    private Integer oldActiveCount;

    @Column("old_admin_count")
    private Integer oldAdminCount;

    public JobCountHistory() {

    }

    public String getSourceID() {
        return sourceID;
    }

    public void setSourceID(String sourceID) {
        this.sourceID = sourceID;
    }

    public Date getRecordDate() {
        return recordDate;
    }

    public void setRecordDate(Date recordDate) {
        this.recordDate = recordDate;
    }

    public Integer getNewActiveCount() {
        return newActiveCount;
    }

    public void setNewActiveCount(Integer newActiveCount) {
        this.newActiveCount = newActiveCount;
    }

    public Integer getNewAdminCount() {
        return newAdminCount;
    }

    public void setNewAdminCount(Integer newAdminCount) {
        this.newAdminCount = newAdminCount;
    }

    public Integer getOldActiveCount() {
        return oldActiveCount;
    }

    public void setOldActiveCount(Integer oldActiveCount) {
        this.oldActiveCount = oldActiveCount;
    }

    public Integer getOldAdminCount() {
        return oldAdminCount;
    }

    public void setOldAdminCount(Integer oldAdminCount) {
        this.oldAdminCount = oldAdminCount;
    }

    public String toString() {
        return ToStringBuilder.reflectionToString(this);
    }

}

Repository Interface
package com.sillycat.jobsmonitorapi.repository;

import java.util.List;

import org.springframework.data.cassandra.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.sillycat.jobsmonitorapi.domain.JobCountHistory;

public interface JobCountHistoryRepositoryCassandra extends CrudRepository<JobCountHistory, String> {
   
    @Query("select * from jobcounthistory where source_id=?0")
    public List<JobCountHistory> findBySourceID(String sourceID);
   
    @Query("delete from jobcounthistory where source_id=?0")
    public void deleteBySourceID(String sourceID);

}

Unit Test Class
package
com.sillycat.jobsmonitorapi.repository;

import java.util.Date;import
java.util.List;

import org.apache.http.util.Asserts;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import
org.springframework.test.context.junit4.SpringRunner;

import
com.sillycat.jobsmonitorapi.domain.JobCountHistory;

@RunWith(SpringRunner.class)@SpringBootTest
public class
JobCountHistoryCassandraTest {

@Autowired
JobCountHistoryRepositoryCassandra jobCountHistoryRepositoryCassandra;

@Test
public void save() throws Exception {
    jobCountHistoryRepositoryCassandra.deleteBySourceID("9527");
    JobCountHistory    item1 = new JobCountHistory();
    item1.setNewActiveCount(1);
    item1.setNewAdminCount(12);
    item1.setOldActiveCount(12);
    item1.setOldAdminCount(1);
    item1.setSourceID("9527");
    item1.setRecordDate(new Date());
    jobCountHistoryRepositoryCassandra.save(item1);
    List<JobCountHistory> result = jobCountHistoryRepositoryCassandra.findBySourceID("9527");
    Asserts.notNull(result, "result is not null");
    }
}



References:
http://sillycat.iteye.com/blog/2383513