/*
* Copyright 2011, Mysema Ltd
*
* 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.mysema.query.sql;
import javax.annotation.Nullable;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
import com.mysema.query.types.*;
import com.mysema.query.types.expr.BooleanExpression;
import com.mysema.query.types.expr.BooleanOperation;
import com.mysema.query.types.expr.NumberExpression;
import com.mysema.query.types.expr.NumberOperation;
import com.mysema.query.types.path.BeanPath;
import static com.google.common.collect.ImmutableList.copyOf;
/**
* RelationalPathBase is a base class for {@link RelationalPath} implementations
*
* @author tiwe
*
* @param <T>
* entity type
*/
public class RelationalPathBase<T> extends BeanPath<T> implements RelationalPath<T> {
private static final long serialVersionUID = -7031357250283629202L;
@Nullable
private PrimaryKey<T> primaryKey;
private final Map<Path<?>, ColumnMetadata> columnMetadata = Maps.newLinkedHashMap();
private final List<ForeignKey<?>> foreignKeys = Lists.newArrayList();
private final List<ForeignKey<?>> inverseForeignKeys = Lists.newArrayList();
private final String schema, table;
private final SchemaAndTable schemaAndTable;
private transient FactoryExpression<T> projection;
private transient NumberExpression<Long> count, countDistinct;
public RelationalPathBase(Class<? extends T> type, String variable, String schema, String table) {
this(type, PathMetadataFactory.forVariable(variable), schema, table);
}
public RelationalPathBase(Class<? extends T> type, PathMetadata<?> metadata, String schema,
String table) {
super(type, metadata);
this.schema = schema;
this.table = table;
this.schemaAndTable = new SchemaAndTable(schema, table);
}
protected PrimaryKey<T> createPrimaryKey(Path<?>... columns) {
primaryKey = new PrimaryKey<T>(this, columns);
return primaryKey;
}
protected <F> ForeignKey<F> createForeignKey(Path<?> local, String foreign) {
ForeignKey<F> foreignKey = new ForeignKey<F>(this, local, foreign);
foreignKeys.add(foreignKey);
return foreignKey;
}
protected <F> ForeignKey<F> createForeignKey(List<? extends Path<?>> local, List<String> foreign) {
ForeignKey<F> foreignKey = new ForeignKey<F>(this, copyOf(local), copyOf(foreign));
foreignKeys.add(foreignKey);
return foreignKey;
}
protected <F> ForeignKey<F> createInvForeignKey(Path<?> local, String foreign) {
ForeignKey<F> foreignKey = new ForeignKey<F>(this, local, foreign);
inverseForeignKeys.add(foreignKey);
return foreignKey;
}
protected <F> ForeignKey<F> createInvForeignKey(List<? extends Path<?>> local,
List<String> foreign) {
ForeignKey<F> foreignKey = new ForeignKey<F>(this, copyOf(local), copyOf(foreign));
inverseForeignKeys.add(foreignKey);
return foreignKey;
}
protected <P extends Path<?>> P addMetadata(P path, ColumnMetadata metadata) {
columnMetadata.put(path, metadata);
return path;
}
@Override
public NumberExpression<Long> count() {
if (count == null) {
if (primaryKey != null) {
count = NumberOperation.create(Long.class, Ops.AggOps.COUNT_AGG,
primaryKey.getLocalColumns().get(0));
} else {
throw new IllegalStateException("No count expression can be created");
}
}
return count;
}
@Override
public NumberExpression<Long> countDistinct() {
if (countDistinct == null) {
if (primaryKey != null) {
// TODO handle multiple column primary keys properly
countDistinct = NumberOperation.create(Long.class, Ops.AggOps.COUNT_DISTINCT_AGG,
primaryKey.getLocalColumns().get(0));
} else {
throw new IllegalStateException("No count distinct expression can be created");
}
}
return countDistinct;
}
/**
* Compares the two relational paths using primary key columns
*
* @param right rhs of the comparison
* @return
*/
@Override
public BooleanExpression eq(T right) {
if (right instanceof RelationalPath) {
return primaryKeyOperation(Ops.EQ, primaryKey, ((RelationalPath) right).getPrimaryKey());
} else {
return super.eq(right);
}
}
/**
* Compares the two relational paths using primary key columns
*
* @param right rhs of the comparison
* @return
*/
@Override
public BooleanExpression eq(Expression<? super T> right) {
if (right instanceof RelationalPath) {
return primaryKeyOperation(Ops.EQ, primaryKey, ((RelationalPath) right).getPrimaryKey());
} else {
return super.eq(right);
}
}
/**
* Compares the two relational paths using primary key columns
*
* @param right rhs of the comparison
* @return
*/
@Override
public BooleanExpression ne(T right) {
if (right instanceof RelationalPath) {
return primaryKeyOperation(Ops.NE, primaryKey, ((RelationalPath) right).getPrimaryKey());
} else {
return super.ne(right);
}
}
/**
* Compares the two relational paths using primary key columns
*
* @param right rhs of the comparison
* @return
*/
@Override
public BooleanExpression ne(Expression<? super T> right) {
if (right instanceof RelationalPath) {
return primaryKeyOperation(Ops.NE, primaryKey, ((RelationalPath) right).getPrimaryKey());
} else {
return super.ne(right);
}
}
private BooleanExpression primaryKeyOperation(Operator<Boolean> op, PrimaryKey<?> pk1, PrimaryKey<?> pk2) {
if (pk1 == null || pk2 == null) {
throw new UnsupportedOperationException("No primary keys available");
}
if (pk1.getLocalColumns().size() != pk2.getLocalColumns().size()) {
throw new UnsupportedOperationException("Size mismatch for primary key columns");
}
BooleanExpression rv = null;
for (int i = 0; i < pk1.getLocalColumns().size(); i++) {
BooleanExpression pred = BooleanOperation.create(op, pk1.getLocalColumns().get(i), pk2.getLocalColumns().get(i));
rv = rv != null ? rv.and(pred) : pred;
}
return rv;
}
@Override
public FactoryExpression<T> getProjection() {
if (projection == null) {
projection = RelationalPathUtils.createProjection(this);
}
return projection;
}
public Path<?>[] all() {
Path<?>[] all = new Path[columnMetadata.size()];
columnMetadata.keySet().toArray(all);
return all;
}
@Override
protected <P extends Path<?>> P add(P path) {
return path;
}
@Override
public List<Path<?>> getColumns() {
return Lists.newArrayList(this.columnMetadata.keySet());
}
@Override
public Collection<ForeignKey<?>> getForeignKeys() {
return foreignKeys;
}
@Override
public Collection<ForeignKey<?>> getInverseForeignKeys() {
return inverseForeignKeys;
}
@Override
public PrimaryKey<T> getPrimaryKey() {
return primaryKey;
}
@Override
public SchemaAndTable getSchemaAndTable() {
return schemaAndTable;
}
@Override
public String getSchemaName() {
return schema;
}
@Override
public String getTableName() {
return table;
}
@Override
public ColumnMetadata getMetadata(Path<?> column) {
return columnMetadata.get(column);
}
}