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)