database/sqlite3.cpp

   1 #include <iostream>
   2 #include <string>
   3 #include <fstream>
   4 #include <sqlite3.h>
   5 #include <sstream>
   6
   7 using std::cout;
   8 using std::string;
   9 using std::ifstream;
  10 using std::stringstream;
  11 using std::endl;
  12
  13
  14 /*static int callback(void *NotUsed, int argc, char ** argv, char **azColName)
  15 {
  16    return 0;
  17 }*/
  18
  19 int main(int argc, char **argv)
  20 {
  21    sqlite3 *db;
  22    char *zErrMsg = 0;
  23    int rc;
  24    char line[1024];
  25    ifstream sqlite_script;
  26    string query;
  27
  28    if (argc >= 1 && argc < 3)
  29    {
  30       cout << "usage: querydb <database> <sqlite_script>\n";
  31       return 0;
  32    }
  33
  34
  35    query = "";
  36    sqlite_script.open(argv[2]);
  37    while (!sqlite_script.eof())
  38    {
  39       sqlite_script.getline(line,1024);
  40       query += string(line) + "\n";
  41    }
  42
  43    sqlite_script.close();
  44
  45    rc = sqlite3_open(argv[1], &db);
  46    rc = sqlite3_exec(db, query.c_str(), 0, 0, &zErrMsg);
  47
  48    if (rc > 0)
  49    {
  50       cout << "Error " << rc << endl;
  51       cout << sqlite3_errmsg(db);
  52       cout << endl;
  53    }
  54    else
  55       cout << "Ok." << endl;
  56
  57    sqlite3_close(db);
  58
  59    return 0;
  60 }