Skip to content
Pycroft CI

Lookup missing BIC when returning bank account activities #1293

Sign in to view logs

Lookup missing BIC when returning bank account activities

Lookup missing BIC when returning bank account activities #1293

GitHub Actions / JUnit Test Report failed Jul 8, 2024 in 0s

1252 tests run, 962 passed, 1 skipped, 289 failed.

Annotations

Check failure on line 1 in tests/frontend/test_facilities.py

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

test_facilities.test_root_redirect 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestSitesOverview

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestSitesOverview.test_sites_overview_get 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestSitesOverview

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestSitesOverview.test_sites_overview_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestSite

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestSite.test_get_site 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestSite

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestSite.test_get_nonexistent_site 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_list_buildings 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_show_building 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_show_nonexistent_building 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_show_room 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_show_nonexistent_room 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_post_room_logs 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_room_logs_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_building_levels 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_nonexistent_building_levels 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_building_levels_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_building_rooms_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestBuilding

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestBuilding.test_building_level_rooms 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestRoomTenancies

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestRoomTenancies.test_room_tenancies_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestOvercrowdedRooms

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestOvercrowdedRooms.test_overcrowded_rooms 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestOvercrowdedRooms

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestOvercrowdedRooms.test_overcrowded_rooms_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestOvercrowdedRooms

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestOvercrowdedRooms.test_per_building_overcrowded_rooms 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestOvercrowdedRooms

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestOvercrowdedRooms.test_per_building_overcrowded_json 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestRoomCreate

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestRoomCreate.test_get_no_building 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestRoomCreate

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestRoomCreate.test_get_wrong_id 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)

Check failure on line 1 in TestRoomCreate

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

TestRoomCreate.test_get_correct_building_id 

failed on setup with "sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

[SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
[parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)"
Raw output 
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   psycopg2.errors.NotNullViolation: null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).

The above exception was the direct cause of the following exception:
tests/frontend/conftest.py:69: in config
    module_session.flush()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4296: in flush
    self._flush(objects)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4431: in _flush
    with util.safe_reraise():
../venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:146: in __exit__
    raise exc_value.with_traceback(exc_tb)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4392: in _flush
    flush_context.execute()
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:466: in execute
    rec.execute(self)
../venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py:642: in execute
    util.preloaded.orm_persistence.save_obj(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:93: in save_obj
    _emit_insert_statements(
../venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py:1048: in _emit_insert_statements
    result = connection.execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1422: in execute
    return meth(
../venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py:514: in _execute_on_connection
    return connection._execute_clauseelement(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1644: in _execute_clauseelement
    ret = self._execute_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1850: in _execute_context
    return self._exec_single_context(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1990: in _exec_single_context
    self._handle_dbapi_exception(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2357: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
../venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1971: in _exec_single_context
    self.dialect.do_execute(
../venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py:919: in do_execute
    cursor.execute(statement, parameters)
E   sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "non_attributable_transactions_account_id" of relation "config" violates not-null constraint
E   DETAIL:  Failing row contains (2, 3, 4, 6, 8, 9, 10, 11, 5, 7, 1, 1, null, null, 1).
E   
E   [SQL: INSERT INTO config (member_group_id, network_access_group_id, violation_group_id, external_group_id, blocked_group_id, caretaker_group_id, treasurer_group_id, pre_member_group_id, traffic_limit_exceeded_group_id, payment_in_default_group_id, membership_fee_account_id, membership_fee_bank_account_id, non_attributable_transactions_account_id, fints_product_id, id) VALUES (%(member_group_id)s, %(network_access_group_id)s, %(violation_group_id)s, %(external_group_id)s, %(blocked_group_id)s, %(caretaker_group_id)s, %(treasurer_group_id)s, %(pre_member_group_id)s, %(traffic_limit_exceeded_group_id)s, %(payment_in_default_group_id)s, %(membership_fee_account_id)s, %(membership_fee_bank_account_id)s, %(non_attributable_transactions_account_id)s, %(fints_product_id)s, %(id)s)]
E   [parameters: {'member_group_id': 2, 'network_access_group_id': 3, 'violation_group_id': 4, 'external_group_id': 6, 'blocked_group_id': 8, 'caretaker_group_id': 9, 'treasurer_group_id': 10, 'pre_member_group_id': 11, 'traffic_limit_exceeded_group_id': 5, 'payment_in_default_group_id': 7, 'membership_fee_account_id': 1, 'membership_fee_bank_account_id': 1, 'non_attributable_transactions_account_id': None, 'fints_product_id': None, 'id': 1}]
E   (Background on this error at: https://sqlalche.me/e/20/gkpj)
View more details on GitHub Actions