print values.items() db.insert(table='filtered_data_index',values=values) start_time = datetime.now() if len(sys.argv) < 2: timestamp = get_timestamp(day_delta=1) else: timestamp = sys.argv[1] table_name = "raw_data_%s" % timestamp db = DBUtils() keywords = [] c = db.select(table='brand') for one in c.fetchall(): id,name,buss = one keywords.append(name) site_types = {} c = db.select(table='sites') for one in c.fetchall(): id,name,url,site_type = one site_types[url] = site_type print site_types.items() cursor = db.select(table=table_name,columns=["count(*)"]) (total,) = cursor.fetchone() DELTA = 10000