#!/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, 5, 1,    'CAMR', 'FEE1', '1561', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 2,    'CAMR', 'FEE1', '1561', 'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 5, 3,    'CAMR', 'FEE1', '852',  'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 4,    'CAMR', 'FEE1', '852',  'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 5, 5,    'CAMR', 'FEE1', '913',  'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 6,    'CAMR', 'FEE1', '913',  'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 5, 7,    'CAMR', 'FEE1', '1692', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 8,    'CAMR', 'FEE1', '1692', 'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 5, 9,    'CAMR', 'FEE1', '1953', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 10,   'CAMR', 'FEE1', '1953', 'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 5, 11,   'CAMR', 'FEE1', '2953', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 5, 12,   'CAMR', 'FEE1', '2953', 'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
   
    faults.append(FaultInput(38, 6, 1,    'VMPS', 'NEH',  '703',  'ISOL_H' , faultname="STATE", faultedname="IS_FAULTED",  okname="IS_OK"  ))
    faults.append(FaultInput(38, 6, 2,    'VMPS', 'NEH',  '703',  'ISOL_S1', faultname="STATE", faultedname="IS_FAULTED",  okname="IS_OK"  ))
    faults.append(FaultInput(38, 6, 3,    'VMPS', 'NEH',  '703',  'ISOL_S2', faultname="STATE", faultedname="IS_FAULTED",  okname="IS_OK"  ))
   
    faults.append(FaultInput(38, 6, 7,    'CAMR', 'NEH1', '124',  'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 6, 8,    'CAMR', 'NEH1', '124',  'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 6, 9,    'CAMR', 'NEH1', '195',  'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 6, 10,   'CAMR', 'NEH1', '195',  'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 6, 11,   'CAMR', 'NEH1', '1124', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 6, 12,   'CAMR', 'NEH1', '1124', 'OUT'    , faultname="STATE", faultedname="IS_NOT_OUT",  okname="IS_OUT" ))
    faults.append(FaultInput(38, 6, 13,   'CAMR', 'NEH1', '2124', 'IN'     , faultname="STATE", faultedname="IS_NOT_IN",   okname="IS_IN"  ))
    faults.append(FaultInput(38, 6, 14,   'CAMR', 'NEH1', '2124', 'OUT'    , faultname="STATE", 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()
