+
+ QSqlQuery deleteBacklogQuery(logDb());
+ deleteBacklogQuery.prepare(queryString("delete_backlog_for_network"));
+ deleteBacklogQuery.bindValue(":networkid", networkId.toInt());
+ deleteBacklogQuery.exec();
+ if(!watchQuery(&deleteBacklogQuery)) {
+ if(withTransaction)
+ logDb().rollback();
+ return false;
+ }
+
+ QSqlQuery deleteBuffersQuery(logDb());
+ deleteBuffersQuery.prepare(queryString("delete_buffers_for_network"));
+ deleteBuffersQuery.bindValue(":networkid", networkId.toInt());
+ deleteBuffersQuery.exec();
+ if(!watchQuery(&deleteBuffersQuery)) {
+ if(withTransaction)
+ logDb().rollback();
+ return false;
+ }
+
+ QSqlQuery deleteServersQuery(logDb());
+ deleteServersQuery.prepare(queryString("delete_ircservers_for_network"));
+ deleteServersQuery.bindValue(":networkid", networkId.toInt());
+ deleteServersQuery.exec();
+ if(!watchQuery(&deleteServersQuery)) {
+ if(withTransaction)
+ logDb().rollback();
+ return false;
+ }
+
+ QSqlQuery deleteNetworkQuery(logDb());
+ deleteNetworkQuery.prepare(queryString("delete_network"));
+ deleteNetworkQuery.bindValue(":networkid", networkId.toInt());
+ deleteNetworkQuery.exec();
+ if(!watchQuery(&deleteNetworkQuery)) {
+ if(withTransaction)
+ logDb().rollback();
+ return false;
+ }
+
+ logDb().commit();
+ return true;
+}
+
+QList<NetworkInfo> SqliteStorage::networks(UserId user) {
+ QList<NetworkInfo> nets;
+
+ QSqlQuery networksQuery(logDb());
+ networksQuery.prepare(queryString("select_networks_for_user"));
+ networksQuery.bindValue(":userid", user.toInt());
+
+ QSqlQuery serversQuery(logDb());
+ serversQuery.prepare(queryString("select_servers_for_network"));
+
+ networksQuery.exec();
+ if(!watchQuery(&networksQuery))
+ return nets;
+
+ while(networksQuery.next()) {
+ NetworkInfo net;
+ net.networkId = networksQuery.value(0).toInt();
+ net.networkName = networksQuery.value(1).toString();
+ net.identity = networksQuery.value(2).toInt();
+ net.codecForServer = networksQuery.value(3).toString().toAscii();
+ net.codecForEncoding = networksQuery.value(4).toString().toAscii();
+ net.codecForDecoding = networksQuery.value(5).toString().toAscii();
+ net.useRandomServer = networksQuery.value(6).toInt() == 1 ? true : false;
+ net.perform = networksQuery.value(7).toString().split("\n");
+ net.useAutoIdentify = networksQuery.value(8).toInt() == 1 ? true : false;
+ net.autoIdentifyService = networksQuery.value(9).toString();
+ net.autoIdentifyPassword = networksQuery.value(10).toString();
+ net.useAutoReconnect = networksQuery.value(11).toInt() == 1 ? true : false;
+ net.autoReconnectInterval = networksQuery.value(12).toUInt();
+ net.autoReconnectRetries = networksQuery.value(13).toInt();
+ net.unlimitedReconnectRetries = networksQuery.value(14).toInt() == 1 ? true : false;
+ net.rejoinChannels = networksQuery.value(15).toInt() == 1 ? true : false;
+
+ serversQuery.bindValue(":networkid", net.networkId.toInt());
+ serversQuery.exec();
+ if(!watchQuery(&serversQuery))
+ return nets;
+
+ QVariantList servers;
+ while(serversQuery.next()) {
+ QVariantMap server;
+ server["Host"] = serversQuery.value(0).toString();
+ server["Port"] = serversQuery.value(1).toInt();
+ server["Password"] = serversQuery.value(2).toString();
+ server["UseSSL"] = serversQuery.value(3).toInt() == 1 ? true : false;
+ servers << server;
+ }
+ net.serverList = servers;
+ nets << net;
+ }
+ return nets;
+}
+
+bool SqliteStorage::isValidNetwork(UserId user, const NetworkId &networkId) {
+ QSqlQuery query(logDb());
+ query.prepare(queryString("select_networkExists"));
+ query.bindValue(":userid", user.toInt());
+ query.bindValue(":networkid", networkId.toInt());
+ query.exec();
+
+ watchQuery(&query); // there should not occur any errors
+ if(!query.first())
+ return false;
+
+ Q_ASSERT(!query.next());
+ return true;
+}
+
+bool SqliteStorage::isValidBuffer(const UserId &user, const BufferId &bufferId) {
+ QSqlQuery query(logDb());
+ query.prepare(queryString("select_bufferExists"));
+ query.bindValue(":userid", user.toInt());
+ query.bindValue(":bufferid", bufferId.toInt());
+ query.exec();
+
+ watchQuery(&query);
+ if(!query.first())
+ return false;
+
+ Q_ASSERT(!query.next());
+ return true;