def test_insert_and_select(self):
# this test cases leaves entries in the 'production'
# database. In a realistic scenario, it should a) point
# to a testing db, or b) roll back the queries/inputs.
# todo: run db tests on a separate db
letter = random.choice(string.ascii_letters.lower())
currency = 'TS' + letter
request = RequestRecord(currency=currency,
requested_amount=1,
exchange_rate=0.88,
calculated_amount_USD=1.136)
db.insert_request(request)
result = db.select_last_requests(number=1, currency=currency)
self.assertEqual(currency, result[0]['currency'])
def get(self, currency):
with sanitizer_scope():
currency = sanitizers.currency(currency)
return db.select_last_requests(number=1, currency=currency)
def get(self, number, currency):
with sanitizer_scope():
number = sanitizers.number(number)
currency = sanitizers.currency(currency)
return db.select_last_requests(number, currency)
def get(self):
return db.select_last_requests(number=1, currency=None)