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

# Hack
sys.path.append('/afs/slac.stanford.edu/u/xr/snorum/ioc/mpsConfiguration/scripts/version0-0-6')
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(10, 3,  1, 'MPS', 'IN20', '200', 'LHSHT1_OUT' ))
    faults.append( FaultInput(10, 3,  2, 'MPS', 'IN20', '200', 'LHSHT1_IN'  ))
    faults.append( FaultInput(10, 3,  3, 'MPS', 'IN20', '200', 'LHSHT2_OUT' ))
    faults.append( FaultInput(10, 3,  4, 'MPS', 'IN20', '200', 'LHSHT2_IN'  ))
    faults.append( FaultInput(10, 3,  5, 'MPS', 'IN20', '200', 'MSHT1_OUT'  ))
    faults.append( FaultInput(10, 3,  6, 'MPS', 'IN20', '200', 'MSHT1_IN'   ))
    faults.append( FaultInput(10, 3,  7, 'MPS', 'IN20', '200', 'MSHT2_OUT'  ))
    faults.append( FaultInput(10, 3,  8, 'MPS', 'IN20', '200', 'MSHT2_IN'   ))
    faults.append( FaultInput(10, 3,  9, 'MPS', 'IN20', '200', 'ANDBYPALL'  ))
    faults.append( FaultInput(10, 3, 10, 'MPS', 'IN20', '200', 'ANDBYPCH1'  ))
    faults.append( FaultInput(10, 3, 11, 'MPS', 'IN20', '200', 'ANDBYPCH2'  ))
    faults.append( FaultInput(10, 3, 12, 'MPS', 'IN20', '200', 'ANDBYPCH3'  ))
    faults.append( FaultInput(10, 3, 13, 'MPS', 'IN20', '200', 'ANDBYPCH4'  ))
    faults.append( FaultInput(10, 3, 14, 'MPS', 'IN20', '200', 'ANDBYPCH5'  ))
    faults.append( FaultInput(10, 3, 15, 'MPS', 'IN20', '200', 'ANDBYPCH6'  ))
    faults.append( FaultInput(10, 3, 16, 'MPS', 'IN20', '200', 'ANDBYPCH7'  ))
    
    faults.append( FaultInput(10, 4,  1, 'MPS', 'IN20', '200', 'ANDBYPCH8'  ))
    

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

    
if __name__ == '__main__':
    main()
