still a bit off from a solid state... added fmdatabase, updated acidcow parser with a formate, added some standard stuff to piccast app delegate, created a section dictionary, did some serializing to/from db for topics, added a bunch of logic to topic view controller, added db table

1 files changed, 49 insertions, 4 deletions

diff --git a/PicCast.xcodeproj/project.pbxproj b/PicCast.xcodeproj/project.pbxproj
index e615bb9..f450738 100644
--- a/PicCast.xcodeproj/project.pbxproj
+++ b/PicCast.xcodeproj/project.pbxproj
@@ -31,9 +31,14 @@
 		4E68282F13594C48001EB808 /* Topic.m in Sources */ = {isa = PBXBuildFile; fileRef = 4E68282E13594C48001EB808 /* Topic.m */; };
 		4E68298B13596FB9001EB808 /* TopicTableViewCell.xib in Resources */ = {isa = PBXBuildFile; fileRef = 4E68298A13596FB9001EB808 /* TopicTableViewCell.xib */; };
 		4E6829F313597AF1001EB808 /* AsyncImageView.m in Sources */ = {isa = PBXBuildFile; fileRef = 4E6829F113597AF1001EB808 /* AsyncImageView.m */; };
-		4E759C46135DCC4D00171031 /* iAd.framework in Frameworks */ = {isa = PBXBuildFile; fileRef = 4E759C45135DCC4D00171031 /* iAd.framework */; };
+		4E8CFE9C136234CA00B810C6 /* PicCastSqlTable.db in Resources */ = {isa = PBXBuildFile; fileRef = 4E8CFE9B136234CA00B810C6 /* PicCastSqlTable.db */; };
 		4EA95FCB135CE8C3009243EE /* PhotoSource.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EA95FC9135CE8C3009243EE /* PhotoSource.m */; };
 		4EA95FD5135CE959009243EE /* PhotoViewController.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EA95FD4135CE959009243EE /* PhotoViewController.m */; };
+		4EB53ECA136359E3009A5AC5 /* FMDatabaseAdditions.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EB53EC3136359E3009A5AC5 /* FMDatabaseAdditions.m */; };
+		4EB53ECB136359E3009A5AC5 /* FMDatabase.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EB53EC5136359E3009A5AC5 /* FMDatabase.m */; };
+		4EB53ECC136359E3009A5AC5 /* FMResultSet.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EB53EC7136359E3009A5AC5 /* FMResultSet.m */; };
+		4EB53ED213635A22009A5AC5 /* libsqlite3.0.dylib in Frameworks */ = {isa = PBXBuildFile; fileRef = 4EB53ED113635A22009A5AC5 /* libsqlite3.0.dylib */; };
+		4EB53EE81363773B009A5AC5 /* SectionDictionary.m in Sources */ = {isa = PBXBuildFile; fileRef = 4EB53EE71363773B009A5AC5 /* SectionDictionary.m */; };
 		4EBFCAD51360D12C005AC5CC /* titleBarBackground.png in Resources */ = {isa = PBXBuildFile; fileRef = 4EBFCAD41360D12C005AC5CC /* titleBarBackground.png */; };
 		4EBFCB0B1360DDB5005AC5CC /* Default.png in Resources */ = {isa = PBXBuildFile; fileRef = 4EBFCB0A1360DDB5005AC5CC /* Default.png */; };
 		4EBFCB261360E0D2005AC5CC /* PicCast.512.png in Resources */ = {isa = PBXBuildFile; fileRef = 4EBFCB251360E0D2005AC5CC /* PicCast.512.png */; };
