1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
// file : hello/driver.cxx
// copyright : not copyrighted - public domain
#include <memory> // std::auto_ptr
#include <iostream>
#include <odb/database.hxx>
#include <odb/transaction.hxx>
#include "database.hxx" // create_database
#include "person.hxx"
#include "person-odb.hxx"
using namespace std;
using namespace odb::core;
int
main (int argc, char* argv[])
{
try
{
auto_ptr<database> db (create_database (argc, argv));
//person p[3];
std::vector<person> p (5, person ());
p[0].id = 1;
p[0].num = 1;
p[0].str = "aaa";
p[1].id = 2;
p[1].num = 2;
p[1].str = "bbb";
p[2].id = 3;
p[2].num = 3;
p[2].str = "ccc";
p[3].id = 4;
p[3].num = 4;
p[3].str = "ccc";
p[4].id = 5;
p[4].num = 5;
p[4].str = "ccc";
std::vector<person*> pp (5);
pp[0] = &p[0];
pp[1] = &p[1];
pp[2] = &p[2];
pp[3] = &p[3];
pp[4] = &p[4];
{
transaction t (db->begin ());
t.tracer (stderr_tracer);
//db->persist (p, p + 3);
//db->persist (p.begin (), p.end ());
try
{
db->persist (pp.begin (), pp.end ());
}
catch (const odb::multiple_exceptions& e)
{
if (!e.fatal ())
cerr << e.what () << endl;
else
throw;
}
cerr << pp[0]->id << endl
<< pp[1]->id << endl
<< pp[2]->id << endl
<< pp[3]->id << endl
<< pp[4]->id << endl;
t.commit ();
}
{
transaction t (db->begin ());
auto_ptr<person> p1 (db->find<person> (1));
auto_ptr<person> p2 (db->find<person> (2));
auto_ptr<person> p3 (db->find<person> (3));
auto_ptr<person> p4 (db->find<person> (4));
auto_ptr<person> p5 (db->find<person> (5));
if (p1.get ()) cerr << p1->id << " " << p1->num << " " << p1->str << endl;
if (p2.get ()) cerr << p2->id << " " << p2->num << " " << p2->str << endl;
if (p3.get ()) cerr << p3->id << " " << p3->num << " " << p3->str << endl;
if (p4.get ()) cerr << p4->id << " " << p4->num << " " << p4->str << endl;
if (p5.get ()) cerr << p5->id << " " << p5->num << " " << p5->str << endl;
t.commit ();
}
{
transaction t (db->begin ());
unsigned long ids[] = {
pp[0]->id,
pp[1]->id,
pp[2]->id,
pp[3]->id,
pp[4]->id,
123
};
db->erase<person> (ids, ids + sizeof (ids)/sizeof (ids[0]));
t.commit ();
}
}
catch (const odb::exception& e)
{
cerr << e.what () << endl;
return 1;
}
}
|
