customedit.cpp

Go to the documentation of this file.

#include <qlayout.h>
#include <qpushbutton.h>
#include <qbuttongroup.h>
#include <qlabel.h>
#include <qcursor.h>
#include <qlistview.h>
#include <qdatetime.h>
#include <qapplication.h>
#include <qimage.h>
#include <qpainter.h>
#include <qheader.h>
#include <qsqldatabase.h>
#include <qhbox.h>

#include <unistd.h>

#include <iostream>
using namespace std;

#include "customedit.h"

#include "mythcontext.h"
#include "dialogbox.h"
#include "programinfo.h"
#include "proglist.h"
#include "scheduledrecording.h"
#include "recordingtypes.h"
#include "mythdbcon.h"

CustomEdit::CustomEdit(MythMainWindow *parent, const char *name,
                       ProgramInfo *pginfo)
              : MythDialog(parent, name)
{
    ProgramInfo *p = new ProgramInfo();

    if (pginfo)
    {
        delete p;
        p = pginfo;
    }

    QString baseTitle = p->title;
    baseTitle.remove(QRegExp(" \\(.*\\)$"));

    QString quoteTitle = baseTitle;
    quoteTitle.replace("\'","\'\'");

    prevItem = 0;
    maxex = 0;
    seSuffix = QString(" (%1)").arg(tr("stored search"));
    exSuffix = QString(" (%1)").arg(tr("stored example"));
    addString = tr("Add");

    QVBoxLayout *vbox = new QVBoxLayout(this, (int)(20 * wmult));

    QVBoxLayout *vkbox = new QVBoxLayout(vbox, (int)(1 * wmult));
    QHBoxLayout *hbox = new QHBoxLayout(vkbox, (int)(1 * wmult));

    // Edit selection
    hbox = new QHBoxLayout(vbox, (int)(10 * wmult));

    QString message = tr("Edit Rule") + ": ";
    QLabel *label = new QLabel(message, this);
    label->setBackgroundOrigin(WindowOrigin);
    label->setSizePolicy(QSizePolicy(QSizePolicy::Fixed, QSizePolicy::Fixed));
    hbox->addWidget(label);

    m_rule = new MythComboBox( false, this, "rule");
    m_rule->setBackgroundOrigin(WindowOrigin);

    m_rule->insertItem(tr("<New rule>"));
    m_recid   << "0";
    m_recsub  << "";
    m_recdesc << "";

    MSqlQuery result(MSqlQuery::InitCon());
    result.prepare("SELECT recordid, title, subtitle, description "
                   "FROM record WHERE search = :SEARCH ORDER BY title;");
    result.bindValue(":SEARCH", kPowerSearch);

    int titlematch = -1;
    if (result.exec() && result.isActive())
    {
        while (result.next())
        {
            QString trimTitle = QString::fromUtf8(result.value(1).toString());
            trimTitle.remove(QRegExp(" \\(.*\\)$"));

            m_rule->insertItem(trimTitle);
            m_recid   << result.value(0).toString();
            m_recsub  << QString::fromUtf8(result.value(2).toString());
            m_recdesc << QString::fromUtf8(result.value(3).toString());

            if (trimTitle == baseTitle ||
                result.value(0).toInt() == p->recordid)
                titlematch = m_rule->count() - 1;
        }
    }
    else
        MythContext::DBError("Get power search rules query", result);

    hbox->addWidget(m_rule);

    // Title edit box
    hbox = new QHBoxLayout(vbox, (int)(10 * wmult));

    message = tr("Rule Name") + ": ";
    label = new QLabel(message, this);
    label->setBackgroundOrigin(WindowOrigin);
    label->setSizePolicy(QSizePolicy(QSizePolicy::Fixed, QSizePolicy::Fixed));
    hbox->addWidget(label);

    m_title = new MythRemoteLineEdit( this, "title" );
    m_title->setBackgroundOrigin(WindowOrigin);
    hbox->addWidget(m_title);

    m_clause = new MythComboBox( false, this, "clause");
    m_clause->setBackgroundOrigin(WindowOrigin);

    m_clause->insertItem(tr("Match an exact title"));
    m_cfrom << "";
    if (p->title > "")
        m_csql << QString("program.title = '%1' ")
                          .arg(quoteTitle);
    else
        m_csql << "program.title = 'Nova' ";

    if (p->seriesid > "")
    {
        m_clause->insertItem(tr("Match this series"));
        m_cfrom << "";
        m_csql << QString("program.seriesid = '%1' ").arg(p->seriesid);
    }
    m_clause->insertItem(tr("Match words in the title"));
    m_cfrom << "";
    if (p->title > "")
        m_csql << QString("program.title LIKE '\%%1\%' ").arg(quoteTitle);
    else
        m_csql << "program.title LIKE 'CSI: %' ";

    m_clause->insertItem(tr("Match words in the subtitle"));
    m_cfrom << "";
    if (p->subtitle > "")
    {
        QString subt = p->subtitle;
        subt.replace("\'","\'\'");
        m_csql << QString("program.subtitle LIKE '\%%1\%' ").arg(subt);
    }
    else
        m_csql << "program.subtitle LIKE '%Las Vegas%' ";

    if (p->programid > "")
    {
        m_clause->insertItem(tr("Match this episode"));
        m_cfrom << "";
        m_csql << QString("program.programid = '%1' ").arg(p->programid);
    }
    else if (p->subtitle > "")
    {
        m_clause->insertItem(tr("Match this episode"));
        m_cfrom << "";
        m_csql << QString("program.subtitle = '%1' \n"
                          "AND program.description = '%2' ")
                          .arg(p->subtitle.replace("\'","\'\'"))
                          .arg(p->description.replace("\'","\'\'"));
    }
    else
    {
        m_clause->insertItem(tr("Match an exact episode"));
        m_cfrom << "";
        m_csql << QString("program.title = 'Seinfeld' \n"
                      "AND program.subtitle = 'The Soup' ");
    }
    m_clause->insertItem(tr("Match in any descriptive field"));
    m_cfrom << "";
    m_csql << QString("(program.title LIKE '%Japan%' \n"
                      "     OR program.subtitle LIKE '%Japan%' \n"
                      "     OR program.description LIKE '%Japan%') ");

    m_clause->insertItem(tr("New episodes only"));
    m_cfrom << "";
    m_csql << "program.previouslyshown = 0 ";

    m_clause->insertItem(tr("Exclude unidentified episodes"));
    m_cfrom << "";
    m_csql << "program.generic = 0 ";

    m_clause->insertItem(tr("First showing of each episode"));
    m_cfrom << "";
    m_csql << "program.first > 0 ";

    m_clause->insertItem(tr("Last showing of each episode"));
    m_cfrom << "";
    m_csql << "program.last > 0 ";

    m_clause->insertItem(tr("Anytime on a specific day of the week"));
    m_cfrom << "";
    m_csql << QString("DAYNAME(program.starttime) = '%1' ")
                      .arg(p->startts.toString("dddd"));

    m_clause->insertItem(tr("Only on weekdays (Monday through Friday)"));
    m_cfrom << "";
    m_csql << "WEEKDAY(program.starttime) < 5 ";

    m_clause->insertItem(tr("Only on weekends"));
    m_cfrom << "";
    m_csql << "WEEKDAY(program.starttime) >= 5 ";

    m_clause->insertItem(tr("Only in primetime"));
    m_cfrom << "";
    m_csql << QString("HOUR(program.starttime) >= 19 \n"
                      "AND HOUR(program.starttime) < 23 ");

    m_clause->insertItem(tr("Not in primetime"));
    m_cfrom << "";
    m_csql << QString("(HOUR(program.starttime) < 19 \n"
                      "      OR HOUR(program.starttime) >= 23) ");

    m_clause->insertItem(tr("Only on a specific station"));
    m_cfrom << "";
    if (p->chansign > "")
        m_csql << QString("channel.callsign = '%1' ").arg(p->chansign);
    else
        m_csql << "channel.callsign = 'ESPN' ";

    m_clause->insertItem(tr("Exclude one station"));
    m_cfrom << "";
    m_csql << "channel.callsign != 'GOLF' ";

    m_clause->insertItem(tr("Match related callsigns"));
    m_cfrom << "";
    m_csql << "channel.callsign LIKE 'HBO%' ";

    m_clause->insertItem(tr("Only on channels marked as favorites"));
    m_cfrom << ", favorites";
    m_csql << "program.chanid = favorites.chanid ";

    m_clause->insertItem(tr("Only channels from a specific video source"));
    m_cfrom << "";
    m_csql << "channel.sourceid = 2 ";

    m_clause->insertItem(tr("Only channels marked as commercial free"));
    m_cfrom << "";
    m_csql << "channel.commmethod = -2 ";

    m_clause->insertItem(tr("Only shows marked as HDTV"));
    m_cfrom << "";
    m_csql << "program.hdtv > 0 ";

    m_clause->insertItem(tr("Only shows marked as widescreen"));
    m_cfrom << "";
    m_csql << "FIND_IN_SET('WIDESCREEN', program.videoprop) > 0 ";

    m_clause->insertItem(tr("Exclude H.264 encoded streams (EIT only)"));
    m_cfrom << "";
    m_csql << "FIND_IN_SET('AVC', program.videoprop) = 0 ";

    m_clause->insertItem(tr("Limit by category"));
    m_cfrom << "";
    if (p->category > "")
        m_csql << QString("program.category = '%1' ").arg(p->category);
    else
        m_csql << "program.category = 'Reality' ";

    m_clause->insertItem(tr("All matches for a genre (Data Direct)"));
    m_cfrom << "LEFT JOIN programgenres ON "
               "program.chanid = programgenres.chanid AND "
               "program.starttime = programgenres.starttime ";
    if (p->category > "")
        m_csql << QString("programgenres.genre = '%1' ").arg(p->category);
    else
        m_csql << "programgenres.genre = 'Reality' ";

    m_clause->insertItem(tr("Limit by MPAA or VCHIP rating (Data Direct)"));
    m_cfrom << "LEFT JOIN programrating ON "
               "program.chanid = programrating.chanid AND "
               "program.starttime = programrating.starttime ";
    m_csql << "(programrating.rating = 'G' OR programrating.rating "
              "LIKE 'TV-Y%') ";

    m_clause->insertItem(QString(tr("Category type") +
            " ('movie', 'series', 'sports' " + tr("or") + " 'tvshow')"));
    m_cfrom << "";
    m_csql << "program.category_type = 'sports' ";

    m_clause->insertItem(tr("Limit movies by the year of release"));
    m_cfrom << "";
    m_csql << "program.category_type = 'movie' AND program.airdate >= 2000 ";

    m_clause->insertItem(tr("Minimum star rating (0.0 to 1.0 for movies only)"));
    m_cfrom << "";
    m_csql << "program.stars >= 0.75 ";

    m_clause->insertItem(tr("Person named in the credits (Data Direct)"));
    m_cfrom << ", people, credits";
    m_csql << QString("people.name = 'Tom Hanks' \n"
                      "AND credits.person = people.person \n"
                      "AND program.chanid = credits.chanid \n"
                      "AND program.starttime = credits.starttime ");

/*  This shows how to use oldprogram but is a bad idea in practice.
    This would match all future showings until the day after the first
    showing when all future showing are no longer 'new' titles.

    m_clause->insertItem(tr("Only titles from the New Titles list"));
    m_cfrom << "LEFT JOIN oldprogram ON oldprogram.oldtitle = program.title ";
    m_csql << "oldprogram.oldtitle IS NULL ";
*/

    m_clause->insertItem(tr("Multiple sports teams (complete example)"));
    m_cfrom << "";
    m_csql << QString("program.title = 'NBA Basketball' \n"
              "AND program.subtitle REGEXP '(Miami|Cavaliers|Lakers)' \n"
              "AND program.first > 0 \n");

    m_clause->insertItem(tr("Sci-fi B-movies (complete example)"));
    m_cfrom << "";
    m_csql << QString("program.category_type='movie' \n"
              "AND program.category='Science fiction' \n"
              "AND program.stars <= 0.5 AND program.airdate < 1970 ");

    m_clause->insertItem(tr("SportsCenter Overnight (complete example - use FindDaily)"));
    m_cfrom << "";
    m_csql << QString("program.title = 'SportsCenter' \n"
              "AND HOUR(program.starttime) >= 2 \n"
              "AND HOUR(program.starttime) <= 6 ");

    m_clause->insertItem(tr("Movie of the Week (complete example - use FindWeekly)"));
    m_cfrom << "";
    m_csql << QString("program.category_type='movie' \n"
              "AND program.stars >= 1.0 AND program.airdate >= 1965 \n"
              "AND DAYNAME(program.starttime) = 'Friday' \n"
              "AND HOUR(program.starttime) >= 12 ");

    m_clause->insertItem(tr("First Episodes (complete example for Data Direct)"));
    m_cfrom << "";
    m_csql << QString("program.first > 0 \n"
              "AND program.programid LIKE 'EP%0001' \n"
              "AND program.originalairdate = DATE(program.starttime) ");

    maxex = m_clause->count();

    result.prepare("SELECT rulename,fromclause,whereclause,search "
                  "FROM customexample;");

    if (result.exec() && result.isActive())
    {
        while (result.next())
        {
            QString str = QString::fromUtf8(result.value(0).toString());

            if (result.value(3).toInt() > 0)
                str += seSuffix;
            else
                str += exSuffix;

            m_clause->insertItem(str);
            m_cfrom << QString::fromUtf8(result.value(1).toString());
            m_csql << QString::fromUtf8(result.value(2).toString());
        }
    }
    vbox->addWidget(m_clause);

    //  Add Button
    m_addButton = new MythPushButton( this, "add" );
    m_addButton->setBackgroundOrigin(WindowOrigin);
    m_addButton->setText(addString);
    m_addButton->setEnabled(true);

    vbox->addWidget(m_addButton);

    // Subtitle edit box
    hbox = new QHBoxLayout(vbox, (int)(10 * wmult));

    message = tr("Additional Tables") + ": ";
    label = new QLabel(message, this);
    label->setBackgroundOrigin(WindowOrigin);
    label->setSizePolicy(QSizePolicy(QSizePolicy::Fixed, QSizePolicy::Fixed));
    hbox->addWidget(label);

    m_subtitle = new MythRemoteLineEdit(this, "subtitle" );
    m_subtitle->setBackgroundOrigin(WindowOrigin);
    hbox->addWidget(m_subtitle);

    // Description edit box
    m_description = new MythRemoteLineEdit(5, this, "description" );
    m_description->setBackgroundOrigin(WindowOrigin);
    vbox->addWidget(m_description);

    //  Test Button
    hbox = new QHBoxLayout(vbox, (int)(10 * wmult));

    m_testButton = new MythPushButton( this, "test" );
    m_testButton->setBackgroundOrigin(WindowOrigin);
    m_testButton->setText( tr( "Test" ) );
    m_testButton->setEnabled(false);

    hbox->addWidget(m_testButton);

    //  Record Button
    m_recordButton = new MythPushButton( this, "record" );
    m_recordButton->setBackgroundOrigin(WindowOrigin);
    m_recordButton->setText( tr( "Record" ) );
    m_recordButton->setEnabled(false);

    hbox->addWidget(m_recordButton);

    //  Store Button
    m_storeButton = new MythPushButton( this, "store" );
    m_storeButton->setBackgroundOrigin(WindowOrigin);
    m_storeButton->setText( tr( "Store" ) );
    m_storeButton->setEnabled(false);

    hbox->addWidget(m_storeButton);

    //  Cancel Button
    m_cancelButton = new MythPushButton( this, "cancel" );
    m_cancelButton->setBackgroundOrigin(WindowOrigin);
    m_cancelButton->setText( tr( "Cancel" ) );
    m_cancelButton->setEnabled(true);

    hbox->addWidget(m_cancelButton);

    connect(this, SIGNAL(dismissWindow()), this, SLOT(accept()));
     
    connect(m_rule, SIGNAL(activated(int)), this, SLOT(ruleChanged(void)));
    connect(m_rule, SIGNAL(highlighted(int)), this, SLOT(ruleChanged(void)));
    connect(m_title, SIGNAL(textChanged(void)), this, SLOT(textChanged(void)));
    connect(m_addButton, SIGNAL(clicked()), this, SLOT(addClicked()));
    connect(m_clause, SIGNAL(activated(int)), this, SLOT(clauseChanged(void)));
    connect(m_clause, SIGNAL(highlighted(int)), this, SLOT(clauseChanged(void)));
    connect(m_description, SIGNAL(textChanged(void)), this,
            SLOT(textChanged(void)));
    connect(m_testButton, SIGNAL(clicked()), this, SLOT(testClicked()));
    connect(m_recordButton, SIGNAL(clicked()), this, SLOT(recordClicked()));
    connect(m_storeButton, SIGNAL(clicked()), this, SLOT(storeClicked()));
    connect(m_cancelButton, SIGNAL(clicked()), this, SLOT(cancelClicked()));

    gContext->addListener(this);
    gContext->addCurrentLocation("CustomEdit");

    if (titlematch >= 0)
    {
        m_rule->setCurrentItem(titlematch);
        ruleChanged();
    }
    else if (p->title > "")
    {
        m_title->setText(baseTitle);
        m_subtitle->setText("");
        m_description->setText("program.title = '" + quoteTitle + "' ");
        textChanged();
    }

    if (m_title->text().isEmpty())
        m_rule->setFocus();
    else 
        m_clause->setFocus();

    clauseChanged();
}

