股票 tushare 到 oracle 问题脚本

# -*- coding: utf-8 -*-
import tushare as ts
import os
import re
from sqlalchemy import create_engine
import cx_Oracle
import sys
reload(sys)
sys.setdefaultencoding('utf-8')  
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'  




stocklistpath = '/root/stock_py/stocklist1.txt'
openstock = open(stocklistpath,'r')
engine = create_engine('oracle+cx_oracle://stock:stock@192.168.1.10:1521/orcl')
cnx = engine.connect()


for i in openstock:
    r = r"S[ZH]\d\d\d\d\d\d"
    stocknum = re.findall(r,i)
    stocknum = i[2:8]
    
    df = ts.get_tick_data(code=stocknum,date='2017-01-03')
    df.index.names = ['op_index']
    df['STOCKID']= i
    df.to_sql('iq_stock_tick',cnx,if_exists='append',chunksize=100) 
    print i  


openstock.close()

cnx.close()

------------------------------------------------------------------------------------------------

#!/usr/bin/python
import tushare as ts
import os
import re
from sqlalchemy import create_engine
import cx_Oracle


p_ktype='W'


stocklistpath = '/root/stock_py/stocklist1.txt'
openstock = open(stocklistpath,'r')
engine = create_engine('oracle+cx_oracle://stock:stock@192.168.1.10/orcl')
cnx = engine.connect()


for i in openstock:
    r = r"S[ZH]\d\d\d\d\d\d"
    stocknum = re.findall(r,i)
    stocknum = i[2:8]
    df = ts.get_hist_data(code=stocknum)
    df.index.names=['op_time']
    df['STOCKID']= i
    df['ktype']= p_ktype
    df.to_sql('iq_stock',cnx,if_exists='append',chunksize=500) 
    print i  


openstock.close()
cnx.close()