class Template(BaseModel):
    name = CharField(unique=True)
    class Meta:
        db_table = 'templates'
        
    def __unicode__(self):
        return self.name
class TemplatePolicy(BaseModel):
    policy = ForeignKeyField(Policy, related_name='template_policies')
    template = ForeignKeyField(Template, related_name='template_policies')
    
    class Meta:
        db_table = 'template_policies'
        indexes = (
            (('policy', 'template'), True),
        )
        
    def __unicode__(self):
        return self.policy.name + ": " + self.template.name
class Policy(BaseModel):
    location = ForeignKeyField(Location, related_name='policies')
    unit = ForeignKeyField(Unit, related_name='policies')
    component = ForeignKeyField(Component, related_name='policies')
    
    @property
    def name(self):
        return "%s-%s-%s" % (self.location.name, self.unit.name, self.component.name)
    class Meta:
        db_table = 'policies'
        indexes = (
            (('location', 'unit', 'component'), True),
        )
        
    def __unicode__(self):
        return self.name
    
    def __str__(self):
        return self.name
class PolicyAdmin(ModelView):
    column_filters = (Location.name,
                      Unit.name,
                      Component.name)
    inline_models = (InterfacePolicy,)
class TemplateAdmin(ModelView):
    column_searchable_list = ('name',)
    column_filters = ('name',)
    inline_models = (TemplatePolicy,)