在while循环中添加到数组时泄漏
|
我有一个名为：“ 0”的函数，此函数将sqlite数据库中的项目（文章）添加到“ 1”，此处此函数的工作方式：
- (void) AddSortedCustomFeed :(NSMutableArray*)rssList {
NSLog(@\"\\n\\n\\n ----- Add Sorted SQL Database -----\");
NSLog(@\"Start\");
// Create Query String.
NSString* sqliteQuery = [NSString stringWithFormat:@\"SELECT mainLink, title, summary, pubDate, author, imageLink, body, favorites, pubdatetime FROM ARTICLES WHERE customfeed = \'Y\' ORDER BY pubdatetime DESC\"];
NSLog(@\"Query String is: %@\", sqliteQuery);
// Pointer to Article and Statement.
Article* article;
sqlite3_stmt* statement;
// Prepare SQL for work.
if( sqlite3_prepare_v2(articlesDB, [sqliteQuery UTF8String], -1, &statement, NULL) == SQLITE_OK ) {
// Get next row from database.
while( sqlite3_step(statement) == SQLITE_ROW ) {
// Alloc and init article.
article = [[Article alloc] initWithValues:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 1)]
mainLink:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 0)]
summary:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 2)]
pubDate:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 3)]
author:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 4)]
imageLink:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 5)] ];
//article.body = [NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 6)];
NSString* favo = [NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 7)];
article.favorite = [favo hasPrefix:@\"N\"] ? NO : YES;
// Add to list.
[rssList addObject:article];
// Release article.
[article release];
}
}
else NSLog( @\"SortSQLDatabase: Failed from sqlite3_prepare_v2. Error is: %s\", sqlite3_errmsg(articlesDB) );
// Finalize and close database.
sqlite3_finalize(statement);
NSLog(@\"End\\n\\n\\n\");
}
Article* article;
NSMutableArray
[article release];
没有找到相关结果
已邀请:
2 个回复
抵浮细
while( .. ) { NSAutoreleasePool *pool = [[NSAutoreleasePool alloc] init]; // .. your code .. // [pool release]; }完趣镐
，就需要从头开始制作。所以你可以做类似的事情Article *article = [[Article alloc] initWithValues:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 1)] mainLink:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 0)] summary:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 2)] pubDate:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 3)] author:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 4)] imageLink:[NSString stringWithUTF8String:(const char*)sqlite3_column_text(statement, 5)] ];不过，请务必从上方取出行。这可能是您不想要的大量开销。 您可以使所有内容保持不变，然后向下移动，这样它就在循环之外。