diff options
Diffstat (limited to 'geo-replication/syncdaemon/changelogsdb.py')
-rw-r--r-- | geo-replication/syncdaemon/changelogsdb.py | 111 |
1 files changed, 0 insertions, 111 deletions
diff --git a/geo-replication/syncdaemon/changelogsdb.py b/geo-replication/syncdaemon/changelogsdb.py deleted file mode 100644 index 7e64158e7af..00000000000 --- a/geo-replication/syncdaemon/changelogsdb.py +++ /dev/null @@ -1,111 +0,0 @@ -# -# Copyright (c) 2016 Red Hat, Inc. <http://www.redhat.com> -# This file is part of GlusterFS. - -# This file is licensed to you under your choice of the GNU Lesser -# General Public License, version 3 or any later version (LGPLv3 or -# later), or the GNU General Public License, version 2 (GPLv2), in all -# cases as published by the Free Software Foundation. -# - -import os -import sqlite3 -from errno import ENOENT - -conn = None -cursor = None - - -def db_commit(): - conn.commit() - - -def db_init(db_path): - global conn, cursor - # Remove Temp Db - try: - os.unlink(db_path) - os.unlink(db_path + "-journal") - except OSError as e: - if e.errno != ENOENT: - raise - - conn = sqlite3.connect(db_path) - cursor = conn.cursor() - cursor.execute("DROP TABLE IF EXISTS data") - cursor.execute("DROP TABLE IF EXISTS meta") - query = """CREATE TABLE IF NOT EXISTS data( - gfid VARCHAR(100) PRIMARY KEY ON CONFLICT IGNORE, - changelog_time VARCHAR(100) - )""" - cursor.execute(query) - - query = """CREATE TABLE IF NOT EXISTS meta( - gfid VARCHAR(100) PRIMARY KEY ON CONFLICT IGNORE, - changelog_time VARCHAR(100) - )""" - cursor.execute(query) - - -def db_record_data(gfid, changelog_time): - query = "INSERT INTO data(gfid, changelog_time) VALUES(?, ?)" - cursor.execute(query, (gfid, changelog_time)) - - -def db_record_meta(gfid, changelog_time): - query = "INSERT INTO meta(gfid, changelog_time) VALUES(?, ?)" - cursor.execute(query, (gfid, changelog_time)) - - -def db_remove_meta(gfid): - query = "DELETE FROM meta WHERE gfid = ?" - cursor.execute(query, (gfid, )) - - -def db_remove_data(gfid): - query = "DELETE FROM data WHERE gfid = ?" - cursor.execute(query, (gfid, )) - - -def db_get_data(start, end, limit, offset): - query = """SELECT gfid FROM data WHERE changelog_time - BETWEEN ? AND ? LIMIT ? OFFSET ?""" - cursor.execute(query, (start, end, limit, offset)) - out = [] - for row in cursor: - out.append(row[0]) - - return out - - -def db_get_meta(start, end, limit, offset): - query = """SELECT gfid FROM meta WHERE changelog_time - BETWEEN ? AND ? LIMIT ? OFFSET ?""" - cursor.execute(query, (start, end, limit, offset)) - out = [] - for row in cursor: - out.append(row[0]) - - return out - - -def db_delete_meta_if_exists_in_data(): - query = """ - DELETE FROM meta WHERE gfid in - (SELECT M.gfid - FROM meta M INNER JOIN data D - ON M.gfid = D.gfid) - """ - cursor.execute(query) - - -def db_get_data_count(): - query = "SELECT COUNT(gfid) FROM data" - cursor.execute(query) - return cursor.fetchone()[0] - - -def db_get_meta_count(): - query = "SELECT COUNT(gfid) FROM meta" - cursor.execute(query) - return cursor.fetchone()[0] |