Package net.sf.basedb.core.query
Class Dynamic
java.lang.Object
net.sf.basedb.core.query.Dynamic
public class Dynamic extends Object
A factory class to create expressions, joins, etc. that are only used
by queries in the dynamic database. The elements will throw an
UnsupportedOperationException
if passed to
a HQL query.- Version:
- 2.0
- Author:
- Nicklas
- Last modified
- $Date: 2016-05-04 10:48:42 +0200 (on, 04 maj 2016) $
-
Constructor Summary
Constructors Constructor Description Dynamic()
-
Method Summary
Modifier and Type Method Description static Expression
column(VirtualColumn column)
Create an expression representing a column in the root table: expression = rootAlias.columnName.static Expression
column(VirtualTable table, VirtualColumn column)
Create an expression representing a column in a table: expression = tableAlias.columnName.static Expression
extraValue(ExtraValue extraValue)
Create an expression representing the extra value of a spot or position.static Restriction
isNotPartOf(ReporterList reporterList)
static Restriction
isPartOf(ReporterList reporterList)
static Expression
meanRawData(String property)
Create an expression representing the mean value of a property of a raw data spot. expression = mean(rawdata.property).static Expression
rawBioAssay(String property)
Create an expression representing a property of a raw bioassay.static Expression
rawData(String property)
Create an expression representing a property of a raw data spot.static Expression
reporter(String property)
Create an expression representing a property of a reporter.static Expression
reporter(String property, Boolean useCloned)
Create an expression representing a property of a reporter.static Expression
score(ReporterList reporterList)
static Select
select(ExtraValue extraValue, String alias)
Select an extra value.static Select
select(VirtualColumn column)
Select a column in the root table.static Select
select(VirtualTable table, VirtualColumn column)
Select a column in a joined or the root table.static Select
selectRawBioAssay(String property)
Select a column in the rawbioassay table.static Select
selectRawData(String property)
Select a column in the raw data table.static Select
selectReporter(String property)
Select a column in the reporters table.static Select
selectReporter(String property, Boolean useCloned)
Select a column in the reporters table.
-
Constructor Details
-
Dynamic
public Dynamic()
-
-
Method Details
-
select
Select a column in the root table.- Parameters:
column
- The column to select- Returns:
- The new selection element
- Throws:
InvalidDataException
- If the column is null- See Also:
select(VirtualTable, VirtualColumn)
-
select
Select a column in a joined or the root table.- Parameters:
table
- The joined table where the column is located, or null to use the root tablecolumn
- The column to select- Returns:
- The new selection element
- Throws:
InvalidDataException
- If the column is null
-
selectReporter
Select a column in the reporters table. The expression uses cloned reporter information if available in the current experiment.- Parameters:
property
- The name of the property- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicSpotQuery.joinReporters(JoinType)
-
selectRawBioAssay
Select a column in the rawbioassay table.- Parameters:
property
- The name of the property- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicRawDataQuery.joinReporters(JoinType)
-
selectReporter
public static Select selectReporter(String property, Boolean useCloned) throws InvalidDataExceptionSelect a column in the reporters table. The expression can be forced to use cloned or master reporter information.- Parameters:
property
- The name of the propertyuseCloned
- TRUE to use cloned reporter information (if available), FALSE to not use cloned information, null to automatically decide- Throws:
InvalidDataException
- If the property is null- Since:
- 3.1
- See Also:
DynamicSpotQuery.joinReporters(JoinType, boolean)
,DynamicQuery.setUseClonedReporters(boolean)
-
selectRawData
Select a column in the raw data table. It is expected that raw data has been joined to the query.- Parameters:
property
- The name of the property- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicSpotQuery.joinRawData(JoinType)
-
select
Select an extra value. It is expected that the extra value has been joined to the query.- Parameters:
extraValue
- The extra value to selectalias
- The alias of the extra value- Throws:
InvalidDataException
- If the extraValue or alias is null- See Also:
DynamicSpotQuery.joinExtraValue(ExtraValue, JoinType)
-
column
Create an expression representing a column in the root table: expression = rootAlias.columnName.- Parameters:
column
- The column- Returns:
- The new expression
- Throws:
InvalidDataException
- If the column is null- See Also:
column(VirtualTable, VirtualColumn)
-
column
public static Expression column(VirtualTable table, VirtualColumn column) throws InvalidDataExceptionCreate an expression representing a column in a table: expression = tableAlias.columnName. It is expected that the specified table is the root table or is already joined by the query.- Parameters:
table
- The table the column is located in or null if the column is located in the root tablecolumn
- The column- Returns:
- The new expression
- Throws:
InvalidDataException
- If the column is null
-
reporter
Create an expression representing a property of a reporter. expression = reporter.property. The expression uses cloned reporter information if available in the current experiment.- Parameters:
property
- The name of the property- Returns:
- The new expression
- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicSpotQuery.joinReporters(JoinType, boolean)
,DynamicQuery.setUseClonedReporters(boolean)
-
reporter
Create an expression representing a property of a reporter. expression = reporter.property. The expression can be forced to use cloned or master reporter information.- Parameters:
property
- The name of the propertyuseCloned
- TRUE to use cloned reporter information (if available), FALSE to not use cloned information, null to automatically decide- Returns:
- The new expression
- Throws:
InvalidDataException
- If the property is null- Since:
- 3.1
- See Also:
DynamicSpotQuery.joinReporters(JoinType, boolean)
,DynamicQuery.setUseClonedReporters(boolean)
-
rawBioAssay
Create an expression representing a property of a raw bioassay. expression = rawbioassay.property.- Parameters:
property
- The name of the property- Returns:
- The new expression
- Throws:
InvalidDataException
- If the property is null- Since:
- 3.9
- See Also:
DynamicRawDataQuery.joinRawBioAssay(JoinType)
-
rawData
Create an expression representing a property of a raw data spot. expression = rawdata.property. It is expected that the raw data table is already joined by the query.- Parameters:
property
- The name of the property- Returns:
- The new expression
- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicSpotQuery.joinRawData(JoinType)
-
meanRawData
Create an expression representing the mean value of a property of a raw data spot. expression = mean(rawdata.property). It is expected that the raw data table is already joined by the query.- Parameters:
property
- The name of the property- Returns:
- The new expression
- Throws:
InvalidDataException
- If the property is null- See Also:
DynamicSpotQuery.joinRawData(JoinType)
-
extraValue
Create an expression representing the extra value of a spot or position. It is expected that the extra value is already joined by the query.- Parameters:
extraValue
- The extra value- Returns:
- The new expression
- Throws:
InvalidDataException
- If the extra value is null- See Also:
DynamicSpotQuery.joinExtraValue(ExtraValue, JoinType)
-
isPartOf
-
isNotPartOf
-
score
-