Added script to generate stats on a git checkout

infra/tools/antibody/cloudsql_connect.py

 # Copyright 2015 The Chromium Authors. All rights reserved.
 # Use of this source code is governed by a BSD-style license that can be
 # found in the LICENSE file.
 
 import sys
 
 try:
   sys.path.append('/usr/lib/python2.7/dist-packages/')
   import MySQLdb
 except ImportError:  # pragma: no cover
   pass
 finally:
   sys.path.remove('/usr/lib/python2.7/dist-packages/')
 
 DB_INSTANCE_IP = '173.194.225.193'
-DEFAULT_DATABASE = 'ANTIBODY_DB'
+DEFAULT_DATABASE = 'ANTIBODY_2'
 USERNAME = 'antibody-team'
 
 
 def connect(password):  # pragma: no cover
   """Connect to Cloud SQL instance google.com:antibody-978:antibody-sql"""
   connection = MySQLdb.connect(host=DB_INSTANCE_IP,
                                user=USERNAME, passwd=password,
                                db=DEFAULT_DATABASE)
   cc = connection.cursor()
   return connection, cc
@@ skipping 14 matching lines @@
      
      VARCHAR(200)|VARCHAR(40)|TIMESTAMP|VARCHAR(10)
 
   type: author or tbr
   """
   cursor.executemany("""REPLACE INTO commit_people VALUES (%s,%s,%s,%s)""",
                      rows)
 
 
 def write_to_git_commit(cursor, rows):  # pragma: no cover
-  """hash|bug_url|timestamp|review_url|project_prj_id
+  """hash|bug_url|timestamp|review_url|project_prj_id|subject
      
-     VARCHAR(40)|VARCHAR(200)|TIMESTAMP|VARCHAR(200)|INT
+     VARCHAR(40)|VARCHAR(200)|TIMESTAMP|VARCHAR(200)|INT|VARCHAR(500)
   """
-  cursor.executemany("""REPLACE INTO git_commit VALUES (%s,%s,%s,%s,%s)""",
+  cursor.executemany("""REPLACE INTO git_commit VALUES (%s,%s,%s,%s,%s,%s)""",
                      rows)
 
 
 def write_to_people(cursor, rows):  # pragma: no cover
   """email_address|committer_since
      
      VARCHAR(200)|TIMESTAMP
   """
   cursor.execute("""REPLACE INTO people VALUES (%s,%s)""", rows)
 
@@ skipping 27 matching lines @@
 
 
 def commit(conn):  # pragma: no cover
   conn.commit()
 
 
 def close(conn, cursor):  # pragma: no cover
   cursor.close()
   conn.commit()
   conn.close()