Python RulePriority示例

示例#1

文件： rule.py 项目： alenacci/BuildingRules

	def store(self):

		updateQuery = False

		database = Database()
		database.open()

		query = "SELECT COUNT(id) FROM rules WHERE id = '@@id@@';"
		query = self.__replaceSqlQueryToken(query)
		queryResult = database.executeReadQuery(query)

		if self.lastEditTimestamp == None:
			self.lastEditTimestamp =  datetime.datetime.now() 

		if self.creationTimestamp == None:
			self.creationTimestamp = datetime.datetime.now() 


		if int(queryResult[0][0]) > 0:
			
			self.lastEditTimestamp =  datetime.datetime.now() 

			query = """UPDATE rules SET 
					priority = '@@priority@@', category = '@@category@@', building_name = '@@building_name@@', group_id = '@@group_id@@', room_name = '@@room_name@@', 
					author_uuid = '@@author_uuid@@', antecedent = '@@antecedent@@', consequent = '@@consequent@@', enabled = '@@enabled@@', 
					deleted = '@@deleted@@', creation_timestamp = '@@creation_timestamp@@', last_edit_timestamp = '@@last_edit_timestamp@@'
					WHERE id = '@@id@@';"""
			updateQuery = True
			
		else:

			query = """INSERT INTO rules (priority, category, building_name, group_id, room_name, author_uuid, antecedent, 
					consequent, enabled, deleted, creation_timestamp, last_edit_timestamp) VALUES (
					'@@priority@@', '@@category@@', '@@building_name@@', '@@group_id@@', '@@room_name@@', '@@author_uuid@@', '@@antecedent@@', '@@consequent@@', '@@enabled@@', 
					'@@deleted@@', '@@creation_timestamp@@', '@@last_edit_timestamp@@');"""


		query = self.__replaceSqlQueryToken(query)
		database.executeWriteQuery(query)
		self.id = int(database.getLastInsertedId()) if not self.id else self.id
		database.close()

		if not self.groupId and not updateQuery:
			from app.backend.model.rulePriority import RulePriority
			rulePriority = RulePriority(buildingName = self.buildingName, roomName = self.roomName, ruleId = self.id, rulePriority = self.__priority)
			rulePriority.store()

示例#2

文件： rule.py 项目： alenacci/BuildingRules

	def setPriority(self, priority, roomName = None, buildingName = None):
	
		from app.backend.model.rulePriority import RulePriority

		if self.groupId and not roomName:
			self.__priority = priority
		elif self.groupId and roomName and buildingName:
			rulePriority = RulePriority(buildingName = buildingName, roomName = roomName, ruleId = self.id, rulePriority = priority)
			rulePriority.store()
		elif self.roomName:
			rulePriority = RulePriority(buildingName = self.buildingName, roomName = self.roomName, ruleId = self.id, rulePriority = priority)
			rulePriority.store()			
		else:
			raise RuleInitFailedError("Some parameters are missing")

示例#3

文件： rule.py 项目： alenacci/BuildingRules

	def getPriority(self, roomName = None, buildingName = None):

		from app.backend.model.rulePriority import RulePriority


		if self.groupId and not roomName:
			return self.__priority
		elif self.groupId and roomName and buildingName:
			try:
				rulePriority = RulePriority(buildingName = buildingName, roomName = roomName, ruleId = self.id)
				rulePriority.retrieve()
				return rulePriority.rulePriority
			except RoomRulePriorityNotFoundError as e:
				return self.__priority
		elif self.roomName:
			try: 
				rulePriority = RulePriority(buildingName = self.buildingName, roomName = self.roomName, ruleId = self.id)
				rulePriority.retrieve()			
				return rulePriority.rulePriority
			except Exception as e:
				return self.__priority
		else:
			raise RuleInitFailedError("Some parameters are missing")