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
def getInfo(self, actionName): checkData(locals()) action = Action(actionName = actionName) action.retrive() return action.getDict()