def fetch_horarios(idhor, nome):
c = env.db.cursor()
idlinha = get_linha_hor(idhor, nome)
#TODO: check if this really works
c.execute('start transaction')
try:
c.execute('delete from hs, h \
using horsets hs, horarios h \
where hs.idlinha=%s and h.idset=hs.id',
[idlinha])
html = horarios.get_horarios_html(idhor)
for pto,dia,apartir,horas in horarios.parse_hor_html(html):
print 'ponto: %s, dias: %s' % (pto, dia)
idponto = get_ponto_hor(pto)
d = dias.id_dias(dia)
c.insert_one('horsets', idlinha=idlinha, idponto=idponto,
dia=d, apartir=apartir)
idset = c.lastrowid
for sp,h in horas:
c.insert_one('horarios',
idset=idset, hora=h, special=sp)
except:
c.execute('rollback')
else:
c.execute('commit')
c.close()
import horarios
import sys
fh = sys.stdout
for pto,dias,apartir,horas in horarios.parse_hor_html(sys.stdin.read()):
fh.write("Ponto: %s - %s\nValido a partir de: %s\n\n" \
% (pto,dias,apartir))
l = 0
for sp,h in horas:
if sp: bold='*'
else: bold=''
s = "%s%s " % (bold, h)
# break lines
l += len(s)
if l > 80:
l = len(s)
s = '\n' + s
fh.write(s)
fh.write("\n\n\n")
