search

rodrigogs / mysql-events

A node package that watches a MySQL database and runs callbacks on matched events.
BSD 3-Clause "New" or "Revised" License
136 stars 52 forks source link

Bulk create support #47

Closed imdkbj closed 1 year ago

imdkbj commented 1 year ago

I am not getting any event for the following query.

INSERT INTO `ticks` (`instrument_token`,`last_price`,`open`,`high`,`low`,`close`,`change`,`volume_traded`,`createdAt`,`updatedAt`) VALUES (1071105,242.4,242,244.1,237.55,240.45,0.8109794135995081,9931,'2022-12-28 13:17:25','2022-12-28 13:17:25'),(940033,431.55,432.9,438.95,430.1,430.05,0.34879665155214507,67414,'2022-12-28 13:17:25','2022-12-28 13:17:25') ON DUPLICATE KEY UPDATE `instrument_token`=VALUES(`instrument_token`),`last_price`=VALUES(`last_price`),`open`=VALUES(`open`),`high`=VALUES(`high`),`low`=VALUES(`low`),`close`=VALUES(`close`),`change`=VALUES(`change`),`volume_traded`=VALUES(`volume_traded`);