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 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_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_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.Insert(_testHobbit); 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 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_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)); }