From 3c9f7ebe59658ae9e45267bf01782a0864c77d48 Mon Sep 17 00:00:00 2001
From: Carl N Baldwin <cnb@plane.(none)>
Date: Sun, 16 Oct 2005 21:57:51 -0600
Subject: [PATCH] It now reads both stdin and the database

---
 filedata.hpp |  3 +++
 main.cc      | 65 +++++++++++++++++++++++++++-------------------------
 2 files changed, 37 insertions(+), 31 deletions(-)

diff --git a/filedata.hpp b/filedata.hpp
index 123ef86..629f933 100644
--- a/filedata.hpp
+++ b/filedata.hpp
@@ -2,6 +2,7 @@
 #define FILEDATA_H
 
 #include <string>
+#include <set>
 
 class FileData {
   public:
@@ -45,4 +46,6 @@ class FileDataPtrCmp {
   std::less<std::string> cmp;
 };
 
+typedef std::set<FileData*,FileDataPtrCmp> file_set;
+
 #endif
diff --git a/main.cc b/main.cc
index 8ffd418..e07c7ee 100644
--- a/main.cc
+++ b/main.cc
@@ -1,9 +1,7 @@
 #include <iostream>
 #include <iterator>
-#include <string>
 #include <vector>
 #include <algorithm>
-#include <set>
 
 #include <sqlite3.h>
 
@@ -30,39 +28,22 @@ vector<string> split( const string &line, char c, int limit = -1 ) {
   return out;
 }
 
-int callback( void *NotUsed, int argc, char **argv, char **azColName ) {
-  int i;
-  for( int i = 0; i < argc; ++i ) {
-    cout << azColName[i] << " = " << ( argv[i] ? argv[i] : "NULL" ) << endl;
-  }
-  cout << endl;
+int populate_set( void *files_v, int, char **vals, char ** ) {
+  file_set *files = reinterpret_cast<file_set*>( files_v );
+  files->insert( new FileData( vals[0][0],
+        vals[1],
+        vals[2],
+        vals[3],
+        atoi( vals[4] ),
+        atoi( vals[5] ),
+        vals[6]) );
   return 0;
 }
 
-void sql_experimenting() {
-  sqlite3 *db;
-  char *sqliteErrMsg = 0;
-  int rc;
-
-  const char *dbname = "test.db";
-  rc = sqlite3_open( dbname, &db );
-  if( SQLITE_OK != rc ) {
-    cerr << "Cannot open database: " << dbname << ".  Error message is..." << endl;
-    cerr << sqlite3_errmsg(db) << endl;
-  }
-
-  rc = sqlite3_exec( db, "select * from filedata;", callback, 0, &sqliteErrMsg );
-  if( SQLITE_OK != rc ) {
-    cerr << "Problem with database.  Message is..." << endl;
-    cerr << sqliteErrMsg << endl;
-  }
-
-  sqlite3_close( db );
-}
-
 int main() {
   string file_string;
-  set<FileData*,FileDataPtrCmp> current_files;
+
+  file_set current_files;
 
   // Parse the list of files on stdin
   do {
@@ -85,5 +66,27 @@ int main() {
     }
   } while( ! cin.eof() );
 
-  set<FileData*,FileDataPtrCmp> previous_files;
+  // Get the list of previously backed up files from the database.
+  sqlite3 *db;
+
+  const char *dbname = "test.db";
+  int rc = sqlite3_open( dbname, &db );
+  if( SQLITE_OK != rc ) {
+    cerr << "Cannot open database: " << dbname << ".  Error message is..." << endl;
+    cerr << sqlite3_errmsg(db) << endl;
+  }
+
+  char *sqliteErrMsg = 0;
+  file_set previous_files;
+  rc = sqlite3_exec( db, "select * from filedata;", populate_set, &previous_files, &sqliteErrMsg );
+  if( SQLITE_OK != rc ) {
+    cerr << "Problem with database.  Message is..." << endl;
+    cerr << sqliteErrMsg << endl;
+  }
+
+  sqlite3_close( db );
+
+  for( file_set::iterator i = previous_files.begin(); i != previous_files.end(); ++i ) {
+    cout << (*i)->getFileName() << endl;
+  }
 }
-- 
2.34.1