X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=main.cc;h=407d572f8a9c46584e9713017e4ed65a0d4383c1;hb=412927c32bdfe547c74576319763f234b72d982d;hp=c930155cae77a6ec538d9f90511da1efd0ee3b1d;hpb=302830c3b46d571d80b378fe91060a4a29e87d63;p=backups%2F.git diff --git a/main.cc b/main.cc index c930155..407d572 100644 --- a/main.cc +++ b/main.cc @@ -2,6 +2,7 @@ #include #include #include +#include #include @@ -44,7 +45,7 @@ int populate_set( void *files_v, int, char **vals, char ** ) { int main() { string file_string; - file_set current_files; + file_set current; // Parse the list of files on stdin do { @@ -57,7 +58,7 @@ int main() { // type perms user group size datemodified name (7 total) // f 0600 cnb cnb 424 20051015205340 ./.git/index vector 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], @@ -72,44 +73,96 @@ int main() { 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; - } + assert( SQLITE_OK == rc ); 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 ); + file_set backed_up; + rc = sqlite3_exec( db, "select * from filedata;", populate_set, &backed_up, &sqliteErrMsg ); + assert( SQLITE_OK == rc ); - for( file_set::iterator i = previous_files.begin(); i != previous_files.end(); ++i ) { - cout << (*i)->getFileName() << endl; - } + rc = sqlite3_close( db ); + assert( SQLITE_OK == rc ); - // Now divide the two sets into three sets (union and set differences) + // Now divide the two sets into three sets (new, deleted and updated ) FileDataPtrCmp cmp; - file_set new_set; - set_difference( current_files.begin(), current_files.end(), - previous_files.begin(), previous_files.end(), - inserter( new_set, new_set.begin() ), + file_set added; + set_difference( current.begin(), current.end(), + backed_up.begin(), backed_up.end(), + inserter( added, added.begin() ), cmp ); - file_set deleted_set; - set_difference( previous_files.begin(), previous_files.end(), - current_files.begin(), current_files.end(), - inserter( deleted_set, deleted_set.begin() ), + file_set deleted; + set_difference( backed_up.begin(), backed_up.end(), + current.begin(), current.end(), + inserter( deleted, deleted.begin() ), cmp ); - // previous_files *should* definitely be the first set here - file_set common_set; - set_difference( previous_files.begin(), previous_files.end(), - current_files.begin(), current_files.end(), - inserter( common_set, common_set.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; } }