37,721
社区成员
发帖
与我相关
我的任务
分享
#!Python
# -*-coding:GBK -*-
import MySQLdb
accounts = {}
conn = MySQLdb.connect (
host="sugarhost",
user="sugardbuser",
passwd="sugardbuserpwd",
db="sugarcrm",
charset="GBK")
cursor = conn.cursor ()
cursor.execute ('''
select
account_customercode_c as code
,name
,conf_dep_c as dept
,conf_zone_c as zone
,conf_assigned_user_c as sale
from accounts a
join accounts_cstm a0 on a.id=a0.id_c
where account_customercode_c regexp '[[:digit:]]{6}';
''')
for row in cursor.fetchall():
accounts[row[0]] = {
'Name':row[1],
'Dept':row[2],
'Zone':row[3],
'Sale':row[4]}
cursor.close ()
conn.close ()
for code,account in accounts.items():
print 'Account:[%s]%s' % (code,account['Name'])
for code,account in accounts.items():
print 'Account:[%s]%s' % (code, account['Name'].decode("gbk"))