pears.CacheWarm

CREATE EVENT "pears"."CacheWarm" TYPE "DatabaseStart"  ENABLE 
HANDLER
BEGIN
  IF "PROPERTY"('IsService') = 'Yes' THEN
    message "string"('IQX Cache Warming Started at ',CURRENT TIMESTAMP) TO console;
    unload SELECT * FROM "pears"."AccordEmployee" INTO file 'nul';
    unload SELECT * FROM "pears"."Company" INTO file 'nul';
    unload SELECT * FROM "pears"."CompanyAccount" INTO file 'nul';
    unload SELECT * FROM "pears"."ContactEvent" INTO file 'nul';
    unload SELECT * FROM "pears"."Department" INTO file 'nul';
    unload SELECT * FROM "pears"."Diary" INTO file 'nul';
    unload SELECT * FROM "pears"."Dictionary" INTO file 'nul';
    unload SELECT * FROM "pears"."Employment" INTO file 'nul';
    unload SELECT * FROM "pears"."IQacDocument" INTO file 'nul';
    unload SELECT * FROM "pears"."IQacJournal" INTO file 'nul';
    unload SELECT * FROM "pears"."Pay_Employee" INTO file 'nul';
    unload SELECT * FROM "pears"."Person" INTO file 'nul';
    unload SELECT * FROM "pears"."Phone" INTO file 'nul';
    unload SELECT * FROM "pears"."PhoneType" INTO file 'nul';
    unload SELECT * FROM "pears"."Placement" INTO file 'nul';
    unload SELECT * FROM "pears"."Progress" INTO file 'nul';
    unload SELECT * FROM "pears"."Search" INTO file 'nul';
    unload SELECT * FROM "pears"."Staff" INTO file 'nul';
    unload SELECT * FROM "pears"."Tag" INTO file 'nul';
    unload SELECT * FROM "pears"."TagChoice" INTO file 'nul';
    unload SELECT * FROM "pears"."TagValue" INTO file 'nul';
    unload SELECT * FROM "pears"."TempDesk" INTO file 'nul';
    unload SELECT * FROM "pears"."TempJobRate" INTO file 'nul';
    unload SELECT * FROM "pears"."TempJobRateMaster" INTO file 'nul';
    unload SELECT * FROM "pears"."TempJobType" INTO file 'nul';
    unload SELECT * FROM "pears"."TempPayBand" INTO file 'nul';
    unload SELECT * FROM "pears"."TempPoolMember" INTO file 'nul';
    unload SELECT * FROM "pears"."TempShift" INTO file 'nul';
    unload SELECT * FROM "pears"."TempShiftPlan" INTO file 'nul';
    unload SELECT * FROM "pears"."TempProvTimeSheet" INTO file 'nul';
    unload SELECT * FROM "pears"."TempProvTimesheetLine" INTO file 'nul';
    unload SELECT * FROM "pears"."TempProvTimesheetShift" INTO file 'nul';
    unload SELECT * FROM "pears"."TempTimeSheet" INTO file 'nul';
    unload SELECT * FROM "pears"."TempTimesheetLine" INTO file 'nul';
    unload SELECT * FROM "pears"."Vacancy" INTO file 'nul';
    unload SELECT * FROM "pears"."VacancyRole" INTO file 'nul';
    unload SELECT * FROM "pears"."VacancyRoleAllocation" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKAssignedRole" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKChangeTracker" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKForm" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKGlobalSwitch" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKGlobalSwitchGroup" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKGlobalSwitchSetting" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKImage" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKLayout" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKLayoutView" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKPickList" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKPickListChoice" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKPickList" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKRole" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKView" INTO file 'nul';
    unload SELECT * FROM "pears"."WPKViewItem" INTO file 'nul';
    message "string"('IQX Cache Warming Completed at ',CURRENT TIMESTAMP) TO console
  END IF
END