example/test_cxx.cpp

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