ambit2.db.update.qlabel

Class CreateQLabelPair

java.lang.Object

net.idea.modbcum.q.update.AbstractUpdate<AmbitUser,String>

ambit2.db.update.qlabel.CreateQLabelPair

All Implemented Interfaces:

net.idea.modbcum.i.IStatement, net.idea.modbcum.i.query.IQueryUpdate<AmbitUser,String>

public class CreateQLabelPair
extends net.idea.modbcum.q.update.AbstractUpdate<AmbitUser,String>

Find minority per source SELECT idchemical,idstructure,if(q.label!="Majority","",if(num_sources=(rel+1),"Majority","Minority")), rel,num_sources,label,q.text,p.text FROM quality_chemicals q join quality_pair p using(idchemical) order by idchemical

Author:

nina

Field Summary

Fields

Modifier and Type	Field and Description
protected static String[]	sql

Fields inherited from class net.idea.modbcum.q.update.AbstractUpdate

group, logger, object

Constructor Summary

Constructors

Constructor and Description
CreateQLabelPair()

Method Summary

Modifier and Type	Method and Description
List<net.idea.modbcum.i.query.QueryParam>	getParameters(int index)
String[]	getSQL()
void	setID(int index, int id)

Methods inherited from class net.idea.modbcum.q.update.AbstractUpdate

getGroup, getObject, isStoredProcedure, returnKeys, setGroup, setObject, truncate

Methods inherited from class java.lang.Object

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

Field Detail

sql

protected static String[] sql

Constructor Detail

CreateQLabelPair

public CreateQLabelPair()

Method Detail

getParameters

public List<net.idea.modbcum.i.query.QueryParam> getParameters(int index)
                                                        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

setID

public void setID(int index,
                  int id)