@@ -252,11 +257,21 @@
 		4E68298A13596FB9001EB808 /* TopicTableViewCell.xib */ = {isa = PBXFileReference; lastKnownFileType = file.xib; path = TopicTableViewCell.xib; sourceTree = "<group>"; };
 		4E6829F113597AF1001EB808 /* AsyncImageView.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = AsyncImageView.m; sourceTree = "<group>"; };
 		4E6829F213597AF1001EB808 /* AsyncImageView.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = AsyncImageView.h; sourceTree = "<group>"; };
-		4E759C45135DCC4D00171031 /* iAd.framework */ = {isa = PBXFileReference; lastKnownFileType = wrapper.framework; name = iAd.framework; path = System/Library/Frameworks/iAd.framework; sourceTree = SDKROOT; };
+		4E8CFE9B136234CA00B810C6 /* PicCastSqlTable.db */ = {isa = PBXFileReference; lastKnownFileType = file; path = PicCastSqlTable.db; sourceTree = "<group>"; };
 		4EA95FC9135CE8C3009243EE /* PhotoSource.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = PhotoSource.m; sourceTree = "<group>"; };
 		4EA95FCA135CE8C3009243EE /* PhotoSource.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = PhotoSource.h; sourceTree = "<group>"; };
 		4EA95FD3135CE959009243EE /* PhotoViewController.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = PhotoViewController.h; sourceTree = "<group>"; };
 		4EA95FD4135CE959009243EE /* PhotoViewController.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = PhotoViewController.m; sourceTree = "<group>"; };
+		4EB53EC2136359E3009A5AC5 /* FMDatabaseAdditions.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = FMDatabaseAdditions.h; sourceTree = "<group>"; };
+		4EB53EC3136359E3009A5AC5 /* FMDatabaseAdditions.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = FMDatabaseAdditions.m; sourceTree = "<group>"; };
+		4EB53EC4136359E3009A5AC5 /* FMDatabase.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = FMDatabase.h; sourceTree = "<group>"; };
+		4EB53EC5136359E3009A5AC5 /* FMDatabase.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = FMDatabase.m; sourceTree = "<group>"; };
+		4EB53EC6136359E3009A5AC5 /* FMResultSet.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = FMResultSet.h; sourceTree = "<group>"; };
+		4EB53EC7136359E3009A5AC5 /* FMResultSet.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = FMResultSet.m; sourceTree = "<group>"; };
+		4EB53EC8136359E3009A5AC5 /* fmdb_Prefix.pch */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = fmdb_Prefix.pch; sourceTree = "<group>"; };
+		4EB53ED113635A22009A5AC5 /* libsqlite3.0.dylib */ = {isa = PBXFileReference; lastKnownFileType = "compiled.mach-o.dylib"; name = libsqlite3.0.dylib; path = usr/lib/libsqlite3.0.dylib; sourceTree = SDKROOT; };
+		4EB53EE61363773B009A5AC5 /* SectionDictionary.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = SectionDictionary.h; sourceTree = "<group>"; };
+		4EB53EE71363773B009A5AC5 /* SectionDictionary.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = SectionDictionary.m; sourceTree = "<group>"; };
 		4EBFCAD41360D12C005AC5CC /* titleBarBackground.png */ = {isa = PBXFileReference; lastKnownFileType = image.png; path = titleBarBackground.png; sourceTree = "<group>"; };
 		4EBFCB0A1360DDB5005AC5CC /* Default.png */ = {isa = PBXFileReference; lastKnownFileType = image.png; path = Default.png; sourceTree = "<group>"; };
 		4EBFCB251360E0D2005AC5CC /* PicCast.512.png */ = {isa = PBXFileReference; lastKnownFileType = image.png; path = PicCast.512.png; sourceTree = SOURCE_ROOT; };
@@ -322,7 +337,7 @@
 				1D60589F0D05DD5A006BFB54 /* Foundation.framework in Frameworks */,
 				1DF5F4E00D08C38300B7A737 /* UIKit.framework in Frameworks */,
 				288765080DF74369002DB57D /* CoreGraphics.framework in Frameworks */,
-				4E759C46135DCC4D00171031 /* iAd.framework in Frameworks */,
+				4EB53ED213635A22009A5AC5 /* libsqlite3.0.dylib in Frameworks */,
 			);
 			runOnlyForDeploymentPostprocessing = 0;
 		};
