text: const FETCH_PRODUCT_QUERY = `
      SELECT * FROM deal.PRODUCT
  `;
  
  const FETCH_PRODUCT_BY_SELLERID_QUERY = `
      SELECT * FROM deal.PRODUCT WHERE seller=?
  `;
  
  const CREATE_PRODUCT_QUERY = `
      INSERT INTO deal.PRODUCT 
      (seller, title, content, town, category, price, photos, thumbnail) 
      VALUES (?, ?, ?, ?, ?, ?, ?, ?)
  `;
  
  const UPDATE_PRODUCT_QUERY = `
      UPDATE deal.PRODUCT 
      SET title=?, content=?, town=?, category=?, price=?, photos=?, thumbnail=? 
      WHERE id=?;
  `;
  
  const FIND_PRODUCT_BY_ID_QUERY = `
      SELECT * from deal.PRODUCT WHERE id=?
  `;
  
  const DELETE_PRODUCT_BY_ID = `
      DELETE FROM deal.PRODUCT WHERE id=?
  `;
  
  const UPDATE_MINUS_ROOM_COUNT = `
      UPDATE PRODUCT SET chatroomcounts = chatroomcounts-1 WHERE id =?
  `;
  
  const UPDATE_PLUS_ROOM_COUNT = `
      UPDATE PRODUCT SET chatroomcounts = chatroomcounts+1 WHERE id =?
  `;
  
  const UPDATE_PRODUCT_STATUS = `
      UPDATE deal.PRODUCT SET state=? WHERE id=?
  `;
  
  const UPDATE_PRODUCT_VIEWS = `
      UPDATE PRODUCT SET views = views+1 WHERE id=?
  `;
  
  const UPDATE_USER_LIKES = `
      UPDATE deal.USER SET likes=? WHERE id=?
  `;
  
  const FETCH_SELLER_BY_ID = `
      SELECT seller FROM deal.PRODUCT WHERE id=?
  `;
  
  const FETCH_THUMBNAIL_BY_ID = `
      SELECT thumbnail FROM PRODUCT WHERE id=?
  `;
  
  const UPDATE_PRODUCT_LIKECOUNTS = `
      UPDATE deal.PRODUCT SET likecounts=? WHERE id=?;
  `;
  
  module.exports = {
    FETCH_PRODUCT_QUERY, //
    FETCH_PRODUCT_BY_SELLERID_QUERY,
    CREATE_PRODUCT_QUERY,
    UPDATE_PRODUCT_QUERY,
    FIND_PRODUCT_BY_ID_QUERY,
    DELETE_PRODUCT_BY_ID,
    UPDATE_MINUS_ROOM_COUNT,
    UPDATE_PLUS_ROOM_COUNT,
    UPDATE_PRODUCT_STATUS,
    UPDATE_PRODUCT_VIEWS,
    UPDATE_USER_LIKES,
    FETCH_SELLER_BY_ID,
    FETCH_THUMBNAIL_BY_ID,
    UPDATE_PRODUCT_LIKECOUNTS,
  };
  