50 |
self.assertEquals(table.NumRows(), 156) |
self.assertEquals(table.NumRows(), 156) |
51 |
self.assertEquals(table.NumColumns(), 8) |
self.assertEquals(table.NumColumns(), 8) |
52 |
|
|
53 |
# Check one each of the possible field types. The width and |
# Check one each of the possible field types. |
|
# decimal precision is always 0. |
|
54 |
columns = table.Columns() |
columns = table.Columns() |
55 |
self.assertEquals(columns[0].name, 'AREA') |
self.assertEquals(columns[0].name, 'AREA') |
56 |
self.assertEquals(columns[0].type, FIELDTYPE_DOUBLE) |
self.assertEquals(columns[0].type, FIELDTYPE_DOUBLE) |
66 |
self.failIf(table.HasColumn("non_existing_name")) |
self.failIf(table.HasColumn("non_existing_name")) |
67 |
self.failIf(table.HasColumn(100)) |
self.failIf(table.HasColumn(100)) |
68 |
|
|
69 |
# Read an `interesting' record |
# Reading rows and values. |
70 |
self.assertEquals(table.ReadRowAsDict(144), |
self.assertEquals(table.ReadRowAsDict(144), |
71 |
{'POPYCOUN': 'IC', 'POPYADMIN': '', 'PONET_': 146, |
{'POPYCOUN': 'IC', 'POPYADMIN': '', 'PONET_': 146, |
72 |
'AREA': 19.462, |
'AREA': 19.462, |
73 |
'POPYTYPE': 1, 'PERIMETER': 88.518000000000001, |
'POPYTYPE': 1, 'PERIMETER': 88.518000000000001, |
74 |
'POPYREG': '1', |
'POPYREG': '1', |
75 |
'PONET_ID': 145}) |
'PONET_ID': 145}) |
76 |
|
self.assertEquals(table.ReadValue(144, "AREA"), 19.462) |
77 |
|
self.assertEquals(table.ReadValue(144, 3), 145) |
78 |
|
|
79 |
# ValueRange may induce a copy to the transient database. |
# ValueRange may induce a copy to the transient database. |
80 |
# Therefore we put it last so that we can execute this method |
# Therefore we put it last so that we can execute this method |
100 |
# The transient_table method should return the table itself |
# The transient_table method should return the table itself |
101 |
self.assert_(table is table.transient_table()) |
self.assert_(table is table.transient_table()) |
102 |
|
|
103 |
|
# The title is simply copied over from the original table |
104 |
|
self.assertEquals(table.Title(), orig_table.Title()) |
105 |
|
|
106 |
|
# The TransientTable class itself doesn't implement the |
107 |
|
# Dependencies method, so we don't test it. |
108 |
|
|
109 |
|
|
110 |
def test_auto_transient_table(self): |
def test_auto_transient_table(self): |
111 |
"""Test AutoTransientTable(dbftable) |
"""Test AutoTransientTable(dbftable) |
130 |
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
131 |
"political.dbf")) |
"political.dbf")) |
132 |
table = AutoTransientTable(self.transientdb, orig_table) |
table = AutoTransientTable(self.transientdb, orig_table) |
133 |
# Only a simple test here. The AutoTransientTable siply |
# Only a simple test here. The AutoTransientTable simply |
134 |
# delegates to its transient table so it should be OK that the |
# delegates to its transient table so it should be OK that the |
135 |
# real test for it is in test_transient_table_query. However, |
# real test for it is in test_transient_table_query. However, |
136 |
# it's important to check that the column handling works |
# it's important to check that the column handling works |
139 |
self.assertEquals(table.SimpleQuery(table.Column("AREA"), ">", 10.0), |
self.assertEquals(table.SimpleQuery(table.Column("AREA"), ">", 10.0), |
140 |
[144]) |
[144]) |
141 |
|
|
142 |
|
# test using a Column object as the right parameter |
143 |
|
self.assertEquals(table.SimpleQuery(table.Column("POPYTYPE"), |
144 |
|
"==", |
145 |
|
table.Column("POPYREG")), |
146 |
|
range(156)) |
147 |
|
|
148 |
|
def test_auto_transient_table_dependencies(self): |
149 |
|
"""Test AutoTransientTable.Dependencies()""" |
150 |
|
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
151 |
|
"political.dbf")) |
152 |
|
table = AutoTransientTable(self.transientdb, orig_table) |
153 |
|
self.assertEquals(table.Dependencies(), (orig_table,)) |
154 |
|
|
155 |
|
def test_auto_transient_table_title(self): |
156 |
|
"""Test AutoTransientTable.Title()""" |
157 |
|
orig_table = DBFTable(os.path.join("..", "Data", "iceland", |
158 |
|
"political.dbf")) |
159 |
|
table = AutoTransientTable(self.transientdb, orig_table) |
160 |
|
# The title is of course the same as that of the original table |
161 |
|
self.assertEquals(table.Title(), orig_table.Title()) |
162 |
|
|
163 |
def test_transient_joined_table(self): |
def test_transient_joined_table(self): |
164 |
"""Test TransientJoinedTable""" |
"""Test TransientJoinedTable""" |
165 |
simple = MemoryTable([("type", FIELDTYPE_STRING), |
simple = MemoryTable([("type", FIELDTYPE_STRING), |
193 |
self.failIf(table.HasColumn("non_existing_name")) |
self.failIf(table.HasColumn("non_existing_name")) |
194 |
self.failIf(table.HasColumn(100)) |
self.failIf(table.HasColumn(100)) |
195 |
|
|
196 |
# Read an `interesting' record |
# Reading rows and values |
197 |
self.assertEquals(table.ReadRowAsDict(22), |
self.assertEquals(table.ReadRowAsDict(22), |
198 |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
199 |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
200 |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
201 |
'code': 1, 'type': 'RUINS'}) |
'code': 1, 'type': 'RUINS'}) |
202 |
|
self.assertEquals(table.ReadValue(22, "type"), 'RUINS') |
203 |
|
self.assertEquals(table.ReadValue(22, 7), 1) |
204 |
|
|
205 |
# The transient_table method should return the table itself |
# The transient_table method should return the table itself |
206 |
self.assert_(table is table.transient_table()) |
self.assert_(table is table.transient_table()) |
207 |
|
|
208 |
|
# The TransientJoinedTable depends on both input tables |
209 |
|
self.assertEquals(table.Dependencies(), (landmarks, auto)) |
210 |
|
|
211 |
|
# The title is constructed from the titles of the input tables. |
212 |
|
self.assertEquals(table.Title(), |
213 |
|
"Join of %s and %s" % (landmarks.Title(), |
214 |
|
auto.Title())) |
215 |
|
|
216 |
|
|
217 |
def test_transient_table_read_twice(self): |
def test_transient_table_read_twice(self): |
218 |
"""Test TransientTable.ReadRowAsDict() reading the same record twice""" |
"""Test TransientTable.ReadRowAsDict() reading the same record twice""" |