Example #1
0
	def getActions(self):

		from app.backend.model.action import Action

		database = Database()
		database.open()

		query = "SELECT * FROM rooms_actions WHERE room_name = '@@room_name@@' AND building_name = '@@building_name@@';"
		query = self.__replaceSqlQueryToken(query)
		queryResult = database.executeReadQuery(query)
		database.close()

		actionList = []
		for record in queryResult:
			actionId = record[2]
			
			action = Action(id = actionId)
			action.retrieve()

			actionList.append(action)

		return actionList
Example #2
0
	def getInfo(self, actionName):
		checkData(locals())
	
		action = Action(actionName = actionName)
		action.retrive()
		return action.getDict()