---

database.h

Go to the documentation of this file.

/*
   This file is part of the KDB libraries
   Copyright (c) 2000 Praduroux Alessandro <pradu@thekompany.com>
 
   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., 59 Temple Place - Suite 330,
   Boston, MA 02111-1307, USA.
*/     
#ifndef DATABASE_H
#define DATABASE_H

#ifdef HAVE_CONFIG_H
#include <config.h>
#endif

#include <qstring.h>
#include <qstringlist.h>
#include <qlist.h>
#include <qvaluelist.h>

#include <ksharedptr.h>

#include <kdb/table.h>
#include <kdb/query.h>
#include <kdb/recordset.h>

#include "object.h"


namespace KDB {

class Connector;

class Database;
typedef QList<Database>         DatabaseList;
typedef QListIterator<Database> DatabaseIterator;

class Database : public Object{

    friend class Connection;

    Q_OBJECT

 public:

    Database(const Database & base);
    
    virtual ~Database();

    TablePtr newTable(const QString &name);

    TablePtr getTable(const QString &name);

    TableList tables(bool system = false);

    QStringList tableNames(bool system = false);
    
     bool removeTable(const QString &name);

    QueryPtr newQuery(const QString &name, const QString &SQL = QString::null);

    QueryPtr getQuery(const QString &name);
    
    QueryList queries();

    QStringList queryNames();

    bool removeQuery(const QString &name);

    RecordsetPtr openRecordset(const QString &SQL);

    unsigned long long execute(const QString &SQL);
    
    bool open();

    void close();

    bool isOpen();


 signals:

    void tableAdded( Table * );
    void tableRemoved( Table * );
    void tableChanged( Table * );
    void queryAdded( Query * );
    void queryRemoved( Query * );
    void queryChanged( Query * );
    void changed();
    void closed();
    void opened();

 protected slots:

    void tableCreated( Table * );

 private:

    Connector * connector;
    QStringList m_tables;
    QStringList m_queries;

    bool m_open;

    Database(Connector *conn,  const char * name, QObject *parent );

    void createQueryTable();

};

}

#endif

---