Subversion Repositories SmartDukaan

Rev

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

Rev 5519 Rev 5536
Line 43... Line 43...
43 
  		 entityType = #{entityType}
 43 
  		 entityType = #{entityType}
44 
  		 AND entityIdentifier = #{entityIdentifier}
 44 
  		 AND entityIdentifier = #{entityIdentifier}
45 
  	</where>
 45 
  	</where>
46 
</select>
 46 
</select>
47 
 
 47 
 
- 
 
 48 
<select id="getEntityMonitoringStatus" parameterType="int" resultType="entity_monitoring_status">
- 
 
 49 
	SELECT *
- 
 
 50 
	FROM entity_monitoring_status
- 
 
 51 
	<where>
- 
 
 52 
  		 entityType = #{entityType}
- 
 
 53 
  	</where>
- 
 
 54 
</select>
- 
 
 55 
 
48 
<insert id="insertAlertedEntity" parameterType="map" useGeneratedKeys="true" keyProperty="id">
 56 
<insert id="insertAlertedEntity" parameterType="map" useGeneratedKeys="true" keyProperty="id">
49 
	INSERT INTO alerted_entity
 57 
	INSERT INTO alerted_entity
50 
      (entityType, eventType, entityIdentifier, lastAlertedTime, entityProperties, entityProcessedState)
 58 
      (entityType, eventType, entityIdentifier, lastAlertedTime, entityProperties, entityProcessedState)
51 
    VALUES
 59 
    VALUES
52 
      (#{entityType}, #{eventType}, #{entityIdentifier}, #{lastAlertedTime}, #{entityProperties}, #{entityProcessedState})
 60 
      (#{entityType}, #{eventType}, #{entityIdentifier}, #{lastAlertedTime}, #{entityProperties}, #{entityProcessedState})