aextsql.h

/****************************************************************************
** $Id: aextsql.h,v 1.2 2007/09/10 08:47:58 app Exp $
**
** Header file of the Report Result Object of Ananas
** Designer and Engine applications
**
** Created : 20070819
**
** Copyright (C) 2005-2007 Grigory Panov <grigory.panov at gmail.com>, Moscow.
** Copyright (C) 2005-2007 Ananas Project.
**
** This file is part of the Library of the Ananas
** automation accounting system.
**
** This file may be distributed and/or modified under the terms of the
** GNU General Public License version 2 as published by the Free Software
** Foundation and appearing in the file LICENSE.GPL included in the
** packaging of this file.
**
** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
**
** See http://www.leaderit.ru/page=ananas or email sales@leaderit.ru
** See http://www.leaderit.ru/gpl/ for GPL licensing information.
**
** Contact org@leaderit.ru if any conditions of this licensing are
** not clear to you.
**
**********************************************************************/
#ifndef AEXTSQL_H
#define AEXTSQL_H


#include <qobject.h>
#include <qsqlselectcursor.h>
#include "adatabase.h"
#include "aextension.h"
#include "aobject.h"

class ANANAS_EXPORT aExtSQL: public AExtension
{
        Q_OBJECT
public:
        aExtSQL();
        virtual int init( aDatabase *database );
        ~aExtSQL();
private:
        QSqlSelectCursor *cursor;
public slots:
        QSqlSelectCursor *      Cursor() const;
        QVariant                Value(int col) const;
        int                     Size() const;
        int                     Count() const;
        bool                    ExecQuery( const QString & query);
        QVariant                ExecScalar( const QString & query);
        bool                    First();
        bool                    Next();
        bool                    Last();
        bool                    Prev();
        QString                 SqlFieldName(aObject * obj, const QString & userFieldName, const QString &tableType="") const;
        QString                 SqlTableName(aObject * obj, const QString &tableType="") const;
        QString                 SqlTableName(const QString & objName) const;
        QString                 SqlFieldName(const QString & fieldName) const;
        QString                 LastError() const;
};

#endif

---