def provider(pageQueue):
import sql_spec
import MySQLdb
import tool
q = sql_spec.connect('119.40.35.7','remote','qwer5678()_+','qiud_materials_db')
qcur = q.cursor()
fd = open('id.txt','r')
data = [record.strip() for record in fd.readlines()]
fd.close()
for id in data:
selectstring = 'select url,response from t_soccerway_players where id = %s'\
%id
qcur.execute(selectstring)
result = qcur.fetchone()
print id
pageQueue.put(result,block = True)
print "Ok,more record!"
import sql_spec
import MySQLdb
import tool
q = sql_spec.connect('119.40.35.7','remote','qwer5678()_+','qiud_materials_db')
qcur = q.cursor()
num = qcur.execute('''select id,url from t_soccerway_players''')
print num
fd = open('record.txt','r')
data = fd.readlines()
data = [record.strip() for record in data]
print len(data)
id_list = []
while True:
record = qcur.fetchone()
if record:
if tool.getplayerid(record[1]):
print tool.getplayerid(record[1])
if '/'.join(tool.getplayerid(record[1])) in data:
pass
else:
id_list.append(record[0])
print tool.getplayerid(record[1])
else:
break
import MySQLdb
import sql_spec
q = sql_spec.connect('localhost','root','88888888','qiud')
qcur= q.cursor()
qcur.execute('''select player_id from playerinfo''')
result = qcur.fetchall()
fd = open('record.txt','w')
for r in result:
fd.write(r[0]+'\n');
