python으로 json 가져오기에 대해 질문드립니다..

Question

json 소스는 [ { &#34;key&#34;:&#34;2659997&#34;, &#34;sts&#34;:&#34;sale&#34;, &#34;stsdetail&#34;:&#34;Finished&#34;, &#34;sdate&#34;:&#34;2017-10-31 20:55:00&#34;, &#34;sname&#34;:&#34;seoul&#34;, &#34;test1&#34;:{ &#34;aaa&#34;:&#34;0&#34;, &#34;bbb&#34;:&#34;0&#34;, &#34;ccc&#34;:&#34;4&#34;, &#34;ddd&#34;:&#34;2&#34;, }, &#34;test2&#34;:{ &#34;aaa&#34;:&#34;2&#34;, &#34;bbb&#34;:&#34;2&#34;, &#34;ccc&#34;:&#34;6&#34;, &#34;ddd&#34;:&#34;6&#34;, } } ]python 소스는url_sale&#61; cfg.oddsurl salefeed &#61; urllib2.urlopen(url_sale) salejson &#61; json.load(salefeed) str2 &#61; {&#34;data&#34;: salejson} for data in str2[&#34;data&#34;]: key &#61; data.get(&#34;key&#34;) sts&#61; data.get(&#34;sts&#34;) stsdetail&#61; data.get(&#34;stsdetail&#34;) sdate&#61; data.get(&#34;sdate&#34;) sname&#61; data.get(&#34;sname&#34;) test1&#61; data.get(&#34;test1&#34;) test2&#61; data.get(&#34;test2&#34;) cursor.execute(sql) conn.commit()결과:INSERT INTO info_test(keys,sts,stsdetail,sname,test1,test2,smalldatetime) VALUES (112233,'sale','Finished','seoul','{u'aaa': u'0', u'bbb': u'0', u'ccc': u'4', u'ddd': u'2'}','{u'aaa': u'2', u'bbb': u'2', u'ccc': u'6', u'ddd': u'6'}', '2017-10-31 23:35:00')결과에 u' 이게 뭘까요? 이결과를 '{u'aaa': u'0', u'bbb': u'0', u'ccc': u'4', u'ddd': u'2'}' 이런식으로 가져오고 싶은데 어떻게 해야 할까요..'aaa:0,bbb:0,ccc:4,ddd:2'

pyzza · Answer

u' <-- unicode

python으로 json 가져오기에 대해 질문드립니다..

1개의 답변

Q&A 목록