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