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 |