1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
#
# 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]
|