SFDC For ALL: Automated

*******Page

<apex:page standardController="Automated_Test_Run__c" extensions="AutomatedTestSetup_Controller" Sidebar="False" id="pg" docType="html-5.0">
<apex:form id="frm">
<apex:pageBlock title="Job Schedule - Test Execution">
<apex:pageMessages />
<apex:pageBlockSection title="Job Schedule" columns="1">
<apex:outputPanel rendered="{!hasScheduledJobs}">
Automated Test execution <a href="/08e">scheduled</a>
</apex:outputPanel>

<apex:outputPanel rendered="{!NOT(hasScheduledJobs)}">
<apex:pageBlockSectionItem >
<div>
<p>Select the Date and Time to schedule the Automated Test execution</p>
</div>
</apex:pageBlockSectionItem>
</apex:outputPanel>

<apex:pageBlockSectionItem id="ScheduleVal" rendered="{!NOT(hasScheduledJobs)}">
<apex:OutputLabel value="Date and Time"/>

<apex:InputField required="true" value="{!Automated_Test_Run__c.Schedule__c}" ID="Schdval"/>
</apex:pageBlockSectionItem>




<apex:commandLink value="Submit" rendered="{!NOT(hasScheduledJobs)}" action="{!scheduleJobs}" styleClass="btn">
<apex:param name="DtValue" value="{!Automated_Test_Run__c.Schedule__c}" assignTo="{!DtValue}"/>
</apex:commandLink>

<apex:commandLink value="Cancel" rendered="{!hasScheduledJobs}" action="{!CancelJobs}" styleClass="btn">
</apex:commandLink>
</apex:pageBlockSection>

<apex:pageBlockSection title="Statistics" id="Piechartsec" columns="2">
<div>
<p>Percentage completion of test execution:</p>
</div>

<apex:commandlink value=" Refresh " status="progress" onclick="window.location.href='/apex/AutomatedTestSetupVFP" styleClass="btn"/>
<apex:chart height="250" width="350" data="{!pieData}" id="Piechartsec2">
<apex:pieSeries dataField="data" labelField="name"/>
<apex:legend position="right"/>
</apex:chart>

</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

**************

public with sharing class AutomatedTestSetup_Controller {

public AutomatedTestSetup_Controller(ApexPages.StandardController controller) {
refreshHasScheduledJobs();
refreshHasTestRun();
}

public boolean hasScheduledJobs { get; set; }
public boolean hasTestRun { get; set; }
public boolean isRunning { get; set; }
public boolean isEmailing { get; set; }
public AutomatedTestSetup_Controller ATS { get; set; }
public String DtValue {get; set; }
public String Staticstics;

public void refreshHasScheduledJobs() {
integer jobCount = [select count() from CronJobDetail where Name like 'TestRunner%' and JobType = '7'];
hasScheduledJobs = jobCount == 1;
}

public void refreshHasTestRun() {
integer runCount = [select count() from Automated_Test_Run__c limit 1];
hasTestRun = runCount > 0;
}

public string getTestRunLink() {
return '/' + Automated_Test_Run__c.SObjectType.getDescribe().getKeyPrefix();
}

public AutomatedTestSetup_Controller() {
refreshHasScheduledJobs();
refreshHasTestRun();
}

public PageReference scheduleJobs() {
//String InputDtValue = ApexPages.currentPage().getParameters().get('DtValue');
// System.debug('Date & Time is given***'+InputDtValue);
System.debug('Date & Time is given***1'+DtValue);

if(DtValue!='null' && DtValue!='' ){
//DateTime Schdtime = (DateTime)Json.deserialize('"'+DtValue+'"', DateTime.class);
//DtValue Format: Sat Aug 25 17:12:00 GMT 2018
//0 12 17 25 Aug 2018 Sat
// 0 12 17 25 AUG ? 2017
// Seconds Minutes Hours Day Of Month Month Day Of Week Year
// 0 12 17 25 AUG ? 2017

String[] splited = DtValue.split(' ');
String day = splited[2];
String month = splited[1];
String HMS = splited[3];
String[] splitedHMS = HMS.split(':');
String hour = splitedHMS[0];
String minute = splitedHMS[1];
String second = splitedHMS[2];
String year =splited[5];
//String minute = string.valueOf(Schdtime.minute() + 1);
//String year = string.valueOf(Schdtime.year());
String strSchedule = '0 ' + minute + ' ' + hour + ' ' + day + ' ' + month + ' ?' + ' ' + year;
System.debug('***strSchedule***'+strSchedule);
//String DaTime=ApexPages.currentPage().getParameters().get('{$Automated_Test_Run__c.Schedule__c}');
//System.debug('Date & Time is'+one);
TestRunner.setup(strSchedule);
refreshHasScheduledJobs();
//ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.Confirm, 'Jobs scheduled'));

}
else{
ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.INFO,'Please Select Date Time Value and then Select Submit Button to Schedule job');
ApexPages.addMessage(myMsg);
}
RETURN NULL;
}
public PageReference CancelJobs() {
//List<CronTrigger> jobsToAbort = [select id,Name from CronJobDetail where Name like 'TestRunner%' and JobType = '7'];
List<CronTrigger> jobsToAbort = [select Id from CronTrigger where CronJobDetail.JobType = '7' and CronJobDetail.Name like 'TestRunner%'];
for (CronTrigger job : jobsToAbort) {
System.abortJob(job.Id);
}
//PageReference pageRef = '/apex/AutomatedTestSetupVFP';
PageReference pageRef = new PageReference('/apex/AutomatedTestSetupVFP');
pageRef.setRedirect(true);
return pageRef;
}
public void createTestRun() {
User currentUser = [select Email from User where Id = :UserInfo.getUserId()];
insert new Automated_Test_Run__c(Name = 'All Tests', Emails__c = currentUser.Email);
refreshHasTestRun();
ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.Confirm, 'Automated Test Run created'));
}

