X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=main.cc;h=9224f00747b7318796c13829ad0504751d79e33e;hb=aff63c3e49fca32e5249de441eb910912d2119dc;hp=dbd96a0c0f56b7fb3b947a3687ff1f43dfe6cb73;hpb=b6878571e12b7d5de53721f12e8fb956d07e44d6;p=backups%2F.git

diff --git a/main.cc b/main.cc
index dbd96a0..9224f00 100644
--- a/main.cc
+++ b/main.cc
@@ -1,11 +1,12 @@
 #include <iostream>
 #include <iterator>
-#include <string>
 #include <vector>
 #include <algorithm>
 
 #include <sqlite3.h>
 
+#include "filedata.hpp"
+
 using namespace std;
 
 vector<string> split( const string &line, char c, int limit = -1 ) {
@@ -27,50 +28,125 @@ 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;
+// Callback function for getting files from the database
+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() {
+int main() {
+  string file_string;
+
+  file_set current;
+
+  // Parse the list of files on stdin
+  do {
+    file_string.clear();
+    for( int c = cin.get(); 0 != c && ! cin.eof(); c = cin.get() ) {
+      file_string.push_back( c );
+    }
+    if( 0 != file_string.size() ) {
+      // Example entry
+      // type perms user group size datemodified name (7 total)
+      // f 0600 cnb cnb 424 20051015205340 ./.git/index
+      vector<string> vals = split( file_string, ' ', 7 );
+      current.insert( new FileData( vals[0][0],
+            vals[1],
+            vals[2],
+            vals[3],
+            atoi( vals[4].c_str() ),
+            atoi( vals[5].c_str() ),
+            vals[6]) );
+    }
+  } while( ! cin.eof() );
+
+  // Get the list of previously backed up files from the database.
   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;
+  int rc = sqlite3_open( dbname, &db );
+  assert( SQLITE_OK == rc );
+
+  char *sqliteErrMsg = 0;
+  file_set backed_up;
+  rc = sqlite3_exec( db, "select * from filedata;", populate_set, &backed_up, &sqliteErrMsg );
+  assert( SQLITE_OK == rc );
+
+  rc = sqlite3_close( db );
+  assert( SQLITE_OK == rc );
+
+  // Now divide the two sets into three sets (new, deleted and updated )
+  FileDataPtrCmp cmp;
+
+  file_set new_set;
+  set_difference( current.begin(),  current.end(),
+                  backed_up.begin(), backed_up.end(),
+                  inserter( new_set, new_set.begin() ),
+                  cmp );
+
+  file_set deleted;
+  set_difference( backed_up.begin(), backed_up.end(),
+                  current.begin(),  current.end(),
+                  inserter( deleted, deleted.begin() ),
+                  cmp );
+
+  // backed_up should *definitely* be the first set here
+  file_set updated;
+  set_difference( backed_up.begin(), backed_up.end(),
+                  current.begin(),  current.end(),
+                  inserter( updated, updated.begin() ),
+                  cmp );
+
+  // Now find the list of files to backup.
+  file_set backup_list;
+
+  // backup all new files
+  copy( new_set.begin(), new_set.end(), inserter( backup_list, backup_list.begin() ) );
+
+  // backup already backed-up files that have changed since the last backup date.
+  for( file_set::iterator i = updated.begin(); i != updated.end(); ++i ) {
+    if( (*i)->getLastBackupDate() < (*i)->getModifiedDate() ) {
+      backup_list.insert( *i );
+    }
   }
 
-  rc = sqlite3_exec( db, "select * from filedata;", callback, 0, &sqliteErrMsg );
-  if( SQLITE_OK != rc ) {
-    cerr << "Problem with database.  Message is..." << endl;
-    cerr << sqliteErrMsg << endl;
+  // Now, sort the backup_list by filesize and build a list of up to SIZE
+
+  // Now, sort the non-backed-up list my last_backup_date and back-fill
+
+  // Remove deleted files from the database.
+  const char *delete_sql = "delete from filedata where filename = :filename";
+  sqlite3_stmt *ppStmt;
+
+  sqlite3_prepare( db, delete_sql, -1, &ppStmt, NULL );
+  assert( NULL != ppStmt );
+
+  for( file_set::iterator i = deleted.begin(); i != deleted.end(); ++i ) {
+    const string &name = (*i)->getFileName();
+
+    rc = sqlite3_bind_text( ppStmt, 1, name.data(), name.size(), SQLITE_TRANSIENT );
+    assert( SQLITE_OK == rc );
+
+    rc = sqlite3_step( ppStmt );
+    assert( SQLITE_OK == rc );
   }
+  rc = sqlite3_finalize( ppStmt );
+  assert( SQLITE_OK == rc );
 
-  sqlite3_close( db );
-}
+  // Now, use the current set to update values in the database.  You should copy
+  // last_backup_date dates from the backed_up set first.  This will get all of
+  // the latest permissions but include the last_backup_date.
 
-int main() {
-//   string file_string;
-//   do {
-//     file_string.clear();
-//     for( int c = cin.get(); 0 != c && ! cin.eof(); c = cin.get() ) {
-//       file_string.push_back( c );
-//     }
-//     if( 0 != file_string.size() ) {
-//       // Example entry
-//       // type perms user group size datemodified name (7 total)
-//       // f 0600 cnb cnb 424 20051015205340 ./.git/index
-//       vector<string> values = split( file_string, ' ', 7 );
-//     }
-//   } while( ! cin.eof() );
-
-  sql_experimenting();
+  // Now, update the last_backup_date for all of the files that are in the list
+
+  // Clean-up
+  for( file_set::iterator i = backed_up.begin(); i != backed_up.end(); ++i ) { delete *i; }
+  for( file_set::iterator i = current.begin();   i != current.end();   ++i ) { delete *i; }
 }