CustomEdit::~CustomEdit(void)
{
    gContext->removeListener(this);
    gContext->removeCurrentLocation();
}

void CustomEdit::ruleChanged(void)
{
    int curItem = m_rule->currentItem();
    if (curItem == prevItem)
        return;

    prevItem = curItem;

    if (curItem > 0)
        m_title->setText(m_rule->currentText());
    else
        m_title->setText("");

    m_subtitle->setText(m_recsub[curItem]);
    m_description->setText(m_recdesc[curItem]);
    textChanged();
}

void CustomEdit::textChanged(void)
{
    bool hastitle = !m_title->text().isEmpty();
    bool hasdesc = !m_description->text().isEmpty();

    m_testButton->setEnabled(hasdesc);
    m_recordButton->setEnabled(hastitle && hasdesc);
    m_storeButton->setEnabled(m_clause->currentItem() >= maxex ||
                              (hastitle && hasdesc));
}

void CustomEdit::clauseChanged(void)
{
    QString msg = m_csql[m_clause->currentItem()];
    msg.replace("\n", " ");
    msg.replace(QRegExp(" [ ]*"), " ");
    msg = QString("%1: \"%2\"").arg(addString).arg(msg);
    if (msg.length() > 50)
    {
        msg.truncate(48);
        msg += "...\"";
    }
    m_addButton->setText(msg);

    bool hastitle = !m_title->text().isEmpty();
    bool hasdesc = !m_description->text().isEmpty();

    m_storeButton->setEnabled(m_clause->currentItem() >= maxex ||
                              (hastitle && hasdesc));
}

