org.apache.empire.db.DBView Maven / Gradle / Ivy
The newest version!
/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you 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 org.apache.empire.db;
import java.util.concurrent.atomic.AtomicInteger;
import org.apache.empire.commons.Options;
import org.apache.empire.commons.StringUtils;
import org.apache.empire.data.Column;
import org.apache.empire.data.DataType;
import org.apache.empire.db.expr.column.DBValueExpr;
import org.apache.empire.exceptions.InvalidArgumentException;
import org.apache.empire.exceptions.ItemExistsException;
import org.apache.empire.exceptions.NotSupportedException;
import org.apache.empire.xml.XMLUtil;
import org.w3c.dom.Element;
/**
* This class represents a database view.
* It contains methods to get and update records from the database
*/
public abstract class DBView extends DBRowSet implements Cloneable
{
// *Deprecated* private static final long serialVersionUID = 1L;
/**
* DBViewColumn
* @author doebele
*/
public static class DBViewColumn extends DBColumn
{
// *Deprecated* private static final long serialVersionUID = 1L;
protected final DBColumnExpr expr;
protected final DataType dataType;
protected final DBColumn updateColumn;
protected final double size;
/**
* Constructs a DBViewColumn object set the specified parameters to this object.
*
* @param view the DBView object
* @param name the column name
* @param expr the DBColumnExpr of the source table
* @param size the column size
*/
protected DBViewColumn(DBView view, String name, DBColumnExpr expr, double size)
{ // call base
super(view, name);
// set Expression
this.expr = expr;
// set DataType
DataType exprType = expr.getDataType();
if (exprType==DataType.AUTOINC)
exprType= DataType.INTEGER;
this.dataType = exprType;
// Source Column
this.updateColumn = expr.getUpdateColumn();
// from update column
this.size = (updateColumn!=null ? updateColumn.getSize() : size);
// Copy enumType
Class> enumType = expr.getEnumType();
if (enumType!=null)
setAttribute(Column.COLATTR_ENUMTYPE, enumType);
// Add to view
if (view != null)
view.addViewColumn(this);
}
/**
* Copy constructor
* @param view the copied view
* @param other the column to copy
*/
protected DBViewColumn(DBView view, DBViewColumn other)
{ // call base
super(view, other.getName());
// set Expression
this.expr = other.expr;
this.dataType = other.dataType;
this.updateColumn = other.updateColumn;
this.size = other.size;
// Copy enumType
Class> enumType = other.getEnumType();
if (enumType!=null)
setAttribute(Column.COLATTR_ENUMTYPE, enumType);
// Add to view
if (view != null)
view.addViewColumn(this);
}
public DBColumnExpr getSourceColumnExpr()
{
return expr;
}
public DBView getView()
{
return (DBView)getRowSet();
}
@Override
public DataType getDataType()
{
return dataType;
}
@Override
public double getSize()
{
return size;
}
@Override
public boolean isAutoGenerated()
{
if (updateColumn==null)
return false;
return updateColumn.isAutoGenerated();
}
@Override
public boolean isReadOnly()
{
// Check ReadOnly attribute
if (updateColumn!=null)
return updateColumn.isReadOnly();
// AUTOINC's are read only
return isAutoGenerated();
}
@Override
public boolean isRequired()
{
// Check update Column
if (updateColumn==null)
return false;
return updateColumn.isRequired();
}
/*
* Obsolete: Type is copied in constructor
*
@Override
public Class> getEnumType()
{
Class> enumType = super.getEnumType();
if (enumType!=null)
return enumType;
// otherwise
return expr.getEnumType();
}
*/
@Override
public Object getAttribute(String name)
{
if (attributes != null && attributes.contains(name))
return attributes.get(name);
// Otherwise ask expression
return expr.getAttribute(name);
}
@Override
public Options getOptions()
{
if (options != null)
return options;
// Otherwise ask expression
return expr.getOptions();
}
@Override
public Object validateValue(Object value)
{
if (updateColumn==null)
return value;
return updateColumn.validateValue(value);
}
@Override
public Element addXml(Element parent, long flags)
{
Element elem = XMLUtil.addElement(parent, "column");
elem.setAttribute("name", name);
// set default attributes
if (updateColumn != null)
elem.setAttribute("source", updateColumn.getFullName());
// size
double size = getSize();
if (size > 0)
elem.setAttribute("size", String.valueOf(size));
// add All Attributes
if (attributes != null)
attributes.addXml(elem, flags);
// add All Options
Options fieldOptions = getOptions();
if (fieldOptions != null)
fieldOptions.addXml(elem, this.dataType);
// done
return elem;
}
/**
* sets the options from an enum class
* @param enumType the enum type
*/
public void setEnumOptions(Class enumType)
{
// Enum special treatment
log.debug("Adding enum options of type {} for column {}.", enumType.getName(), getName());
this.options = new Options(enumType);
// set enumType
setAttribute(Column.COLATTR_ENUMTYPE, enumType);
}
}
private static AtomicInteger viewCount = new AtomicInteger(0);
/**
* Automatically generates a new alias for this Object
* @param prefix the alias prefix
* @return an alias consisting of the prefix and a unique number
*/
protected String generateAlias(String prefix)
{
return prefix + String.valueOf(viewCount.incrementAndGet());
}
private final String name;
private String alias;
private DBViewColumn[] keyColumns;
private boolean updateable; // true if the view is updateable
private Boolean quoteName = null;
/**
* Creates a view object for a given view in the database.
*
* @param name the name of the view
* @param db the database this view belongs to.
* @param isUpdateable true if the records of this view can be updated
* @param alias the view alias
*/
public DBView(String name, DBDatabase db, boolean isUpdateable, String alias)
{ // Set the column expressions
super(db);
// generate alias
if (StringUtils.isEmpty(alias))
alias = generateAlias("v");
// Set Name and Alias
this.name = name;
this.alias = alias;
this.updateable = isUpdateable;
// Add View to Database
if (db != null && name != null)
db.addView(this);
}
/**
* Creates a view object for a given view in the database.
*
* @param name the name of the view
* @param db the database this view belongs to.
* @param isUpdateable true if the records of this view can be updated
*/
public DBView(String name, DBDatabase db, boolean isUpdateable)
{ // Set the column expressions
this(name, db, isUpdateable, null);
}
/**
* Creates a view object for a given view in the database.
*
* @param name the name of the view
* @param db the database this view belongs to.
*/
public DBView(String name, DBDatabase db)
{ // Set the column expressions
this(name, db, false);
}
/**
* Allows a second instance of a view with a different alias
* @return another instance of the view
*/
@Override
public Object clone() throws CloneNotSupportedException
{
DBView clone = (DBView) super.clone();
initClonedFields(clone);
// set key columns
clone.keyColumns = cloneKeyColumns(clone);
// set new alias
clone.alias = generateAlias("v");
// done
log.info("clone: Table " + name + " cloned! Alias old=" + alias + " new=" + clone.alias);
db.addView(clone);
return clone;
}
/**
* Allows a second instance of a view with a different alias
* @param newAlias the new alias
* @return another instance of the view
*/
@SuppressWarnings("unchecked")
public T clone(String newAlias)
{
try {
DBView clone = (DBView) super.clone();
initClonedFields(clone);
// set key columns
clone.keyColumns = cloneKeyColumns(clone);
// set new alias
if (StringUtils.isEmpty(newAlias))
clone.alias = generateAlias("v");
else
clone.alias = newAlias;
// done
log.info("clone: Table " + name + " cloned! Alias old=" + alias + " new=" + clone.alias);
db.addView(clone);
return (T)clone;
} catch (CloneNotSupportedException e) {
// unable to clone table
log.error("Unable to clone table " + getName());
throw new RuntimeException(e);
}
}
@Override
protected DBColumn cloneColumn(DBRowSet clone, DBColumn sourceColumn)
{
DBViewColumn newCol = new DBViewColumn((DBView)clone, (DBViewColumn)sourceColumn);
return newCol;
}
protected DBViewColumn[] cloneKeyColumns(DBView clone)
{
if (this.keyColumns==null)
return null;
// clone columns
DBViewColumn[] columns = new DBViewColumn[keyColumns.length];
for (int i=0; i
* This is function is only used for the creation of DDL statements
* @return a command expression that is used to create the view
*/
public abstract DBCommandExpr createCommand();
/**
* Returns the view name of this object.
* @return the view name of this object
*/
@Override
public String getName()
{
return name;
}
/**
* Returns the full qualified table name.
* @return the full qualified table name
*/
@Override
public String getFullName()
{
String schema = db.getSchema();
return (schema != null) ? StringUtils.concat(schema, ".", name) : name;
}
/**
* Returns the alias name of this object.
* @return the alias name of this object
*/
@Override
public String getAlias()
{
return alias;
}
/**
* Returns whether or not the view is updateable
* @return true if the view is updateable or false if not
*/
@Override
public boolean isUpdateable()
{
return this.updateable;
}
/**
* Adds a column to the view.
*
* @param col a view column object
*/
protected void addViewColumn(DBViewColumn col)
{ // find column by name
if (col == null || col.getRowSet() != this)
throw new InvalidArgumentException("col", col);
if (getColumn(col.getName())!=null)
throw new ItemExistsException(col.getName());
// add now
columns.add(col);
}
/**
* Adds a column to the view.
*
* @param columnName name of the column in the view
* @param dataType the data type of the column
* @param size the size of the column
* @return true if the column was successfully added or false otherwise
*/
protected final DBViewColumn addColumn(String columnName, DataType dataType, double size)
{ // find column by name
return new DBViewColumn(this, columnName, new DBValueExpr(db, null, dataType), size);
}
/**
* Adds a column to the view.
*
* @param columnName name of the column in the view
* @param dataType the data type of the column
* @return true if the column was successfully added or false otherwise
*/
protected final DBViewColumn addColumn(String columnName, DataType dataType)
{ // find column by name
return new DBViewColumn(this, columnName, new DBValueExpr(db, null, dataType), 0.0d);
}
/**
* Adds a column to the view.
*
* @param columnName name of the column in the view
* @param columnExpr the column expression that builds the column
* @return true if the column was successfully added or false otherwise
*/
protected final DBViewColumn addColumn(String columnName, DBColumnExpr columnExpr)
{ // find column by name
return new DBViewColumn(this, columnName, columnExpr, 0.0d);
}
/**
* Adds a column to the view based on an existing column in another table.
*
* @param sourceColumn existing column in another table
* @return the view column object
*/
protected final DBViewColumn addColumn(DBTableColumn sourceColumn)
{ // find column by name
return new DBViewColumn(this, sourceColumn.getName(), sourceColumn, sourceColumn.getSize());
}
/**
* Adds a column to the view based on an existing column in another view.
*
* @param sourceColumn existing column in another view
* @return the view column object
*/
protected final DBViewColumn addColumn(DBViewColumn sourceColumn)
{ // find column by name
return new DBViewColumn(this, sourceColumn.getName(), sourceColumn, sourceColumn.getSize());
}
/**
* This function searches for equal columns given by the specified DBColumnExpr object.
*
* @param expr the DBColumnExpr object
* @return the located column (only DBViewColumn objects)
*/
public DBViewColumn findViewColumn(DBColumnExpr expr)
{
for (int i = 0; i < columns.size(); i++)
{
DBViewColumn vc = (DBViewColumn) columns.get(i);
if (vc.expr.equals(expr))
return vc;
}
// not found
return null;
}
/**
* Creates the SQL-Command adds the alias name to the SQL-Command.
*
* @param sql the SQL-Command
* @param context the current SQL-Command context
*/
@Override
public void addSQL(DBSQLBuilder sql, long context)
{
// Append Name
if ((context & CTX_NAME|CTX_FULLNAME)!=0)
{ // append Qualified Name
db.appendQualifiedName(sql, name, quoteName);
}
// Append Alias
if ((context & CTX_ALIAS)!=0 && alias!=null)
{ // append alias
sql.append(getRenameTablePhrase());
sql.append(alias);
}
}
@Override
public void updateRecord(DBRecordBase rec)
{
if (updateable==false)
throw new NotSupportedException(this, "updateRecord");
// Update the record
super.updateRecord(rec);
}
/*
* (non-Javadoc)
*
* @see org.apache.empire.db.DBRowSet#addRecord(org.apache.empire.db.DBRecord, java.sql.Connection)
*/
@Override
public void createRecord(DBRecordBase record, Object[] initalKey, boolean deferredInit)
{
throw new NotSupportedException(this, "createRecord");
}
/*
* (non-Javadoc)
*
* @see org.apache.empire.db.DBRowSet#deleteRecord(java.lang.Object[], java.sql.Connection, boolean)
*/
@Override
public void deleteRecord(Object[] key, DBContext context)
{
throw new NotSupportedException(this, "deleteRecord");
}
} © 2015 - 2025 Weber Informatics LLC | Privacy Policy