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()
