| OLD | NEW |
| 1 # This file is part of the Adblock Plus web scripts, | 1 # This file is part of the Adblock Plus web scripts, |
| 2 # Copyright (C) 2006-present eyeo GmbH | 2 # Copyright (C) 2006-present eyeo GmbH |
| 3 # | 3 # |
| 4 # Adblock Plus is free software: you can redistribute it and/or modify | 4 # Adblock Plus is free software: you can redistribute it and/or modify |
| 5 # it under the terms of the GNU General Public License version 3 as | 5 # it under the terms of the GNU General Public License version 3 as |
| 6 # published by the Free Software Foundation. | 6 # published by the Free Software Foundation. |
| 7 # | 7 # |
| 8 # Adblock Plus is distributed in the hope that it will be useful, | 8 # Adblock Plus is distributed in the hope that it will be useful, |
| 9 # but WITHOUT ANY WARRANTY; without even the implied warranty of | 9 # but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| (...skipping 60 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 71 if os.name == 'nt': | 71 if os.name == 'nt': |
| 72 return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, | 72 return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, |
| 73 use_unicode=True, charset='utf8', named_pipe=True
) | 73 use_unicode=True, charset='utf8', named_pipe=True
) |
| 74 else: | 74 else: |
| 75 return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, | 75 return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, |
| 76 use_unicode=True, charset='utf8') | 76 use_unicode=True, charset='utf8') |
| 77 | 77 |
| 78 | 78 |
| 79 def _get_domain_id(db, domain): | 79 def _get_domain_id(db, domain): |
| 80 cursor = db.cursor(MySQLdb.cursors.DictCursor) | 80 cursor = db.cursor(MySQLdb.cursors.DictCursor) |
| 81 cursor.execute('SELECT id FROM domains WHERE domain = %s', (domain)) | 81 cursor.execute('SELECT id FROM domains WHERE domain = %s', domain) |
| 82 result = cursor.fetchone() | 82 result = cursor.fetchone() |
| 83 if result == None: | 83 if result == None: |
| 84 cursor.execute('INSERT INTO domains(domain) VALUES (%s)', (domain)) | 84 cursor.execute('INSERT INTO domains(domain) VALUES (%s)', domain) |
| 85 return db.insert_id() | 85 return db.insert_id() |
| 86 else: | 86 else: |
| 87 return result['id'] | 87 return result['id'] |
| 88 | 88 |
| 89 | 89 |
| 90 def _increment_entry(db, domain_id, status): | 90 def _increment_entry(db, domain_id, status): |
| 91 cursor = db.cursor(MySQLdb.cursors.DictCursor) | 91 cursor = db.cursor(MySQLdb.cursors.DictCursor) |
| 92 cursor.execute('INSERT INTO corrections(domain, status, curr_month, prev_mon
th, curr_year, prev_year) VALUES (%s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDAT
E curr_month = curr_month + 1, curr_year = curr_year + 1', (domain_id, status, 1
, 0, 1, 0)) | 92 cursor.execute('INSERT INTO corrections(domain, status, curr_month, prev_mon
th, curr_year, prev_year) VALUES (%s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDAT
E curr_month = curr_month + 1, curr_year = curr_year + 1', (domain_id, status, 1
, 0, 1, 0)) |
| OLD | NEW |