books.hpp

Go to the documentation of this file.

#ifndef BOOKS_HPP
#define BOOKS_HPP

#include <QObject>
#include <QWidget>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlRelationalTableModel>
#include <QSqlRecord>
#include <QSqlField>
#include <QSqlError>

#include "globals.hpp"

class QSqlField;
class QSqlRecord;
class QSqlQuery;
class QSqlError;
class QSqlDatabase;
class QSqlRelationalTableModel;

class Books : public QObject
{
    Q_OBJECT
    Q_PROPERTY(quint32 err READ getLastErr)        
    Q_PROPERTY(QString errmsg READ getLastErrMsg)  

public:
    explicit Books(QObject *parent=0);
    ~Books();

    quint32 getLastErr()    { return err; }
    QString getLastErrMsg() { return errmsg; }

    bool save(BooksRecord rec);

    bool del(BooksRecord rec);

    bool update(BooksRecord rec);

    quint32 findLastID();

    BooksRecord findBooksRecord(BooksRecord rec);

    QSqlQuery findBookTitle(QString title);

    QSqlQuery findAll();

    QSqlQuery findAllBooksByAuth(int id);

    QSqlQuery findID(quint32 id);

    QSqlQuery findAllBooksByTitle();

    QSqlQuery findAllBooksByAuthor(QString auth);

    QSqlQuery findAllBooksGrpAuth(QString auth);

    BooksRecord getBooksRec(int id);

    bool dupchk(BooksRecord *rec);

private:
    quint32 err;

    QString errmsg;

    QSqlDatabase db;
};

#endif // BOOKS_HPP