1 files changed, 0 insertions, 138 deletions
diff --git a/fbreader/src/database/networkdb/runnables/SaveNetworkLinkRunnable.cpp b/fbreader/src/database/networkdb/runnables/SaveNetworkLinkRunnable.cpp
deleted file mode 100644
index 4c80499..0000000
--- a/fbreader/src/database/networkdb/runnables/SaveNetworkLinkRunnable.cpp
+++ /dev/null
@@ -1,138 +0,0 @@
-/*
- * Copyright (C) 2009-2012 Geometer Plus <[email protected]>
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
- * 02110-1301, USA.
- */
-
-#include "../DBRunnables.h"
-#include "../../../network/NetworkLink.h"
-#include "../../sqldb/implsqlite/SQLiteFactory.h"
-
-SaveNetworkLinkRunnable::SaveNetworkLinkRunnable(DBConnection &connection) {
-	myFindNetworkLinkId = SQLiteFactory::createCommand(NetworkDBQuery::FIND_NETWORK_LINK_ID, connection, "@site_name", DBValue::DBTEXT);
-	myAddNetworkLink    = SQLiteFactory::createCommand(NetworkDBQuery::ADD_NETWORK_LINK, connection, "@title", DBValue::DBTEXT, "@site_name", DBValue::DBTEXT, "@summary", DBValue::DBTEXT, "@language", DBValue::DBTEXT, "@predefined_id", DBValue::DBTEXT, "@is_enabled", DBValue::DBINT);
-	myUpdateNetworkLink    = SQLiteFactory::createCommand(NetworkDBQuery::UPDATE_NETWORK_LINK, connection, "@title", DBValue::DBTEXT, "@summary", DBValue::DBTEXT, "@language", DBValue::DBTEXT, "@predefined_id", DBValue::DBTEXT, "@is_enabled", DBValue::DBINT, "@link_id", DBValue::DBINT);
-
-	myFindNetworkLinkUrls = SQLiteFactory::createCommand(NetworkDBQuery::FIND_NETWORK_LINKURLS, connection, "@link_id", DBValue::DBINT);
-	myAddNetworkLinkUrl    = SQLiteFactory::createCommand(NetworkDBQuery::ADD_NETWORK_LINKURL, connection, "@key", DBValue::DBTEXT, "@link_id", DBValue::DBINT, "@url", DBValue::DBTEXT, "@update_time", DBValue::DBINT);
-	myUpdateNetworkLinkUrl    = SQLiteFactory::createCommand(NetworkDBQuery::UPDATE_NETWORK_LINKURL, connection, "@key", DBValue::DBTEXT, "@link_id", DBValue::DBINT, "@url", DBValue::DBTEXT, "@update_time", DBValue::DBINT);
-	myDeleteNetworkLinkUrl    = SQLiteFactory::createCommand(NetworkDBQuery::DELETE_NETWORK_LINKURL, connection, "@key", DBValue::DBTEXT, "@link_id", DBValue::DBINT);
-}
-
-bool SaveNetworkLinkRunnable::run() {
-	if (myNetworkLink.isNull()) {
-		return false;
-	}
-	((DBTextValue &) *myFindNetworkLinkId->parameter("@site_name").value()) = myNetworkLink->getSiteName();
-	shared_ptr<DBDataReader> reader = myFindNetworkLinkId->executeReader();
-	if (reader.isNull() || !reader->next()) {
-		return addNetworkLink();
-	} else if (myNetworkLink->isPredefined()) {
-		return updateNetworkLink(reader->intValue(0)) && updateNetworkLinkUrls(reader->intValue(0));
-	} else {
-		//TODO implement for custom links
-		return false;
-	}
-	return false;
-}
-
-bool SaveNetworkLinkRunnable::addNetworkLink() {
-	((DBTextValue &) *myAddNetworkLink->parameter("@title").value()) = myNetworkLink->getTitle();
-	((DBTextValue &) *myAddNetworkLink->parameter("@site_name").value()) = myNetworkLink->getSiteName();
-	((DBTextValue &) *myAddNetworkLink->parameter("@summary").value()) = myNetworkLink->getSummary();
-	((DBTextValue &) *myAddNetworkLink->parameter("@language").value()) = myNetworkLink->getLanguage();
-	((DBTextValue &) *myAddNetworkLink->parameter("@predefined_id").value()) = myNetworkLink->getPredefinedId();
-	((DBIntValue &) *myAddNetworkLink->parameter("@is_enabled").value()) = myNetworkLink->isEnabled();
-	shared_ptr<DBValue> dbLinkId = myAddNetworkLink->executeScalar();
-	if (dbLinkId.isNull() || dbLinkId->type() != DBValue::DBINT || ((DBIntValue &) *dbLinkId).value() == 0) {
-		return false;
-	}
-
-	bool allExecuted = true;
-	std::map<std::string,std::string> tempLinks = myNetworkLink->getLinks();
-	if (myNetworkLink->getIcon() != std::string()) {
-		tempLinks["icon"] = myNetworkLink->getIcon();
-	}
-	long t = 0;
-	if (myNetworkLink->getUpdated() != 0) {
-		t = myNetworkLink->getUpdated()->getLongSeconds_stupid();
-	}
-	for (std::map<std::string,std::string>::iterator it = tempLinks.begin(); it != tempLinks.end(); ++it) {
-		((DBTextValue &) *myAddNetworkLinkUrl->parameter("@key").value()) = it->first;
-		((DBTextValue &) *myAddNetworkLinkUrl->parameter("@url").value()) = it->second;
-		((DBIntValue &) *myAddNetworkLinkUrl->parameter("@link_id").value()) = ((DBIntValue &) *dbLinkId).value();
-		((DBIntValue &) *myAddNetworkLinkUrl->parameter("@update_time").value()) = t;
-		allExecuted = allExecuted && myAddNetworkLinkUrl->execute();
-	}
-	return allExecuted;
-}
-
-bool SaveNetworkLinkRunnable::updateNetworkLink(int linkId) {
-	((DBTextValue &) *myUpdateNetworkLink->parameter("@title").value()) = myNetworkLink->getTitle();
-	((DBTextValue &) *myUpdateNetworkLink->parameter("@summary").value()) = myNetworkLink->getSummary();
-	((DBTextValue &) *myUpdateNetworkLink->parameter("@language").value()) = myNetworkLink->getLanguage();
-	((DBTextValue &) *myUpdateNetworkLink->parameter("@predefined_id").value()) = myNetworkLink->getPredefinedId();
-	((DBIntValue &) *myUpdateNetworkLink->parameter("@is_enabled").value()) = myNetworkLink->isEnabled();
-	((DBIntValue &) *myUpdateNetworkLink->parameter("@link_id").value()) = linkId;
-
-	return myUpdateNetworkLink->execute();
-}
-
-bool SaveNetworkLinkRunnable::updateNetworkLinkUrls(int linkId) {
-	bool allExecuted = true;
-	((DBIntValue &) *myFindNetworkLinkUrls->parameter("@link_id").value()) = linkId;
-	shared_ptr<DBDataReader> reader = myFindNetworkLinkUrls->executeReader();
-	std::map<std::string,std::string> linksToCheck = myNetworkLink->getLinks();
-	if (!myNetworkLink->getIcon().empty()) {
-		linksToCheck["icon"] = myNetworkLink->getIcon();
-	}
-	long t = 0;
-	if (!myNetworkLink->getUpdated().isNull()) {
-		t = myNetworkLink->getUpdated()->getLongSeconds_stupid();
-	}
-	while (reader->next()) {
-		if (reader->type(0) != DBValue::DBTEXT || reader->type(1) != DBValue::DBTEXT) {
-			return false;
-		}
-		std::string key = reader->textValue(0, std::string());
-//		std::string url = reader->textValue(1, std::string());
-		if (linksToCheck.count(key) == 0) {
-			((DBTextValue &) *myDeleteNetworkLinkUrl->parameter("@key").value()) = key;
-			((DBIntValue &) *myDeleteNetworkLinkUrl->parameter("@link_id").value()) = linkId;
-			allExecuted = allExecuted && myDeleteNetworkLinkUrl->execute();
-		} else {
-			((DBTextValue &) *myUpdateNetworkLinkUrl->parameter("@key").value()) = key;
-			((DBTextValue &) *myUpdateNetworkLinkUrl->parameter("@url").value()) = linksToCheck[key];
-			((DBIntValue &) *myUpdateNetworkLinkUrl->parameter("@link_id").value()) = linkId;
-			((DBIntValue &) *myUpdateNetworkLinkUrl->parameter("@update_time").value()) = t;
-			linksToCheck.erase(key);
-			allExecuted = allExecuted && myUpdateNetworkLinkUrl->execute();
-		}
-	}
-
-	for (std::map<std::string,std::string>::iterator it = linksToCheck.begin(); it != linksToCheck.end(); ++it) {
-		((DBTextValue &) *myAddNetworkLinkUrl->parameter("@key").value()) = it->first;
-		((DBTextValue &) *myAddNetworkLinkUrl->parameter("@url").value()) = it->second;
-		((DBIntValue &) *myAddNetworkLinkUrl->parameter("@link_id").value()) = linkId;
-		((DBIntValue &) *myAddNetworkLinkUrl->parameter("@update_time").value()) = t;
-		allExecuted = allExecuted && myAddNetworkLinkUrl->execute();
-	}
-	return allExecuted;
-}
-
-void SaveNetworkLinkRunnable::setNetworkLink(shared_ptr<NetworkLink> link) {
-	myNetworkLink = link;
-}