# -*- coding: utf-8 -*-

# vim:set expandtab tabstop=4 shiftwidth=4:

"""Modèle pour la table ServiceGroups"""

from sqlalchemy.orm import mapper, relation

from sqlalchemy import Table, ForeignKey, Column, Index

from sqlalchemy.types import Integer, String, Text, DateTime

from vigiboard.model import metadata

from vigiboard.config.vigiboard_config import vigiboard_config

# Generation par SQLAutoCode

servicegroups =  Table(vigiboard_config['vigiboard_bdd.basename'] + 'servicegroups', metadata,

        Column(u'servicename', String(length=100, convert_unicode=True, assert_unicode=None), ForeignKey(vigiboard_config['vigiboard_bdd.basename'] + u'service.name'),primary_key=True, nullable=False),

        Column(u'groupname', String(length=100, convert_unicode=True, assert_unicode=None), ForeignKey(vigiboard_config['vigiboard_bdd.basename'] + u'groups.name'),index=True,primary_key=True, nullable=False),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

# Classe a mapper

class ServiceGroups(object):

    """

    Classe liée avec la table associée

    """

    def __init__(self,servicename, groupname):

        self.servicename = servicename

        self.groupname = groupname

mapper(ServiceGroups,servicegroups)