public void PagingOnSimpleStatementTest()
{
var pageSize = 10;
var totalRowLength = 1003;
var table = CreateSimpleTableAndInsert(totalRowLength);
var statementWithPaging = new SimpleStatement("SELECT * FROM " + table);
var statementWithoutPaging = new SimpleStatement("SELECT * FROM " + table);
statementWithoutPaging.SetPageSize(int.MaxValue);
statementWithPaging.SetPageSize(pageSize);
var rs = Session.Execute(statementWithPaging);
var rsWithoutPaging = Session.Execute(statementWithoutPaging);
//Check that the internal list of items count is pageSize
Assert.True(rs.InnerQueueCount == pageSize);
Assert.True(rsWithoutPaging.InnerQueueCount == totalRowLength);
var allTheRowsPaged = rs.ToList();
Assert.True(allTheRowsPaged.Count == totalRowLength);
}
private List <CassandraRoom> Execute(string query)
{
var statement = new SimpleStatement(query);
statement.SetPageSize(1000);
List <CassandraRoom> result = NoSQL.roomsKeyspace.Execute(statement).ToCassandraRoom();
return(result);
}
public async Task <IEnumerable <CrimesDb> > ReadCrimesByYear(ISession session, int year)
{
var statement = new SimpleStatement($"select * from crimes where \"year\"={year} Allow Filtering");
statement.SetPageSize(1000);
var rowDbData = await session.ExecuteAsync(statement);
return(MappedToCrimes(rowDbData));
}
public void RequestHandler_GetRequest_SimpleStatement_Statement_Level_Settings_Are_Used()
{
var stmt = new SimpleStatement("DUMMY QUERY");
stmt.SetConsistencyLevel(ConsistencyLevel.EachQuorum);
stmt.SetPageSize(350);
stmt.SetSerialConsistencyLevel(ConsistencyLevel.LocalSerial);
Assert.AreEqual(350, stmt.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, stmt.ConsistencyLevel);
Assert.AreEqual(ConsistencyLevel.LocalSerial, stmt.SerialConsistencyLevel);
var request = (QueryRequest)RequestHandler<RowSet>.GetRequest(stmt, 2, GetConfig());
Assert.AreEqual(350, request.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, request.Consistency);
Assert.AreEqual(ConsistencyLevel.LocalSerial, request.SerialConsistency);
}
public void SimpleStatement_Statement_Level_Settings_Are_Used()
{
var stmt = new SimpleStatement("DUMMY QUERY");
stmt.SetConsistencyLevel(ConsistencyLevel.EachQuorum);
stmt.SetPageSize(350);
stmt.SetSerialConsistencyLevel(ConsistencyLevel.LocalSerial);
Assert.AreEqual(350, stmt.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, stmt.ConsistencyLevel);
Assert.AreEqual(ConsistencyLevel.LocalSerial, stmt.SerialConsistencyLevel);
var session = GetInstance();
var request = (QueryRequest)session.GetRequest(stmt);
Assert.AreEqual(350, request.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, request.Consistency);
Assert.AreEqual(ConsistencyLevel.LocalSerial, request.SerialConsistency);
}
public void RequestHandler_GetRequest_SimpleStatement_Statement_Level_Settings_Are_Used()
{
var stmt = new SimpleStatement("DUMMY QUERY");
stmt.SetConsistencyLevel(ConsistencyLevel.EachQuorum);
stmt.SetPageSize(350);
stmt.SetSerialConsistencyLevel(ConsistencyLevel.LocalSerial);
Assert.AreEqual(350, stmt.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, stmt.ConsistencyLevel);
Assert.AreEqual(ConsistencyLevel.LocalSerial, stmt.SerialConsistencyLevel);
var request = (QueryRequest)RequestHandler.GetRequest(stmt, Serializer, GetConfig());
Assert.AreEqual(350, request.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, request.Consistency);
Assert.AreEqual(ConsistencyLevel.LocalSerial, request.SerialConsistency);
}
public void SimpleStatement_Statement_Level_Settings_Are_Used()
{
var stmt = new SimpleStatement("DUMMY QUERY");
stmt.SetConsistencyLevel(ConsistencyLevel.EachQuorum);
stmt.SetPageSize(350);
stmt.SetSerialConsistencyLevel(ConsistencyLevel.LocalSerial);
Assert.AreEqual(350, stmt.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, stmt.ConsistencyLevel);
Assert.AreEqual(ConsistencyLevel.LocalSerial, stmt.SerialConsistencyLevel);
var session = GetInstance();
var request = (QueryRequest)session.GetRequest(stmt);
Assert.AreEqual(350, request.PageSize);
Assert.AreEqual(ConsistencyLevel.EachQuorum, request.Consistency);
Assert.AreEqual(ConsistencyLevel.LocalSerial, request.SerialConsistency);
}
public void Should_PagingOnSimpleStatement_When_ReceivedNumberOfRowsIsHigherThanPageSize()
{
var pageSize = 10;
var totalRowLength = 1003;
var table = CreateSimpleTableAndInsert(totalRowLength);
var statementWithPaging = new SimpleStatement($"SELECT * FROM {table}");
var statementWithoutPaging = new SimpleStatement($"SELECT * FROM {table}");
statementWithoutPaging.SetPageSize(int.MaxValue);
statementWithPaging.SetPageSize(pageSize);
var rsWithPaging = Session.Execute(statementWithPaging);
var rsWithoutPaging = Session.Execute(statementWithoutPaging);
//Check that the internal list of items count is pageSize
Assert.True(rsWithPaging.InnerQueueCount == pageSize);
Assert.True(rsWithoutPaging.InnerQueueCount == totalRowLength);
var allTheRowsPaged = rsWithPaging.ToList();
Assert.True(allTheRowsPaged.Count == totalRowLength);
}
public void PagingOnSimpleStatementTest()
{
var pageSize = 10;
var totalRowLength = 1003;
var table = CreateSimpleTableAndInsert(totalRowLength);
var statementWithPaging = new SimpleStatement("SELECT * FROM " + table);
var statementWithoutPaging = new SimpleStatement("SELECT * FROM " + table);
statementWithoutPaging.SetPageSize(int.MaxValue);
statementWithPaging.SetPageSize(pageSize);
var rsWithPaging = Session.Execute(statementWithPaging);
var rsWithoutPaging = Session.Execute(statementWithoutPaging);
//Check that the internal list of items count is pageSize
Assert.True(rsWithPaging.InnerQueueCount == pageSize);
Assert.True(rsWithoutPaging.InnerQueueCount == totalRowLength);
var allTheRowsPaged = rsWithPaging.ToList();
Assert.True(allTheRowsPaged.Count == totalRowLength);
}
