def process_ticket_artifact(self, dict_ticket_artifact): id_ticket = dict_ticket_artifact["id_ticket"] logger.debug("search ticket %s" % id_ticket) row_ticket_board = self.get_ticket_board(id_ticket) # if ticket exists if row_ticket_board: user_request = dict_ticket_artifact["modification_user"] # update user_request with new value of the artifact's email row_ticket_board.user_request = user_request row_ticket_board.date_requested = time.time() else: user_request = dict_ticket_artifact["modification_user"] id_environment = self.get_ticket_environment(id_ticket=id_ticket) dict_ticket = {"id_ticket": id_ticket, "id_environment": id_environment, "user_request": user_request} print "creating ticket_board, id_environment, id_ticket, id_status, date_requested..." self.insert_ticket_board(dict_ticket) ticket_artifact_dao = TicketArtifactDao(self._controller_dao.get_dict_database()) ticket_artifact_logging = TicketArtifactLoggingDao(self._controller_dao.get_dict_database()) cat_artifact_dao = CatArtifactDao(self._controller_dao.get_dict_database()) ls_artifact = dict_ticket_artifact["artifacts"] dict_ticket_artifact["code_base"] = id_ticket for code_artifact in ls_artifact: id_artifact = cat_artifact_dao.get_id_artifact(code_artifact) ticket_artifact_dao.process_ticket_artifact(id_artifact, dict_ticket_artifact) ticket_artifact_logging.add(id_artifact, dict_ticket_artifact) board_ticket = self.get_dict_board_code(id_ticket) return {"result": "OK", "board_ticket": board_ticket}
def get_artifacts(self): cat_artifact_dao = CatArtifactDao(self._controller_dao.get_dict_database()) rows = cat_artifact_dao.list_all() dict_artifact = {} for row in rows: key = row.path_directory value_key = row.id_artifact dict_artifact[key] = value_key return dict_artifact
def index(self): self._dict_database["session"] = cherrypy.request.db """ List artifacts """ cat_artifact_dao = CatArtifactDao(self._dict_database) artifacts = cat_artifact_dao.list_all() output_result = '<b>SdaTracker Application</b><br>' for artifact in artifacts: output_result += artifact.code_artifact + '<br>' return output_result
def test_01(self): config_file = '../board.cfg' config = ConfigParser.RawConfigParser() config.read(config_file) connection_file = config.get('DatabaseSection', 'database.file') controller_dao = ControllerDao(connection_file) cat_artifact_dao = CatArtifactDao(controller_dao.get_dict_database()) res = cat_artifact_dao.list_all() m_dict = {} for row in res: m_dict[row.path_directory] = row.code_artifact print m_dict self.assertTrue(len(res) > 0)
def get_list_artifacts(self): cat_artifact_dao = CatArtifactDao(self._controller_dao.get_dict_database()) return cat_artifact_dao.list_all()