void CustomEdit::addClicked(void)
{
    QString clause = "";

    if (m_description->text().contains(QRegExp("\\S")))
        clause = "AND ";

    clause += m_csql[m_clause->currentItem()];
    m_description->append(clause);
    m_subtitle->append(m_cfrom[m_clause->currentItem()]);
}

void CustomEdit::testClicked(void)
{
    if (!checkSyntax())
    {
        m_testButton->setFocus();
        return;
    }

    ProgLister *pl = new ProgLister(plSQLSearch, m_description->text(), 
                                    m_subtitle->text(),
                                    gContext->GetMainWindow(), "proglist");
    pl->exec();
    delete pl;

    m_testButton->setFocus();
}

void CustomEdit::recordClicked(void)
{
    if (!checkSyntax())
    {
        m_recordButton->setFocus();
        return;
    }

    ScheduledRecording *record = new ScheduledRecording();

    int cur_recid = m_recid[m_rule->currentItem()].toInt();

    if (cur_recid > 0)
        record->modifyPowerSearchByID(cur_recid, m_title->text(),
                                      m_subtitle->text(),
                                      m_description->text()); 
    else
        record->loadBySearch(kPowerSearch, m_title->text(),
                             m_subtitle->text(), m_description->text());
    record->exec();

    if (record->getRecordID())
        accept();
    else
        m_recordButton->setFocus();

    record->deleteLater();
}

