1 @message |
assert
+ ['2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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', ' 0 ms\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n']
LOG DETAILS:
2024-05-16 11:11:29.163
2024-05-16 11:11:29.163 act = <firebird.qa.plugin.Action object at [hex]>
2024-05-16 11:11:29.163 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-05-16 11:11:29.163
2024-05-16 11:11:29.163 @pytest.mark.trace
2024-05-16 11:11:29.163 @pytest.mark.version('>=3')
2024-05-16 11:11:29.163 def test_1(act: Action, capsys):
2024-05-16 11:11:29.163 with act.trace(db_events=trace), act.db.connect() as con:
2024-05-16 11:11:29.163 for cmd in ddl_lst:
2024-05-16 11:11:29.163 con.execute_immediate(cmd)
2024-05-16 11:11:29.163 con.commit()
2024-05-16 11:11:29.163
2024-05-16 11:11:29.163 #print(act.trace_to_stdout())
2024-05-16 11:11:29.163 print(act.trace_log)
2024-05-16 11:11:29.163 act.expected_stdout = '' # expected_stdout
2024-05-16 11:11:29.163 act.stdout = capsys.readouterr().out
2024-05-16 11:11:29.163 > assert act.clean_stdout == act.clean_expected_stdout
2024-05-16 11:11:29.163 E assert
2024-05-16 11:11:29.163 E + ['2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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', ' 0 ms\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n']
2024-05-16 11:11:29.163
2024-05-16 11:11:29.163 tests\bugs\test_trace_eol_cr_space_nl.py:76: AssertionError
2024-05-16 11:11:29.163 ---------------------------- Captured stdout setup ----------------------------
2024-05-16 11:11:29.163 Cached db: db-12.0-None-None-NONE.fdb [page_size=None, sql_dialect=None, charset='NONE'
|
2 #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-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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', ' 0 ms\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n', '2024-05-16T11:05:00.5580 (2500:0000000001B82740) EXECUTE_STATEMENT_FINISH\r \n', '\tR:\\TEMP\\QA\\FBQA\\TEST_11336\\TEST.FDB (ATT_7, SYSDBA:NONE, NONE, TCPv6:::1/58956)\r \n', '\tC:\\Python3x\\python.exe:10388\r \n', '\t\t(TRA_3, 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\r \n', '\r \n']
tests\bugs\test_trace_eol_cr_space_nl.py:76: AssertionError
|