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 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 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()
