automation: added gerrit integration

1. Initalized webserver with template code (will be used in cron
automation)
2. API integration with gerrit to read change metadata from gerrit

BUG=None
TEST=None

Change-Id: I63464defa6d3c074e31a8b40455b5a6d35f74447
Reviewed-on: https://chromium-review.googlesource.com/c/chromiumos/platform/dev-util/+/2040479
Reviewed-by: Hirthanan Subenderan <hirthanan@google.com>
Reviewed-by: Guenter Roeck <groeck@chromium.org>
Commit-Queue: Hirthanan Subenderan <hirthanan@google.com>
Auto-Submit: Hirthanan Subenderan <hirthanan@google.com>
Tested-by: Hirthanan Subenderan <hirthanan@google.com>
diff --git a/contrib/findmissing/common.py b/contrib/findmissing/common.py
index 02b1aea..dfa93b1 100755
--- a/contrib/findmissing/common.py
+++ b/contrib/findmissing/common.py
@@ -33,10 +33,13 @@
     return os.path.join(DBDIR, 'chromeos-%s.db' % version)
 
 
-def patchdb(version):
-    """Path of patchdb for each chromeosdb"""
-    return os.path.join(DBDIR, '/patch-%s.db' % version)
+def patchdb_stable(version):
+    """Path of patchdb for stable versions."""
+    return os.path.join(DBDIR, 'patch-stable-%s.db' % version)
 
+def patchdb_chromeos(version):
+    """Path of patchdb for chromeos versions."""
+    return os.path.join(DBDIR, 'patch-chromeos-%s.db' % version)
 
 def stable_branch(version):
     """Stable branch name"""
@@ -65,7 +68,7 @@
     """Create database table storing information about chrome/stable git logs"""
 
     c.execute('CREATE TABLE commits (sha text, usha text, '
-            'patchid text, description text)')
+            'patchid text, description text, changeid text)')
     c.execute('CREATE UNIQUE INDEX commit_sha ON commits (sha)')
     c.execute('CREATE INDEX upstream_sha ON commits (usha)')
     c.execute('CREATE INDEX patch_id ON commits (patchid)')