blob: fc0b3f9d492e9f0a8db3f15d97424db493913218 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
from fuel.schemes import IterationScheme
import sqlite3
import random
import os
from picklable_itertools import iter_
import data
first_time = 1372636853
last_time = 1404172787
class TaxiTimeCutScheme(IterationScheme):
def __init__(self, dbfile=None, use_cuts=None):
self.dbfile = os.path.join(data.path, 'time_index.db') if dbfile == None else dbfile
self.use_cuts = use_cuts
def get_request_iterator(self):
cuts = self.use_cuts
if cuts == None:
cuts = [random.randrange(first_time, last_time) for _ in range(100)]
l = []
with sqlite3.connect(self.dbfile) as db:
c = db.cursor()
for cut in cuts:
part = [i for (i,) in
c.execute('SELECT trip FROM trip_times WHERE begin >= ? AND begin <= ? AND end >= ?',
(cut - 40000, cut, cut))]
l = l + part
random.shuffle(l)
return iter_(l)
|