void CustomEdit::storeClicked(void)
{
    bool nameExists = false;
    QString oldwhere = "";

    MSqlQuery query(MSqlQuery::InitCon());
    query.prepare("SELECT rulename,whereclause FROM customexample "
                  "WHERE rulename = :RULE;");
    query.bindValue(":RULE", m_title->text());

    if (query.exec() && query.isActive() && query.next())
    {
        nameExists = true;
        oldwhere = QString::fromUtf8(query.value(1).toString());
    }
    QString msg = QString("%1: %2\n\n").arg(QObject::tr("Current Example"))
                                       .arg(m_title->text());

    if (m_subtitle->text() != "")
        msg += m_subtitle->text() + "\n\n";

    msg += m_description->text();

    DialogBox *storediag = new DialogBox(gContext->GetMainWindow(), msg);
    int button = 0, sebtn = -1, exbtn = -1, deletebtn = -1, cancelbtn = -1;

    QString action = QObject::tr("Store");
    if (nameExists)
        action = QObject::tr("Replace");

    QString str = QString("%1 \"%2\"").arg(action).arg(m_title->text());

    if (!m_title->text().isEmpty())
    {
        QString str2;
        str2 = QString("%1 %2").arg(str).arg(QObject::tr("as a search"));
        storediag->AddButton(str2);
        sebtn = button++;

        str2 = QString("%1 %2").arg(str).arg(QObject::tr("as an example"));
        storediag->AddButton(str2);
        exbtn = button++;
    }
    if (m_clause->currentItem() >= maxex)
    {
        str = QString("%1 \"%2\"").arg(QObject::tr("Delete"))
                                  .arg(m_clause->currentText());

        storediag->AddButton(str);
        deletebtn = button++;
    }
    storediag->AddButton(QObject::tr("Cancel"));
    cancelbtn = button++;

    DialogCode code = storediag->exec();
    int ret = MythDialog::CalcItemIndex(code);
    storediag->deleteLater();
    storediag = NULL;

    if (ret == sebtn || ret == exbtn)
    {
        // Store the current strings
        query.prepare("REPLACE INTO customexample "
                       "(rulename,fromclause,whereclause,search) "
                       "VALUES(:RULE,:FROMC,:WHEREC,:SEARCH);");
        query.bindValue(":RULE", m_title->text());
        query.bindValue(":FROMC", m_subtitle->text());
        query.bindValue(":WHEREC", m_description->text());
        query.bindValue(":SEARCH", ret == sebtn);

        if (!query.exec())
            MythContext::DBError("Store custom example", query);
        else if (nameExists)
        {
            // replace item
            unsigned i = maxex;
            while (i < m_csql.count())
            {
                if (m_csql[i] == oldwhere)
                {
                    m_cfrom[i] = m_subtitle->text();
                    m_csql[i] =  m_description->text();
                    break;
                }
                i++;
            }
        }
        else
        {
            // append item
            if (ret == sebtn)
                m_clause->insertItem(m_title->text() + seSuffix);
            else
                m_clause->insertItem(m_title->text() + exSuffix);
            m_cfrom << m_subtitle->text();
            m_csql << m_description->text();
        }
    }
    else if (ret == deletebtn)
    {
        query.prepare("DELETE FROM customexample "
                      "WHERE rulename = :RULE;");
        query.bindValue(":RULE", m_clause->currentText().remove(seSuffix)
                                                        .remove(exSuffix));
        if (!query.exec())
            MythContext::DBError("Delete custom example", query);
        else
        {
            // remove item
            unsigned i = m_clause->currentItem();
            m_clause->removeItem(i);
            i++;
            while (i < m_csql.count())
            {
                m_cfrom[i-1] = m_cfrom[i];
                m_csql[i-1]  = m_csql[i];
                i++;
            }
            m_cfrom.pop_back();
            m_csql.pop_back();
        }
    }
    clauseChanged();
    m_storeButton->setFocus();
}

