Class property_group

object --+        
         |        
  property --+    
             |    
      datatype --+
                 |
                property_group

This datatype will manage several columns of the same datatype that follow a naming convention. It is maily indended for database tables that store several versions of a string in several columns, as for example for applications where you have more than one language.

  CREATE TABLE item_category
  (
     id SERIAL,
     name_en TEXT,
     name_de TEXT,

     PRIMARY KEY(id)
  )

  class item_category:
      id = serial()
      name = datatype_group(Unicode, ('en', 'de',), 'en')

  lang = 'de'
  category_name = item_category.name[lang]

  { 'p1': sql.column(name1), 'p2': sql.column(name2) }