public void test_should_find_the_most_actual_rate_for_every_currency() {
Currency c1 = CurrencyBuilder.withDb(db).name("USD").title("Dollar").symbol("$").create();
Currency c2 = CurrencyBuilder.withDb(db).name("EUR").title("Euro").symbol("€").create();
Currency c3 =
CurrencyBuilder.withDb(db).name("SGD").title("Singapore Dollar").symbol("S$").create();
RateBuilder.withDb(db).from(c1).to(c2).at(DateTime.date(2012, 1, 17)).rate(0.78592f).create();
RateBuilder.withDb(db).from(c1).to(c2).at(DateTime.date(2012, 1, 18)).rate(0.78635f).create();
RateBuilder.withDb(db).from(c1).to(c3).at(DateTime.date(2012, 1, 15)).rate(0.111f).create();
RateBuilder.withDb(db).from(c2).to(c3).at(DateTime.date(2012, 1, 16)).rate(0.222f).create();
RateBuilder.withDb(db).from(c2).to(c3).at(DateTime.date(2012, 1, 14)).rate(0.333f).create();
ExchangeRateProvider m = db.getLatestRates();
ExchangeRate rate = m.getRate(c1, c2);
assertRate(DateTime.date(2012, 1, 18), 0.78635f, rate);
rate = m.getRate(c2, c1);
assertRate(DateTime.date(2012, 1, 18), 1.0f / 0.78635f, rate);
rate = m.getRate(c1, c3);
assertRate(DateTime.date(2012, 1, 15), 0.111f, rate);
rate = m.getRate(c2, c3);
assertRate(DateTime.date(2012, 1, 16), 0.222f, rate);
rate = m.getRate(c3, c2);
assertRate(DateTime.date(2012, 1, 16), 1.0f / 0.222f, rate);
}
private void assertAccountBlotterTotal(Account a1, DateTime start, DateTime end, int total) {
WhereFilter filter = enhanceFilterForAccountBlotter(WhereFilter.empty());
filter.btw(
BlotterFilter.DATETIME,
String.valueOf(start.atMidnight().asLong()),
String.valueOf(end.atDayEnd().asLong()));
filter.eq(BlotterFilter.FROM_ACCOUNT_ID, String.valueOf(a1.id));
TransactionsTotalCalculator calculator = new TransactionsTotalCalculator(db, filter);
assertEquals(total, calculator.getAccountTotal().balance);
}
public void test_should_calculate_accounts_total_in_home_currency() {
AccountBuilder.withDb(db).title("Cash").currency(c1).total(500).create();
AccountBuilder.withDb(db).title("Bank").currency(c2).total(1200).create();
RateBuilder.withDb(db).from(c1).to(c2).at(DateTime.date(2012, 1, 17)).rate(0.78592f).create();
RateBuilder.withDb(db).from(c1).to(c2).at(DateTime.date(2012, 1, 18)).rate(0.78635f).create();
// total in c1
assertEquals((long) (500 + (1.0f / 0.78635f) * 1200), db.getAccountsTotal(c1).balance);
// total in c2
assertEquals((long) (1200 + (0.78635f) * 500), db.getAccountsTotal(c2).balance);
// total in c3
Currency c3 =
CurrencyBuilder.withDb(db).name("SGD").title("Singapore Dollar").symbol("S$").create();
assertTrue(db.getAccountsTotal(c3).isError());
}