目标c中的断言失败错误 [英] Assertion failure error in objective c

问题描述

我有Json数据但是当我尝试将此记录插入sqlite数据库时，我得到了此错误断言失败。我可以使用NSLog查看数据，但我无法插入数据库。哪里不对？我怎么解决？感谢您的回复。我的代码如下：

I have Json datas but I got this error assertion failure when I try to insert this records to sqlite database. I can see the datas with NSLog but I can not insert database. What is wrong? How can I solve? Thanks for reply. My code is below:

 -(void)processDoneWithRequestName:(NSString*)tagName{

sqlite3_stmt *stmt=nil;


//NSArray *pathsArray=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES);
NSString *doumentDirectoryPath=@"/Users/ds/Desktop/SqliteTest/SqliteTest";
NSString *cruddatabase=[doumentDirectoryPath stringByAppendingPathComponent:@"SqliteTestDb.sqlite"];

if ([tagName isEqualToString:Logins]) {

    int keys = [[response.item objectForKey:@"Lipton"] count];
    NSLog(@"count %i",keys);
    for (int i=0; i<keys; i++)
    {

        NSString *str1 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"IsSuccess"];
        NSString *str2 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"ProducerId"];
        NSString *str3 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Latitude"];
        NSString *str4 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Longitude"];
        NSString *str5 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Altitude"];
        NSString *str6 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Slope"];
        NSString *str7 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"SampleDate"];
        NSString *str8 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"PackageNo"];
        NSString *str9 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Status"];
        NSString *str10 =[[[response.item objectForKey:@"Lipton"] objectAtIndex:i]objectForKey:@"Description"];


        if (sqlite3_open([cruddatabase UTF8String], &cruddb)==SQLITE_OK)  {


            const char *sql = "INSERT INTO LabUpdate (IsSuccess, ProducerId, Latitude, Longitude, Altitude, Slope, SampleDate, PackageNo, Status, Description) VALUES (?,?,?,?,?,?,?,?,?,?)";            

            NSInteger result = sqlite3_prepare_v2(cruddb,sql, -1, &stmt, NULL);
            if(sqlite3_step(stmt) == SQLITE_ROW || result == SQLITE_ROW) 
            {
                sqlite3_prepare_v2(cruddb, sql, 1, &stmt, NULL);
                sqlite3_bind_int(stmt, 1, [str1 integerValue]);
                sqlite3_bind_int(stmt, 2, [str2 integerValue]);
                sqlite3_bind_double(stmt, 3, [str3 floatValue]);
                sqlite3_bind_double(stmt, 4, [str4 floatValue]);
                sqlite3_bind_double(stmt, 5, [str5 floatValue]);
                sqlite3_bind_double(stmt, 6, [str6 floatValue]);
                sqlite3_bind_text(stmt, 7, [str7 UTF8String], -1, SQLITE_TRANSIENT);
                sqlite3_bind_int(stmt, 8, [str8 integerValue]);
                sqlite3_bind_int(stmt, 9, [str9 integerValue]);
                sqlite3_bind_text(stmt, 10, [str10 UTF8String], -1, SQLITE_TRANSIENT);
            }

            else
            {
                NSAssert1(0, @"Error . '%s'", sqlite3_errmsg(cruddb));                        
            }
            sqlite3_reset(stmt);
            sqlite3_finalize(stmt);
        }
    }                       
    sqlite3_close(cruddb);
}  
}

推荐答案

检查输出以下代码

if (sqlite3_open([cruddatabase UTF8String], &cruddb)==SQLITE_OK)  {

sqlite3_prepare_v2(cruddatabase, "BEGIN TRANSACTION", -1, &compiledStmt, NULL);
sqlite3_step(compiledStmt);
sqlite3_finalize(compiledStmt);

const char *sql = "INSERT INTO LabUpdate (IsSuccess, ProducerId, Latitude, Longitude, Altitude, Slope, SampleDate, PackageNo, Status, Description) VALUES (?,?,?,?,?,?,?,?,?,?)";  
if(sqlite3_prepare_v2(cruddatabase, sql, -1, &stmt, NULL) == SQLITE_OK){  

    sqlite3_prepare_v2(cruddb, sql, 1, &stmt, NULL);
            sqlite3_bind_int(stmt, 1, [str1 integerValue]);
            sqlite3_bind_int(stmt, 2, [str2 integerValue]);
            sqlite3_bind_double(stmt, 3, [str3 floatValue]);
            sqlite3_bind_double(stmt, 4, [str4 floatValue]);
            sqlite3_bind_double(stmt, 5, [str5 floatValue]);
            sqlite3_bind_double(stmt, 6, [str6 floatValue]);
            sqlite3_bind_text(stmt, 7, [str7 UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_int(stmt, 8, [str8 integerValue]);
            sqlite3_bind_int(stmt, 9, [str9 integerValue]);
            sqlite3_bind_text(stmt, 10, [str10 UTF8String], -1, SQLITE_TRANSIENT);

        NSUInteger err = sqlite3_step(compiledStmt);
        if (err != SQLITE_DONE){
            NSLog(@"error while binding %d %s",err, sqlite3_errmsg(database));
        }
        sqlite3_reset(compiledStmt);
    sqlite3_finalize(compiledStmt);     
} else {
    NSLog(@"Invalid Query");
}

sqlite3_prepare_v2(cruddatabase, "END TRANSACTION", -1, &compiledStmt, NULL);
sqlite3_step(compiledStmt);
sqlite3_finalize(compiledStmt); 
sqlite3_close(cruddatabase);

这篇关于目标c中的断言失败错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！