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

"""Model For GroupPermissions Table"""

from sqlalchemy.orm import mapper, relation

from sqlalchemy import Table, ForeignKeyConstraint, Column

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

from vigiboard.model import metadata, Permission

from vigiboard.model.vigiboard_bdd import Groups

from tg import config

# Generation par SQLAutoCode

grouppermissions =  Table(config['vigiboard_bdd.basename'] + 'grouppermissions', metadata,

            Column(u'groupname', String(length=100, convert_unicode=False, assert_unicode=None), primary_key=True, nullable=False),

            Column(u'idpermission', Integer(), primary_key=True, nullable=False),

            ForeignKeyConstraint([u'groupname'], [config['vigiboard_bdd.basename'] + u'groups.name'], name=u'grouppermissions_ibfk_1'),

    )

# Classe a mapper

class GroupPermissions(object):

        def get_grp (self,user_p):

                events = DBSession.query(Groups).join(

                        ( GroupPermissions , Groups.name == GroupPermission.groupname ),

                        ( Permission , Permission.permission_id == GroupPermissions.idpermission )

                        ).filter(in_(Permission.permission_name,user_p))

                return events

mapper(GroupPermissions,grouppermissions)