public List <TableEntity> FindEntitiesByDatatype(string dataType) { var sql = _sqlQueryConstructor.FindEntitiesByDataTypeQuery(dataType); var nameValueCollections = _sqLiteDatabase.ExecuteReader(sql); return(CreateTableEntities(nameValueCollections)); }
public void FindEntitiesByDataType_GetsSqlAndExecutesAsQuery() { const string sql = "sql"; const string path = @"C:\Temp\MYDATABASE.db"; A.CallTo(() => _databaseBuilder.Build(path)).Returns(_sqLiteDatabase); _database.Connect(path); var nameValueData = new List <NameValueCollection> { new NameValueCollection() { { "Eid", "1" }, { "DataType", "String" }, { "Value", "Test" } } }; A.CallTo(() => _sqlQueryConstructor.FindEntitiesByDataTypeQuery(A <string> .Ignored)).Returns(sql); A.CallTo(() => _sqLiteDatabase.ExecuteReader(sql)).Returns(nameValueData); _database.FindEntitiesByDatatype(null); A.CallTo(() => _sqlQueryConstructor.FindEntitiesByDataTypeQuery(null)).MustHaveHappened(); A.CallTo(() => _sqLiteDatabase.ExecuteReader(sql)).MustHaveHappened(); }