#include <iostream>
+#include <iterator>
+#include <string>
+#include <vector>
#include <algorithm>
+#include <sqlite3.h>
+
using namespace std;
-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() ) {
- cout << file_string << endl;
+vector<string> split( const string &line, char c, int limit = -1 ) {
+ string::size_type start = 0, end = 0;
+
+ vector<string> out;
+ while( 0 != limit-- && end != line.size() ) {
+ if( 0 == limit ) {
+ end = line.size();
+ } else {
+ end = line.find( c, start );
+ if( end == string::npos ) {
+ end = line.size();
+ }
}
- } while( ! cin.eof() );
+ out.push_back( line.substr( start, end-start ) );
+ start = end + 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() );
+
+ sql_experimenting();
}