private boolean isNewRecord(DatabaseTable table, DatabaseTableFilter filter)
throws CantLoadTableToMemoryException {
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
table.loadToMemory();
if (table.getRecords().isEmpty()) return true;
else return false;
}
private List<DatabaseTableRecord> getRecordsByFilter(DatabaseTableFilter filter)
throws CantLoadTableToMemoryException {
DatabaseTable table =
this.database.getTable(
BitcoinVenezuelaProviderDatabaseConstants.DAILY_EXCHANGE_RATES_TABLE_NAME);
if (filter != null)
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
table.loadToMemory();
return table.getRecords();
}
private List<DatabaseTableRecord> getCryptoMoneyRestockData(DatabaseTableFilter filter)
throws CantLoadTableToMemoryException {
DatabaseTable table =
getDatabaseTable(
StockTransactionsCrpytoMoneyRestockDatabaseConstants.CRYPTO_MONEY_RESTOCK_TABLE_NAME);
if (filter != null)
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
table.loadToMemory();
return table.getRecords();
}
private List<DatabaseTableRecord> getBankMoneyRestockData(DatabaseTableFilter filter)
throws CantLoadTableToMemoryException {
DatabaseTable table =
getDatabaseTable(
BussinessTransactionBankMoneyRestockDatabaseConstants.BANK_MONEY_STOCK_TABLE_NAME);
if (filter != null)
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
table.loadToMemory();
return table.getRecords();
}
private List<DatabaseTableRecord> getTransactionRecordsByFilter(
DatabaseTableFilter filter, int max, int offset) throws CantLoadTableToMemoryException {
DatabaseTable table =
this.database.getTable(CashMoneyWalletDatabaseConstants.TRANSACTIONS_TABLE_NAME);
if (filter != null)
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
if (offset >= 0) table.setFilterOffSet(String.valueOf(offset));
if (max >= 0) table.setFilterTop(String.valueOf(max));
table.loadToMemory();
return table.getRecords();
}
public void saveBankMoneyRestockTransactionData(BankMoneyTransaction bankMoneyTransaction)
throws DatabaseOperationException, MissingBankMoneyRestockDataException {
try {
database = openDatabase();
DatabaseTransaction transaction = database.newTransaction();
// TODO: Solo para prueba ya que priceReference viene null desde android revisar con Nelson
bankMoneyTransaction.setPriceReference(new BigDecimal(0));
/*//TODO:Revisar con guillermo que el accountNumber viene null
bankMoneyTransaction.setBankAccount("123456");
*/
DatabaseTable table =
getDatabaseTable(
BussinessTransactionBankMoneyRestockDatabaseConstants.BANK_MONEY_STOCK_TABLE_NAME);
DatabaseTableRecord bankMoneyRestockRecord = getBankMoneyRestockRecord(bankMoneyTransaction);
DatabaseTableFilter filter = table.getEmptyTableFilter();
filter.setType(DatabaseFilterType.EQUAL);
filter.setValue(bankMoneyTransaction.getTransactionId().toString());
filter.setColumn(
BussinessTransactionBankMoneyRestockDatabaseConstants
.BANK_MONEY_RESTOCK_TRANSACTION_ID_COLUMN_NAME);
if (isNewRecord(table, filter)) transaction.addRecordToInsert(table, bankMoneyRestockRecord);
else {
table.addStringFilter(filter.getColumn(), filter.getValue(), filter.getType());
transaction.addRecordToUpdate(table, bankMoneyRestockRecord);
}
// I execute the transaction and persist the database side of the asset.
database.executeTransaction(transaction);
database.closeDatabase();
} catch (Exception e) {
if (database != null) database.closeDatabase();
throw new DatabaseOperationException(
DatabaseOperationException.DEFAULT_MESSAGE,
e,
"Error trying to save the Bank Money Restock Transaction in the database.",
null);
}
}
