1 package org.apache.maven.archiva.database.constraints;
2
3 /*
4 * Licensed to the Apache Software Foundation (ASF) under one
5 * or more contributor license agreements. See the NOTICE file
6 * distributed with this work for additional information
7 * regarding copyright ownership. The ASF licenses this file
8 * to you under the Apache License, Version 2.0 (the
9 * "License"); you may not use this file except in compliance
10 * with the License. You may obtain a copy of the License at
11 *
12 * http://www.apache.org/licenses/LICENSE-2.0
13 *
14 * Unless required by applicable law or agreed to in writing,
15 * software distributed under the License is distributed on an
16 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
17 * KIND, either express or implied. See the License for the
18 * specific language governing permissions and limitations
19 * under the License.
20 */
21
22 import org.apache.maven.archiva.database.Constraint;
23
24 /**
25 * UniqueFieldConstraint
26 */
27 public class UniqueFieldConstraint
28 extends AbstractSimpleConstraint
29 implements Constraint
30 {
31 private String sql;
32
33 public UniqueFieldConstraint( String className, String fieldName )
34 {
35 sql = "SELECT " + fieldName + " FROM " + className + " GROUP BY " + fieldName + " ORDER BY " + fieldName +
36 " ASCENDING";
37 }
38
39 public UniqueFieldConstraint( String className, String fieldName, String fieldNamePrefix )
40 {
41 sql = "SELECT " + fieldName + " FROM " + className + " WHERE " + fieldName +
42 ".startsWith( fieldPrefix ) PARAMETERS String fieldPrefix GROUP BY " + fieldName + " ORDER BY " +
43 fieldName + " ASCENDING";
44
45 super.params = new Object[]{fieldNamePrefix};
46 }
47
48 public Class<?> getResultClass()
49 {
50 return String.class;
51 }
52
53 public String getSelectSql()
54 {
55 return sql;
56 }
57 }