public void GetAll_ReturnsHobbits() { HobbitDataManager dataManager = new HobbitDataManager(); dataManager.Insert(_testHobbit); List<Hobbit> hobbits = dataManager.GetAll().ToList(); Assert.NotNull(hobbits); Assert.True(hobbits.Count > 0); }
public void GetAll_ReturnsData() { string[] hobbitNames = new string[] { FIRST_HOBBIT_NAME, SECOND_HOBBIT_NAME }; IDbConnection database = CreateHobbitDatabase(hobbitNames); HobbitDataManager manager = new HobbitDataManager(database); IEnumerable <Hobbit> hobbits = manager.GetAll(); Assert.Equal(2, hobbits.Count()); }
public void Insert_ReturnsHobbit() { Hobbit testHobbit = new Hobbit("Insert hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit hobbit = dataManager.Insert(testHobbit); Assert.NotNull(hobbit); Assert.True(CompareHobbits(testHobbit, hobbit)); }
public void TryGet_ReturnsFalse_ForUnknownHobbit() { Hobbit testHobbit = new Hobbit("TryGet_ReturnsFalse hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); long hobbitId; bool foundHobbit = dataManager.TryGet(testHobbit, out hobbitId); Assert.False(foundHobbit); }
public void TryGet_ReturnsTrue_ForKnownHobbit() { Hobbit testHobbit = new Hobbit("TryGet_ReturnsTrue hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit insertedHobbit = dataManager.Insert(testHobbit); long hobbitId; bool foundHobbit = dataManager.TryGet(insertedHobbit, out hobbitId); Assert.True(foundHobbit); Assert.True(hobbitId != default(long)); // SQLite ids/rownums start at 1 }
public void Insert_ReturnsHobbit_WhenUsingDefaultValues( string name, string familyName, int birthYear, int deathYear, long id) { Hobbit testHobbit = new Hobbit("Insert " + name, familyName, birthYear, deathYear, id); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit hobbit = dataManager.Insert(testHobbit); Assert.NotNull(hobbit); Assert.True(CompareHobbits(testHobbit, hobbit)); }
public void Delete_ReturnsFalse_WhenZeroDatabaseRowsAffected() { Mock<IDbDataParameter> mockParameter = new Mock<IDbDataParameter>(); Mock<IDataParameterCollection> mockParameterCollection = new Mock<IDataParameterCollection>(); Mock<IDbCommand> mockCommand = new Mock<IDbCommand>(); mockCommand.Setup(cmd => cmd.ExecuteNonQuery()).Returns(0); mockCommand.Setup(cmd => cmd.CreateParameter()).Returns(mockParameter.Object); mockCommand.Setup(cmd => cmd.Parameters).Returns(mockParameterCollection.Object); Mock<IDbConnection> mockConnection = new Mock<IDbConnection>(); mockConnection.Setup(conn => conn.CreateCommand()).Returns(mockCommand.Object); HobbitDataManager dataManager = new HobbitDataManager(mockConnection.Object); bool deleted = dataManager.Delete(ID); Assert.False(deleted); mockCommand.Verify(cmd => cmd.ExecuteNonQuery(), Times.Once); }
public void Update_ReturnsNull_WhenZeroDatabaseRowsAffected() { Mock<IDbDataParameter> mockParameter = new Mock<IDbDataParameter>(); Mock<IDataParameterCollection> mockParameterCollection = new Mock<IDataParameterCollection>(); Mock<IDbCommand> mockCommand = new Mock<IDbCommand>(); mockCommand.Setup(cmd => cmd.ExecuteNonQuery()).Returns(0); mockCommand.Setup(cmd => cmd.CreateParameter()).Returns(mockParameter.Object); mockCommand.Setup(cmd => cmd.Parameters).Returns(mockParameterCollection.Object); Mock<IDbConnection> mockConnection = new Mock<IDbConnection>(); mockConnection.Setup(conn => conn.CreateCommand()).Returns(mockCommand.Object); HobbitDataManager dataManager = new HobbitDataManager(mockConnection.Object); Hobbit hobbit = dataManager.Update(_testHobbit, ID); Assert.Null(hobbit); mockCommand.Verify(cmd => cmd.ExecuteNonQuery(), Times.Once); }
public void Insert_ReturnsNull_WhenNameIsNull() { Hobbit testHobbit = new Hobbit(null, FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit hobbit = dataManager.Insert(testHobbit); Assert.Null(hobbit); }
public void Delete_ReturnsFalse_ForUnknownHobbit() { HobbitDataManager dataManager = new HobbitDataManager(); Random prng = new Random(); bool idExists = true; long someId = 0; while (idExists) { someId = Convert.ToInt64(prng.Next()); Hobbit someHobbit; idExists = dataManager.TryGet(someId, out someHobbit); } bool deleted = dataManager.Delete(someId); Assert.False(deleted); }
public void Delete_ReturnsTrue_ForKnownHobbit() { Hobbit testHobbit = new Hobbit("Deletable Hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit insertedHobbit = dataManager.Insert(testHobbit); bool deleted = dataManager.Delete(insertedHobbit.Id); Hobbit hobbit; bool foundHobbit = dataManager.TryGet(insertedHobbit.Id, out hobbit); Assert.True(deleted); Assert.False(foundHobbit); }
public void Update_ReturnsHobbit_WhenUsingDefaultValues( string name, string familyName, int birthYear, int deathYear, long id) { Hobbit testHobbit = new Hobbit("Update " + name, familyName, birthYear, deathYear, id); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit insertedHobbit = dataManager.Insert(testHobbit); Hobbit updatedHobbit = new Hobbit( "Updated and updated " + insertedHobbit.Name, insertedHobbit.FamilyName, insertedHobbit.BirthYear, insertedHobbit.DeathYear, insertedHobbit.Id); Hobbit hobbit = dataManager.Update(updatedHobbit, updatedHobbit.Id); Assert.NotNull(hobbit); Assert.True(CompareHobbits(updatedHobbit, hobbit)); }
public void Update_ReturnsUpdatedHobbit() { Hobbit testHobbit = new Hobbit("Insert hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit insertedHobbit = dataManager.Insert(testHobbit); Hobbit updatedHobbit = new Hobbit( "Inserted and updated" + insertedHobbit.Name, insertedHobbit.FamilyName, insertedHobbit.BirthYear, insertedHobbit.DeathYear, insertedHobbit.Id); Hobbit hobbit = dataManager.Update(updatedHobbit, updatedHobbit.Id); Assert.True(CompareHobbits(updatedHobbit, hobbit)); }