from utils import SalesforceUtility

username = 'joe.fusaro@ivanti.com'
password = 'myPassword'
token = 'mySecurityToken'

if __name__ == "__main__":
    sfdc = SalesforceUtility(username, password, token)
    client = sfdc.connection

    members = client.query(
        """SELECT Id, Historical_Responded_Date__c,
        Campaign.StartDate, Status
        FROM CampaignMember
        WHERE CampaignId='7011B000002R6LwQAK' AND
        Status='No Show' AND
        Historical_Responded_Date__c = NULL
        """)
    print("\n\n\nUpdating {} records\n\n\n".format(members['totalSize']))

    for member in members['records']:
        client.CampaignMember.update(
            member['Id'],
            {'Historical_Responded_Date__c':member['Campaign']['StartDate']}
        )
        print('Updated {}\n'.format(member['Id']))

    print('-'*10 + 'COMPLETE' + '-'*10)