提交: a1229f1946ef2ea825bbc30bd25577293e637f4e - aretokoreConverter (git)

あれとこれのコンバータ

Commit MetaInfo

• 修訂: a1229f1946ef2ea825bbc30bd25577293e637f4e (tree)
• 時間: 2011-12-03 16:40:23
• 作者: masakih <masakih@user...>
• Commiter: masakih

Log Message

板移転履歴のコンバート

Change Summary

• modified: BathyScapheDataConverter/BSDCAppDelegate.m

差異

--- a/BathyScapheDataConverter/BSDCAppDelegate.m
+++ b/BathyScapheDataConverter/BSDCAppDelegate.m
@@ -17,6 +17,7 @@
 #import "BSBoardInformationObject.h"
 #import "BSThreadInformationObject.h"
 #import "BSFavoriteObject.h"
+#import "BSBoardHistoryObject.h"
 
 
 @implementation BSDCAppDelegate
@@ -174,6 +175,30 @@
 	}
 }
 
+- (void)convertFavorites:(BSCoreDataManager *)cdm
+{
+    panel.message = @"Converting Favorites ...";
+	DatabaseManager *dm = [DatabaseManager defaultManager];
+	NSArray *favs = [cdm fetchDataForEntityName:@"Favorite"
+									  predicate:nil];
+	for(BSFavoriteObject *fav in favs) {
+		[self updateTime];
+//		NSLog(@"%@", fav.thread.board.boardName);
+		NSUInteger boardID = [dm boardIDForURLString:fav.thread.board.boardURL];
+		SQLiteReservedQuery *query = [self sqlForInsertFav];
+		[query cursorWithFormat:F_Int F_NSNumberOfInt,
+		 boardID, fav.thread.threadID];
+	}
+}
+
+- (void)loggingIfNeeded
+{
+	SQLiteDB *db = [[DatabaseManager defaultManager]databaseForCurrentThread];
+	if([db lastErrorID] != SQLITE_OK) {
+		NSLog(@"%@", [db lastError]);
+	}
+}
+
 - (void)doConvertToSQLite
 {
 	self.startTime = [NSDate dateWithTimeIntervalSinceNow:0.0];
@@ -198,10 +223,31 @@
 	[pool release];
 	[self updateTime];
 	
+	pool = [[NSAutoreleasePool alloc] init];
 	panel.message = @"Converting board histories ...";
-	//
+	DatabaseManager *dm = [DatabaseManager defaultManager];
+	NSString *sql = [NSString stringWithFormat:@"INSERT INTO %@ (%@, %@, %@) VALUES (?, ?, ?);",
+					 BoardInfoHistoryTableName,
+					 BoardIDColumn, BoardNameColumn, BoardURLColumn];
+	SQLiteReservedQuery *query = [[SQLiteReservedQuery alloc] initWithQuery:sql
+															  usingSQLiteDB:[[DatabaseManager defaultManager] databaseForCurrentThread]];
+	for(BSBoardInformationObject *board in boards) {
+		[self updateTime];
+		NSUInteger boardID = [dm boardIDForURLString:board.boardURL];
+		for(BSBoardHistoryObject *hist in board.histories) {
+			[self updateTime];
+			[query cursorWithFormat:F_Int F_NSString F_NSString,
+			 boardID, hist.boardName, hist.boardURL];
+			[self loggingIfNeeded];
+		}
+	}
+	[query release];
 	
+	panel.amount = 0;
+	panel.count = 0;
+	[pool release];
 	[self updateTime];
+	
 	pool = [[NSAutoreleasePool alloc] init];
 	[self convertThreadsInBoards:boards];
 	panel.amount = 0;
@@ -210,21 +256,12 @@
 	[self updateTime];
 	
 	pool = [[NSAutoreleasePool alloc] init];
-	panel.message = @"Converting Favorites ...";
-	// Fav
-	DatabaseManager *dm = [DatabaseManager defaultManager];
-	NSArray *favs = [cdm fetchDataForEntityName:@"Favorite"
-									  predicate:nil];
-	for(BSFavoriteObject *fav in favs) {
-//		NSLog(@"%@", fav.thread.board.boardName);
-		NSUInteger boardID = [dm boardIDForURLString:fav.thread.board.boardURL];
-		SQLiteReservedQuery *query = [self sqlForInsertFav];
-		[query cursorWithFormat:F_Int F_NSNumberOfInt,
-		 boardID, fav.thread.threadID];
-	}
+	[self convertFavorites:cdm];
+	panel.amount = 0;
+	panel.count = 0;
+	[pool release];
 	
 finish:
-	[pool release];
 	[NSApp endModalSession:session];
 	[panel.window close];
 	[panel release];