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