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); }