forked from nhibernate/nhibernate-core
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathOuterJoinableAssociation.cs
168 lines (149 loc) · 4.46 KB
/
OuterJoinableAssociation.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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
using System;
using System.Collections.Generic;
using NHibernate.Engine;
using NHibernate.Persister.Collection;
using NHibernate.Persister.Entity;
using NHibernate.SqlCommand;
using NHibernate.Type;
using NHibernate.Util;
namespace NHibernate.Loader
{
public sealed class OuterJoinableAssociation
{
private readonly IAssociationType joinableType;
private readonly IJoinable joinable;
private readonly string lhsAlias; // belong to other persister
private readonly string[] lhsColumns; // belong to other persister
private readonly string rhsAlias;
private readonly string[] rhsColumns;
private readonly JoinType joinType;
private readonly SqlString on;
private readonly IDictionary<string, IFilter> enabledFilters;
public OuterJoinableAssociation(IAssociationType joinableType, String lhsAlias, String[] lhsColumns, String rhsAlias,
JoinType joinType, SqlString withClause, ISessionFactoryImplementor factory,
IDictionary<string, IFilter> enabledFilters)
{
this.joinableType = joinableType;
this.lhsAlias = lhsAlias;
this.lhsColumns = lhsColumns;
this.rhsAlias = rhsAlias;
this.joinType = joinType;
joinable = joinableType.GetAssociatedJoinable(factory);
rhsColumns = JoinHelper.GetRHSColumnNames(joinableType, factory);
on = new SqlString(joinableType.GetOnCondition(rhsAlias, factory, enabledFilters));
if (StringHelper.IsNotEmpty(withClause))
on = on.Append(" and ( ").Append(withClause).Append(" )");
this.enabledFilters = enabledFilters; // needed later for many-to-many/filter application
}
public JoinType JoinType
{
get { return joinType; }
}
public string RHSAlias
{
get { return rhsAlias; }
}
public SqlString On
{
get { return on; }
}
private bool IsOneToOne
{
get
{
if (joinableType.IsEntityType)
{
EntityType etype = (EntityType) joinableType;
return etype.IsOneToOne;
}
else
{
return false;
}
}
}
public IAssociationType JoinableType
{
get { return joinableType; }
}
public string RHSUniqueKeyName
{
get { return joinableType.RHSUniqueKeyPropertyName; }
}
public bool IsCollection
{
get { return joinableType.IsCollectionType; }
}
public IJoinable Joinable
{
get { return joinable; }
}
public int GetOwner(IList<OuterJoinableAssociation> associations)
{
if (IsOneToOne || IsCollection)
{
return GetPosition(lhsAlias, associations);
}
else
{
return -1;
}
}
/// <summary>
/// Get the position of the join with the given alias in the
/// list of joins
/// </summary>
private static int GetPosition(string lhsAlias, IEnumerable<OuterJoinableAssociation> associations)
{
int result = 0;
foreach (OuterJoinableAssociation oj in associations)
{
if (oj.Joinable.ConsumesEntityAlias())
{
if (oj.rhsAlias.Equals(lhsAlias))
{
return result;
}
result++;
}
}
return -1;
}
public void AddJoins(JoinFragment outerjoin)
{
outerjoin.AddJoin(joinable.TableName, rhsAlias, lhsColumns, rhsColumns, joinType, on);
outerjoin.AddJoins(joinable.FromJoinFragment(rhsAlias, false, true),
joinable.WhereJoinFragment(rhsAlias, false, true));
}
public void ValidateJoin(string path)
{
if (rhsColumns == null || lhsColumns == null || lhsColumns.Length != rhsColumns.Length || lhsColumns.Length == 0)
{
throw new MappingException("invalid join columns for association: " + path);
}
}
public bool IsManyToManyWith(OuterJoinableAssociation other)
{
if (joinable.IsCollection)
{
IQueryableCollection persister = (IQueryableCollection) joinable;
if (persister.IsManyToMany)
{
return persister.ElementType == other.JoinableType;
}
}
return false;
}
public void AddManyToManyJoin(JoinFragment outerjoin, IQueryableCollection collection)
{
string manyToManyFilter = collection.GetManyToManyFilterFragment(rhsAlias, enabledFilters);
SqlString condition = string.Empty.Equals(manyToManyFilter)
? on
: StringHelper.IsEmpty(on) ? new SqlString(manyToManyFilter) :
on.Append(" and ").Append(manyToManyFilter);
outerjoin.AddJoin(joinable.TableName, rhsAlias, lhsColumns, rhsColumns, joinType, condition);
outerjoin.AddJoins(joinable.FromJoinFragment(rhsAlias, false, true),
joinable.WhereJoinFragment(rhsAlias, false, true));
}
}
}