Tabula livros armazenados no couchdb

books.py

# coding: utf-8

import json
import urllib2

books = json.loads(urllib2.urlopen('http:/127.0.0.1:5984/scielobooks_1a/_design/scielobooks/_view/books').read())

for row in books['rows']:
    print u'|'.join(
        [
            row['value'].get('title', 'not defined'),
            row['value'].get('year', 'not defined'),
            str(row['value'].get('is_comercial', 'not defined'))
        ]
    ).encode('utf-8')