59、salesforce实现数据的批量处理
2024-09-02 15:02:58
批处理,往自己的邮箱发一封邮件,批处理采用异步的处理方式处理数据,最多可以处理5000万条数据 global with sharing class MerchandiseBatch implements Database.Batchable<sObject>,Database.Stateful{
Integer queryCount = 0;
String myEmailAddress = 'weizhen.zhao@pactera.com';
global Database.QueryLocator start(database.BatchableContext bc){
String query = 'select Name from Merchandise__c';
return Database.getQueryLocator(query);
} global void execute (Database.BatchableContext bc,List<Merchandise__c> merchandiseList){
for(Merchandise__c merchandise : merchandiseList){
Decimal price = merchandise.Price__c;
price += 1;
queryCount +=1;
}
upsert merchandiseList;
} global void finish(Database.BatchableContext bc){
System.debug('query count: '+ queryCount);
Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();
email.setToAddresses(new String[]{myEmailAddress});
email.setSubject('show count');//set subject
email.setHtmlBody('query Count' + queryCount);
Messaging.sendEmail(new Messaging.SingleEmailMessage[]{email});
}
}
MerchandiseBatch merchandise = new MerchandiseBatch();
Id batchId = Database.executeBatch(merchandise);
最新文章
- swift 如何在IOS应用图标上添加消息数
- 试用 Nexus OSS 3.0 的docker仓库 (二)
- .net Int16 、(int Int32)、 Int64 的区别
- JDBC 创建连接对象的三种方式 、 properties文件的建立、编辑和信息获取
- SGU 299.Triangle
- Response.End(); 用HttpContext.Current.ApplicationInstance.CompleteRequest 代替
- 图片特效-仿 iPhone 图片查看器效果
- springmvc 在非controller下使用@autowired
- Binder吐槽学习
- OCR库Tesseract初探
- Go语言开发Windows应用
- 动态规划-子数组乘积小于k的总个数 Subarray Product Less Than K
- GetWindowRect
- 《Pro SQL Server Internals, 2nd edition》中CHAPTER 7 Designing and Tuning the Indexes中的Clustered Index Design Considerations一节(译)
- 【noip模拟赛3】贾老二的工件 (模拟)
- POJ - 2115C Looooops 扩展欧几里得(做的少了无法一眼看出)
- Android学习之路(转载)
- 关于easyUI
- MongoDB学习笔记(五)--复制集 &;&; sharding分片
- JS埋点 小结