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 '配置信息为:'.decode('utf-8').encode('gbk')
couchbaseconnect='couchbase://'+couchbaseip+':' + couchbaseport +'/' + buckname
print couchbaseconnect
c = Bucket(couchbaseconnect, password='assign')
print
res = c.get(subkey.strip(), quiet=True)
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")
[couchbase]
ip=10.2.130.64
port=8091
buckname=assign
buckpasswd=assign
subkey=*_870000000779