1 |
# Copyright (c) 2001 by Intevation GmbH |
# Copyright (c) 2001, 2002 by Intevation GmbH |
2 |
# Authors: |
# Authors: |
3 |
# Bernhard Herzog <[email protected]> |
# Bernhard Herzog <[email protected]> |
4 |
# |
# |
32 |
Currently this is basically just a wrapper around dbflib. |
Currently this is basically just a wrapper around dbflib. |
33 |
""" |
""" |
34 |
|
|
35 |
|
# Implementation strategy regarding writing to a DBF file: |
36 |
|
# |
37 |
|
# Most of the time Thuban only needs to read from a table and it is |
38 |
|
# important that Thuban can work with read-only files. Therefore the |
39 |
|
# DBF file is opened only for reading initially. Only when |
40 |
|
# write_record is called we try to open the DBF file for writing as |
41 |
|
# well. If that succeeds the dbf read/write DBF file will be used |
42 |
|
# for all IO afterwards. |
43 |
|
# |
44 |
|
# It's important to use the same DBF file object for both reading |
45 |
|
# and writing to make sure that reading a records after writing |
46 |
|
# returns the new values. With two separate objects this wouldn't |
47 |
|
# work because a DBF file object buffers some data |
48 |
|
|
49 |
def __init__(self, filename): |
def __init__(self, filename): |
50 |
self.filename = filename |
self.filename = filename |
51 |
self.dbf = dbflib.DBFFile(filename) |
self.dbf = dbflib.DBFFile(filename) |
52 |
|
|
53 |
|
# If true, self.dbf is open for writing. |
54 |
|
self._writable = 0 |
55 |
|
|
56 |
|
def Destroy(self): |
57 |
|
self.dbf.close() |
58 |
|
self.dbf = None |
59 |
|
|
60 |
def record_count(self): |
def record_count(self): |
61 |
"""Return the number of records""" |
"""Return the number of records""" |
62 |
return self.dbf.record_count() |
return self.dbf.record_count() |
80 |
""" |
""" |
81 |
return self.dbf.read_record(record) |
return self.dbf.read_record(record) |
82 |
|
|
83 |
|
def write_record(self, record, values): |
84 |
|
"""Write the values into the record |
85 |
|
|
86 |
|
The values parameter may either be a dictionary or a sequence. |
87 |
|
|
88 |
|
If it's a dictionary the keys must be the names of the fields |
89 |
|
and their value must have a suitable type. Only the fields |
90 |
|
actually contained in the dictionary are written. Fields for |
91 |
|
which there's no item in the dict are not modified. |
92 |
|
|
93 |
|
If it's a sequence, all fields must be present in the right |
94 |
|
order. |
95 |
|
""" |
96 |
|
if not self._writable: |
97 |
|
new_dbf = dbflib.DBFFile(self.filename, "r+b") |
98 |
|
self.dbf.close() |
99 |
|
self.dbf = new_dbf |
100 |
|
self._writable = 1 |
101 |
|
self.dbf.write_record(record, values) |
102 |
|
self.dbf.commit() |