Review Board 1.7.22


SQOOP-1042 Sqoop2: Name constraints in Derby repository

Review Request #11071 - Created May 12, 2013 and submitted

Jarek Cecho
SQOOP-1042
Reviewers
Sqoop
sqoop-sqoop2
I've added explicit constraint names.
Both unit and integration tests seems to be passing.
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java
Revision e1b1128cfcfa38d095096067629c37a585646f47 New Change
[20] 20 lines
[+20]
21

    
   
21

   
22
  public static final String SCHEMA_SQOOP = "SQOOP";
22
  public static final String SCHEMA_SQOOP = "SQOOP";
23

    
   
23

   
24
  private static final String SCHEMA_PREFIX = SCHEMA_SQOOP + ".";
24
  private static final String SCHEMA_PREFIX = SCHEMA_SQOOP + ".";
25

    
   
25

   

    
   
26
  private static final String CONSTRAINT_PREFIX = "FK_";

    
   
27

   
26
  // SQ_CONNECTOR
28
  // SQ_CONNECTOR
27

    
   
29

   
28
  public static final String TABLE_SQ_CONNECTOR_NAME = "SQ_CONNECTOR";
30
  public static final String TABLE_SQ_CONNECTOR_NAME = "SQ_CONNECTOR";
29

    
   
31

   
30
  public static final String TABLE_SQ_CONNECTOR = SCHEMA_PREFIX
32
  public static final String TABLE_SQ_CONNECTOR = SCHEMA_PREFIX
[+20] [20] 24 lines
[+20]
55

    
   
57

   
56
  public static final String COLUMN_SQF_TYPE = "SQF_TYPE";
58
  public static final String COLUMN_SQF_TYPE = "SQF_TYPE";
57

    
   
59

   
58
  public static final String COLUMN_SQF_INDEX = "SQF_INDEX";
60
  public static final String COLUMN_SQF_INDEX = "SQF_INDEX";
59

    
   
61

   

    
   
62
  public static final String CONSTRAINT_SQF_SQC_NAME = CONSTRAINT_PREFIX + "SQF_SQC";

    
   
63

   

    
   
64
  public static final String CONSTRAINT_SQF_SQC = SCHEMA_PREFIX + CONSTRAINT_SQF_SQC_NAME;

    
   
65

   
60
  // SQ_INPUT
66
  // SQ_INPUT
61

    
   
67

   
62
  public static final String TABLE_SQ_INPUT_NAME = "SQ_INPUT";
68
  public static final String TABLE_SQ_INPUT_NAME = "SQ_INPUT";
63

    
   
69

   
64
  public static final String TABLE_SQ_INPUT = SCHEMA_PREFIX
70
  public static final String TABLE_SQ_INPUT = SCHEMA_PREFIX
[+20] [20] 13 lines
[+20]
78

    
   
84

   
79
  public static final String COLUMN_SQI_STRLENGTH = "SQI_STRLENGTH";
85
  public static final String COLUMN_SQI_STRLENGTH = "SQI_STRLENGTH";
80

    
   
86

   
81
  public static final String COLUMN_SQI_ENUMVALS = "SQI_ENUMVALS";
87
  public static final String COLUMN_SQI_ENUMVALS = "SQI_ENUMVALS";
82

    
   
88

   

    
   
89
  public static final String CONSTRAINT_SQI_SQF_NAME = CONSTRAINT_PREFIX + "SQI_SQF";

    
   
90

   

    
   
91
  public static final String CONSTRAINT_SQI_SQF = SCHEMA_PREFIX + CONSTRAINT_SQI_SQF_NAME;

    
   
92

   
83
  // SQ_CONNECTION
93
  // SQ_CONNECTION
84

    
   
94

   
85
  public static final String TABLE_SQ_CONNECTION_NAME = "SQ_CONNECTION";
95
  public static final String TABLE_SQ_CONNECTION_NAME = "SQ_CONNECTION";
86

    
   
96

   
87
  public static final String TABLE_SQ_CONNECTION = SCHEMA_PREFIX
97
  public static final String TABLE_SQ_CONNECTION = SCHEMA_PREFIX
[+20] [20] 7 lines
[+20]
95

    
   
105

   
96
  public static final String COLUMN_SQN_CREATION_DATE = "SQN_CREATION_DATE";
106
  public static final String COLUMN_SQN_CREATION_DATE = "SQN_CREATION_DATE";
