# Doc
#  Script to extract Contacts from Sailfish Contact SQLite DB located at 
# ChangeLog

import sqlite3
import vobject

SQLconn = sqlite3.connect('../Testdata/system/Contacts/qtcontacts-sqlite/contacts.db')


try:
    SQLContCur = SQLconn.cursor()
    for row in SQLContCur.execute('SELECT * FROM Contacts'):
            print(row[4] + ' ' + row[6])
        
            # contactID abfragen
            contactID=row[0]
            
            vcf = vobject.vCard()
            vcf.add('n')
            vcf.n.value = vobject.vcard.Name( family=row[6], given=row[4] )
            vcf.add('fn')
            vcf.fn.value =row[1]
            
            SQLEmailCur = SQLconn.cursor()
            ## Abfragen E-Mail-Adressen
            for Emailrow in SQLEmailCur.execute('SELECT * from EmailAddresses JOIN Details on Details.detailId= EmailAddresses.detailId where EmailAddresses.contactId = ' + str(contactID)):
                vcf.add('email')
                vcf.email.value = Emailrow[2]
                vcf.email.type_param = Emailrow[9]


            vcf.prettyPrint()
        
            
           
except:
    print("Error in executing SQL")