-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.py
133 lines (103 loc) · 4.32 KB
/
database.py
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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
import sqlite3
from datetime import datetime
class Datenbank():
def __init__(self):
super().__init__()
self.connection = sqlite3.connect('datenbank.db')
self.handle = self.connection.cursor()
def read_all_comments(self):
self.handle.execute("SELECT url FROM comments")
list_= [list[0] for list in self.handle.fetchall()]
return list_
def find_comment(self,url_):
self.handle.execute("SELECT id,url FROM comments WHERE url=?",(url_,))
if self.handle.fetchone() != None:
return True
def delete_comment(self,url_):
self.handle.execute("DELETE FROM comments WHERE url=?",(url_,))
self.connection.commit()
def add_comment(self,url_):
self.handle.execute("INSERT INTO comments(url) VALUES(?)",(url_,))
self.connection.commit()
def read_all_likes(self):
self.handle.execute("SELECT url FROM likes")
list_= [list[0] for list in self.handle.fetchall()]
return list_
def find_like(self,url_):
self.handle.execute("SELECT id,url FROM likes WHERE url=?",(url_,))
if self.handle.fetchone() != None:
return True
def delete_like(self,url_):
self.handle.execute("DELETE FROM likes WHERE url=?",(url_,))
self.connection.commit()
def add_like(self,url_):
self.handle.execute("INSERT INTO likes(url) VALUES(?)",(url_,))
self.connection.commit()
def find_commentFeed(self,url_):
self.handle.execute("SELECT id,url FROM commentsFeed WHERE url=?",(url_,))
if self.handle.fetchone() != None:
return True
def delete_commentFeed(self,url_):
self.handle.execute("DELETE FROM commentsFeed WHERE url=?",(url_,))
self.connection.commit()
def add_commentFeed(self,url_):
self.handle.execute("INSERT INTO commentsFeed(url) VALUES(?)",(url_,))
self.connection.commit()
#datetime.now().strftime("%d-%m-%Y / %H:%M:%S")
def get_following(self,url_):
self.handle.execute("SELECT url,timestamp FROM following WHERE url=?",(url_,))
data = self.handle.fetchone()
if data != None:
return data
else:
return False
def get_all_following(self):
self.handle.execute("SELECT url,timestamp FROM following")
data = self.handle.fetchall()
if data != None:
return data
elif data == None:
return False
#list_= [list[0] for list in self.handle.fetchall()]
#return list_
def find_following(self,url_):
self.handle.execute("SELECT url,timestamp FROM following WHERE url=?",(url_,))
if self.handle.fetchone() != None:
return True
else:
return False
def delete_following(self,url_):
self.handle.execute("DELETE FROM following WHERE url=?",(url_,))
self.connection.commit()
def add_following(self,url_):
self.handle.execute("INSERT INTO following(url,timestamp) VALUES(?,?)",(url_,datetime.now().strftime("%d-%m-%Y / %H:%M:%S"),))
self.connection.commit()
def deleteCommentsToPosts(self):
self.handle.execute("DELETE FROM settings_comment")
self.connection.commit()
def addCommentsToPost(self,comments):
for comment_ in comments:
self.handle.execute("INSERT INTO settings_comment(comment) VALUES(?)",(comment_,))
self.connection.commit()
def getComments(self):
self.handle.execute("SELECT comment FROM settings_comment")
list_= [list[0] for list in self.handle.fetchall()]
return list_
def deleteHashtag(self):
self.handle.execute("DELETE FROM settings_hashtag")
self.connection.commit()
def addHashtags(self,hashtags):
for hashtag_ in hashtags:
self.handle.execute("INSERT INTO settings_hashtag(hashtag) VALUES(?)",(hashtag_,))
self.connection.commit()
def getHashtags(self):
self.handle.execute("SELECT hashtag FROM settings_hashtag")
list_= [list[0] for list in self.handle.fetchall()]
return list_
'''data = self.handle.fetchall()
if data != None:
data = list(data)
return data
else:
return False
'''