X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;ds=sidebyside;f=main.cc;fp=main.cc;h=dbd96a0c0f56b7fb3b947a3687ff1f43dfe6cb73;hb=b6878571e12b7d5de53721f12e8fb956d07e44d6;hp=b809f589e5d6381e8e8af3251772f27f1ede5e79;hpb=730dd480e7020e009ac5205693be92a71242fc06;p=backups%2F.git

diff --git a/main.cc b/main.cc
index b809f58..dbd96a0 100644
--- a/main.cc
+++ b/main.cc
@@ -4,6 +4,8 @@
 #include <vector>
 #include <algorithm>
 
+#include <sqlite3.h>
+
 using namespace std;
 
 vector<string> split( const string &line, char c, int limit = -1 ) {
@@ -25,18 +27,50 @@ 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;
+  return 0;
+}
+
+void sql_experimenting() {
+  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;
+  }
+
+  rc = sqlite3_exec( db, "select * from filedata;", callback, 0, &sqliteErrMsg );
+  if( SQLITE_OK != rc ) {
+    cerr << "Problem with database.  Message is..." << endl;
+    cerr << sqliteErrMsg << endl;
+  }
+
+  sqlite3_close( db );
+}
+
 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() );
+//   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();
 }