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)