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_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 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 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 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
