-
Notifications
You must be signed in to change notification settings - Fork 73
/
test_db_validity.py
42 lines (32 loc) · 1.21 KB
/
test_db_validity.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
import sqlite3
import unittest
from whotracksme.data import load_tracker_db
class ValidateTrackerDatabase(unittest.TestCase):
conn = None
@classmethod
def setUpClass(cls):
cls.conn = load_tracker_db()
def test_db_has_trackers(self):
cur = self.conn.cursor()
cur.execute('SELECT COUNT(*) FROM trackers')
count = cur.fetchone()[0]
self.assertGreater(count, 0)
def test_db_has_companies(self):
cur = self.conn.cursor()
cur.execute('SELECT COUNT(*) FROM companies')
count = cur.fetchone()[0]
self.assertGreater(count, 0)
def test_db_has_tracker_domains(self):
cur = self.conn.cursor()
cur.execute('SELECT COUNT(*) FROM tracker_domains')
count = cur.fetchone()[0]
self.assertGreater(count, 0)
def test_no_trackers_without_domain(self):
cur = self.conn.cursor()
cur.execute('SELECT COUNT(DISTINCT tracker) FROM tracker_domains')
domain_tracker_count = cur.fetchone()[0]
cur.execute('SELECT COUNT(*) FROM trackers')
tracker_count = cur.fetchone()[0]
self.assertEqual(domain_tracker_count, tracker_count)
if __name__ == '__main__':
unittest.main()