445
448
assert len(results1) == len(results2)
446
449
assert results1 == results2
452
"""Checking selecting values from an Index (long flavor)"""
455
print '\n', '-=' * 30
456
print "Running %s.test03c..." % self.__class__.__name__
458
table1 = self.fileh.root.table1
459
table2 = self.fileh.root.table2
461
# Convert the limits to the appropriate type
465
# Do some selections and check the results
466
t1col = table1.cols.var3
469
results1 = [p["var3"] for p in table1.where(t1col < sl)]
470
results2 = [p["var3"] for p in table2
472
# sort lists (indexing does not guarantee that rows are returned in
474
results1.sort(); results2.sort()
477
print "Selection results (index):", results1
478
print "Should look like:", results2
479
print "Length results:", len(results1)
480
print "Should be:", len(results2)
481
assert len(results1) == len(results2)
482
assert results1 == results2
485
results1 = [p["var3"] for p in table1.where(t1col <= sl)]
486
results2 = [p["var3"] for p in table2
488
# sort lists (indexing does not guarantee that rows are returned in
490
results1.sort(); results2.sort()
493
# print "Selection results (index):", results1
494
# print "Should look like:", results2
495
print "Length results:", len(results1)
496
print "Should be:", len(results2)
497
assert len(results1) == len(results2)
498
assert results1 == results2
501
results1 = [p["var3"] for p in table1.where(t1col > sl)]
502
results2 = [p["var3"] for p in table2
504
# sort lists (indexing does not guarantee that rows are returned in
506
results1.sort(); results2.sort()
509
# print "Selection results (index):", results1
510
# print "Should look like:", results2
511
print "Length results:", len(results1)
512
print "Should be:", len(results2)
513
assert len(results1) == len(results2)
514
assert results1 == results2
517
results1 = [p["var3"] for p in table1.where(t1col >= sl)]
518
results2 = [p["var3"] for p in table2
520
# sort lists (indexing does not guarantee that rows are returned in
522
results1.sort(); results2.sort()
525
# print "Selection results (index):", results1
526
# print "Should look like:", results2
527
print "Length results:", len(results1)
528
print "Should be:", len(results2)
529
assert len(results1) == len(results2)
530
assert results1 == results2
533
"""Checking selecting values from an Index (long and int flavor)"""
536
print '\n', '-=' * 30
537
print "Running %s.test03d..." % self.__class__.__name__
539
table1 = self.fileh.root.table1
540
table2 = self.fileh.root.table2
542
# Convert the limits to the appropriate type
546
# Do some selections and check the results
547
t1col = table1.cols.var3
550
results1 = [p["var3"] for p in table1.where(t1col < sl)]
551
results2 = [p["var3"] for p in table2
553
# sort lists (indexing does not guarantee that rows are returned in
555
results1.sort(); results2.sort()
558
print "Selection results (index):", results1
559
print "Should look like:", results2
560
print "Length results:", len(results1)
561
print "Should be:", len(results2)
562
assert len(results1) == len(results2)
563
assert results1 == results2
566
results1 = [p["var3"] for p in table1.where(t1col <= sl)]
567
results2 = [p["var3"] for p in table2
569
# sort lists (indexing does not guarantee that rows are returned in
571
results1.sort(); results2.sort()
574
# print "Selection results (index):", results1
575
# print "Should look like:", results2
576
print "Length results:", len(results1)
577
print "Should be:", len(results2)
578
assert len(results1) == len(results2)
579
assert results1 == results2
582
results1 = [p["var3"] for p in table1.where(t1col > sl)]
583
results2 = [p["var3"] for p in table2
585
# sort lists (indexing does not guarantee that rows are returned in
587
results1.sort(); results2.sort()
590
# print "Selection results (index):", results1
591
# print "Should look like:", results2
592
print "Length results:", len(results1)
593
print "Should be:", len(results2)
594
assert len(results1) == len(results2)
595
assert results1 == results2
598
results1 = [p["var3"] for p in table1.where(t1col >= sl)]
599
results2 = [p["var3"] for p in table2
601
# sort lists (indexing does not guarantee that rows are returned in
603
results1.sort(); results2.sort()
606
# print "Selection results (index):", results1
607
# print "Should look like:", results2
608
print "Length results:", len(results1)
609
print "Should be:", len(results2)
610
assert len(results1) == len(results2)
611
assert results1 == results2
448
613
def test04a(self):
449
614
"""Checking selecting values from an Index (float flavor)"""
1818
1983
assert len(results1) == len(results2)
1819
1984
assert results1 == results2
1987
"""Checking selecting values from an Index via readCoordinates()"""
1990
print '\n', '-=' * 30
1991
print "Running %s.test11a..." % self.__class__.__name__
1993
table1 = self.fileh.root.table1
1994
table2 = self.fileh.root.table2
1996
# Convert the limits to the appropriate type
2000
# Do a selection and check the result
2001
t1var1 = table1.cols.var1
2002
coords1 = table1.getWhereList(il <= t1var1 <= sl)
2003
results1 = table1.readCoordinates(coords1, field="var1", flavor="List")
2004
results2 = [p["var1"] for p in table2
2005
if il <= p["var1"] <= sl]
2006
results1.sort(); results2.sort()
2008
# print "Superior & inferior limits:", il, sl
2009
# print "Selection results (index):", results1
2010
# print "Should look like:", results2
2011
print "Length results:", len(results1)
2012
print "Should be:", len(results2)
2013
assert len(results1) == len(results2)
2014
assert results1 == results2
1822
2017
class SV1aTestCase(SelectValuesTestCase):
1823
2018
minRowIndex = 10