97

    
   
107

   
98
  public static final String COLUMN_SQN_UPDATE_DATE = "SQN_UPDATE_DATE";
108
  public static final String COLUMN_SQN_UPDATE_DATE = "SQN_UPDATE_DATE";
99

    
   
109

   

    
   
110
  public static final String CONSTRAINT_SQN_SQC_NAME = CONSTRAINT_PREFIX + "SQN_SQC";

    
   
111

   

    
   
112
  public static final String CONSTRAINT_SQN_SQC = SCHEMA_PREFIX + CONSTRAINT_SQN_SQC_NAME;

    
   
113

   
100
  // SQ_JOB
114
  // SQ_JOB
101

    
   
115

   
102
  public static final String TABLE_SQ_JOB_NAME = "SQ_JOB";
116
  public static final String TABLE_SQ_JOB_NAME = "SQ_JOB";
103

    
   
117

   
104
  public static final String TABLE_SQ_JOB = SCHEMA_PREFIX
118
  public static final String TABLE_SQ_JOB = SCHEMA_PREFIX
[+20] [20] 9 lines
[+20]
114

    
   
128

   
115
  public static final String COLUMN_SQB_CREATION_DATE = "SQB_CREATION_DATE";
129
  public static final String COLUMN_SQB_CREATION_DATE = "SQB_CREATION_DATE";
116

    
   
130

   
117
  public static final String COLUMN_SQB_UPDATE_DATE = "SQB_UPDATE_DATE";
131
  public static final String COLUMN_SQB_UPDATE_DATE = "SQB_UPDATE_DATE";
118

    
   
132

   

    
   
133
  public static final String CONSTRAINT_SQB_SQN_NAME = CONSTRAINT_PREFIX + "SQB_SQN";

    
   
134

   

    
   
135
  public static final String CONSTRAINT_SQB_SQN = SCHEMA_PREFIX + CONSTRAINT_SQB_SQN_NAME;

    
   
136

   
119
  // SQ_CONNECTION_INPUT
137
  // SQ_CONNECTION_INPUT
120

    
   
138

   
121
  public static final String TABLE_SQ_CONNECTION_INPUT_NAME =
139
  public static final String TABLE_SQ_CONNECTION_INPUT_NAME =
122
      "SQ_CONNECTION_INPUT";
140
    "SQ_CONNECTION_INPUT";
123

    
   
141

   
[+20] [20] 4 lines
[+20]
128

    
   
146

   
129
  public static final String COLUMN_SQNI_INPUT = "SQNI_INPUT";
147
  public static final String COLUMN_SQNI_INPUT = "SQNI_INPUT";
130

    
   
148

   
131
  public static final String COLUMN_SQNI_VALUE = "SQNI_VALUE";
149
  public static final String COLUMN_SQNI_VALUE = "SQNI_VALUE";
132

    
   
150

   

    
   
151
  public static final String CONSTRAINT_SQNI_SQN_NAME = CONSTRAINT_PREFIX + "SQNI_SQN";

    
   
152

   

    
   
153
  public static final String CONSTRAINT_SQNI_SQN = SCHEMA_PREFIX + CONSTRAINT_SQNI_SQN_NAME;

    
   
154

   

    
   
155
  public static final String CONSTRAINT_SQNI_SQI_NAME = CONSTRAINT_PREFIX + "SQNI_SQI";

    
   
156

   

    
   
157
  public static final String CONSTRAINT_SQNI_SQI = SCHEMA_PREFIX + CONSTRAINT_SQNI_SQI_NAME;

    
   
158

   
133
  // SQ_JOB_INPUT
159
  // SQ_JOB_INPUT
134

    
   
160

   
135
  public static final String TABLE_SQ_JOB_INPUT_NAME =
161
  public static final String TABLE_SQ_JOB_INPUT_NAME =
136
      "SQ_JOB_INPUT";
162
    "SQ_JOB_INPUT";
137

    
   
163

   
[+20] [20] 4 lines
[+20]
142

    
   
168

   
143
  public static final String COLUMN_SQBI_INPUT = "SQBI_INPUT";
169
  public static final String COLUMN_SQBI_INPUT = "SQBI_INPUT";
144

    
   
170

   
145
  public static final String COLUMN_SQBI_VALUE = "SQBI_VALUE";
171
  public static final String COLUMN_SQBI_VALUE = "SQBI_VALUE";
