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)