#!/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():
    FaultInput = mpsconfig.FaultInput
    faults = list()


    faults.append(FaultInput(39, 1, 1,    'SAS', 'MMM', '01', 'A',     faultname="POSITION", faultedname="IS_NOT_IN",      okname="IS_IN"      ))
    faults.append(FaultInput(39, 1, 2,    'SAS', 'MMM', '01', 'B',     faultname="POSITION", faultedname="IS_NOT_OUT",     okname="IS_OUT"     ))
    faults.append(FaultInput(39, 1, 3,    'SAS', 'MMS', '01', 'A',     faultname="POSITION", faultedname="IS_NOT_IN",      okname="IS_IN"      ))
    faults.append(FaultInput(39, 1, 4,    'SAS', 'MMS', '01', 'B',     faultname="POSITION", faultedname="IS_NOT_OUT",     okname="IS_OUT"     ))
    faults.append(FaultInput(39, 1, 5,    'AMO', 'KBO', 'VGC', '01B',  faultname="POSITION", faultedname="IS_NOT_OPEN",    okname="IS_OPEN"    ))
    faults.append(FaultInput(39, 1, 6,    'AMO', 'KBO', 'VGC', '01A',  faultname="POSITION", faultedname="IS_NOT_CLOSED",  okname="IS_CLOSED"  ))
    faults.append(FaultInput(39, 1, 7,    'AMO', 'KBO', 'VGC', '02B',  faultname="POSITION", faultedname="IS_NOT_OPEN",    okname="IS_OPEN"    ))
    faults.append(FaultInput(39, 1, 8,    'AMO', 'KBO', 'VGC', '02A',  faultname="POSITION", faultedname="IS_NOT_CLOSED",  okname="IS_CLOSED"  ))
    faults.append(FaultInput(39, 1, 9,    'AMO', 'HFP', 'VGC', '02B',  faultname="POSITION", faultedname="IS_NOT_OPEN",    okname="IS_OPEN"    ))
    faults.append(FaultInput(39, 1, 10,   'AMO', 'HFP', 'VGC', '02A',  faultname="POSITION", faultedname="IS_NOT_CLOSED",  okname="IS_CLOSED"  ))
    faults.append(FaultInput(39, 1, 11,   'AMO', 'DIA', 'VGC', '02B',  faultname="POSITION", faultedname="IS_NOT_OPEN",    okname="IS_OPEN"    ))
    faults.append(FaultInput(39, 1, 12,   'AMO', 'DIA', 'VGC', '02A',  faultname="POSITION", faultedname="IS_NOT_CLOSED",  okname="IS_CLOSED"  ))
    faults.append(FaultInput(39, 1, 13,   'AMO', 'HFP', 'MPA', '02A',  faultname="POSITION", faultedname="IS_NOT_IN",      okname="IS_IN"      ))
    faults.append(FaultInput(39, 1, 14,   'AMO', 'HFP', 'MPA', '02B',  faultname="POSITION", faultedname="IS_NOT_OUT",     okname="IS_OUT"     ))
    faults.append(FaultInput(39, 1, 15,   'AMO', 'HFP', 'MPA', '02A',  faultname="POSITION", faultedname="IS_NOT_IN",      okname="IS_IN"      ))
    faults.append(FaultInput(39, 1, 16,   'AMO', 'HFP', 'MPA', '02B',  faultname="POSITION", faultedname="IS_NOT_OUT",     okname="IS_OUT"     ))
   
    
    
    connection             = sqlite3.connect(sys.argv[1])
    connection.row_factory = sqlite3.Row
    cursor                 = connection.cursor()
    
    mpsconfig.insert_fault_inputs(cursor, faults, True)
    
    connection.commit()
    connection.close()

    
if __name__ == '__main__':
    main()
