def test_import_should_write_into_abrechnungen():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
import_data.index(PostRequest({'import': _IMPORT_DATA}))
written_abrechnung = None
for key in file_system.instance()._fs_stub.keys():
if key.startswith('../Import'):
written_abrechnung = file_system.instance()._fs_stub[key]
assert written_abrechnung == _IMPORT_DATA
def test_gemeinsam_import_with_unpassenden_kategorie_should_import_value_and_requestmapping(
):
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'KeinEssen', 'some name', -1.54)
requester.INSTANCE = RequesterStub(
{
'https://test.test/gemeinsamebuchung.php':
_JSON_IMPORT_DATA_GEMEINSAM,
'https://test.test/deletegemeinsam.php': '',
'https://test.test/login.php': LOGIN_RESPONSE
},
DECODED_LOGIN_DATA,
auth_cookies=LOGIN_COOKIES)
context = import_data.index(
PostRequest({
'action': 'load_online_gemeinsame_transactions',
'email': '',
'server': 'test.test',
'password': ''
}))
assert context['element_titel'] == 'Kategorien zuweisen'
assert context['import'] == _IMPORT_DATA_GEMEINSAM
assert context['unpassende_kategorien'] == ['Essen']
context = import_data.index(
PostRequest({
'action': 'map_and_push',
'Essen_mapping': 'neue Kategorie anlegen',
'import': _IMPORT_DATA_GEMEINSAM
}))
assert context['element_titel'] == 'Export / Import'
assert len(database_instance().gemeinsamebuchungen.content) == 2
assert database_instance(
).gemeinsamebuchungen.content.Person[0] == 'TestUser'
assert database_instance(
).gemeinsamebuchungen.content.Person[1] == 'Partner'
assert database_instance(
).gemeinsamebuchungen.content.Kategorie[0] == 'Essen'
assert database_instance(
).gemeinsamebuchungen.content.Kategorie[1] == 'Essen'
assert requester.instance().call_count_of(
'https://test.test/deletegemeinsam.php') == 1
assert requester.instance().complete_call_count() == 3
def test_import_with_one_buchung_should_show_success_single_message():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
context = import_data.index(PostRequest({'import': _IMPORT_DATA}))
assert context['message_content'] == '1 Buchung wurde importiert'
def test_gemeinsam_import_adde_passende_kategorie_should_import_value():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
requester.INSTANCE = RequesterStub(
{
'https://test.test/gemeinsamebuchung.php':
_JSON_IMPORT_DATA_GEMEINSAM,
'https://test.test/deletegemeinsam.php': '',
'https://test.test/login.php': LOGIN_RESPONSE
},
DECODED_LOGIN_DATA,
auth_cookies=LOGIN_COOKIES)
context = import_data.index(
PostRequest({
'action': 'load_online_gemeinsame_transactions',
'email': '',
'server': 'test.test',
'password': ''
}))
assert context['element_titel'] == 'Export / Import'
assert len(database_instance().gemeinsamebuchungen.content) == 2
assert database_instance().gemeinsamebuchungen.get(
0)['Name'] == 'Testausgabe1'
assert database_instance().gemeinsamebuchungen.get(
0)['Person'] == 'TestUser'
assert database_instance().gemeinsamebuchungen.get(
1)['Name'] == 'Testausgabe2'
assert requester.instance().call_count_of(
'https://test.test/deletegemeinsam.php') == 1
assert requester.instance().complete_call_count() == 3
def test_adde_unpassenden_kategorie_should_show_import_mapping_page():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'unbekannt', 'some name', -1.54)
context = import_data.index(PostRequest({'import': _IMPORT_DATA}))
assert context['element_titel'] == 'Kategorien zuweisen'
def test_add_passende_kategorie_should_import_value():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
context = import_data.index(PostRequest({'import': _IMPORT_DATA}))
assert context['element_titel'] == 'Export / Import'
assert einzelbuchungen.select().select_year(2017).sum() == -11.54
def test_gemeinsam_import_with_unpassenden_partnername_should_import_value_and_repalce_name(
):
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
requester.INSTANCE = RequesterStub(
{
'https://test.test/gemeinsamebuchung.php':
_JSON_IMPORT_DATA_GEMEINSAM_WRONG_PARTNER,
'https://test.test/deletegemeinsam.php': '',
'https://test.test/login.php': LOGIN_RESPONSE
},
DECODED_LOGIN_DATA,
auth_cookies=LOGIN_COOKIES)
context = import_data.index(
PostRequest({
'action': 'load_online_gemeinsame_transactions',
'email': '',
'server': 'test.test',
'password': ''
}))
assert context['element_titel'] == 'Export / Import'
assert len(database_instance().gemeinsamebuchungen.content) == 2
assert database_instance().gemeinsamebuchungen.get(0) == {
'Datum': datetime.date(2019, 7, 11),
'Dynamisch': False,
'Kategorie': 'Essen',
'Name': 'Testausgabe2',
'Person': 'TestUser',
'Wert': -0.9,
'index': 0
}
assert database_instance().gemeinsamebuchungen.get(1) == {
'Datum': datetime.date(2019, 7, 15),
'Dynamisch': False,
'Kategorie': 'Essen',
'Name': 'Testausgabe1',
'Person': 'Partner',
'Wert': -1.3,
'index': 1
}
assert requester.instance().call_count_of(
'https://test.test/deletegemeinsam.php') == 1
assert requester.instance().complete_call_count() == 3
def test_upload_data_fehler():
set_up()
database_instance().gemeinsamebuchungen.add(datum('1.1.2020'),
'kategorie1', 'name1', 1.11,
'TestUser')
database_instance().gemeinsamebuchungen.add(datum('2.2.2020'),
'kategorie2', 'name2', 2.22,
'Partner')
requester.INSTANCE = RequesterStub(
{
'https://test.test/api/gemeinsamebuchung.php':
'{"result": "error"}',
'https://test.test/api/partner.php': _JSON_DATA_PARTNER,
'https://test.test/api/login.php': LOGIN_RESPONSE
},
DECODED_LOGIN_DATA,
auth_cookies=LOGIN_COOKIES)
result = import_data.index(
PostRequest({
'action': 'upload_gemeinsame_transactions',
'email': '',
'server': 'test.test/api',
'password': ''
}))
assert len(database_instance().gemeinsamebuchungen.content) == 2
assert result['message']
assert result['message_type'] == 'error'
assert result[
'message_content'] == 'Fehler beim Hochladen der gemeinsamen Buchungen.'
assert requester.INSTANCE.data_of_request(
'https://test.test/api/gemeinsamebuchung.php') == [[{
'datum': '2020-01-01',
'kategorie': 'kategorie1',
'name': 'name1',
'zielperson': 'online user name',
'wert': 1.11
}, {
'datum': '2020-02-02',
'kategorie': 'kategorie2',
'name': 'name2',
'zielperson': 'OnlinePartner',
'wert': 2.22
}]]
def test_import_with_error_should_show_message():
set_up()
requester.INSTANCE = RequesterErrorStub()
context = import_data.index(
PostRequest({
'action': 'load_online_gemeinsame_transactions',
'email': '',
'server': 'test.test',
'password': ''
}))
assert context['message']
assert context['message_type'] == 'error'
assert context[
'message_content'] == 'Verbindung zum Server konnte nicht aufgebaut werden.'
def test_einzelbuchung_import_adde_passende_kategorie_should_import_value():
set_up()
einzelbuchungen = database_instance().einzelbuchungen
einzelbuchungen.add(datum('01.01.2017'), 'Essen', 'some name', -1.54)
requester.INSTANCE = RequesterStub(
{
'https://test.test/einzelbuchung.php': _JSON_IMPORT_DATA,
'https://test.test/deleteitems.php': '',
'https://test.test/login.php': LOGIN_RESPONSE
},
mocked_decode=DECODED_LOGIN_DATA)
context = import_data.index(
PostRequest({
'action': 'load_online_transactions',
'email': '',
'server': 'test.test',
'password': ''
}))
assert context['element_titel'] == 'Export / Import'
assert len(database_instance().einzelbuchungen.content) == 3
assert database_instance().einzelbuchungen.get(1) == {
'Datum': datum('11.07.2019'),
'Dynamisch': False,
'Kategorie': 'Essen',
'Name': 'Testausgabe2',
'Tags': np.nan,
'Wert': -0.9,
'index': 1
}
assert database_instance().einzelbuchungen.get(2) == {
'Datum': datum('15.07.2019'),
'Dynamisch': False,
'Kategorie': 'Essen',
'Name': 'Testausgabe1',
'Tags': np.nan,
'Wert': -1.3,
'index': 2
}
assert requester.instance().call_count_of(
'https://test.test/deleteitems.php') == 1
assert requester.instance().complete_call_count() == 3
def test_set_kategorien_with_ausgeschlossene_kategoerien_should_hide_ausgeschlossene_kategorien(
):
set_up()
database_instance().einzelbuchungen.add(datum('20.01.1990'), 'JaEins',
'SomeTitle', -10)
database_instance().einzelbuchungen.add(datum('20.01.1990'), 'NeinEins',
'SomeTitle', -10)
database_instance().einzelbuchungen.add(datum('20.01.1990'), 'JaZwei',
'SomeTitle', -10)
configuration.index(
PostRequest({
'action': 'set_ausgeschlossene_kategorien',
'ausgeschlossene_kategorien': 'NeinEins'
}))
requester.INSTANCE = RequesterStub(
{
'https://test.test/setkategorien.php': '',
'https://test.test/login.php': LOGIN_RESPONSE
},
DECODED_LOGIN_DATA,
auth_cookies=LOGIN_COOKIES)
result = import_data.index(
PostRequest({
'action': 'set_kategorien',
'email': '',
'server': 'test.test',
'password': ''
}))
assert result['message']
assert result['message_type'] == 'success'
assert result[
'message_content'] == 'Kategorien erfolgreich in die Online-Version übertragen.'
assert requester.instance().data_of_request(
'https://test.test/setkategorien.php'
)[0]['kategorien'] == 'JaEins,JaZwei'
def test_init_should_return_index_page():
set_up()
context = import_data.index(GetRequest())
assert context['element_titel'] == 'Export / Import'
def test_transaction_id_should_be_in_context():
set_up()
context = import_data.index(GetRequest())
print(context)
assert 'ID' in context
def view_import():
return import_data.index(request)
