X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=main.cc;h=407d572f8a9c46584e9713017e4ed65a0d4383c1;hb=412927c32bdfe547c74576319763f234b72d982d;hp=89c17429f0338f29891e8c5feb0f0cc4864d678b;hpb=ec3f8dcca4d2a3db11684ee48417890fd3b02ecb;p=backups%2F.git diff --git a/main.cc b/main.cc index 89c1742..407d572 100644 --- a/main.cc +++ b/main.cc @@ -2,6 +2,7 @@ #include #include #include +#include #include @@ -72,55 +73,58 @@ 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 backed_up; rc = sqlite3_exec( db, "select * from filedata;", populate_set, &backed_up, &sqliteErrMsg ); - if( SQLITE_OK != rc ) { - cerr << "Problem with database. Message is..." << endl; - cerr << sqliteErrMsg << endl; - } + assert( SQLITE_OK == rc ); - sqlite3_close( db ); - - for( file_set::iterator i = backed_up.begin(); i != backed_up.end(); ++i ) { - cout << (*i)->getFileName() << endl; - } + 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(), + file_set added; + set_difference( current.begin(), current.end(), backed_up.begin(), backed_up.end(), - inserter( new_set, new_set.begin() ), + inserter( added, added.begin() ), cmp ); file_set deleted; set_difference( backed_up.begin(), backed_up.end(), - current.begin(), current.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 ); + 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( new_set.begin(), new_set.end(), inserter( backup_list, backup_list.begin() ) ); + copy( added.begin(), added.end(), inserter( backup_list, backup_list.begin() ) ); - // backup all the already backed-up files that have changed since the last - // backup date. + // 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 ); @@ -129,10 +133,28 @@ int main() { // 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