src/UdpTasks/StatusChecker/serverinfoinsert.cpp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

#include "statuschecker.h"

bool StatusChecker::insertServerInfo(const QString        &serverAddress,
                                     const unsigned short &serverPort)
{
    // insert query string
    QSqlQuery q;
    QString insertString = "INSERT INTO serverinfo (sid) "
                           "SELECT id FROM serverlist "
                           "WHERE ip = :ip AND queryport = :queryport";

    // bind values and execute
    q.prepare(insertString);
    q.bindValue(":ip",        serverAddress);
    q.bindValue(":queryport", serverPort);

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

    // was a row updated?
    return (q.numRowsAffected() > 0);
}