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 |
120 |
self.run_iceland_political_tests(table) |
self.run_iceland_political_tests(table) |
121 |
self.run_iceland_political_tests(table) |
self.run_iceland_political_tests(table) |
122 |
|
|
123 |
|
def test_auto_transient_table_query(self): |
124 |
|
"""Test AutoTransientTable.SimpleQuery()""" |
125 |
|
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
126 |
|
"political.dbf")) |
127 |
|
table = AutoTransientTable(self.transientdb, orig_table) |
128 |
|
# Only a simple test here. The AutoTransientTable siply |
129 |
|
# delegates to its transient table so it should be OK that the |
130 |
|
# real test for it is in test_transient_table_query. However, |
131 |
|
# it's important to check that the column handling works |
132 |
|
# correctly because the AutoTransientTable and it's underlying |
133 |
|
# transient table use different column object types. |
134 |
|
self.assertEquals(table.SimpleQuery(table.Column("AREA"), ">", 10.0), |
135 |
|
[144]) |
136 |
|
|
137 |
def test_transient_joined_table(self): |
def test_transient_joined_table(self): |
138 |
"""Test TransientJoinedTable""" |
"""Test TransientJoinedTable""" |
167 |
self.failIf(table.HasColumn("non_existing_name")) |
self.failIf(table.HasColumn("non_existing_name")) |
168 |
self.failIf(table.HasColumn(100)) |
self.failIf(table.HasColumn(100)) |
169 |
|
|
170 |
# Read an `interesting' record |
# Reading rows and values |
171 |
self.assertEquals(table.ReadRowAsDict(22), |
self.assertEquals(table.ReadRowAsDict(22), |
172 |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
173 |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
174 |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
175 |
'code': 1, 'type': 'RUINS'}) |
'code': 1, 'type': 'RUINS'}) |
176 |
|
self.assertEquals(table.ReadValue(22, "type"), 'RUINS') |
177 |
|
self.assertEquals(table.ReadValue(22, 7), 1) |
178 |
|
|
179 |
# The transient_table method should return the table itself |
# The transient_table method should return the table itself |
180 |
self.assert_(table is table.transient_table()) |
self.assert_(table is table.transient_table()) |