@@ -332,6 +347,8 @@
 		080E96DDFE201D6D7F000001 /* Classes */ = {
 			isa = PBXGroup;
 			children = (
+				4EB53EBE136359D5009A5AC5 /* fmdb */,
+				4EB53E6513634D4E009A5AC5 /* Data Managers */,
 				4ECFB853135FD22C007FAB8D /* Cells */,
 				4ECFB7D4135FC4B0007FAB8D /* SourcesEditViewController.h */,
 				4ECFB7D5135FC4B0007FAB8D /* SourcesEditViewController.m */,
@@ -366,6 +383,7 @@
 		29B97314FDCFA39411CA2CEA /* PicCast */ = {
 			isa = PBXGroup;
 			children = (
+				4E8CFE9B136234CA00B810C6 /* PicCastSqlTable.db */,
 				4EBFCBBC1360F90A005AC5CC /* Default@2x.png */,
 				4EBFCB0A1360DDB5005AC5CC /* Default.png */,
 				080E96DDFE201D6D7F000001 /* Classes */,
@@ -414,7 +432,6 @@
 				1DF5F4DF0D08C38300B7A737 /* UIKit.framework */,
 				1D30AB110D05D00D00671497 /* Foundation.framework */,
 				288765070DF74369002DB57D /* CoreGraphics.framework */,
-				4E759C45135DCC4D00171031 /* iAd.framework */,
 			);
 			name = Frameworks;
 			sourceTree = "<group>";
@@ -502,10 +519,33 @@
 				4E6829F213597AF1001EB808 /* AsyncImageView.h */,
 				4E68282D13594C48001EB808 /* Topic.h */,
 				4E68282E13594C48001EB808 /* Topic.m */,
+				4EB53EE61363773B009A5AC5 /* SectionDictionary.h */,
+				4EB53EE71363773B009A5AC5 /* SectionDictionary.m */,
 			);
 			name = Objects;
 			sourceTree = "<group>";
 		};
+		4EB53E6513634D4E009A5AC5 /* Data Managers */ = {
+			isa = PBXGroup;
+			children = (
+			);
+			name = "Data Managers";
+			sourceTree = "<group>";
+		};
+		4EB53EBE136359D5009A5AC5 /* fmdb */ = {
+			isa = PBXGroup;
+			children = (
+				4EB53EC2136359E3009A5AC5 /* FMDatabaseAdditions.h */,
+				4EB53EC3136359E3009A5AC5 /* FMDatabaseAdditions.m */,
+				4EB53EC4136359E3009A5AC5 /* FMDatabase.h */,
+				4EB53EC5136359E3009A5AC5 /* FMDatabase.m */,
+				4EB53EC6136359E3009A5AC5 /* FMResultSet.h */,
+				4EB53EC7136359E3009A5AC5 /* FMResultSet.m */,
+				4EB53EC8136359E3009A5AC5 /* fmdb_Prefix.pch */,
+			);
+			name = fmdb;
+			sourceTree = "<group>";
+		};
 		4ECFB751135F8869007FAB8D /* Images */ = {
 			isa = PBXGroup;
 			children = (
@@ -777,6 +817,7 @@
 				4EBFCBB01360F8FE005AC5CC /* backgroundGradient@2x.png in Resources */,
 				4EBFCBB11360F8FE005AC5CC /* backgroundGradient.png in Resources */,
 				4EBFCBBD1360F90A005AC5CC /* Default@2x.png in Resources */,
+				4E8CFE9C136234CA00B810C6 /* PicCastSqlTable.db in Resources */,
 			);
 			runOnlyForDeploymentPostprocessing = 0;
 		};
@@ -809,6 +850,10 @@
 				4ECFB6D2135F5807007FAB8D /* AcidCowFeedburnerParser.m in Sources */,
 				4ECFB7D7135FC4B0007FAB8D /* SourcesEditViewController.m in Sources */,
 				4ECFB858135FD34B007FAB8D /* SourcesEditViewCell.m in Sources */,
+				4EB53ECA136359E3009A5AC5 /* FMDatabaseAdditions.m in Sources */,
+				4EB53ECB136359E3009A5AC5 /* FMDatabase.m in Sources */,
+				4EB53ECC136359E3009A5AC5 /* FMResultSet.m in Sources */,
+				4EB53EE81363773B009A5AC5 /* SectionDictionary.m in Sources */,
 			);
 			runOnlyForDeploymentPostprocessing = 0;
 		};