/[thuban]/branches/WIP-pyshapelib-bramz/Thuban/Model/table.py

Diff of /branches/WIP-pyshapelib-bramz/Thuban/Model/table.py

Parent Directory | Revision Log | View Patch Patch

-revision 1024 by jan,
Fri May 23 12:56:34 2003 UTC
+revision 1025 by frank,
Mon May 26 11:46:17 2003 UTC
 Line 2
  # Authors:
  # Bernhard Herzog <[email protected]>
  # Jan-Oliver Wagner <[email protected]>
+ # Frank Koormann <[email protected]>
  #
  # This program is free software under the GPL (>=v2)
  # Read the file COPYING coming with Thuban for details.
-Line 229 
 class DBFTable(TitledObject, OldTableInt
+Line 230 
 class DBFTable(TitledObject, OldTableInt
      # DBF specific interface parts.
+     def Precision(self, col):
+         """Return column precision"""
+         return self.column_map[col].prec
+     def Width(self, col):
+         """Return column width"""
+         return self.column_map[col].width
      def Destroy(self):
          self.dbf.close()
          self.dbf = None
-Line 346 
 class MemoryTable(TitledObject, OldTable
+Line 355 
 class MemoryTable(TitledObject, OldTable
          return min(values), max(values)
      def UniqueValues(self, col):
-         """Return a sorted list of all unique values in the column col"""
+         """Return a sorted list of all unique values in the column col
+         col can be either column index or name.
+         """
          dict = {}
          for i in range(self.NumRows()):
-Line 357 
 class MemoryTable(TitledObject, OldTable
+Line 369 
 class MemoryTable(TitledObject, OldTable
          values.sort()
          return values
+     def Width(self, col):
+         """Return the maximum width of values in the column
+         The return value is the the maximum length of string representation
+         of the values in the column (represented by index or name)."""
+         max = 0
+         type  = self.column_map[col].type
+         index = self.column_map[col].index
+         values = [row[index] for row in self.data]
+         if not values:
+             return None
+         if type == FIELDTYPE_DOUBLE:
+             prec = self.Precision(col)
+             format = "%%.%df" % prec
+         elif type == FIELDTYPE_INT:
+             format = "%d"
+         else:
+             format = "%s"
+         for value in values:
+             l = len(format % value)
+             if l > max:
+                 max = l
+         return max
+     def Precision(self, col):
+         """Return the precision of the column
+         The return value is the maximum number of numeric characters after the
+         decimal if column type is double. Else precision zero is returned.
+         The column can be represented by index or name.
+         """
+         type  = self.column_map[col].type
+         if type == FIELDTYPE_DOUBLE:
+             index = self.column_map[col].index
+             values = [row[index] for row in self.data]
+             if not values:
+                 return 0
+             max = 0
+             for value in values:
+                 l = len(str(value % 1))
+                 if l > max:
+                     max = l
+             if max > 2:
+                 return max - 2
+             else:
+                 return 0
+         else:
+             return 0
      def Dependencies(self):
          """Return an empty sequence. The MemoryTable doesn't depend on anything
          """
-Line 368 
 class MemoryTable(TitledObject, OldTable
+Line 434 
 class MemoryTable(TitledObject, OldTable
          # TODO: Allow values to be a dictionary and write the single
          # fields that are specified.
          self.data[record] = values
+ def table_to_dbf(table, filename):
+     """Create the dbf file filename from the table"""
+     dbf = dbflib.create(filename)
+     dbflib_fieldtypes = {FIELDTYPE_STRING: dbflib.FTString,
+                          FIELDTYPE_INT: dbflib.FTInteger,
+                          FIELDTYPE_DOUBLE: dbflib.FTDouble}
+     # Initialise the header. Distinguish between DBFTable and others.
+     for col in table.Columns():
+         prec  = table.Precision(col.name)
+         width = table.Width(col.name)
+         dbf.add_field(col.name, dbflib_fieldtypes[col.type], width, prec)
+     for i in range(table.NumRows()):
+         record = table.ReadRowAsDict(i)
+         dbf.write_record(i, record)
+     dbf.close()
+ def table_to_csv(table, filename):
+     """Export table to csv file."""
+     file = open(filename,"w")
+     columns = table.Columns()
+     if columns:
+         header = "#%s" % columns[0].name
+         for col in columns[1:]:
+             header = header + ",%s" % col.name
+         header = header + "\n"
+         file.write(header)
+         for i in range(table.NumRows()):
+             record = table.ReadRowAsDict(i)
+             if len(record):
+                 line = "%s" % record[columns[0].name]
+                 for col in columns[1:]:
+                     line = line + ",%s" % record[col.name]
+             line = line + "\n"
+             file.write(line)
+     file.close()

 Legend:



Removed from v.1024
 


changed lines


 
Added in v.1025
 Legend:



Removed from v.1024
 


changed lines


 
Added in v.1025
-Removed from v.1024
+Added in v.1025

[email protected]	ViewVC Help
Powered by ViewVC 1.1.26