2 @message |
assert
+ ['2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'recreate /* ddl_1 line_1 */ \n', ' \n', ' table /* ddl_1 line_2 */ \n', ' \n', ' \n', ' \n', ' t_test /* ddl_1 line_3 */ (x int) \n', ' \r \n', '0 records fetched\r \n', ' 1 ms, 22 read(s), 244 fetch(es), 30 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'comment on /* ddl_2 line_1 */ \n', ' table /* ddl_2 line_2 */ \n', ' \n', ' \n', ' t_test is /* ddl_2 line_3 */ \n', " 'foo /* ddl_2 line_4 */ \n", " /* ddl_2 line_4 */ bar' \n", ' \r \n', '0 records fetched\r \n', ' 0 ms, 19 fetch(es), 3 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', ' \n', ' \n', ' create /* ddl_3 line_1 */ \n', ' or /* ddl_3 line_2 */ \n', ' \n', ' alter /* ddl_3 line_3 */ \n', ' view /* ddl_3 line_4 */ \n', ' \n', ' v_rio /* ddl_3 line_5 */ \n', ' \n', ' as /* ddl_3 line_6 */ \n', ' select * /* ddl_3 line_6 */ \n', ' ...\r \n', '0 records fetched\r \n', ' 0 ms, 4 read(s), 221 fetch(es), 51 mark(s)\r \n', '\r \n']
LOG DETAILS:
2024-05-16 09:15:49.166
2024-05-16 09:15:49.166 act = <firebird.qa.plugin.Action object at [hex]>
2024-05-16 09:15:49.166 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-05-16 09:15:49.166
2024-05-16 09:15:49.166 @pytest.mark.trace
2024-05-16 09:15:49.166 @pytest.mark.version('>=3')
2024-05-16 09:15:49.166 def test_1(act: Action, capsys):
2024-05-16 09:15:49.166 with act.trace(db_events=trace), act.db.connect() as con:
2024-05-16 09:15:49.166 for cmd in ddl_lst:
2024-05-16 09:15:49.166 con.execute_immediate(cmd)
2024-05-16 09:15:49.166 con.commit()
2024-05-16 09:15:49.166
2024-05-16 09:15:49.166 #print(act.trace_to_stdout())
2024-05-16 09:15:49.166 print(act.trace_log)
2024-05-16 09:15:49.166 act.expected_stdout = '' # expected_stdout
2024-05-16 09:15:49.166 act.stdout = capsys.readouterr().out
2024-05-16 09:15:49.166 > assert act.clean_stdout == act.clean_expected_stdout
2024-05-16 09:15:49.166 E assert
2024-05-16 09:15:49.166 E + ['2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'recreate /* ddl_1 line_1 */ \n', ' \n', ' table /* ddl_1 line_2 */ \n', ' \n', ' \n', ' \n', ' t_test /* ddl_1 line_3 */ (x int) \n', ' \r \n', '0 records fetched\r \n', ' 1 ms, 22 read(s), 244 fetch(es), 30 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'comment on /* ddl_2 line_1 */ \n', ' table /* ddl_2 line_2 */ \n', ' \n', ' \n', ' t_test is /* ddl_2 line_3 */ \n', " 'foo /* ddl_2 line_4 */ \n", " /* ddl_2 line_4 */ bar' \n", ' \r \n', '0 records fetched\r \n', ' 0 ms, 19 fetch(es), 3 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', ' \n', ' \n', ' create /* ddl_3 line_1 */ \n', ' or /* ddl_3 line_2 */ \n', ' \n', ' alter /* ddl_3 line_3 */ \n', ' view /* ddl_3 line_4 */ \n', ' \n', ' v_rio /* ddl_3 line_5 */ \n', ' \n', ' as /* ddl_3 line_6 */ \n', ' select * /* ddl_3 line_6 */ \n', ' ...\r \n', '0 records fetched\r \n', ' 0 ms, 4 read(s), 221 fetch(es), 51 mark(s)\r \n', '\r \n']
2024-05-16 09:15:49.166
2024-05-16 09:15:49.166 tests\bugs\test_trace_eol_cr_space_nl.py:76: AssertionError
2024-05-16 09:15:49.166 ---------------------------- Captured stdout setup ----------------------------
2024-05-16 09:15:49.166 Cached db: db-13.0-None-None-NONE.fdb [page_size=None, sql_dialect=None, charset='NONE'
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.trace
@pytest.mark.version('>=3')
def test_1(act: Action, capsys):
with act.trace(db_events=trace), act.db.connect() as con:
for cmd in ddl_lst:
con.execute_immediate(cmd)
con.commit()
#print(act.trace_to_stdout())
print(act.trace_log)
act.expected_stdout = '' # expected_stdout
act.stdout = capsys.readouterr().out
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E + ['2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'recreate /* ddl_1 line_1 */ \n', ' \n', ' table /* ddl_1 line_2 */ \n', ' \n', ' \n', ' \n', ' t_test /* ddl_1 line_3 */ (x int) \n', ' \r \n', '0 records fetched\r \n', ' 1 ms, 22 read(s), 244 fetch(es), 30 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', 'comment on /* ddl_2 line_1 */ \n', ' table /* ddl_2 line_2 */ \n', ' \n', ' \n', ' t_test is /* ddl_2 line_3 */ \n', " 'foo /* ddl_2 line_4 */ \n", " /* ddl_2 line_4 */ bar' \n", ' \r \n', '0 records fetched\r \n', ' 0 ms, 19 fetch(es), 3 mark(s)\r \n', '\r \n', '2024-05-16T09:06:18.0970 (2836:00000000010D0AC0) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11558\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/49459)\r \n', '\tC:\\Python3x\\python.exe:10560\r \n', '\t\t(TRA_4, CONCURRENCY | WAIT | READ_WRITE)\r \n', '\r \n', '-------------------------------------------------------------------------------\r \n', ' \n', ' \n', ' create /* ddl_3 line_1 */ \n', ' or /* ddl_3 line_2 */ \n', ' \n', ' alter /* ddl_3 line_3 */ \n', ' view /* ddl_3 line_4 */ \n', ' \n', ' v_rio /* ddl_3 line_5 */ \n', ' \n', ' as /* ddl_3 line_6 */ \n', ' select * /* ddl_3 line_6 */ \n', ' ...\r \n', '0 records fetched\r \n', ' 0 ms, 4 read(s), 221 fetch(es), 51 mark(s)\r \n', '\r \n']
tests\bugs\test_trace_eol_cr_space_nl.py:76: AssertionError
|