def sqlSelect():
conn = sqlite3.connect('megasena.sqlite')
sql = 'select * from `megasenametrics`;'
rows = conn.execute(sql); concursos = []
for row in rows:
row2 = {}; fieldnameCount = 0
for fieldname in fat.allowedFieldNamesInOriginalOrder:
value = row[fieldnameCount]
# this "if" is to be ported to the conc.convertRowListToConcursoObj(row2) function at an opportunity
if fieldname == 'dataDoSorteio':
value = str(value)
value = conv.convertToDatetimeDate(value, 'YYYY-MM-DD')
row2[fieldname] = value
print fieldnameCount, fieldname, value, 'type', type(value)
fieldnameCount += 1
print 'row2', row2
concurso = conc.convertRowListToConcursoObj(row2)
concursos.append(concurso)
return concursos
row['rateioDaQuina']='15.322,24'
row['ganhadoresDaQuadra']='3311'
row['rateioDaQuadra']='180,48'
row['acumuladoSimNao']='si'
row['valorAcumulado']='717.080,75'
row['estimativaDePremio']='0,00'
row['acumuladoDeNatal']='0,00'
rows.append(row)
row = {}
# =================================================================
concursos = []
for row in rows:
concurso = conc.convertRowListToConcursoObj(row)
concursos.append(concurso)
def compareConcursos(htmlConcursos, concursos):
print "compareConcursos(htmlConcursos, concursos):",
for i in range(len(concursos)):
concurso1 = concursos[i]
concurso2 = htmlConcursos[i]
if not concurso1.isEqualTo(concurso2):
raise ValueError, 'concurso1 is not Equal To concurso2 \n They follow: \n concurso1 = %s \n concurso2 = %s ' %(concurso1, concurso2)
print "OK"
import HTMLGrabber as hg
def prelimaryTest():
bsObj = bs.BeautifulSoup(htmlTextSampleWith4Records)
htmlConcursos = hg.processRowsAcrossTable(bsObj)
