处理异常

# -*- coding:utf-8 -*-

import pandas as pd
import pymysql
from sqlalchemy import create_engine
## 加上字符集参数，防止中文乱码
dbconn = pymysql.connect(
        host="127.0.0.1",
        database="test",
        user="root",
        password="111111",
        port=3306,
        charset='utf8')
conn = create_engine('mysql+mysqldb://root:111111@localhost:3306/test?charset=utf8')

sqlcmd = "select * from t_stock_pinyin"
#
#
data = pd.read_sql(sqlcmd, dbconn)

import tushare as ts

codelist = list(data['Fsecode'])

for code in codelist:
        print code
        df = ts.get_hist_data(code=str(code), start='2017-05-04', end='2017-06-04', ktype='D', retry_count=3, pause=0.001)
        if type(df) == pd.DataFrame:
                df['code']=code
                if df.shape[0]>0:
                        try:
                                pd.io.sql.to_sql(df,"kankan",con=conn,if_exists='append')#只能说使用createegien的方式
                        except Exception as e:
                                print 'Error',e
                        else:
                                pass
                else:
                        print 'Data is not enough'
        else:
                print 'No data @', code