python连接本地mysql_python连接mysql

from__future__ import division

import pymysql

coon=pymysql.connect(

host= '',user = 'r',passwd = 'bQ',

port=,db = '',charset = '')

f=file('ddd.txt')

i= 0p_id_dic={}

lists=[]

cur=coon.cursor()for line inf:

i+= 1chunk= line.strip().split('\t')

p_id= chunk[0]

price= round(float(chunk[2]) / 1, 2)

p_id_dic[int(p_id)] =price

lists.append(p_id)if i % 1000:

sql= "select p_id, pay_price,total_price from map_ugc_core.task_package where p_id in (%s)" % ','.join(lists)

cur.execute(sql)

res=cur.fetchall()for db_pid, db_price,total_price inres:if abs(db_price - p_id_dic.get(db_pid)) > 0.01:

print db_pid, db_price, p_id_dic.get(db_pid), db_price - p_id_dic.get(db_pid), total_price

lists=[]iflists:for db_pid, db_price, total_price inres:if abs(db_price - p_id_dic.get(db_pid)) > 0.01:

print db_pid, db_price, p_id_dic.get(db_pid), db_price - p_id_dic.get(db_pid), total_price

cur.close()

coon.close()