#!/usr/bin/env python
"""
Use `fault_count` to return the total number of faults as `count`.

Use `epics_fault_count` to return the total number of epics faults as `count`.

Use `link_node_channel_faults` to return the following columns:
    device_name
    fault_name
    fault_id
    fault_number
    pv_device_type
    pv_area
    pv_position
    pv_attribute
    ok_state_name
    faulted_state_name
    link_node_id
    card
    channel
    debounce_enum
    debounce_time
    debounce_name
    is_deadman
    is_autorecoverable
    position_x
    position_y
    position_z
    cable
    description
    area

Use `epics_faults` to return the following columns:
    device_name
    fault_name
    fault_id
    fault_number
    pv_device_type
    pv_area
    pv_position
    pv_attribute
    input_pv
    ok_state_name
    faulted_state_name
    is_autorecoverable
    position_x
    position_y
    position_z
    description
    area

Use `link_node_faults` to return the following columns:
    device_name
    base_fault_name
    fault_name
    fault_id
    fault_number
    link_node_id
    pv_device_type
    pv_area
    pv_position
    pv_attribute
    ok_state_name
    faulted_state_name
    is_autorecoverable
    description
    area

Use `link_processor_faults` to return the following columns:
    device_name
    fault_name
    fault_id
    fault_number
    pv_device_type
    pv_area
    pv_position
    pv_attribute
    ok_state_name
    faulted_state_name
    is_autorecoverable
    position_x
    position_y
    position_z
    description
    area
"""
    
fault_count = 'select count(*) count from fault_number'    
epics_fault_count = 'select count(*) count from epics_fault;'    
link_node_channel_faults = 'select * from link_node_channel_fault'
epics_faults = 'select * from epics_fault'
link_node_faults = 'select * from link_node_fault'
link_processor_faults = 'select * from link_processor_fault'
