【python 】查找couchbase中的键

#getfundacco.py
#!/usr/bin/python
# -*- coding: utf-8 -*-

from couchbase.bucket import Bucket
import ConfigParser
import string
import os
import json

cp= ConfigParser.ConfigParser()
cp.read('my.conf')
couchbaseip=cp.get('couchbase', 'ip')
couchbaseport=cp.get('couchbase', 'port')
buckname=cp.get('couchbase', 'buckname')
buckpasswd=cp.get('couchbase', 'buckpasswd')
subkey =cp.get('couchbase','subkey')
#print couchbaseip, buckname,buckpasswd,couchbaseport

print '配置信息为:'.decode('utf-8').encode('gbk')
#couchbase
couchbaseconnect='couchbase://'+couchbaseip+':' + couchbaseport +'/' + buckname
print couchbaseconnect
c = Bucket(couchbaseconnect, password='assign')
print
#subkey = raw_input("请输入分库键:".decode('utf-8').encode('gbk'))

res = c.get(subkey.strip(), quiet=True) # suppress not-found errors
print "分库键为:".decode('utf-8').encode('gbk'), '['+subkey+']'
if json.dumps(res.value, sort_keys=True, indent=2) == 'null' :
    print "分库键不存在,请检查".decode('utf-8').encode('gbk')
    os.system("pause")
print "分库键的内容为:".decode('utf-8').encode('gbk'),  json.dumps(res.value, sort_keys=True, indent=2)
print

custkey=res.value['custkey']
custkeyvalue=c.get(custkey)
print "基金账号键:".decode('utf-8').encode('gbk'),custkey


databaseno=res.value['databaseno']
print '分库号:'.decode('utf-8').encode('gbk'), databaseno

opendate=res.value['opendate']
print '开户日期:'.decode('utf-8').encode('gbk'), opendate

tradekey=res.value['tradekey']
print '交易键:'.decode('utf-8').encode('gbk'),tradekey

print

print "【基金账号键相关】".decode('utf-8').encode('gbk')
print "【基金账号键】".decode('utf-8').encode('gbk'),custkey
print "【内容】基金账号:".decode('utf-8').encode('gbk'),custkeyvalue.value['fundacco']
custkeylist=custkey.split('_')
custkeylistch=['租户号','TA代码','客户类型','证件类型','证件是否18位','证件号码(18位)','客户名称的hash字符串']
print "基金账号键字段解析:".decode('utf-8').encode('gbk')
for i in range(0,len(custkeylistch)-1):
    print  custkeylistch[i].decode('utf-8').encode('gbk') +": " , custkeylist[i]

tradekeylistch=['租户号','TA代码','交易账号','销售商','网点代码']
tradekey=res.value['tradekey']
print

print "【交易键相关】".decode('utf-8').encode('gbk')
for i in range(0, len(tradekey)):
    res = c.get(tradekey[i], quiet=True)
    fundacco = res.value['fundacco']
    opendate = res.value['opendate']
    print "交易键: ".decode('utf-8').encode('gbk'), tradekey[i]
    print "【内容】基金账号:".decode('utf-8').encode('gbk'), fundacco, "开户日期".decode('utf-8').encode('gbk'),opendate

print
print "交易键字段解析:".decode('utf-8').encode('gbk')
for i in range(0, len(tradekey)):
    print "交易键: ".decode('utf-8').encode('gbk'), tradekey[i]
    tradekeylist= tradekey[i].split('_')
    for j in range(0,len(tradekeylist)):
        print tradekeylistch[j].decode('utf-8').encode('gbk') + ": ", tradekeylist[j]
    print
os.system("pause")
#my.conf
[couchbase]
ip=10.2.130.64
port=8091
buckname=assign
buckpasswd=assign
subkey=*_870000000779
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值