public void run() {
TestRunner.enqueueTests();
isRunning = true;
ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.Confirm, 'Tests queued'));
}

public void email() {
TestRunnerResults.emailUnprocessedJobStatus();
isEmailing = true;
ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.Confirm, 'Results processed and emailed'));
}

//Statistics

public List<PieWedgeData> getPieData() {
//Select id,Status from ApexTestQueueItem where ParentJobId='7070K00008HsU7EQAV'
Test_Runner_Job__c RunningJob =[Select Name,Automated_Test_Run__c,CreatedDate From Test_Runner_Job__c where Processed__c = false order by CreatedDate desc limit 1];
//integer Cmpltd = [select count() FROM ApexTestResult WHERE Outcome = 'Pass' and AsyncApexJobId=:RunningJob.Name];
integer Cmpltd = [select count() FROM ApexTestQueueItem where Status='Completed' and ParentJobId=:RunningJob.Name];
integer Queuedjobs = [select count() FROM ApexTestQueueItem where Status='Queued' and ParentJobId=:RunningJob.Name];
Integer Tot=Cmpltd+Queuedjobs;
Integer Pending=Tot-Queuedjobs;
Staticstics='Total Testclasses='+Tot+'Pending Testclasses='+Pending;
List<PieWedgeData> data = new List<PieWedgeData>();
data.add(new PieWedgeData('Completed'+' '+Cmpltd, +Cmpltd));
data.add(new PieWedgeData('In Progress'+' '+Queuedjobs, +Queuedjobs));
return data;
}

// Wrapper class
public class PieWedgeData {

public String name { get; set; }
public Integer data { get; set; }
public Integer Cmpltd{ get; set; }
public Integer Queuedjobs{ get; set; }
public PieWedgeData(String name, Integer data) {
this.name = name;
this.data = data;
}
}

}

*************

global class TestRunner implements Schedulable {
// derived from http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_testing_unit_tests_running.htm#APISectionTitle

public static void setup(String strSchedule) {
try {
String cronexpression=strSchedule;
system.schedule('TestRunner',cronexpression, new TestRunner());
// system.schedule('TestRunnerResults', '0 30 23 ? * SUN-THU', new TestRunnerResults());
} catch (Asyncexception ex) {
system.debug('Job already scheduled');
ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.INFO,'Please Select Future Date Time');
ApexPages.addMessage(myMsg);
}
}

global void execute(SchedulableContext SC) {
enqueueTests();
}

// 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>();

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]) {
string whereExcluded = '';
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';
}

string query = 'SELECT Id FROM ApexClass WHERE Name LIKE \'' + run.Query__c + '\' ' + 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()) {
insert queueItems;

// 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 = run.Id);

jobIds.add(item.parentjobid);
}
}
}

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;
}
}

*******************

SELECT Id, StartTime, LogUserId, LogLength, Location FROM ApexLog

https://developer.salesforce.com/forums/?id=9060G000000XhvVQAS

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_datetime.htm

DateTime myDateTime = DateTime.newInstance(1997, 1, 31, 7, 8, 16);
DateTime newDateTime = myDateTime.addHours(3);
DateTime expected = DateTime.newInstance(1997, 1, 31, 10, 8, 16);
System.assertEquals(expected, newDateTime);

********

SFDC For ALL

Sunday, 26 August 2018

Automated_WIP

No comments:

Post a Comment