KDbSqlResult.h

/* This file is part of the KDE project
   Copyright (C) 2016 Jarosław Staniek <[email protected]>
 
   This program 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 program 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 program; see the file COPYING.  If not, write to
   the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
*/
 
#ifndef KDB_SQLRESULT_H
#define KDB_SQLRESULT_H
 
#include "kdb_export.h"
#include <QSharedPointer>
#include <QString>
 
class KDbConnection;
class KDbField;
class KDbRecordData;
class KDbResult;
class KDbSqlField;
class KDbSqlRecord;
 
/**
 * The KDbSqlResult class abstracts result of a raw SQL query preparation by KDbConnection::prepareSql()
 *
 * The KDbSqlResult object provides low-level access to information about fields of the result and
 * can fetch records by actual execution of the prepared query.
 *
 * @note the KDbSqlResult object should be deleted before closing the database connection that
 * created it. This is needed because the connection is used by the object to retrieve data or to
 * obtain status information.
 */
class KDB_EXPORT KDbSqlResult
{
public:
    KDbSqlResult();
 
    virtual ~KDbSqlResult();
 
    //! @return connection for this result
    virtual KDbConnection *connection() const { return nullptr; }
 
    //! @return number of fields in this result
    virtual int fieldsCount() = 0;
 
    //! @return field @a index from this result
    virtual KDbSqlField *field(int index) /*Q_REQUIRED_RESULT*/ = 0;
 
    //! Creates a KDb field for field @a index and returns it
    //! On failure returns @c nullptr.
    //! @a tableName is the table name and may be used to retrieve information but may
    //! be ignored as well if the KDbSqlResult already has field metadata available.
    virtual KDbField* createField(const QString &tableName, int index) /*Q_REQUIRED_RESULT*/ = 0;
 
    /**
     * Fetches one record.
     *
     * @return a shared pointer to the record or a null pointer if there is no record to fetch or
     * on error.
     * Check lastResult() for detailed result. Ownership is transferred to the caller.
     */
    virtual QSharedPointer<KDbSqlRecord> fetchRecord() /*Q_REQUIRED_RESULT*/ = 0;
 
    //! Convenience method. Fetches one record and all values into @a data.
    //! @return record data object and passes its ownership
    //! @c nullptr is returned on error or when there is no record to fetch.
    //! Check lastResult() for errors.
    Q_REQUIRED_RESULT KDbRecordData *fetchRecordData();
 
    //! @return result of last operation on this SQL result
    virtual KDbResult lastResult() = 0;
 
    /*! @return unique identifier of the most recently inserted record.
     Typically this is just primary key value. This identifier could be reused when we want
     to reference just inserted record. If there was no insertion recently performed for
     the result, std::numeric_limits<quint64>::max() is returned. */
    virtual quint64 lastInsertRecordId() { return std::numeric_limits<quint64>::max(); }
private:
    Q_DISABLE_COPY(KDbSqlResult)
};
 
#endif