def testCicloIndirecto(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.', 'ODJdbeidbww', 1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idFound0 = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia', idFound0)
search = aAcc.searchAccion('cinrohbwidia', idFound0)
idFound = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1', 0, 1, idFound, idFound0, 1, True,
TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1', idFound0)
idFound1 = searchHist[0].UH_idUserHistory
# Insertamos la categoria
aCategory = category()
aCategory.insertCategory('wofhweoifh', 1)
# Insertamos la tarea 1
aTarea = task()
aTarea.insertTask('dwidjw', 1, 1, idFound1, True, TODAY)
searchTask1 = aTarea.searchTask('dwidjw')
idprimera = searchTask1[0].HW_idTask
# Insertamos la tarea 2
bTarea = task()
bTarea.insertTask('dfghj', 2, 2, idFound1, True, TODAY)
searchTask2 = bTarea.searchTask('dfghj')
idsegunda = searchTask2[0].HW_idTask
# Insertamos la tarea 3
cTarea = task()
cTarea.insertTask('dfghj2', 3, 3, idFound1, True, TODAY)
searchTask3 = cTarea.searchTask('dfghj2')
idtercera = searchTask3[0].HW_idTask
#Insertamos la precedencia
aPrecedence = precedence()
aPrecedence.insertPrecedence(idprimera, idsegunda, idFound0)
aPrecedence.insertPrecedence(idsegunda, idtercera, idFound0)
self.assertEqual(
(aPrecedence.insertPrecedence(idtercera, idprimera, idFound0)),
None)
# Eliminamos la precedencia, tarea, categoria, historia, accion y producto
aPrecedence.deletePrecedence(idprimera, idsegunda)
aPrecedence.deletePrecedence(idsegunda, idtercera)
aTarea.deleteTask('dwidjw')
bTarea.deleteTask('dfghj')
bTarea.deleteTask('dfghj2')
aCategory.deleteCategory('wofhweoifh')
aHist.deleteUserHistory(idFound1)
aAcc.deleteAccion('cinrohbwidia', idFound0)
aBacklog.deleteProduct('Podn fjdd.')
def testSearchConsecuenteMuchosCorrecto(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.','ODJdbeidbww',1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idFound0 = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia',idFound0)
search = aAcc.searchAccion('cinrohbwidia',idFound0)
idFound = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1',0, 1,idFound, idFound0,1,True,TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1',idFound0)
idFound1 = searchHist[0].UH_idUserHistory
# Insertamos la categoria
aCategory = category()
aCategory.insertCategory('wofhweoifh',1)
# Insertamos la tarea 1
aTarea = task()
aTarea.insertTask('dwidjw',1,1,idFound1,True,TODAY)
searchTask1 = aTarea.searchTask('dwidjw')
idprimera = searchTask1[0].HW_idTask
# Insertamos la tarea 2
bTarea = task()
bTarea.insertTask('dfghj',2,2,idFound1,True,TODAY)
searchTask2 = bTarea.searchTask('dfghj')
idsegunda = searchTask2[0].HW_idTask
# Insertamos la tarea 3
cTarea = task()
cTarea.insertTask('dfghj2',3,3,idFound1,True,TODAY)
searchTask3 = cTarea.searchTask('dfghj2')
idtercera = searchTask3[0].HW_idTask
#Insertamos la precedencia
aPrecedence = precedence()
aPrecedence.insertPrecedence(idprimera,idsegunda,idFound0)
aPrecedence.insertPrecedence(idtercera,idsegunda,idFound0)
self.assertEqual ((aPrecedence.searchTaskByCons(idsegunda) != []), True)
# Eliminamos la precedencia, tarea, categoria, historia, accion y producto
aPrecedence.deletePrecedence(idprimera,idsegunda)
aPrecedence.deletePrecedence(idtercera,idsegunda)
aTarea.deleteTask('dwidjw')
bTarea.deleteTask('dfghj')
bTarea.deleteTask('dfghj2')
aCategory.deleteCategory('wofhweoifh')
aHist.deleteUserHistory(idFound1)
aAcc.deleteAccion('cinrohbwidia', idFound0)
aBacklog.deleteProduct('Podn fjdd.')
def __call__(self):
""""""
# Update things before creating all the tasks
self._on_before_tasks()
# create all the tasks
tasks = []
self.log.debug("Loading entry points from group {group}".format(
group=self.entry_point_group))
for ep in pkg_resources.iter_entry_points(self.entry_point_group):
# Tasks share the same args instance the command has.
tasks.append(ep.load()(self.args))
self.log.info("Running tasks {tasks}".format(tasks=tasks))
# Run each task
for task in tasks:
self.log.debug("Running task {task.name}".format(task=task))
task_dir = None
try:
task_dir = task()
except (Exception) as e:
if self.args.fail_fast:
raise
self.log.warn("Error from task {task.name}".format(task=task),
exc_info=True)
task.receipt.error = e
task.receipt.write()
self.log.info("Task {task.name} generated output in "\
"{task_dir}".format(task=task, task_dir=task_dir))
return (0, self._describe_receipts(tasks))
def add(self):
global tasks
start_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
t = task(self.t.get(), int(self.pt.get()), start_time, 0, 0, 0)
t.add_task_counts()
t.save()
self.refresh_window()
def initialize(log_text_box, text1, paramload, **kwargs):
# setup the logger and log display box
# examples of how to use (I need explanation):
print(logging.getLogger('test'))
private.logger = logging.getLogger('log')
#private.logger.setLevel(logging.DEBUG)
private.logger.setLevel(logging.INFO)
sh = logging.StreamHandler(log_text_box)
formatter = logging.Formatter('%(asctime)s - %(levelname)s - %(message)s')
sh.setFormatter(formatter)
private.logger.addHandler(sh)
private.logger.info('initialize complete')
private.A = task()
private.B = task()
#private.C = need class for timed task
text1.value = 'Process begun!'
def init_task(file_path):
taskset = []
conf_file = open(file_path, "r")
line = conf_file.readline()
while line != "":
if line == '\n' or line[0] == '#':
line = conf_file.readline()
continue
key = line.split(':')[0]
value = line.split(':')[1]
if key == "name":
new_task = task(value)
taskset.append(new_task)
if key == "priority":
new_task.priority = int(value)
if key == "deadline":
new_task.deadline = int(value) + new_task.release
if key == "period":
new_task.period = int(value)
if key == "release":
new_task.release = int(value)
if key == "cpu":
new_task.cpu = int(value)
line = conf_file.readline()
conf_file.close()
return taskset
def __call__(self):
""""""
# Update things before creating all the tasks
self._on_before_tasks()
# create all the tasks
tasks = []
self.log.debug("Loading entry points from group {group}".format(
group=self.entry_point_group))
for ep in pkg_resources.iter_entry_points(self.entry_point_group):
# Tasks share the same args instance the command has.
tasks.append(ep.load()(self.args))
self.log.info("Running tasks {tasks}".format(tasks=tasks))
# Run each task
for task in tasks:
self.log.debug("Running task {task.name}".format(task=task))
task_dir = None
try:
task_dir = task()
except (Exception) as e:
if self.args.fail_fast:
raise
self.log.warn("Error from task {task.name}".format(task=task),
exc_info=True)
task.receipt.error = e
task.receipt.write()
self.log.info("Task {task.name} generated output in "\
"{task_dir}".format(task=task, task_dir=task_dir))
return (0, self._describe_receipts(tasks))
def testIncompleteHistoriaUsuarioNoExistenteConTareas(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.', 'ODJdbeidbww', 1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idFound0 = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia', idFound0)
search = aAcc.searchAccion('cinrohbwidia', idFound0)
idFound = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1', 0, 1, idFound, idFound0, 1, True, TODAY,True, TOMORROW)
searchHist = aHist.searchUserHistory('BIEEIEB1', idFound0)
idFound1 = searchHist[0].UH_idUserHistory
# Insertamos la categoria
aCategory = category()
aCategory.insertCategory('wofhweoifh', 1)
# Insertamos la tarea 1
aTarea = task()
aTarea.insertTask('dwidjw', 1, 1, idFound1, True, TODAY,True, TOMORROW)
searchTask1 = aTarea.searchTask('dwidjw')
idprimera = searchTask1[0].HW_idTask
# Insertamos la tarea 2
bTarea = task()
bTarea.insertTask('dfghj', 2, 2, idFound1, True, TODAY,True, TOMORROW)
searchTask2 = bTarea.searchTask('dfghj')
idsegunda = searchTask2[0].HW_idTask
# Completamos historia
badId = idFound1 + 1
self.assertEqual((aHist.incompleteHistory(badId)), False)
# Eliminamos todo de la BD
aTarea.deleteTask('dwidjw')
bTarea.deleteTask('dfghj')
aCategory.deleteCategory('wofhweoifh')
aHist.deleteUserHistory(idFound1)
aAcc.deleteAccion('cinrohbwidia', idFound0)
aBacklog.deleteProduct('Podn fjdd.')
def testCompletarHistoriaUsuarioConTareas(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.','ODJdbeidbww',1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idFound0 = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia',idFound0)
search = aAcc.searchAccion('cinrohbwidia',idFound0)
idFound = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1',0, 1,idFound, idFound0,1,True,TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1',idFound0)
idFound1 = searchHist[0].UH_idUserHistory
# Insertamos la categoria
aCategory = category()
aCategory.insertCategory('wofhweoifh',1)
# Insertamos la tarea 1
aTarea = task()
aTarea.insertTask('dwidjw',1,1,idFound1,True,TODAY)
searchTask1 = aTarea.searchTask('dwidjw')
idprimera = searchTask1[0].HW_idTask
# Insertamos la tarea 2
bTarea = task()
bTarea.insertTask('dfghj',2,2,idFound1,True,TODAY)
searchTask2 = bTarea.searchTask('dfghj')
idsegunda = searchTask2[0].HW_idTask
# Completamos historia
self.assertEqual ((aHist.completeHistory(idFound1)),True)
# Eliminamos todo de la BD
aTarea.deleteTask('dwidjw')
bTarea.deleteTask('dfghj')
aCategory.deleteCategory('wofhweoifh')
aHist.deleteUserHistory(idFound1)
aAcc.deleteAccion('cinrohbwidia', idFound0)
aBacklog.deleteProduct('Podn fjdd.')
def taskWithIdAndDescription(self, idPila):
otask = task()
oHistory = userHistory()
result = []
historias = oHistory.getAllUserHistoryId(idPila)
for h in historias:
tareas = otask.getAllTask(h.UH_idUserHistory)
for t in tareas:
result.append((t.HW_idTask, t.HW_description + "\n(" + h.UH_codeUserHistory + ")"))
return result
def deleteAssignedSprintTask(self, sprintNumber, idBacklog, idTask): ''' Permite la asignacion de una historia asociado a un Sprint dado su id''' checkSprintNumber = type(sprintNumber) == int and MIN_SPRINT_NUMBER <= sprintNumber <= MAX_SPRINT_NUMBER checkidBacklog = type(idBacklog) == int and MIN_ID <= idBacklog checkidTask = type(idTask) == int and MIN_ID <= idTask if checkSprintNumber and checkidBacklog and checkidTask: oTask = task() tarea = oTask.getTaskById(idTask) if tarea: tarea.HW_idSprint = None db.session.commit() return True return False
def getTasks(self):
#Get whether we are rendering, etc
taskName = str(self.mainSelect.currentText())
#Create an empty list of tasks
tasks = []
if taskName == "Render":
paths = str(self.contextItems[0].text()).split(',')
tasks = [
task(taskName + '\n' + i,
command(execType.EXEC_BASH, "Render " + i)) for i in paths
]
del tasks[-1]
self.numTasks = len(paths)
elif taskName == "Wait":
t = taskName + '\n' + str(
self.contextItems[0].value()) + " minutes"
cmd = command(
execType.EXEC_PYTHON,
"time.sleep(" + str(self.contextItems[0].value() * 60) + ")")
tasks.append(task(t, cmd))
elif taskName == "Send Email":
t = taskName + '\n' + str(
self.contextItems[2].text()) + '\n' + str(
self.contextItems[3].text())
usr = str(self.contextItems[0].text())
pwd = str(self.contextItems[1].text())
address = str(self.contextItems[2].text())
body = str(self.contextItems[3].text())
cmd = command(
execType.EXEC_PYTHON, "util.sendEmail('" + usr + "','" + pwd +
"','" + address + "','" + body + "')")
tasks.append(task(t, cmd))
else:
tasks.append(task(taskName))
self.numTasks = 1
return tasks
def asignSprintTask(self, sprintNumber, idBacklog, idTask): ''' Permite asignar a un Sprint una tarea asociado a sus historias''' checkSprintNumber = type(sprintNumber) == int and MIN_SPRINT_NUMBER <= sprintNumber <= MAX_SPRINT_NUMBER checkidBacklog = type(idBacklog) == int and MIN_ID <= idBacklog checkidTask = type(idTask) == int and MIN_ID <= idTask if checkSprintNumber and checkidBacklog and checkidTask: oTask = task() tarea = oTask.getTaskById(idTask) sprint = self.searchIdSprint(sprintNumber, idBacklog) if tarea and sprint: tarea.HW_idSprint = sprint[0].S_idSprint db.session.commit() return True return False
def deleteAssignedSprintTask(self, sprintNumber, idBacklog, idTask):
''' Permite la asignacion de una historia asociado a un Sprint dado su id'''
checkSprintNumber = type(
sprintNumber
) == int and MIN_SPRINT_NUMBER <= sprintNumber <= MAX_SPRINT_NUMBER
checkidBacklog = type(idBacklog) == int and MIN_ID <= idBacklog
checkidTask = type(idTask) == int and MIN_ID <= idTask
if checkSprintNumber and checkidBacklog and checkidTask:
oTask = task()
tarea = oTask.getTaskById(idTask)
if tarea:
tarea.HW_idSprint = None
db.session.commit()
return True
return False
def asignSprintTask(self, sprintNumber, idBacklog, idTask):
''' Permite asignar a un Sprint una tarea asociado a sus historias'''
checkSprintNumber = type(
sprintNumber
) == int and MIN_SPRINT_NUMBER <= sprintNumber <= MAX_SPRINT_NUMBER
checkidBacklog = type(idBacklog) == int and MIN_ID <= idBacklog
checkidTask = type(idTask) == int and MIN_ID <= idTask
if checkSprintNumber and checkidBacklog and checkidTask:
oTask = task()
tarea = oTask.getTaskById(idTask)
sprint = self.searchIdSprint(sprintNumber, idBacklog)
if tarea and sprint:
tarea.HW_idSprint = sprint[0].S_idSprint
db.session.commit()
return True
return False
def conc_calculate(self, initial_args, user_id, corpus_name, subc_name, subchash, query, samplesize):
"""
Perform actual concordance calculation.
This is called automatically by the 'register()' function above.
arguments:
initial_args -- a dict(cachefile=..., pidfile=..., stored_pidfile=...) as obtained from register()
user_id -- an identifier of the user who entered the query (used to specify subc. directory if needed)
corpus_id -- a corpus identifier
subc_name -- a sub-corpus identifier (None if not used)
subchash -- a MD5 checksum of the sub-corpus data file
query -- a query tuple
samplesize -- a row number limit (if 0 then unlimited - see Manatee API)
"""
task = concworker.ConcCalculation(task_id=self.request.id)
subc_path = '%s/%s' % (settings.get('corpora', 'users_subcpath'), user_id)
return task(initial_args, subc_path, corpus_name, subc_name, subchash, query, samplesize)
def testInsertPrimeraTareaNoValida(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.','ODJdbeidbww',1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idFound0 = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia',idFound0)
search = aAcc.searchAccion('cinrohbwidia',idFound0)
idFound = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1',0, 1,idFound, idFound0,1,True,TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1',idFound0)
idFound1 = searchHist[0].UH_idUserHistory
# Insertamos la categoria
aCategory = category()
aCategory.insertCategory('wofhweoifh',1)
# Insertamos la tarea 1
aTarea = task()
aTarea.insertTask('dwidjw',1,1,idFound1,True,TODAY)
searchTask1 = aTarea.searchTask('dwidjw')
idprimera = searchTask1[0].HW_idTask
#Insertamos la precedencia
aPrecedence = precedence()
self.assertEqual ((aPrecedence.insertPrecedence(idprimera,None,idFound0)), None)
# Eliminamos la precedencia, tarea, categoria, historia, accion y producto
aTarea.deleteTask('dwidjw')
aCategory.deleteCategory('wofhweoifh')
aHist.deleteUserHistory(idFound1)
aAcc.deleteAccion('cinrohbwidia', idFound0)
aBacklog.deleteProduct('Podn fjdd.')
def perform_task(self, name):
name_without_suffix = name.replace("_expected", "").replace("_unexpected", "")
task = getattr(self, name_without_suffix)
task(name.endswith('_expected'))
spider.fetchDatas(task['flow'], step, *tuple(task['params'][1:-1].split(',')), **{'additions':additions})
else:
if task['index'] is None or task['index'].isdigit():
spider.fetchDatas(task['flow'], step, task['params'], **{'additions':additions})
else:
spider.fetchDatas(task['flow'], step, **{task['index']:task['params'], 'additions':additions})
spider.statistic()
changestate(task['_id'], 0)
if task.get('push_url') is not None:
requPost(task['push_url'], {'type':'video', 'tid':task['_id']})
except:
t, v, b = sys.exc_info()
err_messages = traceback.format_exception(t, v, b)
extra = ','.join(err_messages)
print extra
changestate(task['_id'], 3, extra=extra)
else:
if not task.get('type', 'FOREVER') == 'FOREVER':
stat(task, spider)
finally:
if ((datetime.datetime.now() - last_stat).seconds) >= LIMIT:
last_stat = datetime.datetime.now()
for spider in local_spider.values():
spider.statistic()
stat(task, spider, last_stat)
time.sleep(60)
if __name__ == '__main__':
task()
def generateDocument(idProduct,path):
width, height = letter #Tipo de hoja del documento.
documentName = path + "Documento-Vision.pdf" #Ruta donde se creara el documento.
#----------------------- Funciones especiales -----------------------------
def header(canvas,document):
'''Permite definir el encabezado del documento vision'''
canvas.saveState()
canvas.setLineWidth(width=1)
canvas.setStrokeColor(black)
#Dibujamos la tabla. rect(x, y, ancho, alto)
canvas.rect(2*cm , height - 13, width - 130, 22, fill=False, stroke=True)
#canvas.rect(12.3*cm, height - 13, 190 , 22, fill=False, stroke=True)
canvas.rect(2*cm , height - 26, width - 130, 13, fill=False, stroke=True)
canvas.rect(12.3*cm, height - 26, 190 , 13, fill=False, stroke=True)
canvas.rect(2*cm , height - 39, width - 130, 13, fill=False, stroke=True)
canvas.setFont('Arial',10)
canvas.drawString(2.1*cm, height - 1, "Título del proyecto: ")
canvas.setFont('Arial Bold',10)
canvas.drawString(5.2*cm, height - 1, projectName)
canvas.setFont('Arial',10)
canvas.drawString(2.1*cm, height - 23, "Artefacto: ")
canvas.setFont('Arial Bold',10)
canvas.drawString(3.7*cm, height - 23, "Documento de Visión")
canvas.setFont('Arial',10)
canvas.drawString(12.4*cm, height - 23, "Fecha: ")
canvas.setFont('Arial Bold',10)
canvas.drawString(13.6*cm, height - 23, currentDate)
canvas.setFont('Arial',10)
canvas.drawString(2.1*cm, height - 36, "Método de desarrollo de Software: Scrum")
canvas.restoreState()
def footer(canvas,document):
'''Permite definir el pie de pagina del documento vision'''
canvas.saveState()
canvas.setFont('Arial',10)
if (document.page != 1):
canvas.drawString(width - 180, 1 * cm, "Página %d" %document.page)
canvas.restoreState()
def insertJumpLine(statement,interval):
'''Permite insertar saltos de linea en un string para que se ajuste a un espacio
determinado'''
split = False
n = len(statement) // interval
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
for i in range(n,0,-1):
for j in range(i*interval,-1,-1):
j -= 1
if statement[j] == " ":
statement = statement[:j] + "\n" + statement[j+1:]
break
if j == 0:
split = True
if split:
n = len(statement)
acum = 0
for i in range(0,n+1,1):
if i == acum:
statement = statement[:i] + "\n" + statement[i:]
acum += interval
return statement
def days_between(d1, d2):
'''Permite calcular los dias transcurridos entre dos fechas dadas'''
return abs((d2 - d1).days)
#----------------------------- Clases a usar ------------------------------
oUser = user()
oTeam = team()
oBacklog = backlog()
oSprint = sprints()
oActor = role()
oAccion = accions()
oObjective = objective()
oUserHistory = userHistory()
oTask = task()
oActUserHist = actorsUserHistory()
oObjUserHist = objectivesUserHistory()
oSubTeam = subEquipoClass()
oDocument = visionDocument()
oCategory = category()
oACriteria = acceptanceCriteria()
oTCriteria = acceptanceTest()
#------------------------------ Fecha actual ------------------------------
i = datetime.datetime.now()
day = i.day
month = i.month
year = i.year
currentDate = str(day) + "/" + str(month) + "/" + str(year)
#---------------------------- Datos del proyecto --------------------------
result = oBacklog.findIdProduct(idProduct)
projectName = result.BL_name
projectDescription = result.BL_description
projectScaleType = result.BL_scaleType
information = oDocument.searchVisionDocument(idProduct)
#------------------ Datos de las historias de usuario ---------------------
#Obtenemos las historias asociadas al producto.
userHistoriesList = oBacklog.userHistoryAsociatedToProduct(idProduct)
weights = []
userHistories = []
epics = []
options = {1:'podria ',2:'puede '}
priorities = {0:'Epica',1:'Alta',2:'Media',3:'Baja'}
priorities2 = {i:str(i)for i in range(1,20+1)}
priorities2[0] = 'Epica'
#Obtenemos primero las epicas y las almacenamos en un arreglo.
for hist in userHistoriesList:
if oUserHistory.isEpic(hist.UH_idUserHistory):
result = oUserHistory.transformUserHistory(hist.UH_idUserHistory)
result['code'] = hist.UH_codeUserHistory
epics.append(result)
#Obtenemos los valores de las historias de usuario y sus pesos.
for hist in userHistoriesList:
if not oUserHistory.isEpic(hist.UH_idUserHistory):
result = oUserHistory.transformUserHistory(hist.UH_idUserHistory)
result['code'] = hist.UH_codeUserHistory
userHistories.append(result)
if projectScaleType == 1:
for hist in userHistories:
hist['priority'] = priorities[hist['priority']]
#--------------------- Secciones del proyecto -----------------------------
section_num = 1
section1 = ". Descripción de la metodología"
section2 = ". Descripción General del Método de Desarrollo de Software"
section3 = ". Personas y roles del proyecto"
section4 = ". Artefactos"
#--------------------- Subsecciones del proyecto --------------------------
subsection11 = "1.1 Introducción"
subsection12 = "1.2 Propósito de este documento"
subsection13 = "1.3 Motivación"
subsection14 = "1.4 Estado del Proyecto"
subsection15 = "1.5 Alcance"
subsection21 = "2.1 Fundamentación"
subsection22 = "2.2 Valores del equipo"
subsection_num = 2
subsection41 = ".1 Pila del producto"
subsection42 = ".2 Objetivos"
#------------------ Personas y roles del proyecto -------------------------
teamList = oTeam.getTeam(idProduct)
#--------------------- Descripcion de la metodologia ----------------------
introduction = information.VD_introduccion
porpose = information.VD_proposito
motivation = information.VD_motivacion
projectStatus = information.VD_estado
scope = information.VD_alcance
#-------- Descripción General del Método de Desarrollo del Software -------
groundwork = information.VD_fundamentacion
teamworkValues = information.VD_valores
#-------------------- Construccion del Documento --------------------------
#==========================================================================
#----------------------------- Portada ------------------------------------
story.append(Spacer(0,20))
story.append(Paragraph(projectName + ": " + projectDescription, styles['tittlePage']))
story.append(PageBreak())
#-------------------------- Introduccion ----------------------------------
story.append(Spacer(0,6))
story.append(Paragraph(str(section_num) + section1, styles['tittle']))
story.append(Spacer(0,15))
story.append(Paragraph(subsection11, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(introduction, styles['content']))
#---------------------------- Proposito -----------------------------------
story.append(Spacer(0,15))
story.append(Paragraph(subsection12, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(porpose, styles['content']))
#--------------------------- Motivacion -----------------------------------
story.append(Spacer(0,15))
story.append(Paragraph(subsection13, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(motivation, styles['content']))
#------------------------ Estado del proyecto -----------------------------
story.append(Spacer(0,15))
story.append(Paragraph(subsection14, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(projectStatus, styles['content']))
#------------------------------- Alcance ----------------------------------
story.append(Spacer(0,15))
story.append(Paragraph(subsection15, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(scope, styles['content']))
#---------------------------- Fundamentacion ------------------------------
story.append(Spacer(0,20))
section_num += 1
story.append(Paragraph(str(section_num) + section2, styles['tittle']))
story.append(Spacer(0,15))
story.append(Paragraph(subsection21, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(groundwork, styles['content']))
#------------------------------- Valores ----------------------------------
story.append(Spacer(0,15))
story.append(Paragraph(subsection22, styles['subtittle']))
story.append(Spacer(0,10))
story.append(Paragraph(teamworkValues, styles['content']))
story.append(Spacer(0,20))
#------------------- Personas y Roles del proyecto ------------------------
if teamList != []:
section_num += 1
story.append(Paragraph(str(section_num) + section3, styles['tittle']))
story.append(Spacer(0,15))
#Cabecera de la tabla.
t1 = Paragraph("Persona", styles['header'])
t2 = Paragraph("Contacto", styles['header'])
t3 = Paragraph("Rol", styles['header'])
tam_colums = [6.3*cm,6.3*cm,4.2*cm]
dataTable = [[t1,t2,t3]]
t_roles_persons = Table(dataTable,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_roles_persons)
#Mostramos los miembros del equipo asociado al producto.
for e in teamList:
u = oUser.searchUser(e.EQ_username)
if e.EQ_rol == "Product owner":
dataTable = [[u[0].U_fullname,u[0].U_email,"Dueño del Producto"]]
t_roles_persons = Table(dataTable,tam_colums,style=stylesTable1,hAlign='CENTER')
story.append(t_roles_persons)
for e in teamList:
u = oUser.searchUser(e.EQ_username)
if e.EQ_rol == "Scrum master":
dataTable = [[u[0].U_fullname,u[0].U_email,"Maestro Scrum"]]
t_roles_persons = Table(dataTable,tam_colums,style=stylesTable1,hAlign='CENTER')
story.append(t_roles_persons)
story.append(Spacer(0,20))
dataTable = [[t1,t2,t3]]
t_roles_persons = Table(dataTable,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_roles_persons)
for e in teamList:
u = oUser.searchUser(e.EQ_username)
if e.EQ_rol == "Team member":
dataTable = [[u[0].U_fullname,u[0].U_email,"Miembro del Equipo"]]
t_roles_persons = Table(dataTable,tam_colums,style=stylesTable1,hAlign='CENTER')
story.append(t_roles_persons)
story.append(Spacer(0,25))
#---------------------------- Pila del producto ---------------------------
#Lista donde se almacenara el orden en que fueron mostradas las historias y epicas.
historiesListId = []
if userHistories != [] or epics != []:
section_num += 1
story.append(Paragraph(str(section_num) + section4, styles['tittle']))
story.append(Spacer(0,10))
story.append(Paragraph(str(section_num) + subsection41, styles['subtittle']))
#Cabecera de la tabla.
t1 = Paragraph("ID", styles['header'])
t2 = Paragraph("Prioridad", styles['header'])
t3 = Paragraph("Épicas e Historias de Usuario", styles['header'])
tam_colums = [2.2*cm,2.2*cm,12.4*cm]
dataTableHist = [[t1,t2,t3]]
t_user_histories = Table(dataTableHist,tam_colums,style=stylesTable2,hAlign='CENTER')
story.append(t_user_histories)
tam_colums1 = [2.2*cm,14.6*cm]
#Mostramos las epicas.
for e in epics:
#Construimos el enunciado.
statement = "En tanto" + e['actors'] + e['actions'] + "para" + e['objectives']
historiesListId.append(e['idHistory'])
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
statement = insertJumpLine(statement,75)
dataTableHist = [[e['code'],statement]]
t_user_histories = Table(dataTableHist,tam_colums1,style=stylesTable3,hAlign='CENTER')
story.append(t_user_histories)
#Eliminamos la epica que ya mostramos.
epics.remove(e)
#Obtenemos los hijos de la epica y los mostramos asociados a la epica.
succesors = oUserHistory.succesors(e['idHistory'])
cantSuc = len(succesors)
for h in succesors:
result = oUserHistory.transformUserHistory(h)
result1 = oUserHistory.searchIdUserHistory(h)
result['code'] = result1[0].UH_codeUserHistory
if projectScaleType == 1:
result['priority'] = priorities[result['priority']]
#Construimos el enunciado.
statement = "En tanto" + result['actors'] + result['actions'] + "para" + result['objectives']
historiesListId.append(result['idHistory'])
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
statement = insertJumpLine(statement,65)
cantSuc -= 1
dataTableHist = [[result['code'], result['priority'],statement]]
if cantSuc != 1:
t_user_histories = Table(dataTableHist,tam_colums,style=stylesTable4,hAlign='CENTER')
else:
t_user_histories = Table(dataTableHist,tam_colums,style=stylesTable5,hAlign='CENTER')
story.append(t_user_histories)
userHistories.remove(result)
#Mostramos las historias de usuario que no son parte de una epica.
for hist in userHistories:
#Construimos el enunciado.
statement = "En tanto" + hist['actors'] + hist['actions'] + "para" + hist['objectives']
historiesListId.append(hist['idHistory'])
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
statement = insertJumpLine(statement,75)
dataTableHist = [[hist['code'], hist['priority'],statement]]
t_user_histories = Table(dataTableHist,tam_colums,style=stylesTable6,hAlign='CENTER')
story.append(t_user_histories)
story.append(Spacer(0,25))
#-------------------------------- Objetivos -------------------------------
#Obtenemos todos los objetivos asociados al producto.
objsList = oObjective.getAllObjectives(idProduct)
if objsList != []:
story.append(Paragraph(str(section_num) + subsection42, styles['subtittle']))
#Cabecera de la tabla.
t1 = Paragraph("ID", styles['header'])
t2 = Paragraph("Objetivo", styles['header'])
t3 = Paragraph("ID Historia", styles['header'])
tam_colums = [2.2*cm,11.9*cm,2.7*cm]
dataTableObj = [[t1,t2,t3]]
t_user_obj = Table(dataTableObj,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_user_obj)
#Mostramos los objetivos asociados a las historias de usuario.
idObj = 0
objectivesListId = []
for h in historiesListId:
hist = oUserHistory.searchIdUserHistory(h)
code = hist[0].UH_codeUserHistory
objs = oObjUserHist.idObjectivesAsociatedToUserHistory(h)
for o in objs:
obj = oObjective.searchIdObjective(o)
desc = obj[0].O_descObjective + "."
idObj += 1
objectivesListId.append(o)
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
desc = insertJumpLine(desc,70)
dataTableObj = [[idObj,desc,code]]
t_user_obj = Table(dataTableObj,tam_colums,style=stylesTable7,hAlign='CENTER')
story.append(t_user_obj)
#Mostramos los objetivos transversales y los que no estan asociados a una historia.
#Obtenemos solo los ids
objsIdList = []
for o in objsList:
objsIdList.append(o.O_idObjective)
conj1 = set(objsIdList)
conj2 = set(objectivesListId)
conj = conj1 - conj2
remainObjects = list(conj)
for o in remainObjects:
obj = oObjective.searchIdObjective(o)
desc = obj[0].O_descObjective + "."
idObj += 1
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
desc = insertJumpLine(desc,70)
dataTableObj = [[idObj,desc," "]]
t_user_obj = Table(dataTableObj,tam_colums,style=stylesTable7,hAlign='CENTER')
story.append(t_user_obj)
story.append(Spacer(0,25))
#------------------------------ Pila del sprint ---------------------------
#Obtenemos los sprints asociados al producto
sprintsList = oSprint.getAllSprintsAsociatedToProduct(idProduct)
if sprintsList != []:
story.append(Paragraph("4.3 Pila del sprint", styles['subtittle']))
for s in sprintsList:
#Cabecera de la tabla.
t1 = Paragraph("ID", styles['header'])
t2 = Paragraph("Historia de Usuario", styles['header'])
t3 = Paragraph("T/E", styles['header'])
#Obtenemos las historias asociadas al sprint.
userHistoryList = oSprint.getAssignedSprintHistory(s.S_numero,idProduct)
if userHistoryList != []:
tam_colums = [2.7*cm,12.6*cm,1.5*cm]
dataTableSprint = [[t1,t2,t3]]
t_user_sprints = Table(dataTableSprint,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_user_sprints)
t4 = Paragraph("Sprint " + str(s.S_numero),styles['subtittle'])
tam_colums1 = [16.8*cm]
tam_row = [0.6*cm]
dataTableSprint = [[t4]]
t_user_sprints = Table(dataTableSprint,tam_colums1,tam_row,style=stylesTable7,hAlign='CENTER')
story.append(t_user_sprints)
for uH in userHistoryList:
hist = oUserHistory.transformUserHistory(uH.UH_idUserHistory)
code = uH.UH_codeUserHistory
statement = "En tanto" + hist['actors'] + hist['actions'] + "para" + hist['objectives']
#Establecemos saltos de linea para que el contenido no se salga de la tabla.
statement = insertJumpLine(statement,77)
estimatedTime = oTask.historyEstimatedTime(uH.UH_idUserHistory)
dataTableSprint = [[code,statement, str(estimatedTime) + "h"]]
t_user_sprints = Table(dataTableSprint,tam_colums,style=stylesTable7,hAlign='CENTER')
story.append(t_user_sprints)
#Obtenemos el subequipo del sprint.
subTeamList = oSubTeam.getSubEquipo(s.S_idSprint)
if subTeamList != []:
n = len(subTeamList)
memberSubTeam = ""
for s in subTeamList:
member = s.SEQ_username
member = oUser.searchUser(member)
member = member[0].U_fullname
memberSubTeam += member
n -= 1
if n != 0:
memberSubTeam += ", "
if n == 0:
memberSubTeam += "."
t5 = Paragraph("Responsables", styles['content'])
tam_colums2 = [2.7*cm,14.1*cm]
members = insertJumpLine(memberSubTeam,90)
dataTableSprint = [[t5,members]]
t_user_sprints = Table(dataTableSprint,tam_colums2,style=stylesTable8,hAlign='CENTER')
story.append(t_user_sprints)
story.append(Spacer(0,5))
story.append(Paragraph("T/E es tiempo estimado.",styles['note']))
story.append(Spacer(0,20))
#--------------------------- Sprint planificado ---------------------------
#Obtenemos la lista de desarrolladores de un producto.
teamMemberList = oTeam.getTeamDevs(idProduct)
if sprintsList != []:
story.append(Paragraph("4.4 Sprint planificado", styles['subtittle']))
for s in sprintsList:
#Obtenemos las historias asociadas al sprint.
userHistoryList = oSprint.getAssignedSprintHistory(s.S_numero,idProduct)
#Obtenemos las tareas asociadas a cada sprint.
taskList = oSprint.getAssignedSprintTask(s.S_numero,idProduct)
if userHistoryList != []:
fini = s.S_fechini
dayIni = fini.day
monthIni = fini.month
yearIni = fini.year
fchini = str(dayIni) + "/" + str(monthIni) + "/" + str(yearIni)
ffin = s.S_fechfin
dayFin = ffin.day
monthFin = ffin.month
yearFin = ffin.year
fchfin = str(dayFin) + "/" + str(monthFin) + "/" + str(yearFin)
duration = days_between(fini,ffin)
#Cabecera de la tabla.
t1 = Paragraph("Sprint " + str(s.S_numero), styles['subtittle'])
t2 = Paragraph("Duración: " + str(duration) + " d", styles['content'])
t3 = Paragraph("Inicio: " + fchini, styles['content'])
t4 = Paragraph("Cierre: " + fchfin, styles['content'])
tam_colums = [4.8*cm,4*cm,4*cm,4*cm]
dataTableSprintPlan = [[t1,t2,t3,t4]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_user_sprintsPlan)
t5 = Paragraph("Pila del Sprint", styles['header'])
tam_colums1 = [16.8*cm]
dataTableSprintPlan = [[t5]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums1,style=stylesTable0,hAlign='CENTER')
story.append(t_user_sprintsPlan)
t6 = Paragraph("ID", styles['header'])
t7 = Paragraph("Tarea", styles['header'])
t8 = Paragraph("Categoría", styles['header'])
t9 = Paragraph("Estado", styles['header'])
t10 = Paragraph("T/E", styles['header'])
t11 = Paragraph("Responsable", styles['header'])
tam_colums2 = [1.4*cm,6.5*cm,2.9*cm,2*cm,1*cm,3*cm]
dataTableSprintPlan = [[t6,t7,t8,t9,t10,t11]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums2,style=stylesTable0,hAlign='CENTER')
story.append(t_user_sprintsPlan)
for h in userHistoryList:
#codigo de la historia
histCode = h.UH_codeUserHistory
#Obtenemos todas las tareas asociadas a la historia de la que se obtuvo el codigo.
taskListCurrent = []
for i in taskList:
if h.UH_idUserHistory == i.HW_idUserHistory:
taskListCurrent.append(i)
if taskListCurrent != []:
firstTask = taskListCurrent[0]
#Obtenemos el estado de la realizacion de la tarea.
statusCompleted = taskListCurrent[0].HW_completed
statusInitiated = taskListCurrent[0].HW_iniciado
status = ''
if statusCompleted:
status = "Culminada"
elif not statusCompleted and statusInitiated:
status = "Iniciada"
else:
status = "Por iniciar"
#Buscamos la categoria asiciada a la tarea
cat = oCategory.searchIdCategory(taskListCurrent[0].HW_idCategory)
cat = cat[0].C_nameCate
cat = insertJumpLine(cat,13)
#Obtenemos el tiempo estimado de la tarea.
estimatedTime = taskListCurrent[0].HW_estimatedTime
#Obtenemos el miembro encargado de la tarea.
memberAssigned = ''
for i in teamMemberList:
if i.EQ_idEquipo == taskListCurrent[0].HW_idEquipo:
memberAssigned = oUser.searchUser(i.EQ_username)
memberAssigned = memberAssigned[0].U_fullname
memberAssigned = insertJumpLine(memberAssigned,17)
descTask = taskListCurrent[0].HW_description
descTask = insertJumpLine(descTask,35)
dataTableSprintPlan = [[histCode,descTask,cat,status,estimatedTime,memberAssigned]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums2,style=stylesTable9,hAlign='CENTER')
story.append(t_user_sprintsPlan)
n = len(taskListCurrent)
for t in range(1,n):
statusCompleted = taskListCurrent[t].HW_completed
statusInitiated = taskListCurrent[t].HW_iniciado
status = ''
if statusCompleted:
status = "Culminada"
elif not statusCompleted and statusInitiated:
status = "Iniciada"
else:
status = "Por iniciar"
#Buscamos la categoria asiciada a la tarea
cat = oCategory.searchIdCategory(taskListCurrent[t].HW_idCategory)
cat = cat[0].C_nameCate
cat = insertJumpLine(cat,13)
estimatedTime = taskListCurrent[t].HW_estimatedTime
#Obtenemos el miembro asignado al desarrollo de la tarea.
teamMemberList = oTeam.getTeamDevs(idProduct)
memberAssigned = ''
for i in teamMemberList:
if i.EQ_idEquipo == taskListCurrent[t].HW_idEquipo:
memberAssigned = oUser.searchUser(i.EQ_username)
memberAssigned = memberAssigned[0].U_fullname
memberAssigned = insertJumpLine(memberAssigned,17)
descTask = taskListCurrent[t].HW_description
descTask = insertJumpLine(descTask,35)
dataTableSprintPlan = [["",descTask,cat,status,estimatedTime,memberAssigned]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums2,style=stylesTable10,hAlign='CENTER')
story.append(t_user_sprintsPlan)
num = insertJumpLine(str(oSprint.getEstimatedTime(s.S_numero,idProduct)),4)
t12 = Paragraph("Total de Tiempo Estimado", styles['header'])
t13 = Paragraph(num, styles['header'])
tam_colums3 = [12.8*cm,4*cm]
dataTableSprintPlan = [[t12,t13]]
t_user_sprintsPlan = Table(dataTableSprintPlan,tam_colums3,style=stylesTable1,hAlign='CENTER')
story.append(t_user_sprintsPlan)
story.append(Spacer(0,20))
#------------------------------- Entregables ------------------------------
if sprintsList != []:
story.append(Paragraph("4.5 Entregables", styles['subtittle']))
story.append(Spacer(0,15))
#------------------------ Criterios de Aceptacion -------------------------
if sprintsList != []:
story.append(Paragraph("4.5.1 Criterios de Aceptación de los Entregables", styles['subtittle']))
story.append(Spacer(0,10))
idAceptanceCriteria = 1
for s in sprintsList:
if oACriteria.aceptanceCriteriaEmpty(s.S_idSprint) != []:
#Obtenemos las historias asociadas al sprint.
userHistoryList = oSprint.getAssignedSprintHistory(s.S_numero,idProduct)
if userHistoryList != []:
t1 = Paragraph("ID", styles['header'])
t2 = Paragraph("Productos", styles['header'])
t3 = Paragraph("ID Historias", styles['header'])
tam_colums = [2*cm,10.8*cm,4*cm]
dataTableAcceptanCriteria = [[t1,t2,t3]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums,style=stylesTable0,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
t4 = Paragraph("Sprint " + str(s.S_numero),styles['subtittle'])
tam_colums1 = [16.8*cm]
dataTableAcceptanCriteria = [[t4]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable0,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
#Obtenemos primero las epicas y las almacenamos en un arreglo.
epics = []
for hist in userHistoryList:
if oUserHistory.isEpic(hist.UH_idUserHistory):
result = oUserHistory.transformUserHistory(hist.UH_idUserHistory)
result['code'] = hist.UH_codeUserHistory
epics.append(result)
#Obtenemos los valores de las historias de usuario.
userHistories = []
for hist in userHistoryList:
if not oUserHistory.isEpic(hist.UH_idUserHistory):
result = oUserHistory.transformUserHistory(hist.UH_idUserHistory)
result['code'] = hist.UH_codeUserHistory
userHistories.append(result)
n = len(epics)
#Mostramos las epicas.
for e in epics:
#Obtenemos los criterios de aceptacion asociados a la epica.
aceptanceCriteriaList = oACriteria.getAceptanceCriteriaByHistoryAndSprint(e['idHistory'],s.S_idSprint)
if aceptanceCriteriaList != []:
#Construimos el enunciado
statement = "En tanto" + e['actors'] + e['actions'] + "para" + e['objectives']
statement = insertJumpLine(statement,67)
codes = e['code']
sucessors = oUserHistory.succesors(e['idHistory'])
#Obtenemos las historias hijas.
for i in sucessors:
result = oUserHistory.searchIdUserHistory(i)
result = result[0].UH_codeUserHistory
codes += ", " + result
dataTableAcceptanCriteria = [[idAceptanceCriteria,statement,codes]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums,style=stylesTable9,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
idAceptanceCriteria += 1
t5 = Paragraph("Criterios de aceptación:",styles['subtittle'])
tam_colums1 = [2*cm,14.8*cm]
dataTableAcceptanCriteria = [["",t5]]
if n > 0:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
else:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable1,hAlign='CENTER')
n -= 1
story.append(t_user_acceptanCriteria)
#Mostramos los criterios de aceptacion.
for c in aceptanceCriteriaList:
criteria = c.HAC_enunciado
criteria = insertJumpLine(criteria,80)
dataTableAcceptanCriteria = [["",criteria]]
if n > 0:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
else:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable11,hAlign='CENTER')
print(codes,n,criteria)
n -= 1
story.append(t_user_acceptanCriteria)
statement = ''
n = len(sucessors)
#Mostramos las historias hijas.
for suc in sucessors:
#Obtenemos los criterios de aceptacion asociados a la historia.
aceptanceCriteriaList = oACriteria.getAceptanceCriteriaByHistoryAndSprint(suc,s.S_idSprint)
if aceptanceCriteriaList != []:
for h in userHistories:
if suc == h['idHistory']:
#Construimos el enunciado
statement = "En tanto" + h['actors'] + h['actions'] + "para" + h['objectives']
statement = insertJumpLine(statement,67)
code = h['code']
dataTableAcceptanCriteria = [[idAceptanceCriteria,statement,code]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums,style=stylesTable9,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
idAceptanceCriteria += 1
userHistories.remove(h)
t5 = Paragraph("Criterios de aceptación:",styles['subtittle'])
tam_colums1 = [2*cm,14.8*cm]
dataTableAcceptanCriteria = [["",t5]]
if n > 0:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
else:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable11,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
#Mostramos los criterios de aceptacion.
for c in aceptanceCriteriaList:
criteria = c.HAC_enunciado
criteria = insertJumpLine(criteria,80)
dataTableAcceptanCriteria = [["",criteria]]
if n > 0:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
else:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable11,hAlign='CENTER')
n -= 1
print(code,n,criteria)
story.append(t_user_acceptanCriteria)
n = len(userHistories)
#Mostramos las historias que no pertenenecen a ninguna epica.
for h in userHistories:
#Obtenemos los criterios de aceptacion asociados a la epica.
aceptanceCriteriaList = oACriteria.getAceptanceCriteriaByHistoryAndSprint(h['idHistory'],s.S_idSprint)
if aceptanceCriteriaList != []:
#Construimos el enunciado
statement = "En tanto" + h['actors'] + h['actions'] + "para" + h['objectives']
statement = insertJumpLine(statement,67)
code = h['code']
dataTableAcceptanCriteria = [[idAceptanceCriteria,statement,code]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums,style=stylesTable9,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
idAceptanceCriteria += 1
t5 = Paragraph("Criterios de aceptación:",styles['subtittle'])
tam_colums1 = [2*cm,14.8*cm]
dataTableAcceptanCriteria = [["",t5]]
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
story.append(t_user_acceptanCriteria)
#Mostramos los criterios de aceptacion.
for c in aceptanceCriteriaList:
criteria = c.HAC_enunciado
criteria = insertJumpLine(criteria,80)
dataTableAcceptanCriteria = [["",criteria]]
if n > 0:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable10,hAlign='CENTER')
else:
t_user_acceptanCriteria = Table(dataTableAcceptanCriteria,tam_colums1,style=stylesTable11,hAlign='CENTER')
n -= 1
print(code,n,criteria)
story.append(t_user_acceptanCriteria)
story.append(Spacer(0,20))
#------------------------ Pruebas de Aceptacion -------------------------
if sprintsList != []:
story.append(Paragraph("4.5.2 Pruebas de Aceptación de los Entregables", styles['subtittle']))
story.append(Spacer(0,10))
idTestCriteria = 1
#for s in sprintsList:
#Obtenemos las pruebas de aceptacion almacenadas por historia.
# if True:
#Obtenemos las historias asociadas al sprint.
# userHistoryList = oSprint.getAssignedSprintHistory(s.S_numero,idProduct)
# if userHistoryList != []:
# oTCriteria.getAllAcceptanceTestByUserHistory
#--------------------------- Estructura Documento -------------------------
#==========================================================================
#Frame que contendrá el contenido de una hoja.
frame_page = Frame(78, 50, width - 166, 697, id="page")
#Creamos el pageTemplates para header y footer. Le asignamos los frames y los canvas.
PT_structure = PageTemplate(id='structure', frames=[frame_page],
onPage=header, onPageEnd=footer)
#Definimos el documento y de tamano carta. Creamos el DocTamplate a partir
#del BaseDocTemplate.
document = BaseDocTemplate(documentName,pageSize=letter,
pageTemplates=[PT_structure],
tittle="Documento-Vision", author="APMwSc")
#Construimos el PDF
document.build(story)
return respond
column_widths = [0]*len(columns)
for r in cursor:
ws.append(list(r))
for row in ws.iter_rows():
for i, cell in enumerate(row):
# meaning: if currency entry not provided, two decimal places format obtained.
if fmt[i] == 1 : cell.number_format = sheet.get('currency','$#,##0.00_-')
elif fmt[i] == 2 : cell.number_format = '0.00%'
if column_widths[i] < len(str(cell.value)): column_widths[i] = len(str(cell.value))
for i, c in enumerate(column_widths):
#print(c)
ws.column_dimensions[get_column_letter(i+1)].width = c
con.close()
# Generate excel file
fname = os.path.join(curdir,'excel') + os.sep + self.taskinfo.get('excel') + '-' + datetime.datetime.now().strftime('%Y%m%d-%H%M%S.xlsx')
wb.save(filename = fname )
self.sendFile([fname])
except Exception as e:
self.logger.exception(e)
if __name__ == '__main__':
atlogger.g_logger.addScreenMode()
atlogger.g_logger.setDebug()
c = config()
if not c.loadCfg(): sys.exit()
for t in c.tasksAll():
tsk = task(t, atlogger.g_logger)
tsk.work()
