#
# Functions for interacting with the address_types table in the database
#
# Mark Huang <mlhuang@cs.princeton.edu>
# Copyright (C) 2006 The Trustees of Princeton University
#

from types import StringTypes
from PLC.Faults import *
from PLC.Parameter import Parameter
from PLC.Filter import Filter
from PLC.Storage.AlchemyObj import AlchemyObj
from PLC.Table import Row, Table

class AddressType(AlchemyObj):
    """
    Representation of a row in the address_types table. To use,
    instantiate with a dict of values.
    """

    tablename = 'address_types'
    join_tables = ['address_address_type']
    fields = {
        'address_type_id': Parameter(int, "Address type identifier", primary_key=True),
        'name': Parameter(str, "Address type", max = 20),
        'description': Parameter(str, "Address type description", max = 254),
        }

    def validate_name(self, name):
        # Make sure name is not blank
        if not len(name):
            raise PLCInvalidArgument, "Address type must be specified"

        # Make sure address type does not already exist
        conflicts = AddressTypes(self.api, [name])
        for address_type_id in conflicts:
            if 'address_type_id' not in self or self['address_type_id'] != address_type_id:
                raise PLCInvalidArgument, "Address type name already in use"

        return name

    def sync(self, insert=False, validate=True):
        AlchemyObj.sync(self, insert, validate):
        if insert == True or 'address_type_id'  not in self:
            AlchemyObj.insert(self, dict(self))
        else:
            AlchemyObj.update(self, dict(self))


    def delete(self, commit=True):
        AlchemyObj.delete(self, dict(self))

class AddressTypes(list):
    """
    Representation of the address_types table in the database.
    """

    def __init__(self, api, address_type_filter = None, columns = None):
        if not address_type_filter:
            address_types = AddressType().select()
        elif isinstance(address_type_filter, (list, tuple, set)):
            # Separate the list into integers and strings
            ints = filter(lambda x: isinstance(x, (int, long)), address_type_filter)
            strs = filter(lambda x: isinstance(x, StringTypes), address_type_filter)
            address_types = AddressType().select(filter={'address_type_id': ints, 'name': strs})
        elif isinstance(address_type_filter, dict):
            address_types = AddressType().select(filter=address_type_filter)
        elif isinstance(address_type_filter, (int, long)):
            address_types = AddressType().select(filter={'address_type_id': address_type_filter})
        elif isinstance(address_type_filter, StringTypes):
            address_types = AddressType().select(filter={'name': address_type_filter})
        else:
            raise PLCInvalidArgument, "Wrong address type filter %r"%address_type_filter

        for address_type in address_types:
            self.append(address_type)