vigiboard / dashboard / model / bdd_dashboard / perfdatasource.py @ 805cc54a
History | View | Annotate | Download (1.58 KB)
1 | 805cc54a | Thomas ANDREJAK | # -*- coding: utf-8 -*-
|
---|---|---|---|
2 | """Model For PerfDataSource Table"""
|
||
3 | |||
4 | from sqlalchemy.orm import mapper, relation |
||
5 | from sqlalchemy import Table, ForeignKeyConstraint, Column, Index |
||
6 | from sqlalchemy.types import Integer, String, Text, DateTime, Float |
||
7 | |||
8 | from dashboard.model import metadata |
||
9 | |||
10 | |||
11 | # Generation par SQLAutoCode
|
||
12 | |||
13 | perfdatasource = Table('perfdatasource', metadata,
|
||
14 | Column(u'hostname', String(length=100, convert_unicode=False, assert_unicode=None), primary_key=True, nullable=False), |
||
15 | Column(u'servicename', String(length=100, convert_unicode=False, assert_unicode=None), primary_key=True, nullable=False), |
||
16 | Column(u'graphname', String(length=100, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
||
17 | Column(u'type', String(length=100, convert_unicode=False, assert_unicode=None), primary_key=False, nullable=False), |
||
18 | Column(u'label', String(length=255, convert_unicode=False, assert_unicode=None), primary_key=False), |
||
19 | Column(u'factor', Float(precision=None, asdecimal=False), primary_key=False, nullable=False), |
||
20 | ForeignKeyConstraint([u'hostname'], [u'host.name'], name=u'perfdatasource_ibfk_1'), |
||
21 | ForeignKeyConstraint([u'graphname'], [u'graph.name'], name=u'perfdatasource_ibfk_3'), |
||
22 | ForeignKeyConstraint([u'servicename'], [u'service.name'], name=u'perfdatasource_ibfk_2'), |
||
23 | ) |
||
24 | Index(u'graphname', perfdatasource.c.graphname, unique=False) |
||
25 | Index(u'servicename', perfdatasource.c.servicename, unique=False) |
||
26 | |||
27 | # Classe a mapper
|
||
28 | |||
29 | class PerfDataSource(object): |
||
30 | pass
|
||
31 | mapper(PerfDataSource,perfdatasource) |
||
32 |