提交: 6d5e0b2407690367272c4c561672826efb89b653 - BSDBViewer (git)

BathyScapheのSQLiteデータベース内を覗くアプリ

Commit MetaInfo

• 修订版: 6d5e0b2407690367272c4c561672826efb89b653 (tree)
• 时间: 2008-06-20 21:33:20
• 作者: masakih <masakih@user...>
• Commiter: masakih

Log Message

BSDBViewer.[h|m]
BathyScapheで開く機能を付けた。
Info.plist
versionを1.1にup

git-svn-id: svn+ssh://macmini/usr/local/svnrepos/BSDBViewer/BSDBViewer@11 477addb1-df5c-4826-a637-c2b1bdcd60d4

更改概述

• modified: BSDBViewer.h
• modified: BSDBViewer.m
• modified: BSDBViewer.xcodeproj/project.pbxproj
• modified: Info.plist

差异

--- a/BSDBViewer.h
+++ b/BSDBViewer.h
@@ -13,6 +13,8 @@
     IBOutlet id threadView;
 	
 	int progressStack;
+	
+	NSMutableDictionary *boardNameCache;
 }
 
 + (SQLiteDB *)sqliteDB;

--- a/BSDBViewer.m
+++ b/BSDBViewer.m
@@ -85,6 +85,14 @@ final:
 	return resolveAlias(res);
 }
 
++ (NSString *)BSDocumentFolder
+{
+	id res = [self BSSupportFolder];
+	
+	res = [res stringByAppendingPathComponent:@"Documents"];
+	
+	return resolveAlias(res);
+}
 + (NSString *)databasePath
 {
 	id res = [self BSSupportFolder];
@@ -118,6 +126,19 @@ final:
 	return [[self class] sqliteDB];
 }
 
+- (NSString *)nameOfBathyScaphe
+{
+	NSUserDefaults *d = [NSUserDefaults standardUserDefaults];
+	
+	NSString *bundleID = [d stringForKey:@"OpenApplicationBundleID"];
+	if(!bundleID) return @"BathyScaphe";
+	
+	NSWorkspace *w = [NSWorkspace sharedWorkspace];
+	NSString *app = [w absolutePathForAppBundleWithIdentifier:bundleID];
+	if(!app) return @"BathyScaphe";
+	
+	return [app lastPathComponent];
+}
 #pragma mark-
 - (void)setInProgress:(BOOL)new
 {
@@ -139,7 +160,71 @@ final:
 	progressStack--;
 	[self didChangeValueForKey:InProgressKey];
 }
+
 #pragma mark-
+- (NSString *)boardNameFromBoardID:(id)boardID
+{
+	NSString *result = [boardNameCache objectForKey:boardID];
+	if(result) return result;
+	
+	NSString *query = [NSString stringWithFormat:@"SELECT boardname FROM boardInfo "
+					   @"WHERE boardid = %@"
+					   ,
+					   boardID];
+	
+	SQLiteDB *db = [self sqliteDB];
+	id cursor;
+	if([db beginTransaction]) {
+		cursor = [db cursorForSQL:query];
+		if([db lastErrorID] != 0) {
+			NSLog(@"Fail Sending Query: %@", query);
+			NSLog(@"SQLite Error: %@", [db lastError]);
+		}
+		[db commitTransaction];
+	}
+	
+	NSString *boardName = [cursor valueForColumn:@"boardname" atRow:0];
+	if(!boardName) return nil;
+	
+	[boardNameCache setObject:boardName forKey:boardID];
+	
+	return boardName;
+}
+- (NSString *)pathForThreadID:(id)threadID boardID:(id)boardID
+{
+	if(!threadID || !boardID) return nil;
+	
+	NSString *path = [[self class] BSDocumentFolder];
+	
+	NSString *boardName = [self boardNameFromBoardID:boardID];
+	if(!boardName) {
+		NSLog(@"Can not find boardName from boardID(%@).", boardID);
+		return nil;
+	}
+	path = [path stringByAppendingPathComponent:boardName];
+	path = [path stringByAppendingPathComponent:threadID];
+	path = [path stringByAppendingPathExtension:@"thread"];
+	
+	return path;
+}
+- (void) openInBSThreadID:(id)threadID boardID:(id)boardID
+{
+	[[NSWorkspace sharedWorkspace] openFile:[self pathForThreadID:threadID boardID:boardID]
+							withApplication:[self nameOfBathyScaphe]];
+}
+
+- (void)openThreadsInBS:(NSArray *)infos
+{
+	id enume = [infos objectEnumerator];
+	id obj;
+	id targetBoardID = [threadSource boardID];
+	
+	while(obj = [enume nextObject]) {
+		id threadID = [obj objectForKey:@"threadid"];
+		if(!threadID) continue;
+		[self openInBSThreadID:threadID boardID:targetBoardID];
+	}
+}
 - (void)deleteThreadInformations:(NSArray *)infos
 {
 	NSString *query = 
@@ -208,7 +293,11 @@ final:
 }
 - (IBAction)openInBathyScaphe:(id)sender
 {
+	NSArray *infos = [self targetObjectsInTableView:threadView arrayController:threadArrayController];
 	
+	[self performSelector:@selector(openThreadsInBS:)
+			   withObject:infos
+			   afterDelay:0.0];
 }
 
 #pragma mark-
@@ -242,7 +331,20 @@ final:
 - (BOOL)validateMenuItem:(NSMenuItem *)menuItem
 {
 	if(@selector(showThreadInfo:) == [menuItem action]) return NO;
-	if(@selector(openInBathyScaphe:) == [menuItem action]) return NO;
+	
+	if(@selector(openInBathyScaphe:) == [menuItem action]) {
+		id selection = [self targetObjectsInTableView:threadView
+									  arrayController:threadArrayController];
+		if([selection count] != 1) return NO;
+		
+		NSString *path = [self pathForThreadID:[[selection objectAtIndex:0] objectForKey:@"threadid"]
+									   boardID:[threadSource boardID]];
+		if(!path) return NO;
+		
+		BOOL isDir = NO;
+		if(![[NSFileManager defaultManager] fileExistsAtPath:path isDirectory:&isDir]
+		   || isDir) return NO;
+	}
 	
 	return YES;
 }

--- a/BSDBViewer.xcodeproj/project.pbxproj
+++ b/BSDBViewer.xcodeproj/project.pbxproj
@@ -146,9 +146,9 @@
 				F46C0F040DFFFF3000C1CDCC /* UTILDescription.h */,
 				F46C0F050DFFFF3000C1CDCC /* UTILError.h */,
 				F46C0F060DFFFF3000C1CDCC /* UTILKit.h */,
-				F46C0E8E0DFD72C600C1CDCC /* SQLiteDB.m */,
-				F46C0E8F0DFD72C600C1CDCC /* SQLiteDB.h */,
 				F46C0E900DFD72C600C1CDCC /* sqlite3.h */,
+				F46C0E8F0DFD72C600C1CDCC /* SQLiteDB.h */,
+				F46C0E8E0DFD72C600C1CDCC /* SQLiteDB.m */,
 			);
 			name = "External Sources";
 			sourceTree = "<group>";

--- a/Info.plist
+++ b/Info.plist
@@ -17,7 +17,7 @@
 	<key>CFBundlePackageType</key>
 	<string>APPL</string>
 	<key>CFBundleShortVersionString</key>
-	<string>1.0.1</string>
+	<string>1.1</string>
 	<key>CFBundleSignature</key>
 	<string>????</string>
 	<key>CFBundleVersion</key>