server1.py

#Mail Package
import smtplib
from email.message import EmailMessage

#google sheet package
from gsheets import Sheets

#Authorizing the api
sheets = Sheets.from_files('FD4GS.json','FD4GS_cache.json')



#Fetching information from owners database
vi1 = sheets.get('1URQBjLmkRkPxI1RGQFpp_ZxUa1xMcoMth3qmWH9DK2Y') # Vehicle Information

vi1_form1_ws = vi1.sheets[0]

entries1 = vi1_form1_ws.values()[1:]

entries1 = [(i[2],i[6],i[1]) for i in entries1]



#Fetching information from search database
vi2 = sheets.get('1i2_N7yqcJQQ7cpBJqR8KnxpUOPh3TgNvY8oC1mCSv0U') # Search Database

vi2_form1_ws = vi2.sheets[0]

entries2 = vi2_form1_ws.values()[1:]

entries2 = [(j[1],j[2]) for j in entries2]



#Fetching information from helper database
vi3 = sheets.get('1dYaQqMVPEbJuBwHC-nPbu-2NPIcaqwJf8-MqiZswmU4') # Helper Database

vi3_form1_ws = vi3.sheets[0]

entries3 = vi3_form1_ws.values()[1:]

entries3 = [(k[2],k[3],k[1]) for k in entries3]




# Fetching common features between all three database
#a[0]is mail, a[1] is color, a[2] is name,  b[0] is a mail,b[1]is date, c[0] is location, c[1] is color, c[2] is image link


maaail = 1
for b in entries2:
    for a in entries1:
        if b[0] == a[0]: # matching mail
            matchess = []
            linkk = [] 
            for c in entries3:
                if c[1].casefold() == a[1].casefold(): #matching color
                    #storing location in list 
                    data_matched = [c[0]]
                    matchess.append(data_matched)
                    #storing image links in list
                    link_matched = [c[2]]
                    linkk.append(link_matched)
                    continue
            
            #print("Mail:", b[0], "Location:", matchess)

            #Making a mail template
            f = open("textformat.txt", "w")
            sent = "Hello " +str(a[2]) + "!" + " \n \n \n \t \tWe have collected certain  images based on your features and thier locations are: \n \n "
            for ii in range(0, len(matchess)):
                sent =  sent + "\t\t\t"+ str(ii+1)+ ") " + str(",".join(matchess[ii])) + " and the image link is " + str(",".join(linkk[ii])) + "\n \n"
                continue
            f.write(sent)
            f.close()

            #print(sent)
            fii=open("textformat.txt")
            final = fii.read()
            
            
            # Sending Mail
            msg = EmailMessage()
            msg['Subject'] = "Vehicle Matching"
            msg['From'] = "Vehicle Detector Application"
            msg['to'] = b[0]

            location = "Your cars are found in " + str(matchess)
            msg.set_content(final)

            server = smtplib.SMTP_SSL('smtp.gmail.com',465)
            server.login("vehicledetectorproject@gmail.com","[Password]")
            server.send_message(msg)
            server.quit()
            print("Mail"+ str(maaail)+" Sent!")
            print("************************************")
            maaail = maaail + 1
            f.close()

print("All emails sent!!!")