/
db.py
39 lines (30 loc) · 1.1 KB
/
db.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
from tinydb import TinyDB, Query
import re
class DB:
def __init__(self,db_path):
self.db = TinyDB(db_path)
def add(self, data):
# Only add it if you can't find it
Track = Query()
if not self.db.get(Track.display_id == data['display_id']):
return self.db.insert(data)
def searchById(self, video_id):
Track = Query()
return self.db.get(Track.display_id == video_id)
def search(self, text):
pattern = re.compile(text,re.IGNORECASE)
def test(txt):
return pattern.search(txt)
Track = Query()
q = Track.title.test(test) | Track.description.test(test)
return self.db.search(q)
def all(self):
return self.db.all()
if __name__ == "__main__":
db = DB('/tmp/test.json')
db.add({'display_id':'123', 'tags':['a', 'abc', 'xyz'], 'title': 'num'})
db.add({'display_id':'dumbledore', 'tags':['harry'], 'title': 'Hello HP'})
assert not db.searchById('123') == None
assert db.searchById('456') == None
assert len(db.search('minerva')) == 0
assert len(db.search('HP')) == 1