query cloudant with python

Question

There may be an obvious answer to this, but I can't seem to find it anywhere: what's the best way to query couchdb databases stored on cloudant servers? I try using temporary views, a la the couchdb.py instructions:

>>> db['johndoe'] = dict(type='Person', name='John Doe')
>>> db['maryjane'] = dict(type='Person', name='Mary Jane')
>>> db['gotham'] = dict(type='City', name='Gotham City')
>>> map_fun = '''function(doc) {
...     if (doc.type == 'Person')
...         emit(doc.name, null);
... }'''
>>> for row in db.query(map_fun):
...     print row.key
John Doe
Mary Jane

While this works on locally hosted databases, with CloudAnt it returns the error:

couchdb.http.ServerError: (403, ('forbidden', 'temp views are disabled on Cloudant'))

I've read the cloudant tutorial on querying but the querying syntax proposed seems clumsy and it's not obvious how to work it into python! Is there an easy way around this?

Simon Fearby · Accepted Answer · 2014-06-26 14:17:37Z

3

This is how I am adding a record with python.

import requests
import json

doc = {
  'username':'kerrie',
  'high_score':550,
  'level':3
}

auth = ('username', 'password')
headers = {'Content-type': 'application/json'}

post_url = "https://account.cloudant.com/database/kerrie".format(auth[0])

r = requests.put(post_url,  auth=auth,  headers=headers,  data=json.dumps(doc))
print json.dumps(r.json(), indent=1)

This is how i query 10 records in Python.

import requests
import json
auth = ('username', 'password')
get_url = "https://account.cloudant.com/database/_all_docs?limit=10".format(auth[0])
r = requests.get(get_url, auth=auth)
print json.dumps(r.json(), indent=1)

answered Jun 26, 2014 at 14:17

Simon Fearby

1871 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ryan Ramage · Accepted Answer · 2011-10-18 17:34:43Z

1

The reason Cloudant forbids temp views is because they do not scale. You will need to create a design document with defined views in it. Here is a link to what a design document is like with views defined on it:

http://max.ic.ht/_utils/document.html?action/_design/action

I am not sure about how to do it in couchdb.py, but you might want to try a different python library. Here is a link to the section about creating views in couchquery

http://mikeal.github.com/couchquery/#creating-views

answered Oct 18, 2011 at 17:34

Ryan Ramage

2,61619 silver badges17 bronze badges

2 Comments

radpotato Over a year ago

OK, so I can now create views and am using design documents for this .... the next step is to work out how to send view requests for specific values within couchdb-python's ListField.

Mike Rhodes Over a year ago

I'd recommend using plain HTTP libraries, like requests.

Mike Rhodes · Accepted Answer · 2017-10-19 20:38:34Z

1

Just noting that Cloudant now has an official python library, https://github.com/cloudant/python-cloudant.

answered Oct 19, 2017 at 20:38

Mike Rhodes

1,83612 silver badges15 bronze badges

Comments

mrbillyocean · Accepted Answer · 2013-04-17 16:03:25Z

0

You should probably use couchdbkit. It makes setting up views easy. I don't think you can use temporary views in Cloudant anymore.

answered Apr 17, 2013 at 16:03

mrbillyocean

1,4211 gold badge15 silver badges24 bronze badges

1 Comment

Benjamin Over a year ago

The server is gone ATM.

Collectives™ on Stack Overflow

query cloudant with python

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related