3 # TODO: Whitelist for sites or machines with scheduled maintenance or
4 # predicted downtimes way in the future.
5 # Scheduled outages for some short period of time.
6 # gives admins a chance to compare expectations with observations.
13 history->MultipleJoin->PLCHistory.plc
14 sites -> MultipleJoin->Site.plc
15 actions->MultipleJoin->PLCAction.plc
17 # configuration parameters...
34 # I'm unsure of this. There is a transactional pattern that I need to
35 # discover or define wrt how data is introduced into the db and whether or not
36 # it can be trusted as 'complete'. this action may be the root of all the
41 plc->ForeignKey->PLC.actions
42 plc_query # site, node, slice query.
43 nodes_query # probe nodes
44 nodes_categorize # take raw data and push into finite states
45 # also aggregate data for site and plc
46 stats_aggregate # fill out the rest of aggregate fields in db?
47 nodes_diagnose # decide what actions to take based on history
49 nodes_act # read action db and perform to change state at plc or node
55 active # site exists in PLC
56 plc->ForeignKey->PLC.sites
57 history->MultipleJoin->SiteHistory.site
58 nodes->MultipleJoin->Node.site
59 actions->MultipleJoin->SiteAction.site
62 site->ForeignKey->Site.history
67 plc_slices_max # from plc
68 plc_slices_used # from plc
69 plc_disabled # from plc
70 plc_suspended # from plc
71 ob_nodes_up # from monitor
72 ob_nodes_down # from monitor
75 site->ForeignKey->Site.actions
79 email # from monitor diagnose -> action
80 suspend_slices # from monitor diagnose -> action
81 disable_creation # from monitor diagnose -> action
83 # Are other actions available for either Notify or Findbad scripts?
94 date_performed # from monitor (action)
95 rt_ticket_id # from monitor sent mail (action.py)
101 probe->ForeignKey->NodeProbe.node
102 hardware->OnetoOne->Hardware->node
103 actions->MultipleJoin->NodeAction.node
134 nodecurrent->ForeignKey->Node.actions
140 # Are there actions on individual nodes?
145 # TODO: Whitelist for sites or machines with scheduled maintenance or
146 # predicted downtimes way in the future.
147 # Scheduled outages for some short period of time.
148 # gives admins a chance to compare expectations with observations.
154 message_parts->Join->MessagePart->message.id
160 message->ForeignKey->Message.id