X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=main.cc;h=407d572f8a9c46584e9713017e4ed65a0d4383c1;hb=412927c32bdfe547c74576319763f234b72d982d;hp=dbd96a0c0f56b7fb3b947a3687ff1f43dfe6cb73;hpb=b6878571e12b7d5de53721f12e8fb956d07e44d6;p=backups%2F.git diff --git a/main.cc b/main.cc index dbd96a0..407d572 100644 --- a/main.cc +++ b/main.cc @@ -1,11 +1,13 @@ #include #include -#include #include #include +#include #include +#include "filedata.hpp" + using namespace std; vector split( const string &line, char c, int limit = -1 ) { @@ -27,50 +29,140 @@ vector 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( 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 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 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; } }