146

    
   
172

   

    
   
173
  public static final String CONSTRAINT_SQBI_SQB_NAME = CONSTRAINT_PREFIX + "SQBI_SQB";

    
   
174

   

    
   
175
  public static final String CONSTRAINT_SQBI_SQB = SCHEMA_PREFIX + CONSTRAINT_SQBI_SQB_NAME;

    
   
176

   

    
   
177
  public static final String CONSTRAINT_SQBI_SQI_NAME = CONSTRAINT_PREFIX + "SQBI_SQI";

    
   
178

   

    
   
179
  public static final String CONSTRAINT_SQBI_SQI = SCHEMA_PREFIX + CONSTRAINT_SQBI_SQI_NAME;

    
   
180

   
147
  // SQ_SUBMISSION
181
  // SQ_SUBMISSION
148

    
   
182

   
149
  public static final String TABLE_SQ_SUBMISSION_NAME =
183
  public static final String TABLE_SQ_SUBMISSION_NAME =
150
      "SQ_SUBMISSION";
184
    "SQ_SUBMISSION";
151

    
   
185

   
[+20] [20] 16 lines
[+20]
168

    
   
202

   
169
  public static final String COLUMN_SQS_EXCEPTION = "SQS_EXCEPTION";
203
  public static final String COLUMN_SQS_EXCEPTION = "SQS_EXCEPTION";
170

    
   
204

   
171
  public static final String COLUMN_SQS_EXCEPTION_TRACE = "SQS_EXCEPTION_TRACE";
205
  public static final String COLUMN_SQS_EXCEPTION_TRACE = "SQS_EXCEPTION_TRACE";
172

    
   
206

   

    
   
207
  public static final String CONSTRAINT_SQS_SQB_NAME = CONSTRAINT_PREFIX + "SQS_SQB";

    
   
208

   

    
   
209
  public static final String CONSTRAINT_SQS_SQB = SCHEMA_PREFIX + CONSTRAINT_SQS_SQB_NAME;

    
   
210

   
173
  // SQ_COUNTER_GROUP
211
  // SQ_COUNTER_GROUP
174

    
   
212

   
175
  public static final String TABLE_SQ_COUNTER_GROUP_NAME =
213
  public static final String TABLE_SQ_COUNTER_GROUP_NAME =
176
      "SQ_COUNTER_GROUP";
214
    "SQ_COUNTER_GROUP";
177

    
   
215

   
[+20] [20] 30 lines
[+20]
208

    
   
246

   
209
  public static final String COLUMN_SQRS_SUBMISSION = "SQRS_SUBMISSION";
247
  public static final String COLUMN_SQRS_SUBMISSION = "SQRS_SUBMISSION";
210

    
   
248

   
211
  public static final String COLUMN_SQRS_VALUE = "SQRS_VALUE";
249
  public static final String COLUMN_SQRS_VALUE = "SQRS_VALUE";
212

    
   
250

   

    
   
251
  public static final String CONSTRAINT_SQRS_SQG_NAME = CONSTRAINT_PREFIX + "SQRS_SQG";

    
   
252

   

    
   
253
  public static final String CONSTRAINT_SQRS_SQG = SCHEMA_PREFIX + CONSTRAINT_SQRS_SQG_NAME;

    
   
254

   

    
   
255
  public static final String CONSTRAINT_SQRS_SQR_NAME = CONSTRAINT_PREFIX + "SQRS_SQR";

    
   
256

   

    
   
257
  public static final String CONSTRAINT_SQRS_SQR = SCHEMA_PREFIX + CONSTRAINT_SQRS_SQR_NAME;

    
   
258

   

    
   
259
  public static final String CONSTRAINT_SQRS_SQS_NAME = CONSTRAINT_PREFIX + "SQRS_SQS";

    
   
260

   

    
   
261
  public static final String CONSTRAINT_SQRS_SQS = SCHEMA_PREFIX + CONSTRAINT_SQRS_SQS_NAME;

    
   
262

   
213
  private DerbySchemaConstants() {
263
  private DerbySchemaConstants() {
214
    // Disable explicit object creation
264
    // Disable explicit object creation
215
  }
265
  }
216
}
266
}
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
Revision 24f86eee7a084997194dd0f9421297d6b9839e49 New Change
 
  1. repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java: Loading...
  2. repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java: Loading...