def importBankTransactions():
### imports old transactions, Emma/Dan mint transactions, appends together and inserts into database
start = time.time()
if demo: ## only used to demo account to add dummy data. Is turned on above.
df = pd.read_csv('DemoData/demotransactions.csv', parse_dates = ['transdate'])
else:
df = pd.read_csv('CSVs/oldtransactions.csv', parse_dates = ['transdate'])
df_accrual = pd.read_csv('CSVs/accrual.csv', parse_dates = ['transdate'])
df = df.append(df_accrual)
new = time.time()
start = new
df = df.append(mintImport())
new = time.time()
start = new
df = df.append(stockPricesImport.stockincome())
new = time.time()
start = new
df = df.sort('transdate')
df.to_sql('transactions', engine, if_exists = 'replace', index=False, dtype={'accountname': sqlalchemy.types.VARCHAR(length=30)})
sql.execute("CREATE INDEX transactions_transdate_index ON money.transactions (transdate);", engine)
sql.execute("CREATE INDEX transactions_accountname_index ON money.transactions (accountname);", engine)
def importBankTransactions():
### imports old transactions, Emma/Dan mint transactions, appends together and inserts into database
if demo: ## only used to demo account to add dummy data. Is turned on above.
df = pd.read_csv('DemoData/demotransactions.csv', parse_dates = ['transdate'])
else:
df = pd.read_csv('CSVs/oldtransactions.csv', parse_dates = ['transdate'])
df_accrual = pd.read_csv('CSVs/accrual.csv', parse_dates = ['transdate'])
df = df.append(df_accrual)
df = df.append(mintImport())
df = df.append(stockPricesImport.stockincome())
df = df.sort('transdate')
df.to_sql('transactions', engine, if_exists = 'replace', index=False)
