Added /resetScore, /refreshScore and /showScore features to URL Fixer server-side

sitescripts/urlfixer/web/submitData.py

 # coding: utf-8
 
 # This Source Code is subject to the terms of the Mozilla Public License
 # version 2.0 (the "License"). You can obtain a copy of the License at
 # http://mozilla.org/MPL/2.0/.
 
 import os, MySQLdb, simplejson as json
 from urlparse import parse_qs
 from sitescripts.web import url_handler
 from sitescripts.utils import cached, get_config, setupStderr
 
 @url_handler("/submitData")
 def submit_data(environ, start_response):
-  setupStderr(environ['wsgi.errors'])
+  setupStderr(environ["wsgi.errors"])
 
   if environ["REQUEST_METHOD"].upper() != "POST":
     return showError("Unsupported request method", start_response)
   
   params = parse_qs(environ.get("QUERY_STRING", ""))
   requestVersion = params.get("version", ["0"])[0]
   data = "{}"
   try:
     data_length = int(environ.get("CONTENT_LENGTH", "0"))
   except ValueError:
@@ skipping 42 matching lines @@
   result = cursor.fetchone()
   if result == None:
     cursor.execute("INSERT INTO domains(domain) VALUES (%s)", (domain))
     return db.insert_id()
   else:
     return result["id"]
   
 def _increment_entry(db, domain_id, status):
   cursor = db.cursor(MySQLdb.cursors.DictCursor)
   cursor.execute("INSERT INTO corrections(domain, status, curr_month, prev_month, curr_year, prev_year) VALUES (%s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE curr_month = curr_month + 1, curr_year = curr_year + 1", (domain_id, status, 1, 0, 1, 0))