FMDB中读取原数据,然后insert更改数据,保存后再读取时数据变化了。
-(void)testsetTableData{
__blockSSSSagyoshijiModel *sagyoshijiModel; // 表中的模型
NSError *dbError;
NSString *kojicd =@"1"; //表中的主key
NSString *kokucd =@"2";
NSString *sagyoymd =@"3";
dispatch_group_t dlgroup =dispatch_group_create();
dispatch_group_enter(dlgroup);
//获取数据的方法
[SSSSagyoshiji ModelgetTableData:kojicd kokucd:kokucd sagyoymd:sagyoymdhandler:^(SSSSagyoshijiModel *result,NSError *error) {
if (error) {
XCTAssert(false);
}
else {
sagyoshijiModel = result; // 给模型进行赋值
}
dispatch_group_leave(dlgroup);
}];
dispatch_group_wait(dlgroup,DISPATCH_TIME_FOREVER);
NSString *testyoteihyonm1 =@"yotei";
sagyoshijiModel.yoteihyonm1 = testyoteihyonm1;
// FMDatabase *db = [SWKDataAccessManager openDatabase];
// [sagyoshijiModel deleteFromTable:db error:&dbError]; // 删除数据
// [db commit];
// [db close];
dbError = nil;
FMDatabase *db = [SWKDataAccessManageropenDatabase];
[sagyoshijiModel insert:dberror:&dbError];
[db commit];
// DB数据文件放的地方
NSLog(@"DB file is located at %@",[NSHomeDirectory()stringByAppendingString:@"Documents"]);
[db close];
XCTAssertTrue(dbError ==nil);
dispatch_group_enter(dlgroup);
sagyoymd = testYmd;
// 更改后的数据再一次进行读取
[SSSSagyoshijiModelgetTableData:kojicd kokucd:kokucd sagyoymd:sagyoymdhandler:^(SSSSagyoshijiModel *result,NSError *error) {
if (error) {
XCTAssert(false);
}
else {
sagyoshijiModel = result;
}
dispatch_group_leave(dlgroup);
}];
dispatch_group_wait(dlgroup,DISPATCH_TIME_FOREVER);
//内容确定
XCTAssertTrue([sagyoshijiModel.yoteihyonm1isEqualToString:testyoteihyonm1]);
}
///
+ (void)getTableData:(nonnullNSString *)kojicd
kokucd:(nonnullNSString *)kokucd
sagyoymd:(nonnullNSString *)sagyoymd
handler:(nonnullvoid (^)(SSSSagyoshijiModel *_Nullable, NSError *_Nullable))handler;
{
NSMutableString *sql = [NSMutableStringstringWithString:@""