如何使用python从cloudant数据库读取值

2024-04-19 17:06:56 发布

您现在位置:Python中文网/ 问答频道 /正文

有谁能告诉我使用python从cloudant数据库提取数据的正确方法吗?我使用了this文档并尝试检索数据,但它总是提供空文档

我有如下示例数据库

{
 "id": "0726fa413b4ccf1e7ea549b40c55efd3",
 "key": "0726fa413b4ccf1e7ea549b40c55efd3",
 "value": {
  "rev": "77-71ebe0b54e30ed6ef27d7c79b3280c6a"
 },
 "doc": {
  "_id": "0726fa413b4ccf1e7ea549b40c55efd3",
  "_rev": "77-71ebe0b54e30ed6ef27d7c79b3280c6a",
  "clientName": "client1",
  "projectName": "project33"
}}

我试图提取如下值

client = Cloudant.iam("CLOUDANT_ACCOUNT", "CLOUDANT_KEY",connect=True)
db = client['project'] 
print(db.exists()) #this line gives true
query = Query(db, selector={'clientName': 'client1'})
for doc in query(limit=100, skip=100)['docs']:
  print(doc) #empty
client = Cloudant.iam("CLOUDANT_ACCOUNT", "CLOUDANT_KEY",connect=True)
db = CloudantDatabase(client,'project', fetch_limit=100, partitioned=False)
print(db.exists()) #this line gives true
query = Query(db, selector={'clientName': 'client1'})
for doc in my_database.view('_all_docs'):
  print(doc) #empty