def importDatesTable():
### creates table of dates for all dates from date specified until today + 400 days
from helperfunctions import table_of_dates
tableofdates = table_of_dates(2006,1,1,'D')
tableofdates.reset_index(inplace=True)
tableofdates.to_sql('datestable', engine, if_exists = 'replace', index=False)
def importDatesTable():
### creates table of dates for all dates from date specified until today + 400 days
from helperfunctions import table_of_dates
tableofdates = table_of_dates(2006,1,1,'D')
tableofdates.reset_index(inplace=True)
tableofdates.to_sql('datestable', engine, if_exists = 'replace', index=False, index_label='transdate')
sql.execute("CREATE INDEX transdate_index ON money.datestable (transdate);", engine)
