#!/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(38, 1, 1, 'VMPS', 'FEE1', 'E202', 'ISOV'))
    faults.append(FaultInput(38, 1, 2, 'VMPS', 'FEE1', 'E202', 'APRT'))
    faults.append(FaultInput(38, 1, 3, 'VMPS', 'FEE1', 'E101', 'ISOL'))
    faults.append(FaultInput(38, 1, 4, 'VMPS', 'FEE1', 'E101', 'FSHR'))
    faults.append(FaultInput(38, 1, 5, 'VMPS', 'FEE1',  '703', 'ISOL_H'))
    faults.append(FaultInput(38, 1, 6, 'VMPS', 'FEE1',  '703', 'ISOL_S1'))
    faults.append(FaultInput(38, 1, 7, 'VMPS', 'FEE1',  '703', 'ISOL_S2'))

    faults.append(FaultInput(38, 2,  1, 'SATT', 'FEE1', '329', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 2,  2, 'SATT', 'FEE1', '329', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))

    faults.append(FaultInput(38, 4,  1, 'SATT', 'FEE1', '321', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4,  2, 'SATT', 'FEE1', '321', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4,  3, 'SATT', 'FEE1', '322', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4,  4, 'SATT', 'FEE1', '322', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4,  5, 'SATT', 'FEE1', '323', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4,  6, 'SATT', 'FEE1', '323', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4,  7, 'SATT', 'FEE1', '324', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4,  8, 'SATT', 'FEE1', '324', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4,  9, 'SATT', 'FEE1', '325', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4, 10, 'SATT', 'FEE1', '325', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4, 11, 'SATT', 'FEE1', '326', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4, 12, 'SATT', 'FEE1', '326', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4, 13, 'SATT', 'FEE1', '327', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4, 14, 'SATT', 'FEE1', '327', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 4, 15, 'SATT', 'FEE1', '328', 'IN' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 4, 16, 'SATT', 'FEE1', '328', 'OUT', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))

    faults.append(FaultInput(38, 5,  1, 'STPR', 'FEE1', 'ST1', 'OUTLIM', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 5,  2, 'STPR', 'FEE1', 'ST1', 'INLIM' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    faults.append(FaultInput(38, 5,  3, 'STPR', 'FEE1', 'ST2', 'OUTLIM', faultname="POSITION", faultedname="IS_NOT_OUT", okname="IS_OUT"))
    faults.append(FaultInput(38, 5,  4, 'STPR', 'FEE1', 'ST2', 'INLIM' , faultname="POSITION", faultedname="IS_NOT_IN",  okname="IS_IN" ))
    
    
    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()
