#include <iostream>
#include <iterator>
-#include <string>
#include <vector>
#include <algorithm>
-#include <set>
+#include <cassert>
#include <sqlite3.h>
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() {
- 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;
// Parse the list of files on stdin
do {
// 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_files.insert( new FileData( vals[0][0],
+ current.insert( new FileData( vals[0][0],
vals[1],
vals[2],
vals[3],
}
} 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 );
+ 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 added;
+ set_difference( current.begin(), current.end(),
+ backed_up.begin(), backed_up.end(),
+ inserter( added, added.begin() ),
+ cmp );
+
+ file_set deleted;
+ set_difference( backed_up.begin(), backed_up.end(),
+ current.begin(), current.end(),
+ inserter( deleted, deleted.begin() ),
+ cmp );
+
+ file_set updated;
+ set_union( current.begin(), current.end(),
+ backed_up.begin(), backed_up.end(),
+ inserter( updated, updated.begin() ),
+ cmp );
+
+ { // This little block will copy the last_backup_date from the second set to the first
+ file_set updated_mirror;
+ set_union( current.begin(), current.end(),
+ backed_up.begin(), backed_up.end(),
+ inserter( updated_mirror, updated_mirror.begin() ),
+ cmp );
+
+ // TODO Now we need to copy the last_backup_date from
+ file_set::iterator i = updated.begin(), j = updated_mirror.begin();
+ for( ; i != updated.end(); ++i, ++j ) {
+ (*i)->setLastBackupDate( (*j)->getLastBackupDate() );
+ }
+ }
+
+ // Now find the list of files to backup.
+ file_set backup_list;
+
+ // backup all new files
+ copy( added.begin(), added.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 );
+ }
+ }
+
+ // 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.
+ // TODO CNB You were working in here. Actually, just delete all records in
+ // the database and re-populate with the current list.
+ 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 );
+
+ // 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.
+
+ // 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; }
}