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
|
/* This file is part of the KDE project
Copyright (C) 2003-2004 Jaroslaw Staniek <js@iidea.pl>
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Library General Public
License as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Library General Public License for more details.
You should have received a copy of the GNU Library General Public License
along with this library; see the file COPYING.LIB. If not, write to
the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
* Boston, MA 02110-1301, USA.
*/
#ifndef TABLETEST_H
#define TABLETEST_H
int tablesTest()
{
if (dbCreationTest()!=0)
return 1;
if (!conn->useDatabase( db_name )) {
conn->debugError();
return 1;
}
conn->setAutoCommit(false);
KexiDB::Transaction t = conn->beginTransaction();
if (conn->error()) {
conn->debugError();
return 1;
}
//now: lets create tables:
KexiDB::Field *f;
KexiDB::TableSchema *t_persons = new KexiDB::TableSchema("persons");
t_persons->setCaption("Persons in our factory");
t_persons->addField( f=new KexiDB::Field("id", KexiDB::Field::Integer, KexiDB::Field::PrimaryKey | KexiDB::Field::AutoInc, KexiDB::Field::Unsigned) );
f->setCaption("ID");
t_persons->addField( f=new KexiDB::Field("age", KexiDB::Field::Integer, 0, KexiDB::Field::Unsigned) );
f->setCaption("Age");
t_persons->addField( f=new KexiDB::Field("name", KexiDB::Field::Text) );
f->setCaption("Name");
t_persons->addField( f=new KexiDB::Field("surname", KexiDB::Field::Text) );
f->setCaption("Surname");
if (!conn->createTable( t_persons )) {
conn->debugError();
return 1;
}
kdDebug() << "-- PERSONS created --" << endl;
t_persons->debug();
if (!conn->insertRecord(*t_persons, TQVariant(1), TQVariant(27), TQVariant("Jaroslaw"), TQVariant("Staniek"))
||!conn->insertRecord(*t_persons, TQVariant(2), TQVariant(60), TQVariant("Lech"), TQVariant("Walesa"))
||!conn->insertRecord(*t_persons, TQVariant(3), TQVariant(45), TQVariant("Bill"), TQVariant("Gates"))
||!conn->insertRecord(*t_persons, TQVariant(4), TQVariant(35), TQVariant("John"), TQVariant("Smith"))
)
{
kdDebug() << "-- PERSONS data err. --" << endl;
return 1;
}
kdDebug() << "-- PERSONS data created --" << endl;
KexiDB::TableSchema *t_cars = new KexiDB::TableSchema("cars");
t_cars->setCaption("Cars owned by persons");
t_cars->addField( f=new KexiDB::Field("id", KexiDB::Field::Integer, KexiDB::Field::PrimaryKey | KexiDB::Field::AutoInc, KexiDB::Field::Unsigned) );
f->setCaption("ID");
t_cars->addField( f=new KexiDB::Field("owner", KexiDB::Field::Integer, 0, KexiDB::Field::Unsigned) );
f->setCaption("Car owner");
t_cars->addField( f=new KexiDB::Field("model", KexiDB::Field::Text) );
f->setCaption("Car model");
if (!conn->createTable( t_cars )) {
conn->debugError();
return 1;
}
kdDebug() << "-- CARS created --" << endl;
if (!conn->insertRecord(*t_cars, TQVariant(1), TQVariant(1), TQVariant("Fiat"))
||!conn->insertRecord(*t_cars, TQVariant(2), TQVariant(2), TQVariant("Syrena"))
||!conn->insertRecord(*t_cars, TQVariant(3), TQVariant(3), TQVariant("Chrysler"))
||!conn->insertRecord(*t_cars, TQVariant(4), TQVariant(3), TQVariant("BMW"))
||!conn->insertRecord(*t_cars, TQVariant(5), TQVariant(4), TQVariant("Volvo"))
)
{
kdDebug() << "-- CARS data err. --" << endl;
return 1;
}
kdDebug() << "-- CARS data created --" << endl;
if (!conn->commitTransaction(t)) {
conn->debugError();
return 1;
}
kdDebug() << "NOW, TABLE LIST: " << endl;
TQStringList tnames = conn->tableNames();
for (TQStringList::iterator it = tnames.begin(); it!=tnames.end(); ++it) {
kdDebug() << " - " << (*it) << endl;
}
if (!conn->closeDatabase()) {
conn->debugError();
return 1;
}
return 0;
}
#endif
|
