#!/usr/bin/env python
#encoding=utf-8
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
import MySQLdb
mysql=MySQLdb.connect(host="10.10.243.182",user="root",passwd="123",db="pop_cis_uat",charset="utf8")
sql="select sku_id as id,article_no as `model` from product_vender_shop limit 1"
sql="select sku_id as id,article_no as `model` from product_vender_shop"
hit=mysql.cursor(MySQLdb.cursors.DictCursor)
hit.execute(sql)
result=hit.fetchall()
f=open("/home/mlzboy/work/sh/model2.txt","w")
for row in result:
model=row["model"]
if model is None:
model=""
else:
model=row["model"].decode("utf8","ignore").encode("gbk","ignore")
f.write("%s|||%s\n"%(row["id"],model))
f.close()
mysql.commit()
mysql.close()
print result
