def update_status_ticket(self, dict_status_ticket): ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database()) row = ticket_board_dao.update_status(dict_status_ticket) if row: return {"result_code": "OK", "message": "success"} return {"result_code": "ERROR", "message": "ticket not found with id %s" % dict_status_ticket['id_ticket']}
def get_dict_board_code(self, id_ticket): ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database()) ticket_artifact_dao = TicketArtifactDao(self._controller_dao.get_dict_database()) row_board_code = ticket_board_dao.get_ticket_code(id_ticket) rows = ticket_artifact_dao.get_ticket_artifact_code(id_ticket) list_artifact = [] for a_row in rows: list_artifact.append(json.dumps(a_row, cls=AlchemyEncoder)) return {"dict_board": json.dumps(row_board_code, cls=AlchemyEncoder), "artifacts": list_artifact}
def test_03(self): config_file = '../board.cfg' config = ConfigParser.RawConfigParser() config.read(config_file) connection_file = config.get('DatabaseSection', 'database.file') controller_dao = ControllerDao(connection_file) ticket_board_dao = TicketBoardDao(controller_dao.get_dict_database()) m_result = ticket_board_dao.get_ticket('feature2') print m_result.__dict__ self.assertTrue(m_result is not None)
def test_07(self): config_file = '../board.cfg' config = ConfigParser.RawConfigParser() config.read(config_file) connection_file = config.get('DatabaseSection', 'database.file') controller_dao = ControllerDao(connection_file) try: ticket_board_dao = TicketBoardDao( controller_dao.get_dict_database()) row = ticket_board_dao.get_ticket('feature2') row.user_request = '*****@*****.**' controller_dao._session.commit() self.assertTrue(True) except RuntimeError as e: self.assertTrue(False, e.message)
def process_library_ticket(self, dict_defect): translate_environment_dao = TranslateEnvironmentDao(self._controller_dao.get_dict_database()) crm = dict_defect["crm"] environment = dict_defect["environment"] id_environment = translate_environment_dao.translate(crm=crm, environment=environment) if id_environment: dict_defect['dict_defect'] = dict_defect["description"][:200] dict_defect['id_environment'] = id_environment ticket_library_dao = TicketLibraryDao(self._controller_dao.get_dict_database()) ticket_library_dao.process_ticket_library(dict_defect) ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database()) ticket_board_dao.update_environment(dict_defect['id_ticket'], id_environment) return {"result_code": "OK", "message": "success"} else: message_error = "couldn't find id_environment at translate_environment table, with crm=%s environment=%s" % ( dict_defect["crm"], dict_defect["environment"]) logger.error(message_error) return {"result_code": "ERROR", "message": message_error}
def test_04(self): config_file = '../board.cfg' config = ConfigParser.RawConfigParser() config.read(config_file) connection_file = config.get('DatabaseSection', 'database.file') controller_dao = ControllerDao(connection_file) try: ticket_board_dao = TicketBoardDao( controller_dao.get_dict_database()) dict_ticket_board = { "id_ticket": "feature3", "id_environment": "1", "user_request": "*****@*****.**" } ticket_board_dao.add(dict_ticket_board) controller_dao._session.commit() self.assertTrue(True) except RuntimeError as e: self.assertTrue(False, e.message)
def insert_ticket_board(self, dic_ticket_board): ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database()) ticket_board_dao.add(dic_ticket_board)
def get_ticket_board(self, id_ticket): ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database()) row = ticket_board_dao.get_ticket(id_ticket) return row