ambit2.db.update.qlabel
Class CreateQLabelPair

java.lang.Object
  ambit2.db.update.AbstractUpdate<ambit2.base.data.AmbitUser,java.lang.String>
      ambit2.db.update.qlabel.CreateQLabelPair

All Implemented Interfaces:

IStatement, IQueryUpdate<ambit2.base.data.AmbitUser,java.lang.String>

public class CreateQLabelPair
extends AbstractUpdate<ambit2.base.data.AmbitUser,java.lang.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

Field Summary

protected static java.lang.String[]

sql

Fields inherited from class ambit2.db.update.AbstractUpdate

group, object

Constructor Summary

CreateQLabelPair()

Method Summary

java.util.List<QueryParam>	getParameters(int index)
java.lang.String[]	getSQL()
void	setID(int index, int id)

Methods inherited from class ambit2.db.update.AbstractUpdate

getGroup, getObject, returnKeys, setGroup, setObject

Methods inherited from class java.lang.Object

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

Field Detail

sql

protected static java.lang.String[] sql

Constructor Detail

CreateQLabelPair

public CreateQLabelPair()

Method Detail

getParameters

public java.util.List<QueryParam> getParameters(int index)
                                         throws ambit2.base.exceptions.AmbitException

Throws:

ambit2.base.exceptions.AmbitException

getSQL

public java.lang.String[] getSQL()
                          throws ambit2.base.exceptions.AmbitException

Throws:

ambit2.base.exceptions.AmbitException

setID

public void setID(int index,
                  int id)