getPropertiesFromSingleResource.py

import json
import requests
import time
import csv

secretsVersion = input('To edit production server, enter the name of the \
secrets file: ')
if secretsVersion != '':
    try:
        secrets = __import__(secretsVersion)
        print('Editing Production')
    except ImportError:
        secrets = __import__('secrets')
        print('Editing Development')
else:
    print('Editing Development')

startTime = time.time()

baseURL = secrets.baseURL
user = secrets.user
password = secrets.password
repository = secrets.repository

auth = requests.post(baseURL + '/users/' + user + '/login?password='
                     + password).json()
session = auth['session']
headers = {'X-ArchivesSpace-Session': session,
           'Content_Type': 'application/json'}

f = csv.writer(open('resourceProperties.csv', 'w'))
f.writerow(['title'] + ['uri'] + ['bibnum'] + ['type'] + ['value'])


endpoint = input('Enter resource ID: ')
output = requests.get(baseURL + endpoint, headers=headers).json()
print(json.dumps(output))

title = output['title']
uri = output['uri']
try:
    bibnum = output['user_defined']['real_1']
except ValueError:
    bibnum = ''
try:
    agents = output['linked_agents']
    for agent in agents:
        agentUri = agent['ref']
        agentOutput = requests.get(baseURL + agentUri, headers=headers).json()
        agentName = agentOutput['title']
        f.writerow([title] + [uri] + [bibnum] + ['name'] + [agentName])
except ValueError:
    pass
try:
    subjects = output['subjects']
    for subject in subjects:
        subjectUri = subject['ref']
        subjectOutput = requests.get(baseURL + subjectUri,
                                     headers=headers).json()
        subjectName = subjectOutput['title']
        f.writerow([title] + [uri] + [bibnum] + ['subject'] + [subjectName])
except ValueError:
    pass
for note in output['notes']:
    abstract = ''
    scopecontent = ''
    acqinfo = ''
    custodhist = ''
    if note['type'] == 'abstract':
        abstract = note['content'][0]

        f.writerow([title] + [uri] + [bibnum] + ['abstract'] + [abstract])
    if note['type'] == 'scopecontent':
        scopecontentSubnotes = note['subnotes']
        for subnote in scopecontentSubnotes:
            scopecontent = scopecontent + subnote['content'] + ' '
        f.writerow([title] + [uri] + [bibnum] + ['scopecontent']
                   + [scopecontent])
    if note['type'] == 'acqinfo':
        acqinfoSubnotes = note['subnotes']
        for subnote in acqinfoSubnotes:
            acqinfo = acqinfo + subnote['content'] + ' '
        f.writerow([title] + [uri] + [bibnum] + ['acqinfo'] + [acqinfo])
    if note['type'] == 'custodhist':
        custodhistSubnotes = note['subnotes']
        for subnote in custodhistSubnotes:
            custodhist = custodhist + subnote['content'] + ' '
        f.writerow([title] + [uri] + [bibnum] + ['custodhist'] + [custodhist])

elapsedTime = time.time() - startTime
m, s = divmod(elapsedTime, 60)
h, m = divmod(m, 60)
print('Total script run time: ', '%d:%02d:%02d' % (h, m, s))