# -*- coding: utf-8 -*-
"""
Created on Wed Sep 14 14:41:04 2016
@author: john
"""
import datetime
import sys
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
import tushare as ts
import pandas as pd
reload(sys)
sys.setdefaultencoding('utf-8')
begin = datetime.date(2016,1,4)
end = datetime.date(2016,1,20)
d = begin
engine = create_engine('oracle://stock:stock@127.0.0.1:1521/orcl',encoding='gbk')
Db_Session=sessionmaker(bind=engine)
session=Db_Session()
#session.execute('create table aaaaa (a varchar2(100))')
df=pd.read_sql('select code from test',engine)
print df
#print session.execute('select * from test').first()
delta = datetime.timedelta(days=1)
while d <= end:
print d.strftime("%Y-%m-%d")
data=ts.get_hist_data('600848')
# print(data)
d += delta