forked from ravendb/ravendb
-
Notifications
You must be signed in to change notification settings - Fork 0
/
UsingAsProjection.cs
91 lines (82 loc) · 2.14 KB
/
UsingAsProjection.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
using System.Collections.Generic;
using Raven.Abstractions.Indexing;
using Raven.Client;
using Raven.Client.Document;
using Raven.Client.Indexes;
using Raven.Client.Linq;
using Raven.Database.Indexing;
using System.Linq;
using Xunit;
namespace Raven.Tests.Bugs
{
public class UsingAsProjection : RemoteClientTest
{
[Fact]
public void ShouldWork()
{
using(GetNewServer())
{
using (var documentStore = new DocumentStore { Url = "http://localhost:8079" })
{
documentStore.Initialize();
using (IDocumentSession session = documentStore.OpenSession())
{
var company = new Account
{
Name = "Account A",
};
company.Users.Add(new User { Email = "a", Password = "1" });
company.Users.Add(new User { Email = "b", Password = "2" });
session.Store(company);
company = new Account
{
Name = "Account B",
};
company.Users.Add(new User { Email = "c", Password = "3" });
session.Store(company);
session.SaveChanges();
}
}
using (var documentStore = new DocumentStore { Url = "http://localhost:8079" })
{
documentStore.Initialize();
new UsersIndexTask().Execute(documentStore);
using (IDocumentSession session = documentStore.OpenSession())
{
var user = session.Query<Account, UsersIndexTask>()
.Customize(x=>x.WaitForNonStaleResults())
.AsProjection<User>()
.Where(x => x.Email == "a")
.FirstOrDefault();
Assert.Equal("1", user.Password);
}
}
}
}
public class UsersIndexTask : AbstractIndexCreationTask<Account, User>
{
public UsersIndexTask()
{
Map = accounts => from account in accounts
from user in account.Users
select new { user.Email, user.Password };
Stores.Add(x => x.Email, FieldStorage.Yes);
Stores.Add(x => x.Password, FieldStorage.Yes);
}
}
public class Account
{
public Account()
{
Users = new List<User>();
}
public List<User> Users { get; private set; }
public string Name { get; set; }
}
public class User
{
public string Password { get; set; }
public string Email { get; set; }
}
}
}