PLC/NodeNetworkSettings.py

   1 #
   2 # Thierry Parmentelat - INRIA
   3 #
   4 # $Revision: 5574 $
   5 #
   6 from PLC.Faults import *
   7 from PLC.Parameter import Parameter
   8 from PLC.Filter import Filter
   9 from PLC.Table import Row, Table
  10 from PLC.NodeNetworkSettingTypes import NodeNetworkSettingType, NodeNetworkSettingTypes
  11
  12 class NodeNetworkSetting(Row):
  13     """
  14     Representation of a row in the nodenetwork_setting.
  15     To use, instantiate with a dict of values.
  16     """
  17
  18     table_name = 'nodenetwork_setting'
  19     primary_key = 'nodenetwork_setting_id'
  20     fields = {
  21         'nodenetwork_setting_id': Parameter(int, "Nodenetwork setting identifier"),
  22         'nodenetwork_id': Parameter(int, "NodeNetwork identifier"),
  23         'nodenetwork_setting_type_id': NodeNetworkSettingType.fields['nodenetwork_setting_type_id'],
  24         'name': NodeNetworkSettingType.fields['name'],
  25         'description': NodeNetworkSettingType.fields['description'],
  26         'category': NodeNetworkSettingType.fields['category'],
  27         'min_role_id': NodeNetworkSettingType.fields['min_role_id'],
  28         'value': Parameter(str, "Nodenetwork setting value"),
  29         ### relations
  30
  31         }
  32
  33 class NodeNetworkSettings(Table):
  34     """
  35     Representation of row(s) from the nodenetwork_setting table in the
  36     database.
  37     """
  38
  39     def __init__(self, api, nodenetwork_setting_filter = None, columns = None):
  40         Table.__init__(self, api, NodeNetworkSetting, columns)
  41
  42         sql = "SELECT %s FROM view_nodenetwork_settings WHERE True" % \
  43               ", ".join(self.columns)
  44
  45         if nodenetwork_setting_filter is not None:
  46             if isinstance(nodenetwork_setting_filter, (list, tuple, set)):
  47                 nodenetwork_setting_filter = Filter(NodeNetworkSetting.fields, {'nodenetwork_setting_id': nodenetwork_setting_filter})
  48             elif isinstance(nodenetwork_setting_filter, dict):
  49                 nodenetwork_setting_filter = Filter(NodeNetworkSetting.fields, nodenetwork_setting_filter)
  50             elif isinstance(nodenetwork_setting_filter, int):
  51                 nodenetwork_setting_filter = Filter(NodeNetworkSetting.fields, {'nodenetwork_setting_id': [nodenetwork_setting_filter]})
  52             else:
  53                 raise PLCInvalidArgument, "Wrong nodenetwork setting filter %r"%nodenetwork_setting_filter
  54             sql += " AND (%s) %s" % nodenetwork_setting_filter.sql(api)
  55
  56
  57         self.selectall(sql)