public void GetIdFromNameExceptionTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new ArtistTable();
Assert.That(() => table.GetIdFromNameSql(value, ref parameters), Throws.ArgumentException);
}
public void GetIdFromNameTest()
{
var value = new IdentifyingInfo
{
Name = StringExtensions.GetRandomStringAsync(25).Result
};
var parameters = new List <SQLiteParameter>();
var table = new ArtistTable();
var expected = $"SELECT {ArtistTable.IdColumnName} FROM {table.TableName} WHERE {ArtistTable.NameColumnName} = @{ArtistTable.NameColumnName};";
Assert.AreEqual(expected, table.GetIdFromNameSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
}