Project

General

Profile

Revision 20367931

ID20367931826425cf944d798b717c132dfae9ab42
Parent ed374445
Child 089dfbc2

Added by Thomas ANDREJAK almost 15 years ago

Réorganisation du code (controllers, etc)
Mise en place d'un système de plugin pour ajouter des colonnes à la volée
Internationalisation complète
Création de quelques tests

git-svn-id: https://vigilo-dev.si.c-s.fr/svn@274 b22e2e97-25c9-44ff-b637-2e5ceca36478

View differences:

vigiboard/model/vigiboard_bdd/perfdatasource.py
1 1 
# -*- coding: utf-8 -*-
2 
"""Model For PerfDataSource Table"""
2 
# vim:set expandtab tabstop=4 shiftwidth=4:
3 
"""Modèle pour la table PerfDataSource"""
3 4 

  		




  4
  5
  
    
from sqlalchemy.orm import mapper, relation


  		




  5
  
  
    
from sqlalchemy import Table, ForeignKeyConstraint, Column, Index


  		




  
  6
  
    
from sqlalchemy import Table, ForeignKey, Column, Index


  		




  6
  7
  
    
from sqlalchemy.types import Integer, String, Text, DateTime, Float


  		




  7
  8
  
    

  		




  8
  9
  
    
from vigiboard.model import metadata


  		




  9
  10
  
    

  		




  10
  
  
    
from tg import config


  		




  
  11
  
    
from vigiboard.config.vigiboard_config import vigiboard_config


  		




  11
  12
  
    

  		




  12
  13
  
    
# Generation par SQLAutoCode


  		




  13
  14
  
    

  		




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


  		




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


  		




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


  		




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


  		




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


  		




  19
  
  
    
            Column(u'label', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False),


  		




  20
  
  
    
            Column(u'factor', Float(precision=None, asdecimal=False), primary_key=False, nullable=False),


  		




  21
  
  
    
	    ForeignKeyConstraint([u'hostname'], [config['vigiboard_bdd.basename'] + u'host.name'], name=u'perfdatasource_ibfk_1'),


  		




  22
  
  
    
            ForeignKeyConstraint([u'graphname'], [config['vigiboard_bdd.basename'] + u'graph.name'], name=u'perfdatasource_ibfk_3'),


  		




  23
  
  
    
            ForeignKeyConstraint([u'servicename'], [config['vigiboard_bdd.basename'] + u'service.name'], name=u'perfdatasource_ibfk_2'),


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  20
  
    
        Column(u'label', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False),


  		




  
  21
  
    
        Column(u'factor', Float(precision=None, asdecimal=False), primary_key=False, nullable=False),


  		




  
  22
  
    
        mysql_engine='InnoDB',


  		




  
  23
  
    
        mysql_charset='utf8'


  		




  24
  24
  
    
    )


  		




  25
  
  
    
Index(u'graphname', perfdatasource.c.graphname, unique=False)


  		




  26
  
  
    
Index(u'servicename', perfdatasource.c.servicename, unique=False)


  		




  27
  25
  
    

  		




  28
  26
  
    
# Classe a mapper


  		




  29
  27
  
    

  		




  30
  28
  
    
class PerfDataSource(object):


  		




  31
  
  
    
	pass  


  		




  32
  
  
    
mapper(PerfDataSource,perfdatasource)


  		




  33
  
  
    

  		




  
  29
  
    
    


  		




  
  30
  
    
    """


  		




  
  31
  
    
    Classe liée avec la table associée


  		




  
  32
  
    
    """


  		




  
  33
  
    
    


  		




  
  34
  
    
    def __init__(self,hostname,servicename,graphname,type='',label='',factor=0.0):


  		




  
  35
  
    
        self.hostname = hostname


  		




  
  36
  
    
        self.servicename = servicename


  		




  
  37
  
    
        self.graphname = graphname


  		




  
  38
  
    
        self.type = type


  		




  
  39
  
    
        self.label = label


  		




  
  40
  
    
        self.factor = factor


  		




  34
  41
  
    

  		




  
  42
  
    
mapper(PerfDataSource,perfdatasource)


  		












Also available in:  Unified diff