Index: sitescripts/filterhits/geometrical_mean.py |
=================================================================== |
deleted file mode 100644 |
--- a/sitescripts/filterhits/geometrical_mean.py |
+++ /dev/null |
@@ -1,46 +0,0 @@ |
-# coding: utf-8 |
- |
-# This file is part of the Adblock Plus web scripts, |
-# Copyright (C) 2006-2016 Eyeo GmbH |
-# |
-# Adblock Plus is free software: you can redistribute it and/or modify |
-# it under the terms of the GNU General Public License version 3 as |
-# published by the Free Software Foundation. |
-# |
-# Adblock Plus is distributed in the hope that it will be useful, |
-# but WITHOUT ANY WARRANTY; without even the implied warranty of |
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
-# GNU General Public License for more details. |
-# |
-# You should have received a copy of the GNU General Public License |
-# along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>. |
- |
-import itertools |
- |
-from sitescripts.filterhits import db |
- |
- |
-def update(interval, data): |
- """ |
- Generator that provides all the SQL and parameters needed to update the |
- aggregations for the given data + interval in the database. |
- """ |
- for filter, filter_data in data["filters"].iteritems(): |
- yield ("""INSERT IGNORE INTO `filters` |
- (filter, sha1) VALUES (%s, UNHEX(SHA1(filter)))""", filter) |
- |
- domains = itertools.chain(filter_data.get("thirdParty", {}).iteritems(), |
- filter_data.get("firstParty", {}).iteritems()) |
- for domain, domain_data in domains: |
- yield ("""INSERT INTO `frequencies` |
- (filter_sha1, domain, frequency, timestamp) |
- VALUES (UNHEX(SHA1(%s)), %s, %s, FROM_UNIXTIME(%s)) |
- ON DUPLICATE KEY UPDATE |
- frequency = ( |
- POW(frequency, 1 - (UNIX_TIMESTAMP(VALUES(timestamp)) - |
- UNIX_TIMESTAMP(timestamp)) / %s) * |
- POW(VALUES(frequency), (UNIX_TIMESTAMP(VALUES(timestamp)) - |
- UNIX_TIMESTAMP(timestamp)) / %s)), |
- timestamp = VALUES(timestamp)""", |
- filter, domain, domain_data["hits"], |
- int(domain_data["latest"] / 1000), interval, interval) |