import pymysql.cursors
import json
from DBConnector import DBConnector
# Connect to the database
dbconnector = DBConnector('localhost', 'root', '', 'gerrit_test')
inline_comments = dbconnector.inline_comments()
patch_details = dbconnector.patch_details()
patches = dbconnector.patches()
# people = dbconnector.people()
requests = dbconnector.requests()
request_details = dbconnector.request_detail()
review_comments = dbconnector.review_comments()
reviews = dbconnector.reviews()
def getInlineComments(patch_id, req_id):
I = {}
for comment in inline_comments:
if comment["patchset_id"] == patch_id and comment[
"request_id"] == req_id:
I[comment["file_name"]] = {
'comment_id': comment["comment_id"],
'in_reply_to': comment["in_reply_to"],
'line_number': comment["line_number"],
'author_id': comment["author_id"],
'written_on': comment["written_on"],
'status': comment["status"],
'side': comment["side"],
'message': comment["message"],
