def create_statements(self, input_fields):
"""
Creates the records needed for Table.FINANCE
and returns them as a Statement object.
"""
try:
dba = DatabaseAccess(self.config)
date_created = current_date()
date_modified = current_date()
statement_finance = Statement(T_FINANCE)
records = 0
currency_exchange_id = dba.first_currency_exchange_id_from_latest()
rate_id = dba.first_rate_id_from_latest()
for fields in input_fields:
account_from_id = dba.account_id_from_account_name(
fields[Input.ACCOUNT_FROM], True)
account_to_id = dba.account_id_from_account_name(
fields[Input.ACCOUNT_TO], False)
#NOTE: in the database, the first values in the tables of the
#below id's, are empty/dummy values, used for when we are not
#dealing with stocks.
rate_id = 1
if deals_with_commodities(
fields[Input.ACCOUNT_FROM],
fields[Input.ACCOUNT_TO]
):
rate_id = dba.get_latest_rate_id()
amount_value = fields[Input.AMOUNT]
if is_negative_amount(fields[Input.ACCOUNT_FROM]):
amount_value = Decimal(-1.0) * amount_value
records = records + 1
statement_finance.add(
records,
{
'finance_id': None,
'date': fields[Input.DATE],
'year': fields[Input.DATE].year,
'month': fields[Input.DATE].month,
'day': fields[Input.DATE].day,
'account_from_id': account_from_id,
'account_to_id': account_to_id,
'amount': amount_value,
'comment': fields[Input.COMMENT],
'currency_exchange_id': currency_exchange_id,
'rate_id': rate_id,
'active': 1,
'date_created': date_created,
'date_modified': date_modified
}
)
currency_exchange_id = currency_exchange_id + 1
print 'test: ', statement_finance.statements_insert
return statement_finance
except Exception as ex:
print Error.CREATE_STATEMENTS_TABLE_FINANCE, ex
finally:
dba = None
