33 |
dbflib.FTDouble: FIELDTYPE_DOUBLE} |
dbflib.FTDouble: FIELDTYPE_DOUBLE} |
34 |
|
|
35 |
|
|
|
class OldTableInterfaceMixin: |
|
|
|
|
|
"""Mixin to implement the old table interface using the new one""" |
|
|
|
|
|
def __deprecation_warning(self): |
|
|
"""Issue a DeprecationWarning for code hat uses the old interface""" |
|
|
callername = inspect.currentframe().f_back.f_code.co_name |
|
|
warnings.warn("The %s method of the old table interface" |
|
|
" is deprecated" % callername, |
|
|
DeprecationWarning, stacklevel = 3) |
|
|
|
|
|
def record_count(self): |
|
|
self.__deprecation_warning() |
|
|
return self.NumRows() |
|
|
|
|
|
def field_count(self): |
|
|
self.__deprecation_warning() |
|
|
return self.NumColumns() |
|
|
|
|
|
def field_info(self, field): |
|
|
"""Return a tuple (type, name, width, prec) for the field no. field |
|
|
|
|
|
type is the data type of the field, name the name, width the |
|
|
field width in characters and prec the decimal precision. width |
|
|
and prec will be zero if the information returned by the Column |
|
|
method doesn't provide values for them. |
|
|
""" |
|
|
self.__deprecation_warning() |
|
|
col = self.Column(field) |
|
|
return (col.type, col.name, |
|
|
getattr(col, "width", 0), getattr(col, "prec", 0)) |
|
|
|
|
|
def field_info_by_name(self, col): |
|
|
self.__deprecation_warning() |
|
|
try: |
|
|
return self.field_info(col) |
|
|
except KeyError: |
|
|
# FIXME: It may be that field_info raises other exceptions |
|
|
# when the name is not a valid column name. |
|
|
return None |
|
|
|
|
|
def field_range(self, fieldName): |
|
|
self.__deprecation_warning() |
|
|
min, max = self.ValueRange(fieldName) |
|
|
return ((min, None), (max, None)) |
|
|
|
|
|
def GetUniqueValues(self, field): |
|
|
self.__deprecation_warning() |
|
|
return self.UniqueValues(field) |
|
|
|
|
|
def read_record(self, r): |
|
|
self.__deprecation_warning() |
|
|
return self.ReadRowAsDict(r) |
|
|
|
|
|
|
|
|
|
|
36 |
class DBFColumn: |
class DBFColumn: |
37 |
|
|
38 |
"""Description of a column in a DBFTable |
"""Description of a column in a DBFTable |
55 |
self.index = index |
self.index = index |
56 |
|
|
57 |
|
|
58 |
class DBFTable(TitledObject, OldTableInterfaceMixin): |
class DBFTable(TitledObject): |
59 |
|
|
60 |
""" |
""" |
61 |
Table interface for the data in a DBF file |
Table interface for the data in a DBF file |
131 |
""" |
""" |
132 |
return self.column_map.has_key(col) |
return self.column_map.has_key(col) |
133 |
|
|
134 |
def ReadRowAsDict(self, row): |
def RowIdToOrdinal(self, gid): |
135 |
"""Return the entire row as a dictionary with column names as keys""" |
"""Return the row ordinal given its id |
136 |
|
|
137 |
|
Since for DBFTables the row id is the row number, return the |
138 |
|
value unchanged. |
139 |
|
""" |
140 |
|
return gid |
141 |
|
|
142 |
|
def RowOrdinalToId(self, num): |
143 |
|
"""Return the rowid for given its ordinal |
144 |
|
|
145 |
|
Since for DBFTables the row id is the row number, return the |
146 |
|
value unchanged. |
147 |
|
""" |
148 |
|
return num |
149 |
|
|
150 |
|
def ReadRowAsDict(self, row, row_is_ordinal = 0): |
151 |
|
"""Return the entire row as a dictionary with column names as keys |
152 |
|
|
153 |
|
The row_is_ordinal is ignored for DBF tables because the row id |
154 |
|
is always the row number. |
155 |
|
""" |
156 |
return self.dbf.read_record(row) |
return self.dbf.read_record(row) |
157 |
|
|
158 |
def ReadValue(self, row, col): |
def ReadValue(self, row, col, row_is_ordinal = 0): |
159 |
"""Return the value of the specified row and column |
"""Return the value of the specified row and column |
160 |
|
|
161 |
The col parameter may be the index of the column or its name. |
The col parameter may be the index of the column or its name. |
162 |
|
|
163 |
|
The row_is_ordinal is ignored for DBF tables because the row id |
164 |
|
is always the row number. |
165 |
""" |
""" |
166 |
return self.dbf.read_record(row)[self.column_map[col].name] |
return self.dbf.read_attribute(row, self.column_map[col].index) |
167 |
|
|
168 |
def ValueRange(self, col): |
def ValueRange(self, col): |
169 |
"""Return the minimum and maximum values of the values in the column |
"""Return the minimum and maximum values of the values in the column |
245 |
self.type = type |
self.type = type |
246 |
self.index = index |
self.index = index |
247 |
|
|
248 |
class MemoryTable(TitledObject, OldTableInterfaceMixin): |
class MemoryTable(TitledObject): |
249 |
|
|
250 |
"""Very simple table implementation that operates on a list of tuples""" |
"""Very simple table implementation that operates on a list of tuples""" |
251 |
|
|
298 |
"""Return the number of rows in the table""" |
"""Return the number of rows in the table""" |
299 |
return len(self.data) |
return len(self.data) |
300 |
|
|
301 |
def ReadValue(self, row, col): |
def RowIdToOrdinal(self, gid): |
302 |
|
"""Return the row ordinal given its id |
303 |
|
|
304 |
|
Since for MemoryTables the row id is the row number, return the |
305 |
|
value unchanged. |
306 |
|
""" |
307 |
|
return gid |
308 |
|
|
309 |
|
def RowOrdinalToId(self, num): |
310 |
|
"""Return the rowid for given its ordinal |
311 |
|
|
312 |
|
Since for MemoryTables the row id is the row number, return the |
313 |
|
value unchanged. |
314 |
|
""" |
315 |
|
return num |
316 |
|
|
317 |
|
def ReadValue(self, row, col, row_is_ordinal = 0): |
318 |
"""Return the value of the specified row and column |
"""Return the value of the specified row and column |
319 |
|
|
320 |
The col parameter may be the index of the column or its name. |
The col parameter may be the index of the column or its name. |
321 |
|
|
322 |
|
The row_is_ordinal is ignored for DBF tables because the row id |
323 |
|
is always the row number. |
324 |
""" |
""" |
325 |
return self.data[row][self.column_map[col].index] |
return self.data[row][self.column_map[col].index] |
326 |
|
|
327 |
def ReadRowAsDict(self, index): |
def ReadRowAsDict(self, index, row_is_ordinal = 0): |
328 |
"""Return the entire row as a dictionary with column names as keys""" |
"""Return the entire row as a dictionary with column names as keys |
329 |
|
|
330 |
|
The row_is_ordinal is ignored for DBF tables because the row id |
331 |
|
is always the row number. |
332 |
|
""" |
333 |
return dict([(col.name, self.data[index][col.index]) |
return dict([(col.name, self.data[index][col.index]) |
334 |
for col in self.columns]) |
for col in self.columns]) |
335 |
|
|