1 files changed, 103 insertions, 0 deletions
diff --git a/reader/src/database/networkdb/NetworkDBQuery.cpp b/reader/src/database/networkdb/NetworkDBQuery.cpp
new file mode 100644
index 0000000..a8771cb
--- /dev/null
+++ b/reader/src/database/networkdb/NetworkDBQuery.cpp
@@ -0,0 +1,103 @@
+/*
+ * Copyright (C) 2004-2012 Geometer Plus <contact@geometerplus.com>
+ *
+ * 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 "NetworkDBQuery.h"
+
+const std::string NetworkDBQuery::INIT_DATABASE = \
+	"	CREATE TABLE IF NOT EXISTS Links( " \
+	"	link_id INTEGER PRIMARY KEY, " \
+	"	title TEXT NOT NULL, " \
+	"	site_name TEXT NOT NULL, " \
+	"	summary TEXT, " \
+	"	language TEXT, " \
+	"	predefined_id TEXT, " \
+	"	is_enabled INTEGER " \
+	"); " \
+	" " \
+	"CREATE TABLE IF NOT EXISTS LinkUrls( " \
+	"	key TEXT NOT NULL, " \
+	"	link_id INTEGER NOT NULL REFERENCES Links(link_id), " \
+	"	url TEXT, " \
+	"	update_time INTEGER, " \
+	"	CONSTRAINT LinkUrls_PK PRIMARY KEY (key, link_id) " \
+	"); ";
+
+const std::string NetworkDBQuery::CLEAR_DATABASE = \
+	"DROP TABLE Links; " \
+	"DROP TABLE LinkUrls; ";
+
+
+const std::string NetworkDBQuery::FIND_NETWORK_LINK_ID  = "SELECT link_id, predefined_id FROM Links WHERE site_name = @site_name; ";
+const std::string NetworkDBQuery::ADD_NETWORK_LINK  = \
+	"INSERT INTO Links (title, site_name, summary, language, predefined_id, is_enabled) " \
+	"	VALUES ( " \
+	"		@title, " \
+	"		@site_name, " \
+	"		@summary, " \
+	"		nullif(@language,\"\"), " \
+	"		nullif(@predefined_id,\"\"), " \
+	"		@is_enabled " \
+	"	); " \
+	" " \
+	"SELECT last_insert_rowid() AS link_id; ";
+
+const std::string NetworkDBQuery::DELETE_NETWORK_LINK  = \
+	"DELETE FROM Links WHERE link_id = @link_id; ";
+
+const std::string NetworkDBQuery::UPDATE_NETWORK_LINK  = \
+	"UPDATE Links SET " \
+	"	title = @title, " \
+	"	summary = @summary, " \
+	"	language = nullif(@language,\"\"), " \
+	"	predefined_id = nullif(@predefined_id,\"\"), " \
+	"	is_enabled = @is_enabled " \
+	"WHERE " \
+	"	link_id = @link_id; ";
+
+const std::string NetworkDBQuery::ADD_NETWORK_LINKURL  = \
+	"INSERT INTO LinkUrls (key, link_id, url, update_time) " \
+	"	VALUES ( " \
+	"		@key, " \
+	"		@link_id, " \
+	"		@url, " \
+	"		@update_time " \
+	"	); ";
+
+const std::string NetworkDBQuery::FIND_NETWORK_LINKURLS  = "SELECT key, url, update_time FROM LinkUrls WHERE link_id = @link_id; ";
+
+const std::string NetworkDBQuery::UPDATE_NETWORK_LINKURL  = \
+	"UPDATE LinkUrls SET " \
+	"	url = @url, " \
+	"	update_time = @update_time " \
+	"WHERE " \
+	"	link_id = @link_id AND key = @key; ";
+
+const std::string NetworkDBQuery::DELETE_NETWORK_LINKURLS  = \
+	"DELETE FROM LinkUrls " \
+	"WHERE " \
+	"	link_id = @link_id; ";
+
+const std::string NetworkDBQuery::DELETE_NETWORK_LINKURL  = \
+	"DELETE FROM LinkUrls " \
+	"WHERE " \
+	"	link_id = @link_id AND key = @key; ";
+
+const std::string NetworkDBQuery::LOAD_NETWORK_LINKS = "SELECT link_id, title, site_name, summary, language, predefined_id, is_enabled FROM Links; ";
+
+const std::string NetworkDBQuery::LOAD_NETWORK_LINKURLS = "SELECT key, url, update_time FROM LinkUrls WHERE link_id = @link_id; ";