Revision 20367931
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
| vigiboard/model/vigiboard_bdd/host.py | ||
|---|---|---|
| 1 | 1 |
# -*- coding: utf-8 -*- |
| 2 |
"""Model For Host Table""" |
|
| 2 |
# vim:set expandtab tabstop=4 shiftwidth=4: |
|
| 3 |
"""Modèle pour la table Host""" |
|
| 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 |
| 7 | 8 |
|
| 8 | 9 |
from vigiboard.model import metadata |
| 9 | 10 |
|
| 10 |
from tg import config |
|
| 11 |
|
|
| 11 |
from vigiboard.config.vigiboard_config import vigiboard_config |
|
| 12 | 12 |
# Generation par SQLAutoCode |
| 13 | 13 |
|
| 14 |
host = Table(config['vigiboard_bdd.basename'] + 'host', metadata, |
|
| 15 |
Column(u'name', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=True, nullable=False), |
|
| 16 |
Column(u'checkhostcmd', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
|
| 17 |
Column(u'community', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
|
| 18 |
Column(u'fqhn', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
|
| 19 |
Column(u'hosttpl', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
|
| 20 |
Column(u'mainip', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
|
| 21 |
Column(u'port', Integer(), primary_key=False, nullable=False), |
|
| 22 |
Column(u'snmpoidsperpdu', Integer(), primary_key=False), |
|
| 23 |
Column(u'snmpversion', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False), |
|
| 14 |
host = Table(vigiboard_config['vigiboard_bdd.basename'] + 'host', metadata, |
|
| 15 |
Column(u'name', String(length=255, convert_unicode=True, assert_unicode=None), index=True,primary_key=True, nullable=False), |
|
| 16 |
Column(u'checkhostcmd', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False, nullable=False), |
|
| 17 |
Column(u'community', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False, nullable=False), |
|
| 18 |
Column(u'fqhn', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False, nullable=False), |
|
| 19 |
Column(u'hosttpl', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False, nullable=False), |
|
| 20 |
Column(u'mainip', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False, nullable=False), |
|
| 21 |
Column(u'port', Integer(), primary_key=False, nullable=False), |
|
| 22 |
Column(u'snmpoidsperpdu', Integer(), primary_key=False), |
|
| 23 |
Column(u'snmpversion', String(length=255, convert_unicode=True, assert_unicode=None), primary_key=False), |
|
| 24 |
mysql_engine='InnoDB', |
|
| 25 |
mysql_charset='utf8' |
|
| 24 | 26 |
) |
| 25 |
Index(u'name', host.c.name, unique=False) |
|
| 26 | 27 |
|
| 27 | 28 |
# Classe a mapper |
| 28 | 29 |
|
| 29 | 30 |
class Host(object): |
| 30 |
pass |
|
| 31 |
|
|
| 32 |
""" |
|
| 33 |
Classe liée avec la table associée |
|
| 34 |
""" |
|
| 35 |
|
|
| 36 |
def __init__(self,name,checkhostcmd='',community='',fqhn='',hosttpl='',mainip='',port=0,snmpoidsperdu=0,snmpversion=''): |
|
| 37 |
self.name = name |
|
| 38 |
self.checkhostcmd = checkhostcmd |
|
| 39 |
self.community = community |
|
| 40 |
self.fqhn = fqhn |
|
| 41 |
self.hosttpl = hosttpl |
|
| 42 |
self.mainip = mainip |
|
| 43 |
self.port = port |
|
| 44 |
self.snmpoidsperdu = snmpoidsperdu |
|
| 45 |
self.snmpversion = snmpversion |
|
| 46 |
|
|
| 31 | 47 |
mapper(Host,host) |
| 32 | 48 |
|
| 33 | 49 |
|
Also available in: Unified diff