Summary: 73 methods with SQL local invocations, 1 methods mixing local and delegated SQL invocations, and 13 methods with only delegated SQL invocations.
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_TEMPLATE_TBL
,
- It deletes rows from table(s) CM_TEMPLATE_MAILING_BIND_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_TEMPLATE_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_TEMPLATE_MAILING_BIND_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_TEXT_VERSION_TBL, CM_TEXT_VERSION_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_TEXT_VERSION_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_TEXT_VERSION_TBL
This method implements the following db-related operations:
- It updates the shortname, description attribute(s) in table CM_TEMPLATE_TBL
Some constraints that should be taken into the account are the following:
- Make sure the values in CM_TEMPLATE_TBL.description are not null
- Make sure the values in CM_TEMPLATE_TBL.shortname are not null
This method implements the following db-related operations:
- It queries the table(s) DYN_TARGET_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_CONTENT_MODULE_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_MAILING_BIND_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_CONTENT_TBL
This method implements the following db-related operations:
- It queries the table(s) CM_MAILING_BIND_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_LOCATION_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_CONTENT_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_TYPE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CM_MEDIA_FILE_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CUST_BAN_TBL
This method implements the following db-related operations:
- It queries the table(s) CUST_BAN_TBL, CUST_BAN_TBL
This method implements the following db-related operations:
- It inserts the company_id, email attributes into table CUST_BAN_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in CUST_BAN_TBL do not overflow the varchar limits: 200 (email)
- Make sure the values in CUST_BAN_TBL.company_id are not null
- Make sure the values in CUST_BAN_TBL.email are not null
- Make sure the values of attribute CUST_BAN_TBL.company_id are unique because there is a UNIQUENESS constraint
- Make sure the values of attribute CUST_BAN_TBL.email are unique because there is a UNIQUENESS constraint
This method implements the following db-related operations:
- It deletes rows from table(s) CAMPAIGN_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_ACCOUNT_TBL, MAILING_ACCOUNT_TBL
This method implements the following db-related operations:
- It updates the company_id, shortname, description attribute(s) in table CAMPAIGN_TBL
- It inserts the company_id, shortname, description attributes into table CAMPAIGN_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in CAMPAIGN_TBL do not overflow the varchar limits: 255 (description, shortname)
- Make sure the values in CAMPAIGN_TBL.company_id are not null
- Make sure the values in CAMPAIGN_TBL.description are not null
- Make sure the values in CAMPAIGN_TBL.shortname are not null
This method implements the following db-related operations:
- It queries the table(s) USERFORM_TBL, RDIR_ACTION_TBL
This method implements the following db-related operations:
- It queries the table(s) IMPORT_GENDER_MAPPING_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) IMPORT_COLUMN_MAPPING_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) IMPORT_GENDER_MAPPING_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) IMPORT_PROFILE_TBL
This method implements the following db-related operations:
- It inserts the SESSION_ID, TEMPORARY_TABLE_NAME attributes into table IMPORT_TMP_TABLES
This method implements the following db-related operations:
- It queries the table(s) TABLENAME
This method implements the following db-related operations:
- It queries the table(s) IMPORT_TMP_TABLES
This method implements the following db-related operations:
- It queries the table(s) CUST_BAN_TBL
This method implements the following db-related operations:
- It drops the TABLE CUST_
This method implements the following db-related operations:
- It deletes rows from table(s) IMPORT_TMP_TABLES
- It drops the TABLE TABLENAME
This method implements the following db-related operations:
- It inserts the ip_address, login_status, username attributes into table LOGIN_TRACK_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in LOGIN_TRACK_TBL do not overflow the varchar limits: 50 (username), 20 (ip_address)
This method implements the following db-related operations:
- It deletes rows from table(s) MAILDROP_STATUS_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) DYN_CONTENT_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL, MAILING_ACCOUNT_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILDROP_STATUS_TBL
This method implements the following db-related operations:
- It queries the table(s) TAG_TBL
This method implements the following db-related operations:
- It queries the table(s) RDIR_URL_TBL
This method implements the following db-related operations:
- It queries the table(s) RDIR_URL_TBL
This method implements the following db-related operations:
- It updates the open_count attribute(s) in table ONEPIXEL_LOG_TBL
- It inserts the company_id, customer_id, mailing_id, open_count, ip_adr, changeDateName attributes into table ONEPIXEL_LOG_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in ONEPIXEL_LOG_TBL do not overflow the varchar limits: 15 (ip_adr)
- Make sure the values in ONEPIXEL_LOG_TBL.company_id are not null
- Make sure the values in ONEPIXEL_LOG_TBL.customer_id are not null
- Make sure the values in ONEPIXEL_LOG_TBL.ip_adr are not null
- Make sure the values in ONEPIXEL_LOG_TBL.mailing_id are not null
- Make sure the values in ONEPIXEL_LOG_TBL.open_count are not null
This method implements the following db-related operations:
- It deletes rows from table(s) CUSTOMER_FIELD_TBL
This method implements the following db-related operations:
- It queries the table(s) CUST_BAN_TBL
This method implements the following db-related operations:
- It drops the TABLE TABNAME
This method implements the following db-related operations:
- It queries the table(s) CUST_BAN_TBL
This method implements the following db-related operations:
- It updates the changeDateName, toLowerCase attribute(s) in table CUSTOMER_CUST.GETCOMPANYID_TBL
This method implements the following db-related operations:
- It queries the table(s) DYN_TARGET_TBL
This method implements the following db-related operations:
- It inserts the customer_id, url_id, company_id, ip_adr, mailing_id attributes into table RDIR_LOG_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in RDIR_LOG_TBL do not overflow the varchar limits: 15 (ip_adr)
- Make sure the values in RDIR_LOG_TBL.company_id are not null
- Make sure the values in RDIR_LOG_TBL.customer_id are not null
- Make sure the values in RDIR_LOG_TBL.ip_adr are not null
- Make sure the values in RDIR_LOG_TBL.mailing_id are not null
- Make sure the values in RDIR_LOG_TBL.url_id are not null
This method implements the following db-related operations:
- It updates the DEEP_TRACKING attribute(s) in table RDIR_URL_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILTRACK_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILDROP_STATUS_TBL
- It deletes rows from table(s) MAILDROP_STATUS_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_ACCOUNT_TBL, MAILING_BACKEND_LOG_TBL, MAILING_ACCOUNT_TBL, MAILING_BACKEND_LOG_TBL, MAILDROP_STATUS_TBL, MAILDROP_STATUS_TBL, MAILDROP_STATUS_TBL
This method implements the following db-related operations:
- It queries the table(s) BOUNCE_TBL
This method implements the following db-related operations:
- It queries the table(s) ONEPIXEL_LOG_TBL
This method implements the following db-related operations:
- It queries the table(s) ONEPIXEL_LOG_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_ACCOUNT_TBL
This method implements the following db-related operations:
- It deletes rows from table(s) CUST_BAN_TBL
- It inserts the company_id, email attributes into table CUST_BAN_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in CUST_BAN_TBL do not overflow the varchar limits: 200 (email)
- Make sure the values in CUST_BAN_TBL.company_id are not null
- Make sure the values in CUST_BAN_TBL.email are not null
- Make sure the values of attribute CUST_BAN_TBL.company_id are unique because there is a UNIQUENESS constraint
- Make sure the values of attribute CUST_BAN_TBL.email are unique because there is a UNIQUENESS constraint
This method implements the following db-related operations:
- It queries the table(s) CUSTOMER_FIELD_TBL
This method implements the following db-related operations:
- It inserts the company_id, admin_id, category, ip_adr, message attributes into table LOG_TBL
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in LOG_TBL do not overflow the varchar limits: 65535 (message), 20 (ip_adr)
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL
This method implements the following db-related operations:
- It queries the table(s) MAILING_TBL, MAILINGLIST_TBL
This method implements the following db-related operations:
- It queries the table(s) USERFORM_TBL
This method implements the following db-related operations:
- It queries the table(s) WS_ADMIN_TBL
This method implements the following db-related operations:
- It queries the table(s) RDIRURLTABLENAMEDATABASESPECIFIC, RDIRLOGTABLENAMEDATABASESPECIFIC
This method invokes db-related operations via delegation:
- It queries the table(s) MAILTRACK_TBL via a call to the org.agnitas.ecs.backend.dao.impl.EmbeddedClickStatDaoImpl.getTotalMailsSent method
This method invokes db-related operations via delegation:
- It deletes rows from table(s) CM_CONTENT_TBL via a call to the org.agnitas.cms.dao.impl.ContentModuleDaoImpl.removeContentsForContentModule method
This method invokes db-related operations via delegation:
- It queries the table(s) MAILING_ACCOUNT_TBL, MAILING_ACCOUNT_TBL via a call to the org.agnitas.dao.impl.CampaignDaoImpl.loadTotalSent method
- It queries the table(s) MAILING_TBL via a call to the org.agnitas.dao.impl.CampaignDaoImpl.getMailingIDs method
- It queries the table(s) MAILING_TBL via a call to the org.agnitas.dao.impl.CampaignDaoImpl.loadMailingNames method
This method invokes db-related operations via delegation:
- It queries the table(s) IMPORT_GENDER_MAPPING_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.getGenderMappings method
This method invokes db-related operations via delegation:
- It deletes rows from table(s) IMPORT_COLUMN_MAPPING_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.removeColumnMappings method
- It deletes rows from table(s) IMPORT_GENDER_MAPPING_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.removeGenderMappings method
- It deletes rows from table(s) IMPORT_PROFILE_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.removeImportProfile method
This method invokes db-related operations via delegation:
- It deletes rows from table(s) IMPORT_COLUMN_MAPPING_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.removeColumnMappings method
- It deletes rows from table(s) IMPORT_GENDER_MAPPING_TBL via a call to the org.agnitas.dao.impl.ImportProfileDaoImpl.removeGenderMappings method
This method invokes db-related operations via delegation:
- It drops the TABLE CUST_ via the chain-call org.agnitas.dao.impl.ImportRecipientsDaoImpl.updateMailinglists org.agnitas.dao.impl.ImportRecipientsDaoImpl.createRecipientBindTemporaryTable org.agnitas.dao.impl.ImportRecipientsDaoImpl.removeBindTemporaryTable
- It drops the TABLE CUST_ via the chain-call org.agnitas.dao.impl.ImportRecipientsDaoImpl.updateMailinglists org.agnitas.dao.impl.ImportRecipientsDaoImpl.removeBindTemporaryTable
This method invokes db-related operations via delegation:
- It drops the TABLE CUST_ via a call to the org.agnitas.dao.impl.ImportRecipientsDaoImpl.removeBindTemporaryTable method
This method invokes db-related operations via delegation:
- It drops the TABLE CUST_ via a call to the org.agnitas.dao.impl.ImportRecipientsDaoImpl.removeBindTemporaryTable method
- It drops the TABLE CUST_ via the chain-call org.agnitas.dao.impl.ImportRecipientsDaoImpl.createRecipientBindTemporaryTable org.agnitas.dao.impl.ImportRecipientsDaoImpl.removeBindTemporaryTable
This method invokes db-related operations via delegation:
- It inserts the ip_address, login_status, username attributes into table LOGIN_TRACK_TBL via a call to the org.agnitas.dao.impl.LoginTrackDaoImpl.trackLoginStatus method
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in LOGIN_TRACK_TBL do not overflow the varchar limits: 50 (username), 20 (ip_address)
This method invokes db-related operations via delegation:
- It inserts the ip_address, login_status, username attributes into table LOGIN_TRACK_TBL via a call to the org.agnitas.dao.impl.LoginTrackDaoImpl.trackLoginStatus method
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in LOGIN_TRACK_TBL do not overflow the varchar limits: 50 (username), 20 (ip_address)
This method invokes db-related operations via delegation:
- It inserts the ip_address, login_status, username attributes into table LOGIN_TRACK_TBL via a call to the org.agnitas.dao.impl.LoginTrackDaoImpl.trackLoginStatus method
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in LOGIN_TRACK_TBL do not overflow the varchar limits: 50 (username), 20 (ip_address)
This method invokes db-related operations via delegation:
- It queries the table(s) MAILING_TBL, MAILINGLIST_TBL via a call to the org.agnitas.web.MailingStatAction.getMailingStats method
This method invokes db-related operations via delegation:
- It queries the table(s) USERFORM_TBL via a call to the org.agnitas.web.UserFormEditAction.getUserFromList method