summaryrefslogtreecommitdiffstats
path: root/fbreader/src/database/networkdb/NetworkDBQuery.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'fbreader/src/database/networkdb/NetworkDBQuery.cpp')
-rw-r--r--fbreader/src/database/networkdb/NetworkDBQuery.cpp103
1 files changed, 0 insertions, 103 deletions
diff --git a/fbreader/src/database/networkdb/NetworkDBQuery.cpp b/fbreader/src/database/networkdb/NetworkDBQuery.cpp
deleted file mode 100644
index a8771cb..0000000
--- a/fbreader/src/database/networkdb/NetworkDBQuery.cpp
+++ /dev/null
@@ -1,103 +0,0 @@
-/*
- * 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; ";