**********VFP 1******************
<!--*************************************************************************
Page Name : AutomatedTestSetup
Description : For Automated Test class execution process(SP-684-Automate Test Classes execution in Salesforce Orgs)
Created By : Krishna yerru
Created Date : 23-Oct-2018
********************************************************************************************************************************
Change Version Name Date Task/Case# Description
********************************************************************************************************************************
********************************************************************************************************************************
*************************************************************************/-->
<apex:page standardController="Automated_Test_Run__c" extensions="AutomatedTestSetup_Controller" Sidebar="False" id="pg" docType="html-5.0">
<apex:form id="frm">
<apex:pageBlock id="ATSPB" >
<apex:pageMessages />
Reccurence
<!--<apex:inputField value="{!AtrRecord.Recurence_Job__c}"/>
<apex:actionSupport event="onclick" action="{!dispSect}" rerender="ATSTest" immediate="true"/>-->
<apex:inputcheckbox value="{!isChecked}" label="checkBox">
<apex:actionSupport event="onchange" rerender="ATSTest" action="{!click}" immediate="true"/>
</apex:inputcheckbox>
<!--<apex:outputpanel id="ATSTest" rendered="{!if(isCheckedRec,true,false)}">-->
<apex:outputpanel id="ATSTest" rendered="{!(isCheckedRec != true)}">
<apex:outputPanel id="ThePanel" >
<apex:pageBlock title="Job Schedule - Test Execution" id="ThePanel2">
<br/>
<div align="right" draggable="false" >
<apex:outputLink style="font-weight:bold;font-size:13px;float:Right;" value="{!testRunLink}">Scheduled Jobs History</apex:outputLink>
</div>
<br/><br/>
<!--Automated Test Record-->
<apex:outputPanel rendered="{!if(NOT(hasScheduledJobs) && Not(hasAbort) && Not(hasemailpending),true,false)}">
<apex:pageBlockSection title="Automated Test Run" columns="2">
<apex:pageBlockSectionItem helpText="Test class names containing this value would be considered for automated test execution Ex:Test% or %_Test (case insensitive)">
<apex:outputLabel value="Keyword"/>
<apex:inputField required="true" value="{!AtrRecord.Query__c}" label="Keyword"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Comma-delimited list of classes to exclude from testing">
<apex:outputLabel value="Excluded Classes"/>
<apex:inputField value="{!AtrRecord.Excluded_Classes__c}" label="Excluded Classes"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Check this box to exclude all Managed Package Unit Tests">
<apex:outputLabel value="Exclude Managed_Packages"/>
<apex:inputField value="{!AtrRecord.Exclude_Managed_Packages__c}" label="Exclude Managed_Packages"/>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:pageBlockSection title="Automated Test Email" columns="2">
<apex:pageBlockSectionItem helpText="Comma-separated email addresses">
<apex:outputLabel value="Email"/>
<apex:inputField required="true" value="{!AtrRecord.Emails__c}" label="Email"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Send email when all tests pass">
<apex:outputLabel value="Email on Pass"/>
<apex:inputField value="{!AtrRecord.Email_on_Pass__c}" label="Email on Pass"/>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:pageBlockSection title="Job Schedule " columns="1">
<apex:pageBlockSectionItem helpText="To Schedule Testclass Execution">
<apex:outputLabel value="Schedule Date and Time"/>
<apex:inputField required="true" value="{!AtrRecord.Schedule__c}" label="Schedule Date and Time"/>
<!--<c:AutomatedVFPHelpIcon helpText="To Schedule Testclass Execution"/>-->
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem >
<apex:outputPanel >
<div style="text-align: center">
<apex:commandButton value="Save & Submit" style="text-align:center" action="{!doInsert}" />
</div>
</apex:outputPanel>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<!--Automated Test Record-->
</apex:outputPanel>
<!-- <apex:outputPanel rendered="{!hasScheduledJobs}">-->
<apex:outputPanel rendered="{!if(hasScheduledJobs && Not(hasemailpending),true,false)}">
<apex:pageBlockSection title="Job Schedule Status" columns="1">
Automated Test Run Name:{!ATRdetails}_TestRun_{!shddatetime}
<apex:commandLink value="Cancel" rendered="{!if(hasScheduledJobs && Not(hasAbort) && Not(hasemailpending),true,false)}" action="{!CancelJobs}" styleClass="btn">
</apex:commandLink>
</apex:pageBlockSection>
</apex:outputPanel>
<apex:outputPanel rendered="{!(hasAbort)}">
<apex:pageBlockSection title="Job Schedule Status" columns="1">
Automated Test Run Name:{!ATRdetails}_TestRun_In Progress
</apex:pageBlockSection>
</apex:outputPanel>
<apex:outputPanel rendered="{!if(hasemailpending && Not(hasAbort),true,false)}" >
<apex:pageBlockSection title="Job Schedule Status" columns="1">
Automated Test Run Name:{!ATRdetails}_TestRun_Email Sent in Progress
</apex:pageBlockSection>
</apex:outputPanel>
<!--Startstics Section -->
<apex:pageBlockSection title="Test Class Execution Statistics" id="Piechartsec" columns="4">
<apex:pageBlockSectionItem >
TestRun Name:{!PastATRdetails}<div></div>
Testclass execution {!Percentage}% completed
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem id="ShowGraph">
<apex:outputPanel id="Graph">
<apex:chart height="250" width="350" data="{!pieData}" id="Piechartsec2">
<apex:pieSeries dataField="data" labelField="name"/>
<apex:legend position="left"/>
</apex:chart>
</apex:outputPanel>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem id="Refresh">
<apex:commandlink value=" Refresh " status="progress" action="{!Refresh}" styleClass="btn" reRender="Piechartsec2"/>
<!-- <apex:commandlink value=" Refresh " status="progress" onclick="window.location.reload();" styleClass="btn" reRender="Piechartsec2"/>-->
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem id="Abort">
<apex:commandButton value="Abort" status="progress" action="{!AbortTestJobs}" rendered="{!(hasAbort)}" onclick="return confirm('Are you sure to abort and get the current results in an email ?')" />
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:outputPanel>
<!--recuurence-->
<apex:outputPanel id="ThePanelrec" rendered="{!isCheckedRec}">
<apex:pageBlock title="Reccurence Job Schedule - Test Execution" id="ThePanelrec2">
<apex:outputPanel rendered="{!if(NOT(hasRecScheduledJobs),true,false)}">
<apex:pageBlockSection title="Automated Test Run" columns="2">
<apex:pageBlockSectionItem helpText="Test class names containing this value would be considered for automated test execution Ex:Test% or %_Test (case insensitive)">
<apex:outputLabel value="Keyword"/>
<apex:inputField required="true" value="{!AtrRecord.Query__c}" html-disabled="true" label="Keyword"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Comma-delimited list of classes to exclude from testing">
<apex:outputLabel value="Excluded Classes"/>
<apex:inputField value="{!AtrRecord.Excluded_Classes__c}" label="Excluded Classes"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Check this box to exclude all Managed Package Unit Tests">
<apex:outputLabel value="Exclude Managed_Packages"/>
<apex:inputField value="{!AtrRecord.Exclude_Managed_Packages__c}" label="Exclude Managed_Packages"/>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:pageBlockSection title="Automated Test Email" columns="2">
<apex:pageBlockSectionItem helpText="Comma-separated email addresses">
<apex:outputLabel value="Email"/>
<apex:inputField required="true" value="{!AtrRecord.Emails__c}" label="Email"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Send email when all tests pass">
<apex:outputLabel value="Email on Pass"/>
<apex:inputField value="{!AtrRecord.Email_on_Pass__c}" label="Email on Pass"/>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<apex:pageBlockSection title="Job Schedule " columns="1">
<apex:pageBlockSectionItem helpText="Frequency">
<apex:outputLabel value="Frequency"/>
<apex:inputField required="true" value="{!AtrRecord.Frequency__c}" label="Frequency"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="On Every">
<apex:outputLabel value="On Every"/>
<apex:inputField required="true" value="{!AtrRecord.On_Every__c}" label="On Every"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Schedule Start Date">
<apex:outputLabel value="Schedule Start Date"/>
<apex:inputField required="true" value="{!AtrRecord.Start_Date__c}" label="Schedule Start Date"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Schedule End Date">
<apex:outputLabel value="Schedule End Date"/>
<apex:inputField required="true" value="{!AtrRecord.End_Date__c}" label="Schedule End Date"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem helpText="Time For Schedule Job">
<apex:outputLabel value="Time For Schedule Job"/>
<apex:inputField required="true" value="{!AtrRecord.Preferred_Time__c}" label="Preferred Time"/>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem >
<apex:outputPanel >
<div style="text-align: center">
<apex:commandButton value="Save & Submit" style="text-align:center" action="{!RecuureceATSinsertandSchedule}" />
</div>
</apex:outputPanel>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
<!--Automated Test Record-->
</apex:outputPanel>
<apex:outputPanel rendered="{!IF(hasRecScheduledJobs = false , false , true)}">
<apex:pageBlockSection title="Job Schedule Status" columns="1">
Automated Test Run Name:%Test%_TestRun_{!shddatetime}
<apex:commandLink value="Cancel" rendered="{!IF(hasRecScheduledJobs = false , false , true)}" action="{!CancelRecurrenceJobs}" styleClass="btn">
</apex:commandLink>
</apex:pageBlockSection>
</apex:outputPanel>
</apex:pageBlock>
</apex:outputPanel>
</apex:outputPanel>
</apex:pageBlock>
</apex:form>
</apex:page>
******************VFp 2*****************
<!--************************************************************************* Page Name : AutomatedTestSetupRecurrence Description : For Automated Test class execution process(SP-684-Automate Test Classes execution in Salesforce Orgs) Created By : Krishna yerru Created Date : 23-Oct-2018 ******************************************************************************************************************************** Change Version Name Date Task/Case# Description ******************************************************************************************************************************** ******************************************************************************************************************************** *************************************************************************/--> <apex:page standardController="Automated_Test_Run__c" extensions="AutomatedTestSetup_Controller" Sidebar="False" id="pg" docType="html-5.0"> <apex:form id="frm"> <apex:pageBlock id="ATSPB" > <apex:inputcheckbox value="{!isChecked}" label="checkBox"> <apex:actionSupport event="onchange" action="{!click}" immediate="true"/> </apex:inputcheckbox> <apex:pageMessages /> <apex:pageBlock title="Reccurence Job Schedule - Test Execution" id="ThePanelrec2"> <apex:outputPanel rendered="{!if(NOT(hasRecScheduledJobs),true,false)}"> <apex:pageBlockSection title="Automated Test Run" columns="2"> <apex:pageBlockSectionItem helpText="Test class names containing this value would be considered for automated test execution Ex:Test% or %_Test (case insensitive)"> <apex:outputLabel value="Keyword"/> <apex:inputField required="true" value="{!AtrRecord.Query__c}" html-disabled="true" label="Keyword"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Comma-delimited list of classes to exclude from testing"> <apex:outputLabel value="Excluded Classes"/> <apex:inputField value="{!AtrRecord.Excluded_Classes__c}" label="Excluded Classes"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Check this box to exclude all Managed Package Unit Tests"> <apex:outputLabel value="Exclude Managed_Packages"/> <apex:inputField value="{!AtrRecord.Exclude_Managed_Packages__c}" label="Exclude Managed_Packages"/> </apex:pageBlockSectionItem> </apex:pageBlockSection> <apex:pageBlockSection title="Automated Test Email" columns="2"> <apex:pageBlockSectionItem helpText="Comma-separated email addresses"> <apex:outputLabel value="Email"/> <apex:inputField required="true" value="{!AtrRecord.Emails__c}" label="Email"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Send email when all tests pass"> <apex:outputLabel value="Email on Pass"/> <apex:inputField value="{!AtrRecord.Email_on_Pass__c}" label="Email on Pass"/> </apex:pageBlockSectionItem> </apex:pageBlockSection> <apex:pageBlockSection title="Job Schedule " columns="1"> <apex:pageBlockSectionItem helpText="Frequency"> <apex:outputLabel value="Frequency"/> <apex:inputField required="true" value="{!AtrRecord.Frequency__c}" label="Frequency"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="On Every"> <apex:outputLabel value="On Every"/> <apex:inputField required="true" value="{!AtrRecord.On_Every__c}" label="On Every"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Schedule Start Date"> <apex:outputLabel value="Schedule Start Date"/> <apex:inputField required="true" value="{!AtrRecord.Start_Date__c}" label="Schedule Start Date"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Schedule End Date"> <apex:outputLabel value="Schedule End Date"/> <apex:inputField required="true" value="{!AtrRecord.End_Date__c}" label="Schedule End Date"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem helpText="Time For Schedule Job"> <apex:outputLabel value="Time For Schedule Job"/> <apex:inputField required="true" value="{!AtrRecord.Preferred_Time__c}" label="Preferred Time"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem > <apex:outputPanel > <div style="text-align: center"> <apex:commandButton value="Save & Submit" style="text-align:center" action="{!RecuureceATSinsertandSchedule}" /> </div> </apex:outputPanel> </apex:pageBlockSectionItem> </apex:pageBlockSection> <!--Automated Test Record--> </apex:outputPanel> <apex:outputPanel rendered="{!IF(hasRecScheduledJobs = false , false , true)}"> <apex:pageBlockSection title="Job Schedule Status" columns="1"> Automated Test Run Name:%Test%_TestRun_{!shddatetime} <apex:commandLink value="Cancel" rendered="{!IF(hasRecScheduledJobs = false , false , true)}" action="{!CancelRecurrenceJobs}" styleClass="btn"> </apex:commandLink> </apex:pageBlockSection> </apex:outputPanel> </apex:pageBlock> </apex:pageBlock> </apex:form> </apex:page>********************************
| /* Name : AutomatedTestSetup_Controller Test class : AutomatedTestSetup_Controller_Test Description : For Automated Test class execution process(SP-684-Automate Test Classes execution in Salesforce Orgs) Created By : Krishna yerru Created Date : 23-Oct-2018 ******************************************************************************************************************************** Change Version Name Date Task/Case# Description ******************************************************************************************************************************** ******************************************************************************************************************************** */ public with sharing class AutomatedTestSetup_Controller { public boolean hasScheduledJobs { get; set; } public boolean hasAbort { get; set; } public boolean hasemailpending { get; set; } public boolean isRunning { get; set; } public boolean isEmailing { get; set; } public AutomatedTestSetup_Controller ATS { get; set; } public String DtValue {get; set; } public boolean showMessage {get;set;} public String showdatetime{get;set;} public String Staticstics{get;set;} public Decimal Percentage{get;set;} public String shddatetime {get;set;} public String ATRdetails {get;set;} public String PastATRdetails {get;set;} public List<CronTrigger> Schdjobs{get;set;} public String Jobstatus {get;set;} public Automated_Test_Run__c AtrRecord {get; set;} public Boolean isChecked { get; set; } public Boolean isCheckedRec { get; set; } //recurrence related public boolean hasRecScheduledJobs { get; set; } id ATERecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Execution').getRecordTypeId(); id ATEmailRecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Email Notification').getRecordTypeId(); public PageReference doInsert() { List<Automated_Test_Run__c> ATSrecrdsinsert=New List<Automated_Test_Run__c>(); AtrRecord.Query__c=AtrRecord.Query__c; AtrRecord.Excluded_Classes__c=AtrRecord.Excluded_Classes__c; AtrRecord.Exclude_Managed_Packages__c=AtrRecord.Exclude_Managed_Packages__c; AtrRecord.Schedule__c=AtrRecord.Schedule__c; AtrRecord.RecordTypeId=ATERecordTypeId; ATSrecrdsinsert.add(AtrRecord); Automated_Test_Run__c ATEemail = new Automated_Test_Run__c(); ATEemail.Query__c=AtrRecord.Query__c; ATEemail.Emails__c=AtrRecord.Emails__c; ATEemail.Email_on_Pass__c=AtrRecord.Email_on_Pass__c; ATEemail.RecordTypeId=ATEmailRecordTypeId; ATSrecrdsinsert.add(ATEemail); Savepoint sp = Database.setSavepoint(); try{ scheduleJobs(AtrRecord.Schedule__c); if(showMessage==false){ upsert ATSrecrdsinsert; } } catch(exception ex){ Database.rollback(sp); } GetATSRunDeatils(); return null; } public Automated_Test_Run__c getAtrRecord() { return AtrRecord; } public AutomatedTestSetup_Controller(ApexPages.StandardController controller) { AtrRecord = (Automated_Test_Run__c)Controller.getRecord(); this.ATS=ATS; showMessage=false; refreshHasScheduledJobs(); ShowAbortbutton(); getPieData(); Calculatepercentage(); GetATSRunDeatils(); EmailSendPending(); //recurrence related System.debug('isCheckedRec value is1 '+isCheckedRec); //isCheckedRec=false; System.debug('isCheckedRec value is12is '+isCheckedRec); if(isChecked==null){ isCheckedRec = false; System.debug('isCheckedRec is ' +isCheckedRec); } refreshHasRecrnsScheduledJobs(); } public pagereference dispSect() { System.debug('isCheckedRec value is12is '+isCheckedRec); isCheckedRec = true; system.debug('isCheckedRec'+isCheckedRec); /*PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.*/ PageReference ref = ApexPages.currentPage(); ref.setRedirect(true); return null; //return null; } public void refreshHasScheduledJobs() { integer jobCount = [SELECT count() FROM CronTrigger where CronJobDetail.Name like '%TestRunner%']; Schdjobs=[SELECT CronJobDetail.Name,CreatedDate,NextFireTime,State FROM CronTrigger where CronJobDetail.Name like '%TestRunner%' and State in('WAITING','ACQUIRED','EXECUTING')]; if(Schdjobs.size()>0){ Jobstatus=Schdjobs[0].State; if(Schdjobs[0].NextFireTime!=null ){ Datetime shddatetimeGSt=Schdjobs[0].NextFireTime; Datetime gmt = shddatetimeGSt; String timeZone = UserInfo.getTimeZone().getID(); Datetime GivenDateTime=shddatetimeGSt;// here you can user your dates e.g. createddate Datetime localdt=Datetime.valueOf(GivenDateTime); //showdatetime = string.valueOfGmt(local); shddatetime=localdt.format(); } else if(Jobstatus!=null && Jobstatus!='') { shddatetime='Test Scheduled Job Current State is '+Jobstatus; } } hasScheduledJobs = jobCount !=0; } public void GetATSRunDeatils() { List<String> Keywords=New List<String>(); Keywords.clear(); ATRdetails=''; for(Automated_Test_Run__c atr: [select Query__c, Excluded_Classes__c, Email_on_Pass__c, Exclude_Managed_Packages__c from Automated_Test_Run__c //where Active__c = true and RecordTypeId=:ATERecordTypeId order by createdDate DESC limit 1]){ where RecordTypeId=:ATERecordTypeId order by createdDate DESC limit 1]){ Keywords.add(atr.Query__c); } if(Keywords.size()>0){ for(String kw:Keywords){ ATRdetails+=kw; } } } public void ShowAbortbutton(){ integer runCount = [select count() from Automated_Test_Run__c limit 1]; List<Test_Runner_Job__c> RunningJobnm =[Select Name,Automated_Test_Run__c,CreatedDate From Test_Runner_Job__c order by CreatedDate desc limit 1]; if(RunningJobnm.size()>0){ integer TestexecrunCount = [select count() from ApexTestQueueItem WHERE Status IN ('Holding','Queued','Preparing','Processing') and ParentJobId=:RunningJobnm[0].Name]; hasAbort = TestexecrunCount > 0; } } public void EmailSendPending(){ List<Test_Runner_Job__c> runCountJob = [select id from Test_Runner_Job__c where Processed__c=false order by CreatedDate desc limit 1]; hasemailpending = runCountJob.size()> 0; } public string getTestRunLink() { return '/' + Automated_Test_Run__c.SObjectType.getDescribe().getKeyPrefix(); } public AutomatedTestSetup_Controller() { Automated_Test_Run__c AtrRecord = new Automated_Test_Run__c(); refreshHasScheduledJobs(); Calculatepercentage(); ShowAbortbutton(); EmailSendPending(); System.debug('isCheckedRec value is1 '+isCheckedRec); //isCheckedRec=false; System.debug('isCheckedRec value is12is '+isCheckedRec); //click(); if(isChecked==null){ isCheckedRec = false; System.debug('isCheckedRec is ' +isCheckedRec); } } public PageReference scheduleJobs(Datetime DtValue) { System.debug('Date & Time is given***1'+DtValue); deleteCompletedJobs(); Datetime gmt = DtValue; String timeZone = UserInfo.getTimeZone().getID(); Datetime GivenDateTime=DtValue;// here you can user your dates e.g. createddate System.debug('GivenDateTime is***'+GivenDateTime); Datetime local=Datetime.valueOf(GivenDateTime); System.debug('local is***'+local); Map <Integer,String> monthNumbers = new Map <Integer,String> {1=>'Jan', 2=>'Feb',3=>'Mar',4=>'Apr', 5=>'May', 6=>'Jun',7=>'Jul',8=>'Aug', 9=>'Sep', 10=>'Oct', 11=>'Nov', 12=>'Dec'}; String TestShdmonth=monthNumbers.get(local.month()); String strSchedule = '0 ' + local.minute() + ' ' +local.hour()+ ' ' + local.day()+ ' ' + TestShdmonth+ ' ? ' + ' ' + local.year(); System.debug('***strSchedule***'+strSchedule); AutoTestRunner.setup(strSchedule); refreshHasScheduledJobs(); GetATSRunDeatils(); return null; } public PageReference CancelJobs() { //List<CronTrigger> jobsToAbort = [select id,Name from CronJobDetail where Name like 'AutoTestRunner%' and JobType = '7']; List<CronTrigger> jobsToAbort = [select Id from CronTrigger where CronJobDetail.JobType = '7' and CronJobDetail.Name like '%TestRunner%']; if(jobsToAbort.size()>0){ for (CronTrigger job : jobsToAbort) { System.abortJob(job.Id); } } PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.setRedirect(true); return pageRef; } public PageReference AbortTestJobs() { Test_Runner_Job__c RunningJobnm =[Select Name,Automated_Test_Run__c,CreatedDate From Test_Runner_Job__c order by CreatedDate desc limit 1]; ApexTestQueueItem[] items = [SELECT Id FROM ApexTestQueueItem WHERE Status IN ('Holding','Queued','Preparing','Processing') and ParentJobId=:RunningJobnm.Name]; if(items.size()>0){ for(ApexTestQueueItem item: items) { item.Status = 'Aborted'; } update items; } email(); PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.setRedirect(true); return pageRef; } public void deleteCompletedJobs(){ List<CronTrigger> jobsToAbort = [select Id,State from CronTrigger where CronJobDetail.JobType = '7' and CronJobDetail.Name like '%TestRunner%' and State='DELETED']; for (CronTrigger job : jobsToAbort) { System.abortJob(job.Id); } } public void email() { emailUnprocessedJobStatus(); isEmailing = true; ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.Confirm, 'Results processed and emailed')); } public static list<Messaging.SingleEmailMessage> emailUnprocessedJobStatus() { list<Test_Runner_Job__c> jobs = getUnprocessedJobs(); list<Messaging.SingleEmailMessage> messages =emailMethodStatus(jobs); for (Test_Runner_Job__c job : jobs) { job.Processed__c = true; } update jobs; return messages; } public static list<Test_Runner_Job__c> getUnprocessedJobs() { return [Select t.Name, t.Automated_Test_Run__r.Emails__c, t.Automated_Test_Run__r.Email_on_Pass__c, t.Automated_Test_Run__r.Name, t.Automated_Test_Run__c From Test_Runner_Job__c t where Processed__c = false]; } //Statistics part public Void Calculatepercentage() { PastATRdetails=''; List<Test_Runner_Job__c> RunningJob =[Select Name,Automated_Test_Run__c,CreatedDate From Test_Runner_Job__c order by CreatedDate desc limit 1]; if(RunningJob.size()>0){ Automated_Test_Run__c PastATR=[select id,Query__c from Automated_Test_Run__c where id=:RunningJob[0].Automated_Test_Run__c order by createdDate DESC limit 1]; PastATRdetails=PastATR.Query__c; integer TotalJobsis = [select count() FROM ApexTestQueueItem where ParentJobId=:RunningJob[0].Name]; integer CompltedJobsis = [select count() FROM ApexTestQueueItem where Status IN ('Completed','Aborted') and ParentJobId=:RunningJob[0].Name]; if((TotalJobsis>0)&& (CompltedJobsis>0)){ Percentage=(CompltedJobsis*100)/TotalJobsis; System.debug('Total Jobs is'+TotalJobsis+ 'CompltedJobs' +CompltedJobsis+ 'Percentage is'+Percentage); } } } public List<PieWedgeData> getPieData() { List<PieWedgeData> data = new List<PieWedgeData>(); List<Test_Runner_Job__c> RunningJob =[Select Name,Automated_Test_Run__c,CreatedDate From Test_Runner_Job__c order by CreatedDate desc limit 1]; if(RunningJob.size()>0){ //integer Cmpltd = [select count() FROM ApexTestResult WHERE Outcome = 'Pass' and AsyncApexJobId=:RunningJob[0].Name]; integer CmpltdPass = [select count() FROM ApexTestResult WHERE Outcome = 'Pass' and AsyncApexJobId=:RunningJob[0].Name]; integer Failed = [select count() FROM ApexTestResult WHERE Outcome = 'Fail' and AsyncApexJobId=:RunningJob[0].Name]; integer Queuedjobs = [select count() FROM ApexTestQueueItem where Status='Queued' and ParentJobId=:RunningJob[0].Name]; integer TotalJobs = [select count() FROM ApexTestQueueItem where ParentJobId=:RunningJob[0].Name]; if(Queuedjobs>0){ data.add(new PieWedgeData('In Progress'+' '+Queuedjobs, +Queuedjobs)); }if(CmpltdPass>0){ data.add(new PieWedgeData('Passed'+' '+CmpltdPass, +CmpltdPass)); }if(Failed>0){ data.add(new PieWedgeData('Fail'+' '+Failed, +Failed)); } } return data; } // Wrapper class public class PieWedgeData { public String name { get; set; } public Integer data { get; set; } public Integer CmpltdPass{ get; set; } public Integer Failed{ get; set; } public Integer Queuedjobs{ get; set; } public PieWedgeData(String name, Integer data) { this.name = name; this.data = data; } } public PageReference Refresh(){ deleteCompletedJobs(); Calculatepercentage(); refreshHasScheduledJobs(); if(Percentage==100){ email(); }else{ hasScheduledJobs = true; } PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.setRedirect(true); return pageRef; } //Scheduling Job run & Email Sending from Auotestrunner class // Enqueue all unit test classes as spec'd by Automated_Test_Run__c record(s) public static list<ID> enqueueTests() { list<Id> jobIds = new list<Id>(); Id ATERecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Execution').getRecordTypeId(); Id ATEmilRecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Email Notification').getRecordTypeId(); Automated_Test_Run__c EmailRecord=[select Emails__c from Automated_Test_Run__c where RecordTypeId=:ATEmilRecordTypeId order by createdDate DESC limit 1]; string whereExcluded = ''; string Keywordis = ''; string ATRIDis = ''; for (Automated_Test_Run__c run : [select Query__c, Excluded_Classes__c, Email_on_Pass__c, Exclude_Managed_Packages__c from Automated_Test_Run__c where Active__c = true and RecordTypeId=:ATERecordTypeId order by createdDate DESC limit 1]) { ATRIDis=run.id; if (run.Excluded_Classes__c != null) { for (string c : run.Excluded_Classes__c.split('[,\\s]+')) { whereExcluded += 'and Name != \'' + c + '\''; } } if (run.Exclude_Managed_Packages__c == True) { whereExcluded += ' AND NameSpacePrefix = null'; } if (run.Query__c != null && run.Query__c != ' ' ) { Keywordis +=run.Query__c; } } string query = 'SELECT Id FROM ApexClass WHERE Name LIKE \'' + Keywordis+ '\' ' + whereExcluded; ApexClass[] testClasses = Database.query(query); if (testClasses.size() > 0) { ApexTestQueueItem[] queueItems = new List<ApexTestQueueItem>(); for (ApexClass cls : testClasses) { queueItems.add(new ApexTestQueueItem(ApexClassId=cls.Id)); } if (!Test.isRunningTest()) { DataBase.insert(queueItems,false); // Get the job ID of the first queue item returned. ApexTestQueueItem item =[SELECT ParentJobId FROM ApexTestQueueItem WHERE Id=:queueItems[0].Id LIMIT 1]; insert new Test_Runner_Job__c(Name = item.parentjobid, Automated_Test_Run__c = EmailRecord.Id); jobIds.add(item.parentjobid); if(ATRIDis!='' && ATRIDis!=null){ Automated_Test_Run__c runATRrecd =[select id,Active__c from Automated_Test_Run__c where Id=:ATRIDis limit 1]; runATRrecd.Active__c = false; update runATRrecd; } } } return jobIds; } public static list<Messaging.SingleEmailMessage> emailMethodStatus(list<Test_Runner_Job__c> jobs) { set<string> jobNames = new set<string>(); for (Test_Runner_Job__c job : jobs) { jobNames.add(job.Name); } ApexTestResult[] results = [SELECT AsyncApexJobId, Outcome, ApexClass.Name, MethodName, Message, StackTrace FROM ApexTestResult WHERE AsyncApexJobId in :jobNames]; return emailMethodStatus(jobs, results); } public static list<Messaging.SingleEmailMessage> emailMethodStatus(list<Test_Runner_Job__c> jobs, ApexTestResult[] results) { list<Messaging.SingleEmailMessage> messages = new list<Messaging.SingleEmailMessage>(); for (Test_Runner_Job__c job : jobs) { system.debug('Test Runner Job: Id ' + job.Id + ' Name ' + job.Name); integer passed = 0; integer total = 0; string failTable = '<table border="1" cellpadding="5px">'; string className = ''; for (ApexTestResult atr : results) { system.debug('Apex Test Result: Id ' + atr.AsyncApexJobId); if ((string)atr.AsyncApexJobId == job.Name || (Test.isRunningTest() && jobs.size() == 1)) { if (atr.Outcome == 'Pass') { passed++; } else { if (atr.ApexClass.Name != className) { className = atr.ApexClass.Name; failTable += '<tr style="background: #ddd; font-weight: bold;"><td colspan="2">' + className + '</td></tr>\n'; } failTable += '<tr><td>' + atr.MethodName + '</td><td> ' + atr.message + '</td></tr>\n'; } total++; } } failTable += '</table>'; string body = '<p>' + passed + '/' + total + ' tests passed</p>\n'; boolean allPassed = passed == total; if (!allPassed) { body += '<p>Test Failures:</p>\n' + failTable; } if ((allPassed && job.Automated_Test_Run__r.Email_on_Pass__c) || !allPassed) { Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); mail.setToAddresses(job.Automated_Test_Run__r.Emails__c.split('[,\\s]+')); mail.setSubject(job.Automated_Test_Run__r.Name + ' Automated Test Results: ' + (passed < total ? 'Fail' : 'Pass')); mail.setHtmlBody(body); System.debug(mail); messages.add(mail); } } if (!Test.isRunningTest()) { Messaging.sendEmail(messages); } return messages; } //Recuurence procedure Starts---- public PageReference RecuureceATSinsertandSchedule(){ List<Automated_Test_Run__c> ATSrecinsert=New List<Automated_Test_Run__c>(); AtrRecord.Query__c='%Test%'; AtrRecord.Excluded_Classes__c=AtrRecord.Excluded_Classes__c; AtrRecord.Exclude_Managed_Packages__c=AtrRecord.Exclude_Managed_Packages__c; //AtrRecord.Schedule__c=AtrRecord.Schedule__c; AtrRecord.Frequency__c=AtrRecord.Frequency__c; AtrRecord.On_Every__c=AtrRecord.On_Every__c; AtrRecord.Start_Date__c=AtrRecord.Start_Date__c; AtrRecord.End_Date__c=AtrRecord.End_Date__c; //AtrRecord.Month__c=AtrRecord.Month__c; AtrRecord.Preferred_Time__c=AtrRecord.Preferred_Time__c; AtrRecord.RecordTypeId=ATERecordTypeId; ATSrecinsert.add(AtrRecord); Automated_Test_Run__c ATEemail = new Automated_Test_Run__c(); ATEemail.Query__c=AtrRecord.Query__c; ATEemail.Emails__c=AtrRecord.Emails__c; ATEemail.Email_on_Pass__c=AtrRecord.Email_on_Pass__c; ATEemail.RecordTypeId=ATEmailRecordTypeId; ATSrecinsert.add(ATEemail); Savepoint sp = Database.setSavepoint(); System.debug('Inserting record is Query'+AtrRecord.Query__c +'Frequency__c is'+AtrRecord.Frequency__c+ 'On_Every__c is'+AtrRecord.On_Every__c+'Start_Date__c is'+AtrRecord.Start_Date__c+'End_Date__c is'+AtrRecord.End_Date__c +'Preferred_Time__c'+AtrRecord.Preferred_Time__c); Date StartDateis=AtrRecord.Start_Date__c; Date EndDateis=AtrRecord.End_Date__c; Integer Startyearis=StartDateis.year(); Integer Endyearis=EndDateis.year(); Integer StartmonthNum =StartDateis.month(); Integer EndmonthNum = EndDateis.month(); Map <Integer,String> monthNumbers = new Map <Integer,String> {1=>'Jan', 2=>'Feb',3=>'Mar',4=>'Apr', 5=>'May', 6=>'Jun',7=>'Jul',8=>'Aug', 9=>'Sep', 10=>'Oct', 11=>'Nov', 12=>'Dec'}; String StartMonth=monthNumbers.get(StartmonthNum); String EndMonth=monthNumbers.get(EndmonthNum); string gvnDateis='?'; //String Dateis='?'; String Shddayofmonth='?'; String Dayofweek='?'; string Months=StartMonth+'-'+EndMonth; string Years=Startyearis+'-'+Endyearis; try{ if(AtrRecord.Frequency__c=='Monthly'){ gvnDateis=AtrRecord.On_Every__c; //Date gvnDateis=date.parse(inputDate); //gvnDateis = String.valueOf(StartDateis.day()); } else if(AtrRecord.Frequency__c=='Weekly'){ Dayofweek=AtrRecord.On_Every__c; //gvnDateis = String.valueOf(StartDateis.day()); } String formatedDates=gvnDateis.replaceAll(';', ','); String formatedDayofweek=Dayofweek.replaceAll(';', ','); Map<String,string> Hoursformat=new Map<String,String> {'01:00 AM'=>'1','02:00 AM'=>'2','03:00 AM'=>'3','04:00 AM'=>'4','05:00 AM'=>'5','06:00 AM'=>'6','07:00 AM'=>'7', '08:00 AM'=>'8','09:00 AM'=>'9','10:00 AM'=>'10','11:00 AM'=>'11','12:00 PM'=>'12','01:00 PM'=>'13','02:00 PM'=>'14','03:00 PM'=>'15','04:00 PM'=>'16','05:00 PM'=>'17', '06:00 PM'=>'18','07:00 PM'=>'19','08:00 PM'=>'20','09:00 PM'=>'21','10:00 PM'=>'22','11:00 PM'=>'23','12:00 PM'=>'0'}; Map <String,String> DAYformat = new Map <String,String> {'SUNDAY'=>'SUN', 'MONDAY'=>'MON','TUESDAY'=>'TUE','WEDNESDAY'=>'WED','THURSDAY'=>'THU', 'FRIDAY'=>'FRI','SATURDAY'=>'SAT'}; String GetHour=Hoursformat.get(AtrRecord.Preferred_Time__c); System.debug('***GetHour is***'+GetHour); System.debug('***formatedDates is***'+formatedDates); System.debug('***Months is***'+Months); System.debug('***Dayofweek is***'+Dayofweek); System.debug('***yearis is***'+Years); //Seconds Minutes Hours Day Of Month Month Day Of Week Year String strSchedule = '0 ' + '0 '+GetHour+ ' ' +formatedDates+ ' ' +Months+ ' ' +formatedDayofweek+ ' ' + Years; System.debug('***strSchedule***'+strSchedule); AutoTestRunnerRecuurence.setup(strSchedule); upsert ATSrecinsert; } catch(exception ex){ Database.rollback(sp); } PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.setRedirect(true); return pageRef; //return null; } public void refreshHasRecrnsScheduledJobs() { List<CronTrigger> Schdjobs=New List<CronTrigger>(); integer jobCount = [SELECT count() FROM CronTrigger where CronJobDetail.Name like '%AutoTestRunnerRecuurence%']; Schdjobs=[SELECT CronJobDetail.Name,CreatedDate,NextFireTime,State FROM CronTrigger where CronJobDetail.Name like '%AutoTestRunnerRecuurence%' and State in('WAITING','ACQUIRED','EXECUTING')]; if(Schdjobs.size()>0){ Jobstatus=Schdjobs[0].State; if(Schdjobs[0].NextFireTime!=null ){ Datetime shddatetimeGSt=Schdjobs[0].NextFireTime; Datetime gmt = shddatetimeGSt; String timeZone = UserInfo.getTimeZone().getID(); Datetime GivenDateTime=shddatetimeGSt;// here you can user your dates e.g. createddate Datetime localdt=Datetime.valueOf(GivenDateTime); //showdatetime = string.valueOfGmt(local); shddatetime=localdt.format(); } else if(Jobstatus!=null && Jobstatus!='') { shddatetime='Test Scheduled Job Current State is '+Jobstatus; } } hasRecScheduledJobs = jobCount !=0; } public PageReference CancelRecurrenceJobs() { //List<CronTrigger> jobsToAbort = [select id,Name from CronJobDetail where Name like 'AutoTestRunner%' and JobType = '7']; List<CronTrigger> jobsToAbort = [select Id from CronTrigger where CronJobDetail.JobType = '7' and CronJobDetail.Name like '%AutoTestRunnerRecuurence%']; if(jobsToAbort.size()>0){ for (CronTrigger job : jobsToAbort) { System.abortJob(job.Id); } } PageReference pageRef = new PageReference('/apex/AutomatedTestSetup'); pageRef.setRedirect(true); return pageRef; } public static list<ID> recurrenceenqueueTests() { list<Id> jobIds = new list<Id>(); Id ATERecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Execution').getRecordTypeId(); Id ATEmilRecordTypeId = Schema.SObjectType.Automated_Test_Run__c.getRecordTypeInfosByName().get('Automated Test Email Notification').getRecordTypeId(); Automated_Test_Run__c EmailRecord=[select Emails__c from Automated_Test_Run__c where RecordTypeId=:ATEmilRecordTypeId order by createdDate DESC limit 1]; string whereExcluded = ''; string Keywordis = ''; string ATRIDis = ''; for (Automated_Test_Run__c run : [select Query__c, Excluded_Classes__c, Email_on_Pass__c, Exclude_Managed_Packages__c from Automated_Test_Run__c where Active__c = true and RecordTypeId=:ATERecordTypeId and Frequency__c!=null order by createdDate DESC limit 1]) { ATRIDis=run.id; if (run.Excluded_Classes__c != null) { for (string c : run.Excluded_Classes__c.split('[,\\s]+')) { whereExcluded += 'and Name != \'' + c + '\''; } } if (run.Exclude_Managed_Packages__c == True) { whereExcluded += ' AND NameSpacePrefix = null'; } if (run.Query__c != null && run.Query__c != ' ' ) { Keywordis +=run.Query__c; } } string query = 'SELECT Id FROM ApexClass WHERE Name LIKE \'' + Keywordis+ '\' ' + whereExcluded; ApexClass[] testClasses = Database.query(query); if (testClasses.size() > 0) { ApexTestQueueItem[] queueItems = new List<ApexTestQueueItem>(); for (ApexClass cls : testClasses) { queueItems.add(new ApexTestQueueItem(ApexClassId=cls.Id)); } if (!Test.isRunningTest()) { DataBase.insert(queueItems,false); // Get the job ID of the first queue item returned. ApexTestQueueItem item =[SELECT ParentJobId FROM ApexTestQueueItem WHERE Id=:queueItems[0].Id LIMIT 1]; insert new Test_Runner_Job__c(Name = item.parentjobid, Automated_Test_Run__c = EmailRecord.Id); jobIds.add(item.parentjobid); /*if(ATRIDis!='' && ATRIDis!=null){ Automated_Test_Run__c runATRrecd =[select id,Active__c from Automated_Test_Run__c where Id=:ATRIDis limit 1]; runATRrecd.Active__c = false; update runATRrecd; } */ } } return jobIds; } public PageReference click(){ System.debug('isChecked is ' +isChecked); PageReference pageRef; if(isChecked!=TRUE){ isCheckedRec = true; System.debug('isCheckedRec is ' +isCheckedRec); pageRef = new PageReference('/apex/AutomatedTestSetupRecurrence'); } else{ isCheckedRec = false; pageRef = new PageReference('/apex/AutomatedTestSetup'); } //PageReference pageRef = new PageReference('/apex/AutomatedTestSetupRecurrence'); // PageReference pageRef = ApexPages.currentPage(); pageRef.setRedirect(true); return pageRef; //return null; } } *************************** /* Name : AutoTestRunnerRecuurence Test class : AutomatedTestSetup_Controller_Test Description : For Automated Test class execution process(SP-684-Automate Test Classes execution in Salesforce Orgs) Created By : Krishna yerru Created Date : 26-Oct-2018 ******************************************************************************************************************************** Change Version Name Date Task/Case# Description ******************************************************************************************************************************** ******************************************************************************************************************************** */ global class AutoTestRunnerRecuurence implements Schedulable { public static void setup(String strSchedule) { try { String cronexpression=strSchedule; system.schedule('AutoTestRunnerRecuurence_Job',cronexpression, new AutoTestRunnerRecuurence()); } catch (Asyncexception ex) { system.debug('Job Not scheduled'); ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.INFO,'Job not Schedued Please give proper data+ex'); ApexPages.addMessage(myMsg); } } global void execute(SchedulableContext SC) { AutomatedTestSetup_Controller.recurrenceenqueueTests(); } } ********************** |
No comments:
Post a Comment