Maintenance/pruneserverinfo.cpp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

#include "maintenance.h"

int Maintenance::pruneServerInfo()
{
    QString deleteString = "DELETE FROM serverinfo "
                           "WHERE sid NOT IN ( "
                           "SELECT id FROM serverlist)";
    QSqlQuery deleteQuery;
    deleteQuery.prepare(deleteString);

    if ( ! deleteQuery.exec() )
        return reportQuery(deleteQuery);

    return deleteQuery.numRowsAffected();
}