File indexing completed on 2024-04-21 15:30:21

 /* This file is part of the KDE project
    Copyright (C) 2003-2004 Jarosław Staniek <staniek@kde.org>
 
    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_P_H
 #define TABLETEST_P_H
 
 int tablesTest_createTables(KDbConnection *conn)
 {
     conn->setAutoCommit(false);
     KDbTransaction t = conn->beginTransaction();
     if (conn->result().isError()) {
         qDebug() << conn->result();
         return 1;
     }
 
     //now: lets create tables:
     KDbField *f;
     KDbTableSchema *t_persons = new KDbTableSchema("persons");
     t_persons->setCaption("Persons in our factory");
     t_persons->addField(f = new KDbField("id", KDbField::Integer, KDbField::PrimaryKey | KDbField::AutoInc, KDbField::Unsigned));
     f->setCaption("ID");
     t_persons->addField(f = new KDbField("age", KDbField::Integer, nullptr, KDbField::Unsigned));
     f->setCaption("Age");
     t_persons->addField(f = new KDbField("name", KDbField::Text));
     f->setCaption("Name");
     t_persons->addField(f = new KDbField("surname", KDbField::Text));
     f->setCaption("Surname");
     if (!conn->createTable(t_persons)) {
         qDebug() << conn->result();
         return 1;
     }
     qDebug() << "-- PERSONS created --";
     qDebug() << *t_persons;
 
     if (!conn->insertRecord(t_persons, QVariant(1), QVariant(27), QVariant("Jaroslaw"), QVariant("Staniek"))
             || !conn->insertRecord(t_persons, QVariant(2), QVariant(60), QVariant("Lech"), QVariant("Walesa"))
             || !conn->insertRecord(t_persons, QVariant(3), QVariant(45), QVariant("Bill"), QVariant("Gates"))
             || !conn->insertRecord(t_persons, QVariant(4), QVariant(35), QVariant("John"), QVariant("Smith"))
        ) {
         qDebug() << "-- PERSONS data err. --";
         return 1;
     }
     qDebug() << "-- PERSONS data created --";
 
 
     KDbTableSchema *t_cars = new KDbTableSchema("cars");
     t_cars->setCaption("Cars owned by persons");
     t_cars->addField(f = new KDbField("id", KDbField::Integer, KDbField::PrimaryKey | KDbField::AutoInc, KDbField::Unsigned));
     f->setCaption("ID");
     t_cars->addField(f = new KDbField("owner", KDbField::Integer, nullptr, KDbField::Unsigned));
     f->setCaption("Car owner");
     t_cars->addField(f = new KDbField("model", KDbField::Text));
     f->setCaption("Car model");
     if (!conn->createTable(t_cars)) {
         qDebug() << conn->result();
         return 1;
     }
     qDebug() << "-- CARS created --";
     if (!conn->insertRecord(t_cars, QVariant(1), QVariant(1), QVariant("Fiat"))
             || !conn->insertRecord(t_cars, QVariant(2), QVariant(2), QVariant("Syrena"))
             || !conn->insertRecord(t_cars, QVariant(3), QVariant(3), QVariant("Chrysler"))
             || !conn->insertRecord(t_cars, QVariant(4), QVariant(3), QVariant("BMW"))
             || !conn->insertRecord(t_cars, QVariant(5), QVariant(4), QVariant("Volvo"))
        )
     {
         qDebug() << "-- CARS data err. --";
         return 1;
     }
     qDebug() << "-- CARS data created --";
 
     if (!conn->commitTransaction(t)) {
         qDebug() << conn->result();
         return 1;
     }
 
     qDebug() << "NOW, TABLE LIST: ";
     QStringList tnames = conn->tableNames();
     for (QStringList::iterator it = tnames.begin(); it != tnames.end(); ++it) {
         qDebug() << " - " << (*it);
     }
     return 0;
 }
 
 #endif