RelayState.js 529 B

12345678910111213141516171819
  1. const db = require('../config/db');
  2. const logger = require('../logger');
  3. class RelayState {
  4. static updateRoomInfo(device_id, room_number, room_name) {
  5. const sql = `
  6. UPDATE relay_state
  7. SET room_number = ?, room_name = ?
  8. WHERE device_id = ?
  9. `;
  10. db.query(sql, [room_number, room_name, device_id], (err) => {
  11. if (err) {
  12. logger.error(`更新房间信息失败: ${device_id}`);
  13. }
  14. });
  15. }
  16. }
  17. module.exports = RelayState;