ambit2.db.search.structure

Class QueryMissingProperty

java.lang.Object

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

ambit2.db.search.structure.AbstractStructureQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition>

ambit2.db.search.structure.QueryMissingProperty

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IParameterizedQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition>, 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 QueryMissingProperty
extends AbstractStructureQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition>

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	MISSING_DESCRIPTOR
protected long	pageSize SELECT structure.idchemical,s.idstructure,type_structure,p1.status,p2.status FROM structure join struc_dataset s using(idstructure) left outer join property_values p1 on s.idstructure=p1.idstructure and p1.idproperty =36 and id_srcdataset=1 left outer join property_values p2 on s.idstructure=p2.idstructure and p2.idproperty =37 and id_srcdataset=1 where type_structure != "NA" and p2.id is null and p1.id is null

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
QueryMissingProperty()

Method Summary

Modifier and Type	Method and Description
long	getPageSize()
List<net.idea.modbcum.i.query.QueryParam>	getParameters()
String	getSQL()
void	setPageSize(long records)
String	toString()

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

calculateMetric, getObject, 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, getValue, isSelected, setCondition, setFieldname, setId, setName, setPage, 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, setId, setPage, supportsPaging

Field Detail

MISSING_DESCRIPTOR

protected static String MISSING_DESCRIPTOR

pageSize

protected long pageSize

SELECT structure.idchemical,s.idstructure,type_structure,p1.status,p2.status FROM structure join struc_dataset s using(idstructure) left outer join property_values p1 on s.idstructure=p1.idstructure and p1.idproperty =36 and id_srcdataset=1 left outer join property_values p2 on s.idstructure=p2.idstructure and p2.idproperty =37 and id_srcdataset=1 where type_structure != "NA" and p2.id is null and p1.id is null

Constructor Detail

QueryMissingProperty

public QueryMissingProperty()

Method Detail

getSQL

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

Throws:

net.idea.modbcum.i.exceptions.AmbitException

getParameters

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

Throws:

net.idea.modbcum.i.exceptions.AmbitException

toString

public String toString()

Overrides:

toString in class AbstractQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition,IStructureRecord>

getPageSize

public long getPageSize()

Specified by:

getPageSize in interface net.idea.modbcum.i.IQueryObject<IStructureRecord>

Overrides:

getPageSize in class AbstractQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition,IStructureRecord>

setPageSize

public void setPageSize(long records)

Specified by:

setPageSize in interface net.idea.modbcum.i.IQueryObject<IStructureRecord>

Overrides:

setPageSize in class AbstractQuery<ISourceDataset,Property,net.idea.modbcum.q.conditions.BooleanCondition,IStructureRecord>