使用python访问mysql数据库/取数据/写入文件

总结一下最近使用mysql数据库的代码：进行访问数据库/表——取出表中指定列取值为特定值的所有样本——写入文件

 

#-*- coding；utf-8 -*-
# import sys
# reload(sys)
#sys.setdefaultencoding( "utf-8" )
 
importmysql.connector
import pandas as pd
 
conn=mysql.connector.connect(host='##.##.###',user='***',password='&&&',database='dw_output',use_unicode=True)
cursor=conn.cursor()
cursor.execute('usedw_output')
cursor.execute("select input_user_name asuser_name,input_mobile_number as mobile_number,
input_identity_number asidentity_number from personal_credit_service where customer_id='数据' 
and src_create_timestamp like '2017-02-27%'order by rand() limit500")
values=cursor.fetchall()
df=pd.DataFrame(values)
df.columns=['user_name','mobile_number','identity_number']              
df=df.to_csv('data.csv',index=False)
 
import os
import requests
from datetime importdatetime
import time
 
df=pd.read_csv('data.csv')
 
file_name ='online_score_'+datetime.now().strftime("%Y-%m-%d-%H-%M")+'.txt'
with open(os.path.join(os.getcwd(),'TestResult','data',file_name), 'a') as f:         
 #'a'  为append方式
    for i in range(len(df)):
        print i
        user_name = df.iloc[i,0]
        mobile_number = df.iloc[i,1]
        identity_number = df.iloc[i,2] 
 
       url='https://api.creditx.com/perRisk_creditloan_xScore'
        request_mode='GET'
        params ={'user_name':user_name,'mobile_number':mobile_number,'identity_number':identity_number}
        need_key = 'https' in url
        response= requests.get(url,params =params,verify = 'ca.crt',cert = ('client.crt','client.key'))
        content = response.content
        f.write(content) 
 
    print 'Tests are successfully done!'
    print '\n'