#include <iostream>
#include <iterator>
-#include <string>
#include <vector>
#include <algorithm>
+#include <cassert>
#include <sqlite3.h>
+#include "filedata.hpp"
+
using namespace std;
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 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() );
+ }
}
- 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 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 );
+ }
}
- sqlite3_close( db );
-}
+ // Now, sort the backup_list by filesize and build a list of up to SIZE
-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, 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; }
}