public void FindAllEidsQuery_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" }
},
new NameValueCollection()
{
{ "Eid", "2" }
}
};
var data = new List <int>
{
1, 2
};
A.CallTo(() => _sqlQueryConstructor.FindAllEidsQuery()).Returns(sql);
A.CallTo(() => _sqLiteDatabase.ExecuteReader(sql)).Returns(nameValueData);
var response = _database.FindAllEids();
response.ShouldAllBeEquivalentTo(data);
}
public List <int> FindAllEids()
{
var sql = _sqlQueryConstructor.FindAllEidsQuery();
var nameValueCollections = _sqLiteDatabase.ExecuteReader(sql);
var response = new List <int>();
foreach (var nvc in nameValueCollections)
{
int subjectEid;
int.TryParse(nvc.Get("Eid"), out subjectEid);
response.Add(subjectEid);
}
return(response);
}