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