View of /gencv.py

#!/usr/bin/env python

from pysqlite2 import dbapi2 as sqlite

fi = open('cv_in.html', 'r');
sCV = unicode(fi.read(), "latin-1");
fi.close();

con = sqlite.connect("cv.db");
cur = con.cursor();

scolarite = "<table class=\"fill\">"
scolarite_t = "\n<tr><td>%s</td><td class=\"dr\">%s</td></tr>"
cur.execute("SELECT * FROM 'Scolarite' ORDER BY 'Priority'");
for row in cur:
	# (1, u'2001 - 2003', u'Polyvalente de Saint-Georges')
	scolarite += scolarite_t % (row[2], row[1]);
scolarite += "\n</table>"

emplois = "<div class=\"hr\"><hr/></div>"
emplois_t = "\n<tr><td class=\"empl\">%s</td><td>%s</td></tr>";
cur.execute("SELECT * FROM 'Emplois' ORDER BY 'Priority'");
for row in cur:
	# (1, u'\xc9t\xe9 2002 - 2003', u'Olymel', None, u'Vall\xe9e-Jonction', u'Op\xe9rateur de balance\nOp\xe9rateur de chariot \xe9l\xe9vateur')
	row2 = [];
	for i in range(0, len(row)):
		if type(row[i]) == str or type(row[i]) == unicode:
			row2.append(row[i].replace("\n", "<br/>"));
		else:
			row2.append(row[i]);
	emplois += "<table>";
	emplois += emplois_t % ("Employeur", row2[2]);
	emplois += emplois_t % ("Poste", row2[5]);
	emplois += emplois_t % ("Location", row2[4]);
	emplois += emplois_t % ("Date", row2[1]);
	emplois += emplois_t % ("Fonctions", row2[3]);
	emplois += "\n</table>\n<div class=\"hr\"><hr/></div>\n"

sCV = sCV.replace('<!-- Scolarite -->', scolarite);
sCV = sCV.replace('<!-- Emplois -->', emplois);
fo = open('cv_out.html', 'w');
fo.write(sCV.encode("latin-1"));
fo.close();