old row new row, urgent

[CrazyBunnyz]

i would like to get old row and new row like https://www.npmjs.com/package/mysql-events. right now all i got is IntVar { timestamp: 1604743109000, nextPosition: 4795, size: 9, type: 2, value: 17, binlogName: 'mysql-bin.000001' } basically i want more detail. can you help me ? and it doesnt detect update too. here is my code const mysql = require('mysql'); const MySQLEvents = require('@rodrigogs/mysql-events');

const program = async () => { const connection = mysql.createConnection({ host: 'localhost', user: 'root', password: '', database: 'sociominer' });

const instance = new MySQLEvents(connection, { startAtEnd: true, excludedSchemas: { mysql: true, }, });

await instance.start();

instance.addTrigger({ name: 'TEST', expression: '*', statement: MySQLEvents.STATEMENTS.ALL, onEvent: (event) => { console.log(event); // { type, schema, table, affectedRows: [], affectedColumns: [], timestamp, } }, });

instance.on(MySQLEvents.EVENTS.CONNECTION_ERROR, console.error); instance.on(MySQLEvents.EVENTS.ZONGJI_ERROR, console.error); };

program() .then(() => console.log('Waiting for database events...')) .catch(console.error);

and db

i just want to see if there are insert update delete event from test table ( only test table ) and coresponding old row and new row and what about if i want to listen specificly to certain table only cause currently i listen to al table. already try expression: '*.test', but no event comming instead ( no event ) note : i never and dont want to use schema if possible my aim is really similar to this https://github.com/kuroski/mysql-events-ui/blob/master/server.js except i need to know which table and row inserted and updated so i know which client shoud i emitted to. especially on insert and update

[Kayoti]

you just simply need to traverse the log by calling the right event and traverse the array "e.affectedRows['0']" remember if you have "startAtEnd: true" flag set to true you will not see the output until you actually trigger an event , if you want to view all existing events so that you can debug and traverse without triggering an event set it to false

instance.addTrigger({
    name: 'monitoring all statments',
    expression: 'test.testtable.*', 
    statement: MySQLEvents.STATEMENTS.ALL, 
    onEvent: e => {

      console.log(e.affectedRows['0']['before']);
      console.log(e.affectedRows['0']['after']);

    }
  });

[felippelmartins]

My problem is similar to CrazyBunnyz's The event does not show all the info and the expression does not work unless I put only '*'. My output is similar: IntVar { timestamp: 1622029530000, nextPosition: 715, size: 9, type: 2, value: 8, binlogName: 'mysql-bin-changelog.000188' }

[olivinesguerra]

@felippelmartins Hi. Does this problem resolved?