20 |
support.initthuban() |
support.initthuban() |
21 |
|
|
22 |
from Thuban.Model.table import DBFTable, MemoryTable, FIELDTYPE_STRING, \ |
from Thuban.Model.table import DBFTable, MemoryTable, FIELDTYPE_STRING, \ |
23 |
FIELDTYPE_INT |
FIELDTYPE_INT, FIELDTYPE_DOUBLE |
24 |
from Thuban.Model.transientdb import TransientDatabase, TransientTable, \ |
from Thuban.Model.transientdb import TransientDatabase, TransientTable, \ |
25 |
TransientJoinedTable, AutoTransientTable |
TransientJoinedTable, AutoTransientTable |
26 |
|
|
54 |
# decimal precision is always 0. |
# decimal precision is always 0. |
55 |
columns = table.Columns() |
columns = table.Columns() |
56 |
self.assertEquals(columns[0].name, 'AREA') |
self.assertEquals(columns[0].name, 'AREA') |
57 |
self.assertEquals(columns[0].type, 'double') |
self.assertEquals(columns[0].type, FIELDTYPE_DOUBLE) |
58 |
self.assertEquals(columns[3].name, 'PONET_ID') |
self.assertEquals(columns[3].name, 'PONET_ID') |
59 |
self.assertEquals(columns[3].type, 'int') |
self.assertEquals(columns[3].type, FIELDTYPE_INT) |
60 |
self.assertEquals(columns[6].name, 'POPYCOUN') |
self.assertEquals(columns[6].name, 'POPYCOUN') |
61 |
self.assertEquals(columns[6].type, 'string') |
self.assertEquals(columns[6].type, FIELDTYPE_STRING) |
62 |
|
|
63 |
|
# HasColumn |
64 |
|
self.failUnless(table.HasColumn("AREA")) |
65 |
|
self.failUnless(table.HasColumn(1)) |
66 |
|
# HasColumn for non-exisiting columns |
67 |
|
self.failIf(table.HasColumn("non_existing_name")) |
68 |
|
self.failIf(table.HasColumn(100)) |
69 |
|
|
70 |
# Read an `interesting' record |
# Read an `interesting' record |
71 |
self.assertEquals(table.ReadRowAsDict(144), |
self.assertEquals(table.ReadRowAsDict(144), |
75 |
'POPYREG': '1', |
'POPYREG': '1', |
76 |
'PONET_ID': 145}) |
'PONET_ID': 145}) |
77 |
|
|
78 |
# field_range may induce a copy to the transient database. |
# ValueRange may induce a copy to the transient database. |
79 |
# Therefore we put it last so that we can execute this method |
# Therefore we put it last so that we can execute this method |
80 |
# twice to check whether the other methods still work after the |
# twice to check whether the other methods still work after the |
81 |
# copy |
# copy |
139 |
|
|
140 |
self.assertEquals(table.NumRows(), 34) |
self.assertEquals(table.NumRows(), 34) |
141 |
self.assertEquals(table.NumColumns(), 8) |
self.assertEquals(table.NumColumns(), 8) |
142 |
self.assertEquals(table.field_info(0), ('double', 'AREA', 0, 0)) |
self.assertEquals(table.Column(0).type, FIELDTYPE_DOUBLE) |
143 |
self.assertEquals(table.field_info(7), ('int', 'code', 0, 0)) |
self.assertEquals(table.Column(0).name, 'AREA') |
144 |
self.assertEquals(table.field_info(4), ('string', 'CLPTLABEL', 0, 0)) |
self.assertEquals(table.Column(7).type, FIELDTYPE_INT) |
145 |
|
self.assertEquals(table.Column(7).name, 'code') |
146 |
|
self.assertEquals(table.Column(4).type, FIELDTYPE_STRING) |
147 |
|
self.assertEquals(table.Column(4).name, 'CLPTLABEL') |
148 |
|
# HasColumn |
149 |
|
self.failUnless(table.HasColumn("AREA")) |
150 |
|
self.failUnless(table.HasColumn(1)) |
151 |
|
# HasColumn for non-exisiting columns |
152 |
|
self.failIf(table.HasColumn("non_existing_name")) |
153 |
|
self.failIf(table.HasColumn(100)) |
154 |
|
|
155 |
# Read an `interesting' record |
# Read an `interesting' record |
156 |
self.assertEquals(table.read_record(22), |
self.assertEquals(table.ReadRowAsDict(22), |
157 |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
{'PERIMETER': 0.0, 'CLPOINT_': 23, |
158 |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
'AREA': 0.0, 'CLPTLABEL': 'RUINS', |
159 |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
'CLPOINT_ID': 38, 'CLPTFLAG': 0, |
180 |
# unitialized local variable, so for passing the test it's |
# unitialized local variable, so for passing the test it's |
181 |
# enough if reading simply succeeds. OTOH, while we're at it we |
# enough if reading simply succeeds. OTOH, while we're at it we |
182 |
# might as well check whether the results are equal anyway :) |
# might as well check whether the results are equal anyway :) |
183 |
result1 = table.read_record(3) |
result1 = table.ReadRowAsDict(3) |
184 |
result2 = table.read_record(3) |
result2 = table.ReadRowAsDict(3) |
185 |
self.assertEquals(result1, result2) |
self.assertEquals(result1, result2) |
186 |
|
|
187 |
|
|