public void GetDeleteSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
var expected = $"DELETE FROM {TableFactory<Genre>.GetTable<GenreTable>().TableName} WHERE {GenreTable.IdColumnName} = @{GenreTable.IdColumnName};";
Assert.AreEqual(expected, table.GetDeleteSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
parameters.Clear();
value = new IdentifyingInfo
{
Name = StringExtensions.GetRandomStringAsync(25).Result
};
expected = $"DELETE FROM {TableFactory<Genre>.GetTable<GenreTable>().TableName} WHERE {GenreTable.NameColumnName} = @{GenreTable.NameColumnName};";
Assert.AreEqual(expected, table.GetDeleteSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
}
public void GetDeleteSqlExceptionTest()
{
var value = new IdentifyingInfo
{
Id = null,
Name = null
};
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
Assert.That(() => table.GetDeleteSql(value, ref parameters), Throws.ArgumentException);
}