def walk(connection, func, since=-1, until=-1):
''' Walk the speedtest table and invoke func() on each tuple '''
cursor = connection.cursor()
SELECT = _table_utils.make_select("speedtest", TEMPLATE,
since=since, until=until, desc=True)
cursor.execute(SELECT, {"since": since, "until": until})
return map(func, cursor)
def walk(connection, func, since=-1, until=-1):
''' Walk the list of results of bittorrent table '''
cursor = connection.cursor()
SELECT = _table_utils.make_select("bittorrent", TEMPLATE,
since=since, until=until, desc=True)
cursor.execute(SELECT, {"since": since, "until": until})
return map(func, cursor)
def listify(connection, since=-1, until=-1):
""" Converts the content of speedtest table into a list """
vector = []
cursor = connection.cursor()
query = _table_utils.make_select("speedtest", TEMPLATE, since=since, until=until, desc=True)
cursor.execute(query, {"since": since, "until": until})
for row in cursor:
vector.append(dict(row))
return vector
def listify(connection, since=-1, until=-1):
''' Converts to list the content of RAW table '''
vector = []
cursor = connection.cursor()
query = _table_utils.make_select('raw', TEMPLATE,
since=since, until=until,
desc=True)
cursor.execute(query, {"since": since, "until": until})
for row in cursor:
vector.append(dict(row))
return vector
def walk(connection, func, since=-1, until=-1):
cursor = connection.cursor()
SELECT = _table_utils.make_select("log", TEMPLATE,
since=since, until=until)
cursor.execute(SELECT, {"since": since, "until": until})
return map(func, cursor)
