|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.wm.app.tn.db.Query
com.wm.app.tn.db.TPAQuery
public class TPAQuery
Simple queries on TPA in the datastore. This class provides matching on the fields of a TPA (senderID, receiverID, agreementID, etc.), and control over the results that are returned. tpaData will never be queried. In general, setters will removed the associated criterion if handed a null value. For instance, setSender(null) will remove any sender criteria.
Field Summary | |
---|---|
static int |
AGREEMENT_ID_IDX
|
static java.lang.String |
AGREEMENTID
|
static java.lang.String |
CREATED
|
static int |
CREATED_IDX
|
static int |
DATA_SCHEMA_IDX
|
static java.lang.String |
DATASCHEMA
|
static java.lang.String |
DESCRIPTION
|
static int |
DESCRIPTION_IDX
|
static int |
EXPORT_SERVICE_IDX
|
static java.lang.String |
EXPORTSERVICE
|
static int |
INIT_SERVICE_IDX
|
static java.lang.String |
INITSERVICE
|
static java.lang.String[] |
KEYS
|
static java.lang.String |
LASTMODIFIED
|
static int |
LASTMODIFIED_IDX
|
static int |
RECEIVER_ID_IDX
|
static java.lang.String |
RECEIVERID
|
static java.lang.String |
RECEIVERNAME
|
static java.lang.String |
RECEIVERUNITNAME
|
static int |
SENDER_ID_IDX
|
static java.lang.String |
SENDERID
|
static java.lang.String |
SENDERNAME
|
static java.lang.String |
SENDERUNITNAME
|
static java.lang.String |
STATUS
|
static int |
STATUS_IDX
|
static int |
TPA_ID_IDX
|
static java.lang.String |
TPAID
|
Constructor Summary | |
---|---|
TPAQuery()
|
Method Summary | |
---|---|
void |
clearSortColumns()
Clear sort order |
static com.wm.data.IData |
create()
For internal use only |
java.lang.String |
getAgreementID()
|
com.wm.data.IDataCursor |
getCursor()
For internal use only |
java.lang.String |
getDataSchema()
|
java.lang.String |
getDescription()
|
java.lang.String |
getExportService()
|
com.wm.data.IDataHashCursor |
getHashCursor()
For internal use only |
com.wm.data.IDataIndexCursor |
getIndexCursor()
For internal use only |
java.lang.String |
getInitService()
|
java.lang.String[] |
getReceiverID()
|
java.lang.String[] |
getReceiverName()
|
java.lang.String[] |
getSenderID()
|
java.lang.String[] |
getSenderName()
|
com.wm.data.IDataSharedCursor |
getSharedCursor()
For internal use only |
java.lang.String |
getSortColumn()
|
java.lang.String[][] |
getSortColumns()
returns sort columns (may be null) |
java.lang.String |
getStatus()
|
java.sql.Timestamp[] |
getTimeInterval()
|
int |
getTimeIntervalType()
|
java.lang.String |
getTpaID()
|
com.wm.data.IDataTreeCursor |
getTreeCursor()
For internal use only |
java.lang.String[] |
getVisibleColumns()
For internal use only |
boolean |
isAgreementIDVisible()
|
boolean |
isDataschemaVisible()
|
boolean |
isDescriptionVisible()
|
boolean |
isLastModifiedVisible()
|
boolean |
isReceiverIDVisible()
|
boolean |
isReceiverNameVisible()
|
boolean |
isReceiverUnitNameVisible()
|
boolean |
isSenderIDVisible()
|
boolean |
isSenderNameVisible()
|
boolean |
isSenderUnitNameVisible()
|
boolean |
isSortAscending()
|
boolean |
isStatusVisible()
|
boolean |
isTPAIDVisible()
|
void |
preSql()
For internal use only |
void |
setAgreementID(java.lang.String agreementID)
Search for TPAs of a particular agrrementID |
void |
setAgreementID(java.lang.String[] agreementID)
Search for TPAs with a group of types |
void |
setAgreementID(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Agreement ID. |
void |
setAgreementIDVisible(boolean b)
|
void |
setDataSchema(java.lang.String dataSchema)
Search for TPAs in a particular dataSchema |
void |
setDataSchema(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Data Schema. |
void |
setDataschemaVisible(boolean b)
|
void |
setDaysAgo(int ago)
Query by TPA timestamp, based on "number of days ago". |
void |
setDescription(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Description. |
void |
setDescriptionVisible(boolean b)
|
void |
setExportService(java.lang.String exportService)
Search for TPAs with a particular exportService |
void |
setInitService(java.lang.String initService)
Search for TPAs with a particular initService |
void |
setLastModifiedVisible(boolean b)
|
void |
setReceiverID(java.lang.String id)
Search for TPAs for a single receiver |
void |
setReceiverID(java.lang.String[] id)
Search for TPAs for a group of receivers |
void |
setReceiverID(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Receiver ID. |
void |
setReceiverIDVisible(boolean b)
|
void |
setReceiverName(java.lang.String name)
Search for TPAs from a single Receiver name. |
void |
setReceiverName(java.lang.String[] name)
Search for TPAs from a group of Receivers |
void |
setReceiverName(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Receiver NAME. |
void |
setReceiverNameVisible(boolean b)
|
void |
setReceiverUnitNameVisible(boolean b)
|
void |
setSenderID(java.lang.String id)
Search for TPAs from a single sender. |
void |
setSenderID(java.lang.String[] id)
Search for TPAs from a group of senders |
void |
setSenderID(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Sender ID. |
void |
setSenderIDVisible(boolean b)
|
void |
setSenderName(java.lang.String name)
Search for TPAs from a single sender name. |
void |
setSenderName(java.lang.String[] name)
Search for TPAs from a group of senders |
void |
setSenderName(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on Sender NAME. |
void |
setSenderNameVisible(boolean b)
|
void |
setSenderUnitNameVisible(boolean b)
|
void |
setSortColumn(java.lang.String col,
boolean asc)
Set the sort column and order for this query. |
void |
setSortColumns(java.lang.String[][] columnOrder)
Set the sort columns and order for this query. |
void |
setStatus(java.lang.String status)
Search for TPAs in a particular status |
void |
setStatus(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on STATUS. |
void |
setStatusVisible(boolean b)
|
void |
setTimeInterval(int which)
Set the time interval based on simple codes. |
void |
setTimeInterval(java.sql.Timestamp since,
java.sql.Timestamp until)
Set the time interval based on absolute times. |
void |
setTpaID(java.lang.String s)
Search for TPA from internal TPA ID. |
void |
setTpaID(java.lang.String[][] opVal,
boolean isORquery)
Search for TPA using multiple criteria on internal TPA ID. |
void |
setTPAIDVisible(boolean b)
|
java.lang.String |
toSql()
|
java.lang.String |
toSql(boolean agg)
For internal use only |
java.lang.String |
toString()
For internal use only |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String SENDERID
public static final java.lang.String SENDERNAME
public static final java.lang.String SENDERUNITNAME
public static final java.lang.String RECEIVERID
public static final java.lang.String RECEIVERNAME
public static final java.lang.String RECEIVERUNITNAME
public static final java.lang.String AGREEMENTID
public static final java.lang.String CREATED
public static final java.lang.String LASTMODIFIED
public static final java.lang.String STATUS
public static final java.lang.String DATASCHEMA
public static final java.lang.String EXPORTSERVICE
public static final java.lang.String INITSERVICE
public static final java.lang.String DESCRIPTION
public static final java.lang.String TPAID
public static final int SENDER_ID_IDX
public static final int RECEIVER_ID_IDX
public static final int AGREEMENT_ID_IDX
public static final int CREATED_IDX
public static final int STATUS_IDX
public static final int DATA_SCHEMA_IDX
public static final int EXPORT_SERVICE_IDX
public static final int INIT_SERVICE_IDX
public static final int DESCRIPTION_IDX
public static final int TPA_ID_IDX
public static final int LASTMODIFIED_IDX
public static final java.lang.String[] KEYS
Constructor Detail |
---|
public TPAQuery()
Method Detail |
---|
public com.wm.data.IDataCursor getCursor()
getCursor
in interface com.wm.data.IData
public com.wm.data.IDataIndexCursor getIndexCursor()
getIndexCursor
in interface com.wm.data.IData
public com.wm.data.IDataTreeCursor getTreeCursor()
getTreeCursor
in interface com.wm.data.IData
public com.wm.data.IDataHashCursor getHashCursor()
getHashCursor
in interface com.wm.data.IData
public com.wm.data.IDataSharedCursor getSharedCursor()
getSharedCursor
in interface com.wm.data.IData
public java.lang.String toString()
toString
in class java.lang.Object
public void setSenderID(java.lang.String id)
id
- the id of the sender to look forpublic void setSenderID(java.lang.String[] id)
id
- the ids of the senderspublic void setSenderID(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.SenderID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.SenderID <> 'BBB' )public void setSenderName(java.lang.String name)
name
- the name of the sender to look forpublic void setSenderName(java.lang.String[] name)
name
- the name of the senderspublic void setSenderName(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR s.CorporationName <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA'
AND s.CorporationName <> 'BBB' )public void setReceiverID(java.lang.String id)
id
- the id of the receiver to look forpublic void setReceiverID(java.lang.String[] id)
id
- the ids of the receiverspublic void setReceiverID(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.ReceiverID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.ReceiverID <> 'BBB' )public void setReceiverName(java.lang.String name)
name
- the name of the sender to look forpublic void setReceiverName(java.lang.String[] name)
name
- the name of the Receiverspublic void setReceiverName(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR r.CorporationName <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA'
AND r.CorporationName <> 'BBB' )public void setAgreementID(java.lang.String agreementID)
agreementID
- the agreementID to look forpublic void setAgreementID(java.lang.String[] agreementID)
agreementID
- the agreementIDs to look forpublic void setAgreementID(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.AgreementID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.AgreementID <> 'BBB' )public void setDataSchema(java.lang.String dataSchema)
dataSchema
- the data schema to look forpublic void setDataSchema(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.DataSchema <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.DataSchema <> 'BBB' )public void setStatus(java.lang.String status)
status
- the status to look forpublic void setStatus(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.Status <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.Status <> 'BBB' )public void setExportService(java.lang.String exportService)
exportService
- the exportService to look forpublic void setInitService(java.lang.String initService)
initService
- the initService to look forpublic void setDescription(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR TPA.Description <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
TPA.Description <> 'BBB' )public void setTpaID(java.lang.String s)
public void setTpaID(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ,
"BBB"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.TypeID = 'AAA' OR tpa.TPAID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
tpa.TPAID <> 'BBB' )public void setDaysAgo(int ago)
ago
- how many 24-hour days to go back (0 is till midnight last night, 1 is 24 hours ago, 2 is 48 hours ago,
and so on)public void setTimeInterval(int which)
which
- the interval to usepublic void setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until)
setTimeInterval
in class Query
since
- the start of the interval (null means open-ended)until
- the end of the interval (null means open-ended)public java.lang.String[] getSenderID()
public java.lang.String[] getSenderName()
public java.lang.String[] getReceiverID()
public java.lang.String[] getReceiverName()
public java.lang.String getAgreementID()
public java.lang.String getStatus()
public java.lang.String getDataSchema()
public java.lang.String getExportService()
public java.lang.String getInitService()
public java.lang.String getDescription()
public java.lang.String getTpaID()
public java.sql.Timestamp[] getTimeInterval()
public int getTimeIntervalType()
public void setSenderIDVisible(boolean b)
public void setSenderNameVisible(boolean b)
public void setSenderUnitNameVisible(boolean b)
public void setReceiverIDVisible(boolean b)
public void setReceiverNameVisible(boolean b)
public void setReceiverUnitNameVisible(boolean b)
public void setAgreementIDVisible(boolean b)
public void setLastModifiedVisible(boolean b)
public void setStatusVisible(boolean b)
public void setDataschemaVisible(boolean b)
public void setDescriptionVisible(boolean b)
public void setTPAIDVisible(boolean b)
public boolean isSenderIDVisible()
public boolean isSenderNameVisible()
public boolean isSenderUnitNameVisible()
public boolean isReceiverIDVisible()
public boolean isReceiverNameVisible()
public boolean isReceiverUnitNameVisible()
public boolean isAgreementIDVisible()
public boolean isLastModifiedVisible()
public boolean isStatusVisible()
public boolean isDataschemaVisible()
public boolean isDescriptionVisible()
public boolean isTPAIDVisible()
public java.lang.String[] getVisibleColumns()
public void setSortColumns(java.lang.String[][] columnOrder)
setSortColumns
in class Query
columnOrder
- takes column names and sort orders (e.g. {{TIMESTAMP, "ASC"}, {SENDERID, "DESC"}} )public java.lang.String[][] getSortColumns()
public void clearSortColumns()
public void setSortColumn(java.lang.String col, boolean asc)
public java.lang.String getSortColumn()
public boolean isSortAscending()
public java.lang.String toSql()
toSql
in class Query
public java.lang.String toSql(boolean agg)
public void preSql()
preSql
in class Query
public static com.wm.data.IData create()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |