对于数据库更新的清理

最新推荐文章于 2020-12-19 06:34:33 发布

Lovin01

最新推荐文章于 2020-12-19 06:34:33 发布

阅读量382

点赞数

分类专栏：每日问题记录

本文链接：https://blog.csdn.net/helainthus/article/details/74331230

版权

每日问题记录专栏收录该内容

1 篇文章 0 订阅

订阅专栏

对于数据库更新的清理

当数据库数据太多时，做一个清理。

NSArray *phoneRecordSorts = [LNDBModelcompareTable:[LNPhoneRecordSortclass] withTable:[LNRecordIDclass] byCriteria:@"select * from LNPhoneRecordSort phoneRecordSort where not exists (select 1 from LNContact contact where phoneRecordSort.recordID=contact.recordID )"];

if (phoneRecordSorts.count >0) {

for (LNPhoneRecordSort *phoneRecordSortin phoneRecordSorts) {

if (phoneRecordSort.otherPhoneSearchNumber ==nil) {

phoneRecordSort.otherPhoneSearchNumber = [NSStringgetFomateNumberFromString:phoneRecordSort.otherPhoneNumber];

}

phoneRecordSort.phoneType =LXLocalizedString(@"unknown");

[phoneRecordSort update];

}

对已经存在的数据的更新

NSArray *phones = [LNPhone findByCriteria:[NSString stringWithFormat:@"where recordID = %@",phone.recordID]];

LNContact *contact = [LNContact findFirstByCriteria:[NSString stringWithFormat:@"where recordID = %@",phone.recordID]];

NSArray *oldPhoneRecords = [LNPhoneRecord findByCriteria:[NSString stringWithFormat:@"where myPhoneNumber = '%@' and otherPhoneSearchNumber = '%@'",phoneRecordSort.myPhoneNumber,[NSString getFomateNumberFromString:phoneRecordSort.otherPhoneNumber]]];

for (LNPhoneRecord *phoneRecord in oldPhoneRecords) {

phoneRecord.recordID = phone.recordID;

[phoneRecord update];

}

LNContactInfo *contactInfo = [[LNContactInfo alloc]init];

contactInfo.contact = contact;

contactInfo.phones = phones;

VC.contactInfo = contactInfo;

NSArray *phoneRecords = [LNPhoneRecord findByCriteria:[NSString stringWithFormat:@"where myPhoneNumber = '%@' and recordID = '%@' and dailTime >= '%@' and dailTime <= '%@' order by dailTime desc limit %@",phoneRecordSort.myPhoneNumber,phone.recordID,phoneRecordSort.firstTime,phoneRecordSort.lastTime,phoneRecordSort.times]];

VC.phoneRecords = phoneRecords;