julien-duponchelle/python-mysql-replication

Getting Date and Log position from stream

Closed this issue · 1 comments

blackoctop commented

Hello,
Can I somehow get Date and Log positon from WriteRowsEvent, I found stream.log_pos but could it be used as unique identifier for event all over binlog ?

=== WriteRowsEvent ===
Date: 2022-10-18T17:07:36
Log position: 16392
Event size: 30
Read bytes: 10
Table: test.test
Affected columns: 3
Changed rows: 1
Values:

  • id : 17
  • transaction_date : 2022-02-11 00:00:00
  • amt : 1140.150
blackoctop commented

NVM. I just used print(dir(binlogevent)) and then found the timestamp attribute.