def test_retrieve_ordered_by_time(self):
table_a = self.data.partition_a.table()
with closing(self.conn.cursor()) as cursor:
eq_(row_count(cursor, table_a), 3)
table_names = [table_a.name]
start = self.data.timestamp_1
end = self.data.timestamp_1
entity = self.data.entities[1]
entities = [entity.id]
columns = [
Column(table_a, "CellID"),
Column(table_a, "CCR"),
Column(table_a, "CCRatts"),
Column(table_a, "Drops")]
r = retrieve_orderedby_time(self.conn, SCHEMA, table_names, columns,
entities, start, end)
eq_(len(r), 1)
first_result = head(r)
entity_id, timestamp, c1, c2, c3, c4 = first_result
eq_(entity_id, entity.id)
eq_(c4, 18)
def retrieve_orderedby_time(self, datasources, gp, entitytype, trend_names,
entities, start, end, limit=None):
with closing(self.conn.cursor()) as cursor:
if isinstance(entitytype, str):
entitytype = get_entitytype(cursor, entitytype)
table_names = get_table_names_v4(cursor, datasources, gp, entitytype,
start, end)
return retrieve_orderedby_time(self.conn, schema.name, table_names,
trend_names, entities, start, end, limit)
