LEFT | RIGHT |
1 # coding: utf-8 | 1 # coding: utf-8 |
2 | 2 |
3 # This file is part of the Adblock Plus web scripts, | 3 # This file is part of the Adblock Plus web scripts, |
4 # Copyright (C) 2006-2015 Eyeo GmbH | 4 # Copyright (C) 2006-2015 Eyeo GmbH |
5 # | 5 # |
6 # Adblock Plus is free software: you can redistribute it and/or modify | 6 # Adblock Plus is free software: you can redistribute it and/or modify |
7 # it under the terms of the GNU General Public License version 3 as | 7 # it under the terms of the GNU General Public License version 3 as |
8 # published by the Free Software Foundation. | 8 # published by the Free Software Foundation. |
9 # | 9 # |
10 # Adblock Plus is distributed in the hope that it will be useful, | 10 # Adblock Plus is distributed in the hope that it will be useful, |
11 # but WITHOUT ANY WARRANTY; without even the implied warranty of | 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of |
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
13 # GNU General Public License for more details. | 13 # GNU General Public License for more details. |
14 # | 14 # |
15 # You should have received a copy of the GNU General Public License | 15 # You should have received a copy of the GNU General Public License |
16 # along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>. | 16 # along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>. |
17 | 17 |
18 import unittest | 18 import unittest |
19 import MySQLdb | |
20 from datetime import datetime | 19 from datetime import datetime |
| 20 |
| 21 from sitescripts.filterhits.test import test_helpers |
21 from sitescripts.filterhits import db, geometrical_mean | 22 from sitescripts.filterhits import db, geometrical_mean |
22 | 23 |
23 test_data = [{ | 24 test_data = [{ |
24 "filters": { | 25 "filters": { |
25 "##.top-box-right-ad": { | 26 "##.top-box-right-ad": { |
26 "firstParty": { | 27 "firstParty": { |
27 "acxiom-online.com": { "hits": 6, "latest": 1414817340948 }, | 28 "acxiom-online.com": { "hits": 6, "latest": 1414817340948 }, |
28 "google.com": { "hits": 50, "latest": 1414849084678 }, | 29 "google.com": { "hits": 50, "latest": 1414849084678 }, |
29 "yahoo.com": { "hits": 14, "latest": 1414859271125 }, | 30 "yahoo.com": { "hits": 14, "latest": 1414859271125 }, |
30 "doubleclick.net": { "hits": 26, "latest": 1414823430333 } | 31 "doubleclick.net": { "hits": 26, "latest": 1414823430333 } |
(...skipping 28 matching lines...) Expand all Loading... |
59 }, | 60 }, |
60 "stevedeace.com##.topAddHolder": { | 61 "stevedeace.com##.topAddHolder": { |
61 "firstParty": { | 62 "firstParty": { |
62 "mathtag.com": { "hits": 14, "latest": 1415032601175 }, | 63 "mathtag.com": { "hits": 14, "latest": 1415032601175 }, |
63 "amazonaws.com": { "hits": 18, "latest": 1414977342966 } | 64 "amazonaws.com": { "hits": 18, "latest": 1414977342966 } |
64 } | 65 } |
65 } | 66 } |
66 } | 67 } |
67 }] | 68 }] |
68 | 69 |
69 class GeometricalMeanTestCase(unittest.TestCase): | 70 class GeometricalMeanTestCase(test_helpers.FilterhitsTestCase): |
70 longMessage = True | 71 longMessage = True |
71 maxDiff = None | 72 maxDiff = None |
72 | 73 |
73 def geometrical(self, interval, new, new_timestamp, old, old_timestamp): | 74 def geometrical(self, interval, new, new_timestamp, old, old_timestamp): |
74 delta_divby_interval = (new_timestamp - old_timestamp) / 1000 / float(interv
al) | 75 delta_divby_interval = (new_timestamp - old_timestamp) / 1000 / float(interv
al) |
75 return long(round(old ** (1 - delta_divby_interval) * new ** delta_divby_int
erval)) | 76 return long(round(old ** (1 - delta_divby_interval) * new ** delta_divby_int
erval)) |
76 | 77 |
77 def clear_rows(self): | |
78 if self.db: | |
79 db.write(self.db, (("DELETE FROM frequencies",), | |
80 ("DELETE FROM filters",))) | |
81 | |
82 def setUp(self): | |
83 try: | |
84 db.testing = True | |
85 self.db = db.connect() | |
86 except MySQLdb.Error: | |
87 self.db = None | |
88 self.clear_rows() | |
89 | |
90 def tearDown(self): | |
91 if self.db: | |
92 self.clear_rows() | |
93 self.db.close() | |
94 self.db = None | |
95 | |
96 def test_calculations(self): | 78 def test_calculations(self): |
97 if not self.db: | |
98 raise unittest.SkipTest("Not connected to test DB.") | |
99 | |
100 interval = 86400 | 79 interval = 86400 |
101 | 80 |
102 # Tables should be empty to start with | 81 # Tables should be empty to start with |
103 self.assertEqual(db.query(self.db, "SELECT * FROM filters"), ()) | 82 self.assertEqual(db.query(self.db, "SELECT * FROM filters"), ()) |
104 self.assertEqual(db.query(self.db, "SELECT * FROM frequencies"), ()) | 83 self.assertEqual(db.query(self.db, "SELECT * FROM frequencies"), ()) |
105 # First batch | 84 # First batch |
106 db.write(self.db, geometrical_mean.update(interval, test_data[0])) | 85 db.write(self.db, geometrical_mean.update(interval, test_data[0])) |
107 self.assertEqual(db.query(self.db, "SELECT * FROM filters"), | 86 self.assertEqual(db.query(self.db, "SELECT * FROM filters"), |
108 (("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), | 87 (("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), |
109 u"##.top-box-right-ad"),)) | 88 u"##.top-box-right-ad"),)) |
(...skipping 43 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
153 u"##.top-box-right-ad"))) | 132 u"##.top-box-right-ad"))) |
154 self.assertEqual( | 133 self.assertEqual( |
155 db.query(self.db, "SELECT * FROM frequencies"), | 134 db.query(self.db, "SELECT * FROM frequencies"), |
156 (("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"acxiom-onlin
e.com", | 135 (("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"acxiom-onlin
e.com", |
157 6L, datetime.utcfromtimestamp(1414817340948 / 1000)), | 136 6L, datetime.utcfromtimestamp(1414817340948 / 1000)), |
158 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"adsymptotic.
com", | 137 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"adsymptotic.
com", |
159 self.geometrical(interval, 15, 1414994112862, 49, 1414953943015), | 138 self.geometrical(interval, 15, 1414994112862, 49, 1414953943015), |
160 datetime.utcfromtimestamp(1414994112862 / 1000)), | 139 datetime.utcfromtimestamp(1414994112862 / 1000)), |
161 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"amazon.com", | 140 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"amazon.com", |
162 2L, datetime.utcfromtimestamp(1414913563746 / 1000)), | 141 2L, datetime.utcfromtimestamp(1414913563746 / 1000)), |
163 ("22de8d2ba8429eb170a0ece6ea7a426f7b22e574".decode("hex"), u'amazonaws.co
m', | 142 ("22de8d2ba8429eb170a0ece6ea7a426f7b22e574".decode("hex"), u"amazonaws.co
m", |
164 18L, datetime.utcfromtimestamp(1414977342966 / 1000)), | 143 18L, datetime.utcfromtimestamp(1414977342966 / 1000)), |
165 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"demdex.net", | 144 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"demdex.net", |
166 36L, datetime.utcfromtimestamp(1414838712373 / 1000)), | 145 36L, datetime.utcfromtimestamp(1414838712373 / 1000)), |
167 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"doubleclick.
net", | 146 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"doubleclick.
net", |
168 26L, datetime.utcfromtimestamp(1414823430333 / 1000)), | 147 26L, datetime.utcfromtimestamp(1414823430333 / 1000)), |
169 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"google.com", | 148 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"google.com", |
170 self.geometrical(interval, 14, 1415008533089, | 149 self.geometrical(interval, 14, 1415008533089, |
171 self.geometrical(interval, 21, 1414953920364, | 150 self.geometrical(interval, 21, 1414953920364, |
172 50, 1414849084678), | 151 50, 1414849084678), |
173 1414953920364), | 152 1414953920364), |
174 datetime.utcfromtimestamp(1415008533089 / 1000)), | 153 datetime.utcfromtimestamp(1415008533089 / 1000)), |
175 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"live.com", | 154 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"live.com", |
176 34L, datetime.utcfromtimestamp(1414916268769 / 1000)), | 155 34L, datetime.utcfromtimestamp(1414916268769 / 1000)), |
177 ("22de8d2ba8429eb170a0ece6ea7a426f7b22e574".decode("hex"), u'mathtag.com'
, | 156 ("22de8d2ba8429eb170a0ece6ea7a426f7b22e574".decode("hex"), u"mathtag.com"
, |
178 14L, datetime.utcfromtimestamp(1415032601175 / 1000)), | 157 14L, datetime.utcfromtimestamp(1415032601175 / 1000)), |
179 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"yahoo.com", | 158 ("8c5ea548436c61f05536e205a29ada6204f603b0".decode("hex"), u"yahoo.com", |
180 self.geometrical(interval, 43, 1415045194098, | 159 self.geometrical(interval, 43, 1415045194098, |
181 self.geometrical(interval, 27, 1414917270343, | 160 self.geometrical(interval, 27, 1414917270343, |
182 14, 1414859271125), | 161 14, 1414859271125), |
183 1414917270343), | 162 1414917270343), |
184 datetime.utcfromtimestamp(1415045194098 / 1000)))) | 163 datetime.utcfromtimestamp(1415045194098 / 1000)))) |
185 | 164 |
186 if __name__ == '__main__': | 165 if __name__ == "__main__": |
187 unittest.main() | 166 unittest.main() |
LEFT | RIGHT |