ambit2.db.substance.study

Class SubstanceStudyFlatQuery

java.lang.Object

net.idea.modbcum.q.query.AbstractQuery<net.idea.modbcum.i.bucket.Bucket,V,net.idea.modbcum.q.conditions.EQCondition,net.idea.modbcum.i.bucket.Bucket>

net.idea.modbcum.q.query.BucketQuery<V>

net.idea.modbcum.q.query.SQLFileQuery<com.fasterxml.jackson.databind.node.ObjectNode>

ambit2.db.search.SQLFileQueryParams

ambit2.db.substance.study.SubstanceStudyFlatQuery

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IJSONQueryParams, net.idea.modbcum.i.IParameterizedQuery<net.idea.modbcum.i.bucket.Bucket,com.fasterxml.jackson.databind.node.ObjectNode,net.idea.modbcum.q.conditions.EQCondition>, net.idea.modbcum.i.IQueryObject<net.idea.modbcum.i.bucket.Bucket>, net.idea.modbcum.i.IQueryRetrieval<net.idea.modbcum.i.bucket.Bucket>, net.idea.modbcum.i.IRetrieval<net.idea.modbcum.i.bucket.Bucket>, net.idea.modbcum.i.IStatement

public class SubstanceStudyFlatQuery
extends SQLFileQueryParams

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SubstanceStudyFlatQuery._QUERY_TYPE

Nested classes/interfaces inherited from class ambit2.db.search.SQLFileQueryParams

SQLFileQueryParams._fields

Field Summary

Fields

Modifier and Type	Field and Description
protected com.fasterxml.jackson.databind.ObjectMapper	dx

Fields inherited from class ambit2.db.search.SQLFileQueryParams

jsonParams, psql, queryParams

Fields inherited from class net.idea.modbcum.q.query.SQLFileQuery

sql

Fields inherited from class net.idea.modbcum.q.query.BucketQuery

bucket

Fields inherited from class net.idea.modbcum.q.query.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
SubstanceStudyFlatQuery()
SubstanceStudyFlatQuery(Protocol papp)
SubstanceStudyFlatQuery(ProtocolApplication papp)
SubstanceStudyFlatQuery(ProtocolApplication papp, SubstanceStudyFlatQuery._QUERY_TYPE qtype)
SubstanceStudyFlatQuery(Protocol papp, int[] idchemicals)
SubstanceStudyFlatQuery(Protocol papp, String[] search_query)
SubstanceStudyFlatQuery(String sqlResource, com.fasterxml.jackson.databind.node.ObjectNode params)
SubstanceStudyFlatQuery(String sqlResource, String json)
SubstanceStudyFlatQuery(SubstanceRecord record)
SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE queryType)
SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE querytype, Protocol papp, String[] search_query)
SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE queryType, String... params)

Method Summary

Modifier and Type	Method and Description
net.idea.modbcum.i.bucket.Bucket	getObject(ResultSet rs)
com.fasterxml.jackson.databind.JsonNode	json2params(String json) { "params": { ":id": { "mandatory": false, "type": "Integer", "value": 123 } } }
protected void	setHeader(ResultSet rs, net.idea.modbcum.i.bucket.Bucket bucket)

Methods inherited from class ambit2.db.search.SQLFileQueryParams

getJsonParams, getParameters, getSQL, loadSQL, parseParams, setValue

Methods inherited from class net.idea.modbcum.q.query.SQLFileQuery

loadSQL, loadSQL

Methods inherited from class net.idea.modbcum.q.query.BucketQuery

calculateMetric, isPrescreen

Methods inherited from class net.idea.modbcum.q.query.AbstractQuery

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

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

dx

protected com.fasterxml.jackson.databind.ObjectMapper dx

Constructor Detail

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(SubstanceRecord record)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(Protocol papp)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(Protocol papp,
                               String[] search_query)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE querytype,
                               Protocol papp,
                               String[] search_query)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(Protocol papp,
                               int[] idchemicals)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(ProtocolApplication papp)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(ProtocolApplication papp,
                               SubstanceStudyFlatQuery._QUERY_TYPE qtype)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery()
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE queryType,
                               String... params)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(SubstanceStudyFlatQuery._QUERY_TYPE queryType)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(String sqlResource,
                               String json)
                        throws IOException

Throws:

IOException

SubstanceStudyFlatQuery

public SubstanceStudyFlatQuery(String sqlResource,
                               com.fasterxml.jackson.databind.node.ObjectNode params)
                        throws IOException

Throws:

IOException

Method Detail

json2params

public com.fasterxml.jackson.databind.JsonNode json2params(String json)
                                                    throws com.fasterxml.jackson.core.JsonProcessingException,
                                                           IOException

 {
        "params": {
                ":id": {
                        "mandatory": false,
                        "type": "Integer",
                        "value": 123
                }
        }
 }
 

Parameters:

json -

Returns:

Throws:

com.fasterxml.jackson.core.JsonProcessingException

IOException

getObject

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

Specified by:

getObject in interface net.idea.modbcum.i.IRetrieval<net.idea.modbcum.i.bucket.Bucket>

Overrides:

getObject in class net.idea.modbcum.q.query.SQLFileQuery<com.fasterxml.jackson.databind.node.ObjectNode>

Throws:

net.idea.modbcum.i.exceptions.AmbitException

setHeader

protected void setHeader(ResultSet rs,
                         net.idea.modbcum.i.bucket.Bucket bucket)
                  throws SQLException

Overrides:

setHeader in class net.idea.modbcum.q.query.SQLFileQuery<com.fasterxml.jackson.databind.node.ObjectNode>

Throws:

SQLException