Class DAOAgendaAffinityAccountingsExtractor
java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.ai.bl.agendaaffinity.data.DAOAgendaAffinityAccountingsExtractor
- All Implemented Interfaces:
Serializable,DataAttributesHolder,EDMConfigurableBean,overit.geocall.marks.FieldExposer,overit.geocall.marks.NameExposer,DBFieldMapper,DBObjectMapper,Tool
Search operations affinity for Agenda Affinity algorithm.
- Since:
- 9.3
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class overit.geocall.da.DAO
DAO.Branch, DAO.Code, DAO.Distinct, DAO.Encrypt, DAO.Factory, DAO.Group, DAO.Level, DAO.Order, DAO.Pk, DAO.Pool, DAO.Sequence, DAO.Service, DAO.Star, DAO.Table, DAO.Transaction -
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final Stringstatic final Stringprotected Stringstatic final Commandstatic final CommandFields inherited from class overit.geocall.da.DAO
_dbfm, _dbom, DELETE_FILTER, DELETE_PK, INSATE, INSERT, INSERT_ATTEMPT, SELECT_FILTER, SELECT_NONE, SELECT_PK, UPDATE_FILTER, UPDATE_PK, UPSERT, V_LEVEL_ENABLED -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected voiddefineParams(CommandContext cc, PoolKit pk) The method performs a cloning of the maps of the filters and of the values and makes a merge, putting before the filter field names the string F: and before the value field names the string V: to avoid possible conflicts; this is necessary because the same field can be used with different semantics, as a filter and as a value, for example for theDAO.UPDATE_FILTERcommandsprotected CriteriaMethod to extend to go to introduce the inferential rules with which to deduce the SQL automatically based on the context passed as a parameter.String[]Returns the array that contains the names of the columns on which we want to make the sorting of the results of the queries.String[]Returns the array that contains the field list for all the select queries.Returns the name of the table on which the specific DAO actsprotected StringtruncField(String field) protected voidvalidate(CommandContext cc, PoolKit pk) Method to extend if you want to implement some logic of data validation; it can raise a DAException, or better, a DAValidateException.Methods inherited from class overit.geocall.da.DAO
command, command, commandForName, defineSql, defineStatement, defineValues, execute, execute, execute, execute, feedback, getBranch, getCode, getDataAttributes, getDBFieldMap, getDBObjectMap, getEncrypt, getFactory, getGroup, getLevel, getPk, getPool, getSequence, getTeacher, getTransaction, getValuesCriterion, hasNotBeenDecorated, haveDBFieldMap, haveDBObjectMap, isDistinct, isEncrypted, isService, markAsDecorated, query, query, scan, setDataAttributes, setDBFieldMap, setDBObjectMapMethods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface overit.geocall.edm.model.DataAttributesHolder
getEntitiesMethods inherited from interface overit.geocall.edm.model.EDMConfigurableBean
getEntity, hasEntity
-
Field Details
-
SELECT_ORDERS
-
SELECT_ACCOUNTINGS
-
RANGE_FROM
- See Also:
-
RANGE_TO
- See Also:
-
referenceDate
-
-
Constructor Details
-
DAOAgendaAffinityAccountingsExtractor
public DAOAgendaAffinityAccountingsExtractor()
-
-
Method Details
-
validate
Description copied from class:DAOMethod to extend if you want to implement some logic of data validation; it can raise a DAException, or better, a DAValidateException. By default the method verifies that, if the command requested is a command that refers to a key field, that key field has been defined for the DAO and that the key field is among those passed as filter.- Overrides:
validatein classDAO- Parameters:
cc- TheCommandContextassociated to the DAOpk- ThePoolKitfrom which extract the connections- Throws:
DAException- If there is a (blocking) data-access error, a DAException must be thrownDAValidateException- If there are error in the validation phase, a DAValidateException must be thrown
-
defineParams
Description copied from class:DAOThe method performs a cloning of the maps of the filters and of the values and makes a merge, putting before the filter field names the string F: and before the value field names the string V: to avoid possible conflicts; this is necessary because the same field can be used with different semantics, as a filter and as a value, for example for theDAO.UPDATE_FILTERcommands- Overrides:
defineParamsin classDAO- Parameters:
cc- TheCommandContextassociated to the DAOpk- ThePoolKitfrom which extract the connections- Throws:
DAException- If there is a (blocking) data-access error, a DAException must be thrownDAValidateException- If there are error in the validation phase, a DAValidateException must be thrown
-
getStar
Description copied from class:DAOReturns the array that contains the field list for all the select queries.- Overrides:
getStarin classDAO- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The array of strings that represents the names of the columns to be extracted;
the default value is the array consisting of a single element, the character
*
-
getTable
Description copied from class:DAOReturns the name of the table on which the specific DAO acts- Overrides:
getTablein classDAO- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The string that represents the name of the table on which the DAO want to access and operate
-
getOrder
Description copied from class:DAOReturns the array that contains the names of the columns on which we want to make the sorting of the results of the queries.
The method checks for the presence of a sort string in theCommandContext, the one returned by theCommandContext.getOrder()method; the default implementation interprets the string as a comma-separated list of field names on which you want to sort query results. The presence of the exclamation point in front of a field name defines the will to order in a descending direction with respect to that field.
The extensions of this method can define their own grammar for the received string.
If there is no sort string in the CommandContext, the fields are searched using the annotation Group -
truncField
-
getFilterCriterion
Description copied from class:DAOMethod to extend to go to introduce the inferential rules with which to deduce the SQL automatically based on the context passed as a parameter.- Overrides:
getFilterCriterionin classDAO- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The
Criterionused to create the SQL By default the method returns theCriteria.SEARCH_STRONGfor the commands that refers to key fields and theCriteria.SEARCHfor all the other commands.
-