def testIdAcceptanceTestDoesNotExists(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.','ODJdbeidbww',1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idBacklog = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia',idBacklog)
search = aAcc.searchAccion('cinrohbwidia',idBacklog)
idAccion = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1',0, 1,idAccion, idBacklog,1,True,TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1',idBacklog)
idStory = searchHist[0].UH_idUserHistory
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.findIdAcceptanceTest(1532)
self.assertFalse(result)
# Eliminamos los datos insertados.
aHist.deleteUserHistory(idStory)
aAcc.deleteAccion('cinrohbwidia', idBacklog)
aBacklog.deleteProduct('Podn fjdd.')
def testInsertTestElementMay(self):
# Insertamos Producto
aBacklog = backlog()
aBacklog.insertBacklog('Podn fjdd.','ODJdbeidbww',1)
searchBacklog = aBacklog.findName('Podn fjdd.')
idBacklog = searchBacklog[0].BL_idBacklog
# Insertamos la accion
aAcc = accions()
aAcc.insertAccion('cinrohbwidia',idBacklog)
search = aAcc.searchAccion('cinrohbwidia',idBacklog)
idAccion = search[0].AC_idAccion
# Insertamos la historia
aHist = userHistory()
aHist.insertUserHistory('BIEEIEB1',0, 1,idAccion, idBacklog,1,True,TODAY)
searchHist = aHist.searchUserHistory('BIEEIEB1',idBacklog)
idStory = searchHist[0].UH_idUserHistory
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.insertAcceptanceTest(idStory, 'SDFSDF', '/foo/bar/baz')
self.assertTrue(result)
# Eliminamos los datos insertados.
test = aHist.testsAsociatedToUserHistory(idStory)[0]
oTest.deleteAcceptanceTest(test.AT_idAT)
aHist.deleteUserHistory(idStory)
aAcc.deleteAccion('cinrohbwidia', idBacklog)
aBacklog.deleteProduct('Podn fjdd.')
def AElimPruebaAceptacion(idPrueba):
#POST/PUT parameters
params = request.get_json()
results = [{'label':'/VHistoria', 'msg':['Prueba borrada']},
{'label':'/VHistoria', 'msg':['No se pudo eliminar la prueba']}, ]
res = results[0]
# Obtenemos los parámetros
oPrueba = acceptanceTest()
result = oPrueba.findIdAcceptanceTest(int(idPrueba))
# Delete physical file
os.remove(result.AT_urlScript)
# Eliminamos la prueba
delete = oPrueba.deleteAcceptanceTest(result.AT_idAT)
if delete:
res = results[0]
res['label'] = res['label'] + '/' + str(session['idHistoria'])
if "actor" in res:
if res['actor'] is None:
session.pop("actor", None)
else:
session['actor'] = res['actor']
return json.dumps(res)
def ACrearPruebaAceptacion():
#POST/PUT parameters
params = request.get_json()
results = [{'label':'/VHistoria', 'msg':['Prueba creada']},
{'label':'/VHistoria', 'msg':['No se pudo crear la prueba.']}, ]
res = results[0]
# Obtenemos el id de la historia actual
idHistory = int(session['idHistoria'])
# Extraemos los parámetros
description = request.form['descripcion']
file = request.files['contenido']
file.save(os.path.join(app.config['UPLOADED_SCRIPT_DEST'], file.filename))
url = str(app.config['UPLOADED_SCRIPT_DEST'] + file.filename)
oTest = acceptanceTest()
oTest.insertAcceptanceTest(idHistory,description,url)
res['label'] = res['label'] + '/' + str(idHistory)
if "actor" in res:
if res['actor'] is None:
session.pop("actor", None)
else:
session['actor'] = res['actor']
return json.dumps(res)
def ACrearPruebaAceptacion():
#POST/PUT parameters
params = request.get_json()
results = [
{
'label': '/VHistoria',
'msg': ['Prueba creada']
},
{
'label': '/VHistoria',
'msg': ['No se pudo crear la prueba.']
},
]
res = results[0]
# Obtenemos el id de la historia actual
idHistory = int(session['idHistoria'])
# Extraemos los parámetros
description = request.form['descripcion']
file = request.files['contenido']
file.save(os.path.join(app.config['UPLOADED_SCRIPT_DEST'], file.filename))
url = str(app.config['UPLOADED_SCRIPT_DEST'] + file.filename)
oTest = acceptanceTest()
oTest.insertAcceptanceTest(idHistory, description, url)
res['label'] = res['label'] + '/' + str(idHistory)
if "actor" in res:
if res['actor'] is None:
session.pop("actor", None)
else:
session['actor'] = res['actor']
return json.dumps(res)
def AElimPruebaAceptacion(idPrueba):
#POST/PUT parameters
params = request.get_json()
results = [
{
'label': '/VHistoria',
'msg': ['Prueba borrada']
},
{
'label': '/VHistoria',
'msg': ['No se pudo eliminar la prueba']
},
]
res = results[0]
# Obtenemos los parámetros
oPrueba = acceptanceTest()
result = oPrueba.findIdAcceptanceTest(int(idPrueba))
# Delete physical file
os.remove(result.AT_urlScript)
# Eliminamos la prueba
delete = oPrueba.deleteAcceptanceTest(result.AT_idAT)
if delete:
res = results[0]
res['label'] = res['label'] + '/' + str(session['idHistoria'])
if "actor" in res:
if res['actor'] is None:
session.pop("actor", None)
else:
session['actor'] = res['actor']
return json.dumps(res)
def testdeleteAcceptanceTestNullId(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.deleteAcceptanceTest(None)
self.assertFalse(result)
def testdeleteAcceptanceTestNegativeId(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.deleteAcceptanceTest(-1)
self.assertFalse(result)
def testdeleteAcceptanceTestInvalidId(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.deleteAcceptanceTest("a")
self.assertFalse(result)
def testIdAcceptanceTestNegative(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.findIdAcceptanceTest(-1)
self.assertFalse(result)
def testInsertElement250Description(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.insertAcceptanceTest([], 250*'S', '/foo/bar/baz')
self.assertFalse(result)
def testInsertTestElementSinHistoria(self):
# Inicio de la prueba.
oTest = acceptanceTest()
result = oTest.insertAcceptanceTest([], 'PokemonDaBest1532', '/foo/bar/baz')
self.assertFalse(result)
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