// Get DfpUser from "~/dfp.properties".
DfpUser user = new DfpUser();
// Get the ThirdPartySlotService.
ThirdPartySlotServiceInterface thirdpartySlotService =
user.getService(DfpService.V201208.THIRD_PARTY_SLOT_SERVICE);
//Set the company that the third party slots to archive belong to.
Long companyId = Long.parseLong("INSERT_COMPANY_ID_HERE");
// Create a statement to only select active third party slots.
String statementText = "WHERE status = :status AND "
+ "companyId = :companyId LIMIT 500";
Statement filterStatement =
new StatementBuilder("")
.putValue("status", ThirdPartySlotStatus.ACTIVE.toString())
.putValue("companyId", companyId)
.toStatement();
// Set defaults for page and offset.
ThirdPartySlotPage page = new ThirdPartySlotPage();
int offset = 0;
int i = 0;
List<Long> thirdPartySlotIds = new ArrayList<Long>();
do {
// Create a statement to page through active third party slots.
filterStatement.setQuery(statementText + " OFFSET " + offset);
// Get third party slots by statement.
page = thirdpartySlotService.getThirdPartySlotsByStatement(filterStatement);
if (page.getResults() != null) {
for (ThirdPartySlot thirdPartySlot : page.getResults()) {
System.out.println("Third party slot with ID \"" + thirdPartySlot.getId()
+ "\" will be archived.");
thirdPartySlotIds.add(thirdPartySlot.getId());
}
}
offset += 500;
} while (offset < page.getTotalResultSetSize());
System.out.println("Number of third party slots to be archived: "
+ thirdPartySlotIds.size());
if (thirdPartySlotIds.size() > 0) {
// Modify statement for action.
filterStatement.setQuery("WHERE id IN ("
+ StringUtils.join(thirdPartySlotIds, ",") + ")");
// Create action.
ArchiveThirdPartySlots action = new ArchiveThirdPartySlots();
// Perform action.
UpdateResult result =
thirdpartySlotService.performThirdPartySlotAction(action, filterStatement);
// Display results.
if (result != null && result.getNumChanges() > 0) {
System.out.println("Number of third party slots archived: " + result.getNumChanges());
} else {