docs: def query_record_useful_review(comID, value):
      """
      private funciton
      Adjust the number of useful votes and number of total votes for a comment.
      :param comID: comment id
      :param value: +1 or -1
      :return: integer 1 if successful, integer 0 if not
      """
      # retrieve nb_useful votes
      query1 = """SELECT nb_votes_total, nb_votes_yes FROM "cmtRECORDCOMMENT" WHERE id=%s"""
      params1 = (comID,)
      res1 = run_sql(query1, params1)
      if len(res1) == 0:
          return 0
  
      # modify and insert new nb_useful votes
      nb_votes_yes = int(res1[0][1])
      if value >= 1:
          nb_votes_yes = int(res1[0][1]) + 1
      nb_votes_total = int(res1[0][0]) + 1
      query2 = """UPDATE "cmtRECORDCOMMENT" SET nb_votes_total=%s, nb_votes_yes=%s WHERE id=%s"""
      params2 = (nb_votes_total, nb_votes_yes, comID)
      res2 = run_sql(query2, params2)
      return int(res2)