ambit2.db.chart

Class XTabChartGenerator

java.lang.Object

net.idea.modbcum.p.DefaultAmbitProcessor<Target,Result>

net.idea.modbcum.p.AbstractDBProcessor<T,BufferedImage>

ambit2.db.chart.ChartGenerator<ISourceDataset>

ambit2.db.chart.XTabChartGenerator

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IDBProcessor<ISourceDataset,BufferedImage>, net.idea.modbcum.i.processors.IProcessor<ISourceDataset,BufferedImage>

public class XTabChartGenerator
extends ChartGenerator<ISourceDataset>

select group_concat(distinct b),a-mod(a,10), count(*)
from (

                select a,b from
                (
                select value_num as a,idchemical from query_results
                join property_values using(idstructure) join properties using(idproperty)
                where name = "LLNA EC3 %" and idquery=2
                group by idchemical,value_num
                ) as X
                join
                (
                select value as b,idchemical from query_results
                join property_values using(idstructure) join property_string using(idvalue_string) join properties using(idproperty)
                where name = "Michael Acceptors" and idquery=2
                group by idchemical,value_num
                ) as Y
                using(idchemical)

) as p
group by b,a-mod(a,10)

select concat( 'select a-mod(a,10)','\n' , group_concat(distinct concat( ', sum(','\n' , ' if(b=\"',value,'\"\n' , ' , 1','\n' , ' , null','\n' , ' )\n' , ' )' , ' "',value,'"\n' ) order by value separator '' ) ,',sum(if(b is null, 1, null)) NA ' ,'from (','\n' ,' select a,b from','\n' ,' (','\n' ,' select value_num as a,idchemical from query_results','\n' ,' join property_values using(idstructure) join properties using(idproperty)','\n' ,' where name = "LLNA EC3 %" and idquery=2','\n' ,' group by idchemical,value_num','\n' ,' ) as X','\n' ,' left join','\n' ,' (','\n' ,' select value as b,idchemical from query_results','\n' ,' join property_values using(idstructure) join property_string using(idvalue_string) join properties using(idproperty)','\n' ,' where name = "toxTree.tree.cramer.CramerRules" and idquery=2','\n' ,' group by idchemical,value_num','\n' ,' ) as Y','\n' ,' using(idchemical)','\n' ,') as p','\n' ,'group by a-mod(a,10)','\n' ) statement from query_results join property_values using(idstructure) left join property_string using(idvalue_string) join properties using(idproperty) where name = "toxTree.tree.cramer.CramerRules" and idquery=2

Author:

nina

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected double	binWidth
protected Property	propertyX
protected Property	propertyY
protected static String	sql

Fields inherited from class ambit2.db.chart.ChartGenerator

height, legend, logX, logY, param, thumbnail, width

Fields inherited from class net.idea.modbcum.p.AbstractDBProcessor

closeConnection, connection

Fields inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

enabled, logger, propertyChangeSupport

Constructor Summary

Constructors

Constructor and Description
XTabChartGenerator()

Method Summary

Modifier and Type	Method and Description
double	getBinWidth()
Property	getPropertyX()
Property	getPropertyY()
void	open()
BufferedImage	process(ISourceDataset target)
void	setBinWidth(double binWidth)
void	setPropertyX(Property propertyX)
void	setPropertyY(Property propertyY)

Methods inherited from class ambit2.db.chart.ChartGenerator

getHeight, getParam, getWidth, hasLegend, isLogX, isLogY, isThumbnail, setHeight, setLegend, setLogX, setLogY, setParam, setThumbnail, setWidth

Methods inherited from class net.idea.modbcum.p.AbstractDBProcessor

close, getConnection, isCloseConnection, isEnabled, setCloseConnection, setConnection

Methods inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

addPropertyChangeListener, addPropertyChangeListener, getID, removePropertyChangeListener, removePropertyChangeListener, setEnabled, 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.processors.IProcessor

getID, setEnabled

Field Detail

propertyX

protected Property propertyX

propertyY

protected Property propertyY

binWidth

protected double binWidth

sql

protected static final String sql

See Also:

Constant Field Values

Constructor Detail

XTabChartGenerator

public XTabChartGenerator()

Method Detail

getPropertyX

public Property getPropertyX()

setPropertyX

public void setPropertyX(Property propertyX)

getPropertyY

public Property getPropertyY()

setPropertyY

public void setPropertyY(Property propertyY)

getBinWidth

public double getBinWidth()

setBinWidth

public void setBinWidth(double binWidth)

process

public BufferedImage process(ISourceDataset target)
                      throws net.idea.modbcum.i.exceptions.AmbitException

Throws:

net.idea.modbcum.i.exceptions.AmbitException

open

public void open()
          throws net.idea.modbcum.i.exceptions.DbAmbitException

Specified by:

open in interface net.idea.modbcum.i.processors.IProcessor<ISourceDataset,BufferedImage>

Overrides:

open in class net.idea.modbcum.p.DefaultAmbitProcessor<ISourceDataset,BufferedImage>

Throws:

net.idea.modbcum.i.exceptions.DbAmbitException