public QueryResult ExecuteQuery(string queryText)
{
ISession session = cluster.Connect();
RowSet rowSet = session.Execute(queryText);
QueryResult queryResult = new QueryResult();
foreach (var column in rowSet.Columns)
{
QueryResultColumn queryResultColumn = new QueryResultColumn(column.Name);
queryResult.Columns.Add(queryResultColumn);
}
foreach (var row in rowSet.ToList())
{
QueryResultRow queryResultRow = new QueryResultRow();
foreach (var rowValue in row.ToList())
{
QueryResultRowValue queryResultRowValue = new QueryResultRowValue(rowValue);
queryResultRow.RowValues.Add(queryResultRowValue);
}
queryResult.Rows.Add(queryResultRow);
}
return(queryResult);
}
public void SetUp()
{
_dataReaderStub = MockRepository.GenerateStub <IDataReader>();
_storageTypeInformationProviderStub = MockRepository.GenerateStub <IStorageTypeInformationProvider>();
_queryResultRow = new QueryResultRow(_dataReaderStub, _storageTypeInformationProviderStub);
_storageTypeInformationMock = MockRepository.GenerateStrictMock <IStorageTypeInformation>();
}
public void Construct()
{
//---------------Execute Test ----------------------
var row = new QueryResultRow();
//---------------Test Result -----------------------
Assert.IsNotNull(row.RawValues);
Assert.IsNotNull(row.Values);
Assert.AreEqual(0, row.RawValues.Count);
Assert.AreEqual(0, row.Values.Count);
}
public void Construct_WithRawValues()
{
//---------------Set up test pack-------------------
var rawValues = new object[] { "somevalues", 34 };
//---------------Execute Test ----------------------
var row = new QueryResultRow(rawValues);
//---------------Test Result -----------------------
Assert.AreEqual(rawValues.Length, row.RawValues.Count);
Assert.AreEqual(rawValues[0], row.RawValues[0]);
Assert.AreEqual(rawValues[1], row.RawValues[1]);
}
private object RowToJson(QueryResultRow row)
{
return row.Select(field => field.DisplayValue()).ToList();
}