void CustomEdit::cancelClicked(void)
{
    accept();
}

bool CustomEdit::checkSyntax(void)
{
    bool ret = false;
    QString msg = "";

    QString desc = m_description->text();
    QString from = m_subtitle->text();
    if (desc.contains(QRegExp("^\\s*AND\\s", false)))
    {
        msg = "Power Search rules no longer reqiure a leading \"AND\".";
    }
    else if (desc.contains(";", false))
    {
        msg  = "Power Search rules can not include semicolon ( ; ) ";
        msg += "statement terminators.";
    }
    else
    {
        MSqlQuery query(MSqlQuery::InitCon());
        query.prepare(QString("SELECT NULL FROM (program,channel) "
                              "%1 WHERE\n%2").arg(from).arg(desc));

        if (query.exec() && query.isActive())
        {
            ret = true;
        }
        else
        {
            msg = tr("An error was found when checking") + ":\n\n";
#if QT_VERSION >= 0x030200
            msg += query.executedQuery();
#else
            msg += query.lastQuery();
#endif
            msg += "\n\n" + tr("The database error was") + ":\n";
            msg += query.lastError().databaseText();
        }
    }

    if (!msg.isEmpty())
    {
        DialogBox *errdiag = new DialogBox(gContext->GetMainWindow(), msg);
        errdiag->AddButton(QObject::tr("OK"));
        errdiag->exec();

        errdiag->deleteLater();
        ret = false;
    }
    return ret;
}

---