Subversion Repositories SmartDukaan

Rev

Rev 5563 | Rev 5759 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5563 Rev 5674
Line 77... Line 77...
77 
  		 OR (criticalExpiryTime <= NOW()
 77 
  		 OR (criticalExpiryTime <= NOW()
78 
  		 AND entityProcessedState < 2)
 78 
  		 AND entityProcessedState < 2)
79 
  	</where>
 79 
  	</where>
80 
</select>
 80 
</select>
81 
 
 81 
 
- 
 
 82 
<select id="getActiveAlertEntities" resultType="monitored_entity">
- 
 
 83 
	SELECT *
- 
 
 84 
	FROM monitored_entity
- 
 
 85 
	<where>
- 
 
 86 
  		 warnExpiryTime &lt;= NOW()
- 
 
 87 
  	</where>
- 
 
 88 
</select>
- 
 
 89 
 
82 
<update id="updateEntityProcessedState" parameterType="map">
 90 
<update id="updateEntityProcessedState" parameterType="map">
83 
	UPDATE monitored_entity
 91 
	UPDATE monitored_entity
84 
      SET entityProcessedState=#{state}
 92 
      SET entityProcessedState=#{state}
85 
	<where>
 93 
	<where>
86 
  		id = #{id}
 94 
  		id = #{id}