public void UpdateOnePreferenceTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreatePreferenceTable()); List <UserPreference> preferences = new List <UserPreference>(); // When is the primary key set, at inserion or object creation? UserPreference u1 = new UserPreference("movies", 0.0, 0.0); UserPreference u2 = new UserPreference("games", 0.0, 100.0); preferences.Add(u1); preferences.Add(u2); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); u1._category = "gardening"; u1._minPrice = 95.0; u1._maxPrice = 165.75; result = storage.UpdateUserPreference(u1); Assert.True(result); UserPreference updatedPref = storage.GetUserPreference("gardening"); Assert.NotNull(updatedPref); Assert.Equal(95.0, updatedPref._minPrice); Assert.Equal(165.75, updatedPref._maxPrice); }
public void AddingPreferencesTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); List <UserPreference> preferences = new List <UserPreference>(); preferences.Add(new UserPreference("electronics")); preferences.Add(new UserPreference("books", 10.0, 1900.0)); preferences.Add(new UserPreference("gardening", 50.0, 100.0)); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); }
public void AddingNullPreferenceTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); Assert.Throws <ArgumentNullException>(() => { storage.InsertUserPreference(null); }); Assert.Throws <ArgumentNullException>(() => { storage.InsertUserPreferences(null); }); }
public void GetUserPreferenceNullTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); List <UserPreference> preferences = new List <UserPreference>(); preferences.Add(new UserPreference("movies", 0.0, 0.0)); preferences.Add(new UserPreference("games", 0.0, 100.0)); preferences.Add(new UserPreference("tools", 0.0, 100.0)); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); Assert.True(storage.GetNumberOfRows() == preferences.Count); UserPreference userPreference = storage.GetUserPreference("garden"); Assert.Null(userPreference); }
public void GetUserPreferenceTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); List <UserPreference> preferences = new List <UserPreference>(); preferences.Add(new UserPreference("movies", 0.0, 0.0)); preferences.Add(new UserPreference("games", 0.0, 100.0)); preferences.Add(new UserPreference("tools", 0.0, 100.0)); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); Assert.True(storage.GetNumberOfRows() == preferences.Count); UserPreference userPreference = storage.GetUserPreference("games"); Assert.NotNull(userPreference); Assert.Equal("games", userPreference._category); Assert.True(userPreference._minPrice == 0.0); Assert.True(userPreference._maxPrice == 100.0); }
public void GetNumberOfRowsTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); List <UserPreference> preferences = new List <UserPreference>(); preferences.Add(new UserPreference("movies", 0.0, 0.0)); preferences.Add(new UserPreference("games", 0.0, 100.0)); preferences.Add(new UserPreference("tools", 0.0, 100.0)); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); Assert.True(storage.GetNumberOfRows() == preferences.Count); int numItems = preferences.Count; preferences.RemoveAt(2); result = storage.DeleteUserPreferences(preferences); Assert.True(result); Assert.True(storage.GetNumberOfRows() == (numItems - preferences.Count)); }
public void RetievePreferencesTest() { SqliteStorage storage = _storage; Assert.True(_storage.CreateTables()); List <UserPreference> preferences = new List <UserPreference>(); preferences.Add(new UserPreference("movies", 0.0, 0.0)); preferences.Add(new UserPreference("games", 0.0, 100.0)); bool result = storage.InsertUserPreferences(preferences); Assert.True(result); List <UserPreference> myPreferences = storage.GetUserPreferences(); Assert.True(myPreferences.Count == preferences.Count); for (int i = 0; i < myPreferences.Count; i++) { Assert.Equal(preferences[i], myPreferences[i]); } }