net.sf.basedb.core
Class RealTable

java.lang.Object
  net.sf.basedb.core.RealTable

public class RealTable
extends Object

This class defines constants that are used to specify a table in the regular (non-dynamic) database while doing analysis with dynamic queries. This makes it possible to join data from the regular tables into a dynamic query.

Version:

2.0

Author:

Nicklas

See Also:

DynamicSpotQuery.joinReporters(net.sf.basedb.core.query.JoinType), RealJoin, RawDataType.getRealTable()

Last modified

$Date: 2009-04-06 14:52:39 +0200 (Mon, 06 Apr 2009) $

Field Summary

private String	alias The alias to use in queries for this table.
static RealTable	REPORTER_LIST_SCORES
static RealTable	REPORTERS
private String	tableName The unquoted table name.

Constructor Summary

RealTable(String tableName, String alias)
Creates a new table.

Method Summary

String	getAlias() Get the alias of this table.
String	getAlias(BasicItem item) Get the alias of this table, using the ID of the item to make it unique.
String	getAlias(int id) Get the alias of this table, using the ID of the item to make it unique.
String	getQualifiedTableName() Get the quoted table name of this table in the database.
String	getTableName() Get the unquoted table name of this table in the database.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

REPORTERS

public static final RealTable REPORTERS

REPORTER_LIST_SCORES

public static final RealTable REPORTER_LIST_SCORES

tableName

private final String tableName

The unquoted table name.

alias

private final String alias

The alias to use in queries for this table.

Constructor Detail

RealTable

RealTable(String tableName,
          String alias)

Creates a new table.

Parameters:

tableName - The name of the table

alias - The alias of the table used in queries

Method Detail

getTableName

public String getTableName()

Get the unquoted table name of this table in the database.

getQualifiedTableName

public String getQualifiedTableName()

Get the quoted table name of this table in the database.

getAlias

public String getAlias()

Get the alias of this table. Used in queries: SELECT ... FROM table AS alias ...

getAlias

public String getAlias(BasicItem item)

Get the alias of this table, using the ID of the item to make it unique. Used in queries: SELECT ... FROM table AS alias ...

getAlias

public String getAlias(int id)

Get the alias of this table, using the ID of the item to make it unique. Used in queries: SELECT ... FROM table AS alias ...

Since:

2.8