public void TestUpdate(TestSessionWrapper wrapper) {
var user = wrapper.Session.Query<User>().First();
user.HeightInMeters = 1.7m;
wrapper.Session.Save(user);
var dbUser = wrapper.Session.Get<User>(user.UserId);
Assert.Equal(1.7m, dbUser.HeightInMeters);
}
public void TestMultipleInsertUpdatesIds(TestSessionWrapper wrapper) {
var user = new User { Username = "******", EmailAddress = "asd", Password = "******" };
var user2 = new User { Username = "******", EmailAddress = "asd", Password = "******" };
wrapper.Session.Insert(user, user2);
Assert.NotEqual(0, user.UserId);
Assert.NotEqual(0, user2.UserId);
Assert.NotEqual(user.UserId, user2.UserId);
}
public void TestManyFetches(TestSessionWrapper wrapper) {
var post =
wrapper.Session.Query<Post>()
.FetchMany(p => p.Comments)
.ThenFetch(c => c.User)
.Fetch(p => p.Blog)
.Fetch(p => p.Author)
.SingleOrDefault(p => p.PostId == 1);
Assert.True(post != null);
}
public void TestManyToManyThing(TestSessionWrapper wrapper) {
var post =
wrapper.Session.Query<Post>()
.FetchMany(p => p.Tags)
.ThenFetch(t => t.Tag)
.Fetch(p => p.Blog)
.Fetch(p => p.Author)
.SingleOrDefault(p => p.PostId == 1);
Assert.True(post != null);
}
public void MultipleFetchManyWithNonRootAndThenFetchWorks(TestSessionWrapper wrapper) {
var responses =
wrapper.Session.Query<QuestionnaireResponse>()
.Where(qr => qr.Questionnaire.QuestionnaireId == 1)
.Fetch(qr => qr.Questionnaire)
.FetchMany(qr => qr.Responses)
.ThenFetch(qrr => qrr.Question)
.FetchMany(qr => qr.Booking.Beds)
.ThenFetch(b => b.RoomSlot.Room)
.ToArray();
Assert.Equal(1, responses.Length);
Assert.Equal(1, responses.First().Booking.Beds.Count);
}
public void TestSingleAndFirst(TestSessionWrapper wrapper) {
// now fetch them
var t1 = wrapper.Session.Query<User>().First();
Assert.Equal("User_0", t1.Username);
var t2 = wrapper.Session.Query<User>().First(u => u.Username == "User_1");
Assert.Equal("User_1", t2.Username);
Assert.Throws<InvalidOperationException>(() => wrapper.Session.Query<User>().Single());
var t3 = wrapper.Session.Query<User>().Single(u => u.Username == "User_2");
Assert.Equal("User_2", t3.Username);
var t4 = wrapper.Session.Query<User>().FirstOrDefault();
Assert.Equal("User_0", t1.Username);
var t5 = wrapper.Session.Query<User>().FirstOrDefault(u => u.Username == "Boo");
Assert.Null(t5);
var t6 = wrapper.Session.Query<User>().SingleOrDefault(u => u.Username == "Boo");
Assert.Null(t6);
}
public void UpdateBulk(TestSessionWrapper wrapper) {
wrapper.Session.Update<User>(u => u.Password = "******", u => u.Username == "BulkUpdate");
var user = wrapper.Session.Query<User>().First(u => u.Username == "BulkUpdate");
Assert.Equal("boo", user.Password);
}
public void TestInsertGetsId(TestSessionWrapper wrapper) {
var user = new User { Username = "******", EmailAddress = Guid.NewGuid().ToString(), Password = "******" };
wrapper.Session.Insert(user);
Assert.NotEqual(0, user.UserId);
}
public void TestInsert(TestSessionWrapper wrapper) {
var user = new User { Username = "******", EmailAddress = Guid.NewGuid().ToString(), Password = "******" };
wrapper.Session.Insert(user);
var dbUser = wrapper.Session.Query<User>().First(u => u.EmailAddress == user.EmailAddress);
Assert.NotNull(dbUser);
}
public async Task QueryWorks(TestSessionWrapper wrapper) {
var posts = await wrapper.Session.Query<Post>().ToListAsync();
Assert.Equal(20, posts.Count());
}
public async Task AnyAsyncWhereTrueWorks(TestSessionWrapper wrapper) {
Assert.True(await wrapper.Session.Query<User>().AnyAsync(u => u.UserId == 8));
}
public void TestDelete(TestSessionWrapper wrapper) {
var user = wrapper.Session.Query<User>().First(u => u.Username == "TestDelete");
wrapper.Session.Delete(user);
Assert.Empty(wrapper.Session.Query<User>().Where(u => u.Username == "TestDelete"));
}
public void TestChainedCollectionFetch(TestSessionWrapper wrapper) {
var blog = wrapper.Session.Query<Blog>().FetchMany(p => p.Posts).ThenFetch(p => p.Comments).First();
Assert.Equal(2, blog.Posts.Count);
Assert.Equal(3, blog.Posts.First().Comments.Count);
}
public void TestFetchingEmptyCollection(TestSessionWrapper wrapper) {
var emptyBlog = wrapper.Session.Query<Blog>().First(b => b.Title == "EmptyBlog");
Assert.Empty(emptyBlog.Posts);
}
public void TestMultiCollectionFetch(TestSessionWrapper wrapper) {
var posts = wrapper.Session.Query<Post>().Fetch(p => p.Comments).Fetch(p => p.Tags).Where(p => p.PostId == 1).ToList();
Assert.True(posts.First().Comments.Count == 3);
Assert.True(posts.First().Tags.Count == 2);
}
public void TestCollectionFetch(TestSessionWrapper wrapper) {
var posts = wrapper.Session.Query<Post>().Fetch(p => p.Comments).ToList();
Assert.True(
posts.First(p => p.PostId == 1)
.Comments.Count(c => c.Content == "Comment_0" || c.Content == "Comment_1" || c.Content == "Nullable User Content") == 3);
}
public async Task InsertWorks(TestSessionWrapper wrapper) {
var comment = new Comment { Content = "Foo" };
await wrapper.Session.InsertAsync(comment);
Assert.NotEqual(0, comment.CommentId);
}
public async Task CollectionWorks(TestSessionWrapper wrapper) {
var posts = await wrapper.Session.Query<Post>().Fetch(p => p.Comments).ToListAsync();
Assert.Equal(20, posts.Count());
}
public void DeleteBulk(TestSessionWrapper wrapper) {
wrapper.Session.Delete<User>(u => u.Username == "BulkDelete");
var users = wrapper.Session.Query<User>().Where(u => u.Username == "BulkDelete");
Assert.Empty(users);
}
public void AnyWhereTrueWorks(TestSessionWrapper wrapper) {
Assert.True(wrapper.Session.Query<User>().Any(u => u.UserId == 8));
}
public void FetchWithNonFetchedWhere(TestSessionWrapper wrapper) {
var comment = wrapper.Session.Query<Comment>().Fetch(c => c.Post.Blog).Where(c => c.User.EmailAddress == "foo");
Assert.Null(comment.FirstOrDefault());
}
public void WhereEnumerableWorks(TestSessionWrapper wrapper) {
var ids = new long[] { 1, 2, 3 };
var posts = wrapper.Session.Query<Post>().Where(p => ids.Contains(p.PostId)).ToList();
Assert.Equal(3, posts.Count);
}
public void DateTimeInsertedAndSelectedCorrectly(TestSessionWrapper wrapper) {
var date = new DateTime(2016, 12, 25, 1, 3, 6, DateTimeKind.Utc);
var comment = new Comment { Content = "Foo", CommentDate = date };
wrapper.Session.Insert(comment);
Assert.Equal(date, comment.CommentDate);
var fetchedComment = wrapper.Session.Get<Comment>(comment.CommentId);
Assert.Equal(date, fetchedComment.CommentDate);
}
public void NullableTripleFetchDoesNotThrow(TestSessionWrapper wrapper) {
var comment = wrapper.Session.Query<PostTag>().Fetch(c => c.Post.Blog).Where(t => t.Tag.Content == "Null Post Tag");
Assert.Null(comment.First().Post);
}
public async Task AnyAsyncWhereFalseWorks(TestSessionWrapper wrapper) {
Assert.False(await wrapper.Session.Query<User>().AnyAsync(u => u.UserId == 2000));
}
public async Task GetByIdWorks(TestSessionWrapper wrapper) {
var post = await wrapper.Session.GetAsync<Post, int>(1);
Assert.Equal(1, post.PostId);
}
public void AnyWhereFalseWorks(TestSessionWrapper wrapper) {
Assert.False(wrapper.Session.Query<User>().Any(u => u.UserId == 2000));
}
public async Task InsertAsyncEnablesTracking(TestSessionWrapper wrapper) {
var user = new User { Username = "******", EmailAddress = Guid.NewGuid().ToString(), Password = "******" };
await wrapper.Session.InsertAsync(user);
Assert.True(((ITrackedEntity)user).IsTrackingEnabled());
}
public void WhereAnyWorks(TestSessionWrapper wrapper) {
var posts = wrapper.Session.Query<Post>().Where(p => p.Comments.Any(c => c.Content == "Comment_1")).ToList();
Assert.Equal(1, posts.Count);
}
public void NullableFetchReturnsNull(TestSessionWrapper wrapper) {
var comment = wrapper.Session.Query<Comment>().Fetch(c => c.User).Where(c => c.Content == "Nullable User Content");
Assert.Null(comment.First().User);
}