replaceKeyValuePairOnItemIdCSV.py

import json
import requests
import secrets
import time
import csv
from datetime import datetime
import urllib3

urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)

secretsVersion = input('To edit production server, enter secrets filename: ')
if secretsVersion != '':
    try:
        secrets = __import__(secretsVersion)
        print('Editing Production')
    except ImportError:
        print('Editing Stage')
else:
    print('Editing Stage')

baseURL = secrets.baseURL
email = secrets.email
password = secrets.password
filePath = secrets.filePath
skippedCollections = secrets.skippedCollections

startTime = time.time()
data = {'email': email, 'password': password}
header = {'content-type': 'application/json', 'accept': 'application/json'}
session = requests.post(baseURL+'/rest/login', headers=header,
                        params=data).cookies['JSESSIONID']
cookies = {'JSESSIONID': session}
headerFileUpload = {'accept': 'application/json'}
cookiesFileUpload = cookies
status = requests.get(baseURL+'/rest/status', headers=header, cookies=cookies).json()
print('authenticated')

fileName = filePath+input('Enter fileName (including \'.csv\'): ')
oldKey = input('Enter key: ')
newKey = oldKey

dt = datetime.now().strftime('%Y-%m-%d %H.%M.%S')

f = csv.writer(open(filePath+'oldKeyValuePair'+dt+'.csv', 'w'))
f.writerow(['itemID']+['oldKey']+['oldValue']+['newValue']+['delete']+['post'])

with open(fileName) as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        itemMetadataProcessed = []
        itemID = row['itemID']
        oldValue = row['oldValue']
        newValue = row['newValue']
        link = baseURL+'/rest/items/'+str(itemID)+'/metadata'
        itemMetadata = requests.get(link, headers=header, cookies=cookies).json()
        for element in itemMetadata:
            languageValue = element['language']
            if element['key'] == oldKey and element['value'] == oldValue:
                updatedMetadataElement = {}
                updatedMetadataElement['key'] = newKey
                updatedMetadataElement['value'] = newValue
                updatedMetadataElement['language'] = languageValue
                itemMetadataProcessed.append(updatedMetadataElement)

                provNote = ('\''+newKey+': '+newValue+'\' replaced \''+oldKey
                            + ': '+oldValue+'\' by batch process on '+dt+'.')
                provNoteElement = {}
                provNoteElement['key'] = 'dc.description.provenance'
                provNoteElement['value'] = provNote
                provNoteElement['language'] = 'en_US'
                itemMetadataProcessed.append(provNoteElement)
            else:
                itemMetadataProcessed.append(element)
        print(itemMetadata)
        itemMetadataProcessed = json.dumps(itemMetadataProcessed)

        delete = requests.delete(link, headers=header, cookies=cookies)
        print(delete)
        post = requests.put(link, headers=header, cookies=cookies,
                            data=itemMetadataProcessed)
        print(post)
        f.writerow([itemID]+[oldKey]+[oldValue]+[newValue]+[delete]+[post])