MongoConnection.py

import re

from pymongo import MongoClient

from index import GetCommand

client = MongoClient()
client = MongoClient('localhost', 27017)
client = MongoClient('mongodb://localhost:27017/')
db = client['Vulns']


#db.CVEs.update({}, {"$set": {"CommitHash001": ""}})
i=0

#coll1 = db.CVEs #selecting the coll1 in myDatabase
#for document in coll1.find():
    #print (document)


coll1 = db.CVEs.find({}, {'references':1, 'id': 1, '_id':0})
for document in coll1:
   #split=  str(document).split(', ')\
   Value= list(document.values())[1]

   Url= re.findall('https://github\.com(?:/[^/]+)*/commit/[0-9a-f]{40}', Value)
   length= len(Url)

   if length >1:

     for x in Url:
       MainUrl= x.replace("'", "").replace("[", "").replace("]", "")
       GetCommand(MainUrl, list(document.values())[0])

       i=i+1

   else:
      #print(Url[0].replace("'", "").replace("[", "").replace("]", ""))
      #print(list(document.values())[0])
      MainUrl2= Url[0].replace("'", "").replace("[", "").replace("]", "")
      GetCommand(MainUrl2, list(document.values())[0])
      i=i+1

print(i)



   #print (Url)
   #print(Url)