def new(self, curso, **kw):
"""Create new records in model"""
kw['cursoID'] = curso
curso = Curso.get(curso)
options = { fkname+'ID': [(e.id, '%d.%d - %s' % (e.anio, e.cuatrimestre ,e.nombre)) for e in
Enunciado.select().orderBy((-Enunciado.q.anio, -Enunciado.q.cuatrimestre))] }
return dict(name=name, namepl=namepl, form=form, values=kw, options=options)
def edit(self, id, **kw):
"""Edit record in model"""
r = validate_get(id)
curso = Curso.get(r.cursoID)
options = { fkname+'ID': [(e.id, '%d.%d - %s' % (e.anio, e.cuatrimestre ,e.nombre)) for e in
Enunciado.select().orderBy((-Enunciado.q.anio, -Enunciado.q.cuatrimestre))] }
return dict(name=name, namepl=namepl, record=r, form=form, options=options)
def from_file_add(self, id, archivo):
""" Se espera :
padron,nombre,email,telefono
"""
import csv
lines = archivo.file.read().split('\n')
ok = []
fail = []
curso = Curso.get(int(id))
for line in lines:
for row in csv.reader([line]):
if row == []:
continue
try:
u = Alumno(row[0], nombre=row[1], roles=[Rol.by_nombre('alumno')])
except:
u = Alumno.byPadron(row[0])
try:
u.email = row[2]
u.telefono = row[3]
u.password = row[0]
u.activo = True
curso.add_alumno(u)
ok.append(row)
except Exception, e:
row.append(str(e))
fail.append(row)
def list(self, cursoID = 0):
"""List records in model"""
cursoID = int(cursoID)
if cursoID == 0:
raise redirect('..')
else:
r = cls.select(cls.q.cursoID == cursoID)
curso = Curso.get(cursoID)
return dict(records=r, name=name, namepl=namepl, curso=curso, limit_to=identity.current.user.paginador)
def list(self, curso):
"""List records in model"""
r = cls.selectBy(cursoID=curso)
return dict(records=r, name=name, namepl=namepl.capitalize(), curso=Curso.get(curso))
def de_curso(self, curso_id):
c = Curso.get(curso_id)
e = Enunciado.selectByCurso(c)
return dict(enunciados=e)
def list(self, cursoID):
curso = Curso.get(cursoID)
r = cls.selectBy(curso=curso)
return dict(records=r, name=name, namepl=namepl, curso=curso)
def check_curso(data):
c = Curso.get(data['cursoID'])
del data['cursoID']
data['curso'] = c
return c
def new(self, cursoID, **kw):
"""Create new records in model"""
form.fields[0].attrs['value'] = cursoID
return dict(name=name, namepl=namepl, form=form, values=kw, curso=Curso.get(cursoID))
def list(self, cursoID):
"""List records in model"""
r = cls.select(cls.q.cursoID==cursoID)
return dict(records=r, name=name, namepl=namepl, curso=Curso.get(cursoID))
def list(self, curso):
"""List records in model"""
r = cls.selectBy(cursoID=curso).orderBy(cls.q.numero)
return dict(records=r, name=name, namepl=namepl, curso=Curso.get(curso))
