example/test_cxx.cpp

   1 //
   2
   3 #include "../sqlite3_helper.hpp"
   4 #include "test_cxx_gen.hpp"
   5 #include <boost/foreach.hpp>
   6 #include <iostream>
   7 #include <vector>
   8
   9 using namespace std;
  10
  11 typedef sqlgg<sqlite3_traits> gen;
  12
  13 /*
  14 void to_console(const wchar_t* s)
  15 {
  16   HANDLE console = GetStdHandle(STD_OUTPUT_HANDLE);
  17
  18   DWORD ignore;
  19   WriteConsoleW(console, s, wcslen(s), &ignore, NULL);
  20 }
  21
  22 void to_console(const std::wstring& s)
  23 {
  24    to_console(s.c_str());
  25 }
  26 */
  27
  28 void explain(char const* msg, sqlite3* db)
  29 {
  30   cout << msg << " : " /*<< sqlite3_errcode(db) << " "*/ << sqlite3_errmsg(db) << endl;
  31 }
  32
  33 int main()
  34 {
  35   sqlite3* db = NULL;
  36   int nResult = SQLITE_OK;
  37
  38   nResult = sqlite3_open("test.db", &db);
  39   explain("open",db);
  40
  41   nResult = sqlite3_exec(db,"DROP TABLE test;",NULL,NULL,NULL);
  42   explain("drop",db);
  43   nResult = sqlite3_exec(db,"DROP TABLE loc;",NULL,NULL,NULL);
  44   explain("drop",db);
  45   nResult = sqlite3_exec(db,"DROP TABLE zuzu;",NULL,NULL,NULL);
  46   explain("drop",db);
  47
  48   nResult = gen::create(db);
  49   explain("create",db);
  50
  51 /*
  52   gen::data_1 t;
  53   t.name="c++";
  54   t.descr="ugly";
  55   nResult = gen::Add(db,t);
  56   cout << "insert : " << nResult << " " << sqlite3_errmsg(db) << endl;
  57 */
  58   nResult = gen::Add(db,"c++","ugly");
  59   explain("insert",db);
  60
  61   nResult = gen::Add(db,"c","hard");
  62   explain("insert",db);
  63
  64   nResult = gen::Add(db,"ocaml","wonderful");
  65   explain("insert",db);
  66
  67   nResult = gen::Exaggerate(db,"really");
  68   explain("update",db);
  69
  70   std::vector<gen::data_1> all;
  71   nResult = gen::select_all(db,all);
  72   explain("select",db);
  73
  74   BOOST_FOREACH(gen::data_1 const& q, all)
  75   {
  76      std::cout << q.id << ") " << q.name << " is " << q.descr << std::endl;
  77   }
  78
  79   gen::create_loc(db);
  80   explain("create_loc",db);
  81
  82   nResult = gen::create_zuzu(db,"qq");
  83   explain("create_zuzu",db);
  84
  85   nResult = sqlite3_close(db);
  86   cout << "close : " << nResult << endl;
  87
  88   return 0;
  89 }