67 |
self.failIf(table.HasColumn("non_existing_name")) |
self.failIf(table.HasColumn("non_existing_name")) |
68 |
self.failIf(table.HasColumn(100)) |
self.failIf(table.HasColumn(100)) |
69 |
|
|
70 |
# Read an `interesting' record |
# Reading rows and values. |
71 |
self.assertEquals(table.ReadRowAsDict(144), |
self.assertEquals(table.ReadRowAsDict(144), |
72 |
{'POPYCOUN': 'IC', 'POPYADMIN': '', 'PONET_': 146, |
{'POPYCOUN': 'IC', 'POPYADMIN': '', 'PONET_': 146, |
73 |
'AREA': 19.462, |
'AREA': 19.462, |
74 |
'POPYTYPE': 1, 'PERIMETER': 88.518000000000001, |
'POPYTYPE': 1, 'PERIMETER': 88.518000000000001, |
75 |
'POPYREG': '1', |
'POPYREG': '1', |
76 |
'PONET_ID': 145}) |
'PONET_ID': 145}) |
77 |
|
self.assertEquals(table.ReadValue(144, "AREA"), 19.462) |
78 |
|
self.assertEquals(table.ReadValue(144, 3), 145) |
79 |
|
|
80 |
# ValueRange may induce a copy to the transient database. |
# ValueRange may induce a copy to the transient database. |
81 |
# Therefore we put it last so that we can execute this method |
# Therefore we put it last so that we can execute this method |
125 |
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
126 |
"political.dbf")) |
"political.dbf")) |
127 |
table = AutoTransientTable(self.transientdb, orig_table) |
table = AutoTransientTable(self.transientdb, orig_table) |
128 |
# Only a simple test here. The AutoTransientTable siply |
# Only a simple test here. The AutoTransientTable simply |
129 |
# delegates to its transient table so it should be OK that the |
# delegates to its transient table so it should be OK that the |
130 |
# real test for it is in test_transient_table_query. However, |
# real test for it is in test_transient_table_query. However, |
131 |
# it's important to check that the column handling works |
# it's important to check that the column handling works |
134 |
self.assertEquals(table.SimpleQuery(table.Column("AREA"), ">", 10.0), |
self.assertEquals(table.SimpleQuery(table.Column("AREA"), ">", 10.0), |
135 |
[144]) |
[144]) |
136 |
|
|
137 |
|
# test using a Column object as the right parameter |
138 |
|
self.assertEquals(table.SimpleQuery(table.Column("POPYTYPE"), |
139 |
|
"==", |
140 |
|
table.Column("POPYREG")), |
141 |
|
range(156)) |
142 |
|
|
143 |
def test_transient_joined_table(self): |
def test_transient_joined_table(self): |
144 |
"""Test TransientJoinedTable""" |
"""Test TransientJoinedTable""" |
145 |
simple = MemoryTable([("type", FIELDTYPE_STRING), |
simple = MemoryTable([("type", FIELDTYPE_STRING), |
173 |
self.failIf(table.HasColumn("non_existing_name")) |
self.failIf(table.HasColumn("non_existing_name")) |
174 |
self.failIf(table.HasColumn(100)) |
self.failIf(table.HasColumn(100)) |
175 |
|
|
176 |
# Read an `interesting' record |
# Reading rows and values |
177 |
self.assertEquals(table.ReadRowAsDict(22), |
self.assertEquals(table.ReadRowAsDict(22), |
178 |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
179 |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
180 |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
181 |
'code': 1, 'type': 'RUINS'}) |
'code': 1, 'type': 'RUINS'}) |
182 |
|
self.assertEquals(table.ReadValue(22, "type"), 'RUINS') |
183 |
|
self.assertEquals(table.ReadValue(22, 7), 1) |
184 |
|
|
185 |
# The transient_table method should return the table itself |
# The transient_table method should return the table itself |
186 |
self.assert_(table is table.transient_table()) |
self.assert_(table is table.transient_table()) |