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