ambit2.db.search.structure

Class FreeTextQuery

java.lang.Object

ambit2.db.search.AbstractQuery<F,T,C,IStructureRecord>

ambit2.db.search.structure.AbstractStructureQuery<String[],String[],net.idea.modbcum.q.conditions.StringCondition>

ambit2.db.search.structure.FreeTextQuery

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IParameterizedQuery<String[],String[],net.idea.modbcum.q.conditions.StringCondition>, net.idea.modbcum.i.IQueryObject<IStructureRecord>, net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>, net.idea.modbcum.i.IRetrieval<IStructureRecord>, net.idea.modbcum.i.IStatement

public class FreeTextQuery
extends AbstractStructureQuery<String[],String[],net.idea.modbcum.q.conditions.StringCondition>

select idchemical,metric from
(
(select idchemical,2 as metric  from properties join property_values using(idproperty)
join property_string using(idvalue_string)  join structure using(idstructure)
    where name like "MA%" and value like "Reaction%"
)
union
(select idchemical,2 as metric  from properties join property_values using(idproperty)
join property_string using(idvalue_string)  join structure using(idstructure)
    where value like "MA%" and name like "Reaction%"
)
union
(select idchemical,1 as metric from properties
join property_values using(idproperty) join structure using(idstructure) where name like "MA%")
union
(select idchemical,1 as metric  from property_values
join property_string using(idvalue_string) join structure using(idstructure) where value like "MA%")
union
(select idchemical,1 as metric  from properties
join property_values using(idproperty)  join structure using(idstructure)  where name like "Reaction%")
union
(select idchemical,1 as metric  from property_values
join property_string using(idvalue_string)  join structure using(idstructure)  where value like "Reaction%")
) a

Author:

nina

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class ambit2.db.search.structure.AbstractStructureQuery

AbstractStructureQuery.FIELD_NAMES

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	pairSQL
protected static String	singleSQLName
protected static String	singleSQLValue
protected static String	sql

Fields inherited from class ambit2.db.search.structure.AbstractStructureQuery

chemicalsOnly, group, nanomaterial, order_descendant, where_group

Fields inherited from class ambit2.db.search.AbstractQuery

condition, fieldname, id, logger, maxRecords, name, page, selected, value

Fields inherited from interface net.idea.modbcum.i.IQueryRetrieval

NaN

Constructor Summary

Constructors

Constructor and Description
FreeTextQuery()

Method Summary

Modifier and Type	Method and Description
IStructureRecord	getObject(ResultSet rs)
List<net.idea.modbcum.i.query.QueryParam>	getParameters()
String	getSQL()
String	toString()

Methods inherited from class ambit2.db.search.structure.AbstractStructureQuery

calculateMetric, isChemicalsOnly, isNanomaterial, isOrder_descendant, isPreferredStructure, isPrescreen, retrieveMetric, retrieveStrucType, retrieveValue, setChemicalsOnly, setNanomaterial, setOrder_descendant

Methods inherited from class ambit2.db.search.AbstractQuery

getCategory, getCondition, getFieldname, getId, getKey, getName, getPage, getPageSize, getValue, isSelected, setCondition, setFieldname, setId, setName, setPage, setPageSize, setSelected, setValue, stringify, supportsPaging, test

Methods inherited from class java.lang.Object

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

Methods inherited from interface net.idea.modbcum.i.IQueryObject

getCategory, getId, getKey, getPage, getPageSize, setId, setPage, setPageSize, supportsPaging

Field Detail

sql

protected static final String sql

See Also:

Constant Field Values

pairSQL

protected static final String pairSQL

See Also:

Constant Field Values

singleSQLName

protected static final String singleSQLName

See Also:

Constant Field Values

singleSQLValue

protected static final String singleSQLValue

See Also:

Constant Field Values

Constructor Detail

FreeTextQuery

public FreeTextQuery()

Method Detail

getParameters

public List<net.idea.modbcum.i.query.QueryParam> getParameters()
                                                        throws net.idea.modbcum.i.exceptions.AmbitException

Throws:

net.idea.modbcum.i.exceptions.AmbitException

getSQL

public String getSQL()
              throws net.idea.modbcum.i.exceptions.AmbitException

Throws:

net.idea.modbcum.i.exceptions.AmbitException

getObject

public IStructureRecord getObject(ResultSet rs)
                           throws net.idea.modbcum.i.exceptions.AmbitException

Specified by:

getObject in interface net.idea.modbcum.i.IRetrieval<IStructureRecord>

Overrides:

getObject in class AbstractStructureQuery<String[],String[],net.idea.modbcum.q.conditions.StringCondition>

Throws:

net.idea.modbcum.i.exceptions.AmbitException

toString

public String toString()

Overrides:

toString in class AbstractQuery<String[],String[],net.idea.modbcum.q.conditions.StringCondition,IStructureRecord>