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)