demo/demo_cxx.cpp

   1 #include "../impl/sqlite3_traits.hpp" // sqlite3 traits
   2 #include "demo_cxx_gen.hpp" // generated
   3 #include <iostream>
   4 #include <vector>
   5
   6 using namespace std;
   7
   8 typedef sqlgg<sqlite3_traits> gen_t;
   9 typedef long long int64;
  10
  11 struct output_transfers
  12 {
  13   void operator()(std::string const& fullname, int total)
  14   {
  15      cout << fullname << " = " << total << endl;
  16   }
  17 };
  18
  19 struct output_donors
  20 {
  21   void operator()(std::string const& surname)
  22   {
  23      cout << surname << endl;
  24   }
  25 };
  26
  27 int main()
  28 {
  29   sqlite3* db = NULL;
  30   sqlite3_open(":memory:", &db);
  31
  32   gen_t gen(db);
  33
  34   // create tables
  35   gen.create_person();
  36   gen.create_money();
  37
  38   // add all person records
  39   gen.add_person("John","Black");
  40   int64 john = sqlite3_last_insert_rowid(db);
  41   gen.add_person("Ivan","Petrov");
  42   int64 ivan = sqlite3_last_insert_rowid(db);
  43   gen.add_person("Sancho","Alvares");
  44   int64 sancho = sqlite3_last_insert_rowid(db);
  45
  46   // add money relations
  47   gen.add_money(john,ivan,200);
  48   gen.add_money(john,sancho,100);
  49   gen.add_money(john,sancho,250);
  50   gen.add_money(sancho,ivan,300);
  51
  52   // summarize by person
  53   cout << "Total transfers:" << endl;
  54   gen.calc_total(output_transfers());
  55
  56   // list donors
  57   cout << "Donors:" << endl;
  58   gen.list_donors("petrov",100,output_donors());
  59
  60   // properly close database
  61   sqlite3_close(db);
  62
  63   return 0;
  64 }