#!/usr/bin/env python
import sys
import sqlite3

# Hack
sys.path.append('/afs/slac.stanford.edu/u/xr/snorum/ioc/mpsConfiguration/scripts/version0-0-8')
import mpsconfig

def main():
    
    connection             = sqlite3.connect(sys.argv[1])
    connection.row_factory = sqlite3.Row
    cursor                 = connection.cursor()
    
    FaultInput = mpsconfig.FaultInput
    faults = list()


#    faults.append( FaultInput(11, 7,  8, 'PICS', 'IN20',  'BL665', 'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(16, 7,  8, 'PICS', 'LI24',  '791',   'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(22, 7,  8, 'PICS', 'LI29',  '96',    'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(23, 7,  8, 'PICS', 'CA11',  '54',    'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(25, 7,  8, 'PICS', 'MC00',  '20',    'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(28, 7,  8, 'PICS', 'LTU1',  '220',   'NO_TRIG', faultname='MISSED' ))
#    faults.append( FaultInput(29, 7,  8, 'PICS', 'LTU1',  '480',   'NO_TRIG', faultname='MISSED' ))
    faults.append( FaultInput(31, 7,  8, 'PICS', 'LTU1',  '762',   'NO_TRIG', faultname='MISSED' ))


    mpsconfig.insert_fault_inputs(cursor, faults, True)
    
    connection.commit()
    connection.close()

    
if __name__ == '__main__':
    main()
