#include <iterator>
#include <vector>
#include <algorithm>
+#include <cassert>
#include <sqlite3.h>
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 );
// 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