ambit2.db.search.structure

Class MissingInChIsQuery

java.lang.Object

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

ambit2.db.search.structure.AbstractStructureQuery<String,String,net.idea.modbcum.q.conditions.EQCondition>

ambit2.db.search.structure.MissingInChIsQuery

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IParameterizedQuery<String,String,net.idea.modbcum.q.conditions.EQCondition>, 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 MissingInChIsQuery
extends AbstractStructureQuery<String,String,net.idea.modbcum.q.conditions.EQCondition>

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
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
MissingInChIsQuery()
MissingInChIsQuery(String label) TODO identify potential errors update chemicals,(SELECT inchi,count(*) c FROM chemicals where inchi is not null group by inchi ) a set label='ERROR' where chemicals.inchi=a.inchi and a.c>1; update chemicals set label="ERROR" where inchi is null;

Method Summary

Modifier and Type	Method and Description
List<net.idea.modbcum.i.query.QueryParam>	getParameters()
String	getSQL()
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, 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

public static final String sql

See Also:

Constant Field Values

Constructor Detail

MissingInChIsQuery

public MissingInChIsQuery(String label)

TODO identify potential errors update chemicals,(SELECT inchi,count(*) c FROM chemicals where inchi is not null group by inchi ) a set label='ERROR' where chemicals.inchi=a.inchi and a.c>1; update chemicals set label="ERROR" where inchi is null;

MissingInChIsQuery

public MissingInChIsQuery()

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<String,String,net.idea.modbcum.q.conditions.EQCondition,IStructureRecord>