def read_from_sql(sql_statement, batches): conn = sqlite3.connect(opts.file) cursor = conn.cursor() cursor.execute(sql_statement) for entry in cursor.fetchall(): batch = RequestBatch() batch.set_filename(entry[1]) batch.set_requesturl(entry[2]) batch.set_getrequests(entry[3]) batch.set_dnsrequests(entry[4]) batch.set_downstreamvolume(entry[5]) batch.set_upstreamvolume(entry[6]) batch.set_nr_of_host_contacts(entry[7]) batch.set_connection_count(entry[8]) batch.set_nr_of_web_bugs(entry[9]) batches.append(batch) conn.close()