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
169
170
171
172
173
174
175
176
|
/*
Copyright (c) 2008 Health Market Science, Inc.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/
package com.healthmarketscience.jackcess.impl;
import java.util.Collections;
import java.util.List;
import java.util.ArrayList;
import com.healthmarketscience.jackcess.Column;
import com.healthmarketscience.jackcess.Relationship;
import com.healthmarketscience.jackcess.Table;
/**
* Information about a relationship between two tables in the database.
*
* @author James Ahlborn
*/
public class RelationshipImpl implements Relationship
{
/** flag indicating one-to-one relationship */
public static final int ONE_TO_ONE_FLAG = 0x00000001;
/** flag indicating no referential integrity */
public static final int NO_REFERENTIAL_INTEGRITY_FLAG = 0x00000002;
/** flag indicating cascading updates (requires referential integrity) */
public static final int CASCADE_UPDATES_FLAG = 0x00000100;
/** flag indicating cascading deletes (requires referential integrity) */
public static final int CASCADE_DELETES_FLAG = 0x00001000;
/** flag indicating cascading null on delete (requires referential
integrity) */
public static final int CASCADE_NULL_FLAG = 0x00002000;
/** flag indicating left outer join */
public static final int LEFT_OUTER_JOIN_FLAG = 0x01000000;
/** flag indicating right outer join */
public static final int RIGHT_OUTER_JOIN_FLAG = 0x02000000;
/** the name of this relationship */
private final String _name;
/** the "from" table in this relationship */
private final Table _fromTable;
/** the "to" table in this relationship */
private final Table _toTable;
/** the columns in the "from" table in this relationship (aligned w/
toColumns list) */
private final List<Column> _toColumns;
/** the columns in the "to" table in this relationship (aligned w/
toColumns list) */
private final List<Column> _fromColumns;
/** the various flags describing this relationship */
private final int _flags;
public RelationshipImpl(String name, Table fromTable, Table toTable, int flags,
int numCols)
{
this(name, fromTable, toTable, flags,
Collections.nCopies(numCols, (Column)null),
Collections.nCopies(numCols, (Column)null));
}
public RelationshipImpl(String name, Table fromTable, Table toTable, int flags,
List<? extends Column> fromCols,
List<? extends Column> toCols)
{
_name = name;
_fromTable = fromTable;
_fromColumns = new ArrayList<Column>(fromCols);
_toTable = toTable;
_toColumns = new ArrayList<Column>(toCols);
_flags = flags;
}
@Override
public String getName() {
return _name;
}
@Override
public Table getFromTable() {
return _fromTable;
}
@Override
public List<Column> getFromColumns() {
return _fromColumns;
}
@Override
public Table getToTable() {
return _toTable;
}
@Override
public List<Column> getToColumns() {
return _toColumns;
}
public int getFlags() {
return _flags;
}
@Override
public boolean isOneToOne() {
return hasFlag(ONE_TO_ONE_FLAG);
}
@Override
public boolean hasReferentialIntegrity() {
return !hasFlag(NO_REFERENTIAL_INTEGRITY_FLAG);
}
@Override
public boolean cascadeUpdates() {
return hasFlag(CASCADE_UPDATES_FLAG);
}
@Override
public boolean cascadeDeletes() {
return hasFlag(CASCADE_DELETES_FLAG);
}
@Override
public boolean cascadeNullOnDelete() {
return hasFlag(CASCADE_NULL_FLAG);
}
@Override
public boolean isLeftOuterJoin() {
return hasFlag(LEFT_OUTER_JOIN_FLAG);
}
@Override
public boolean isRightOuterJoin() {
return hasFlag(RIGHT_OUTER_JOIN_FLAG);
}
@Override
public JoinType getJoinType() {
if(isLeftOuterJoin()) {
return JoinType.LEFT_OUTER;
} else if(isRightOuterJoin()) {
return JoinType.RIGHT_OUTER;
}
return JoinType.INNER;
}
private boolean hasFlag(int flagMask) {
return((getFlags() & flagMask) != 0);
}
@Override
public String toString() {
return CustomToStringStyle.builder(this)
.append("name", _name)
.append("fromTable", _fromTable.getName())
.append("fromColumns", _fromColumns)
.append("toTable", _toTable.getName())
.append("toColumns", _toColumns)
.append("flags", Integer.toHexString(_flags))
.toString();
}
}
|
