如何使用python/Cassandra打印用户数据类型变量?

2024-09-28 18:59:17 发布

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

C*2.1,Python 2.7 类型: CREATE TYPE address (street text, zipcode int) 表格: CREATE TABLE myusrs (id int PRIMARY KEY, location map<text, frozen<address>>)

insert into myusrs (id, addresses ) VALUES ( 0, { '123 main':98004})

打印整行:

^{pr2}$

我想打印row.location.街道以及行.位置.地址在

Error: AttributeError: 'OrderedMapSerializedKey' object has no attribute 'street'

session = cluster.connect()
session.set_keyspace('mykeyspace')
session.execute("CREATE TYPE address (street text, zipcode int)")
session.execute("CREATE TABLE myusrs (id int PRIMARY KEY, location map<text, frozen<address>>)")
session.execute("insert into myusrs (id, addresses ) VALUES ( 0, { '123 main':98004})")

results = session.execute("SELECT * FROM myusrs")
rows=results[0]
print rows

Row(id=0, location=OrderedMapSerializedKey([(u'123 main', address(street=u'98004', zipcode=None))]))

    print rows.location[0][1].street

Tags: textidstreetexecutemainaddresssessiontype