#!/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(30,  7,  8, 'BLM', 'LTU1', '722', 'NO_TRIG', faultname='MISSED'))
    faults.append( FaultInput(32,  7,  8, 'BLM', 'LTU1', '762', 'NO_TRIG', faultname='MISSED'))
    faults.append( FaultInput(33,  7,  8, 'BLM', 'UND1', '6',   'NO_TRIG', faultname='MISSED'))
    faults.append( FaultInput(35,  7,  8, 'BLM', 'UND1', '14',  'NO_TRIG', faultname='MISSED'))
    faults.append( FaultInput(37,  7,  8, 'BLM', 'UND1', '30',  'NO_TRIG', faultname='MISSED'))
        
    faults.append( FaultInput(30, 17,  1, 'HVPS', 'LTU1', '722'  , 'LOW' ))
    faults.append( FaultInput(30, 17,  2, 'HVPS', 'LTU1', '722'  , 'HIGH'))
    faults.append( FaultInput(30, 17,  3, 'HVPS', 'LTU1', '732'  , 'LOW' ))
    faults.append( FaultInput(30, 17,  4, 'HVPS', 'LTU1', '732'  , 'HIGH'))
    faults.append( FaultInput(30, 17,  5, 'HVPS', 'LTU1', 'SP1'  , 'LOW' ))
    faults.append( FaultInput(30, 17,  6, 'HVPS', 'LTU1', 'SP1'  , 'HIGH'))
    faults.append( FaultInput(30, 17,  7, 'HVPS', 'LTU1', 'SP2'  , 'LOW' ))
    faults.append( FaultInput(30, 17,  8, 'HVPS', 'LTU1', 'SP2'  , 'HIGH'))
    faults.append( FaultInput(30, 17,  9, 'HVPS', 'UND1', '121'  , 'LOW' ))
    faults.append( FaultInput(30, 17, 10, 'HVPS', 'UND1', '121'  , 'HIGH'))
    faults.append( FaultInput(30, 17, 11, 'HVPS', 'UND1', '921'  , 'LOW' ))
    faults.append( FaultInput(30, 17, 12, 'HVPS', 'UND1', '921'  , 'HIGH'))
    faults.append( FaultInput(30, 17, 13, 'HVPS', 'UND1', 'BLF1' , 'LOW' ))
    faults.append( FaultInput(30, 17, 14, 'HVPS', 'UND1', 'BLF1' , 'HIGH'))
    faults.append( FaultInput(30, 17, 15, 'HVPS', 'UND1', 'BLF17', 'LOW' ))
    faults.append( FaultInput(30, 17, 16, 'HVPS', 'UND1', 'BLF17', 'HIGH'))
    
    faults.append( FaultInput(32, 17,  1, 'HVPS', 'LTU1', '762' , 'LOW'  ) )
    faults.append( FaultInput(32, 17,  3, 'HVPS', 'LTU1', '772' , 'LOW'  ) )
    faults.append( FaultInput(32, 17,  5, 'HVPS', 'LTU1', '980' , 'LOW'  ) )
    faults.append( FaultInput(32, 17,  7, 'HVPS', 'UND1', '120' , 'LOW'  ) )
    faults.append( FaultInput(32, 17,  9, 'HVPS', 'UND1', '221' , 'LOW'  ) )
    faults.append( FaultInput(32, 17, 11, 'HVPS', 'UND1', '321' , 'LOW'  ) )
    faults.append( FaultInput(32, 17, 13, 'HVPS', 'UND1', '421' , 'LOW'  ) )
    faults.append( FaultInput(32, 17, 15, 'HVPS', 'UND1', '521' , 'LOW'  ) )
    faults.append( FaultInput(32, 17,  2, 'HVPS', 'LTU1', '762' , 'HIGH' ) )
    faults.append( FaultInput(32, 17,  4, 'HVPS', 'LTU1', '772' , 'HIGH' ) )
    faults.append( FaultInput(32, 17,  6, 'HVPS', 'LTU1', '980' , 'HIGH' ) )
    faults.append( FaultInput(32, 17,  8, 'HVPS', 'UND1', '120' , 'HIGH' ) )
    faults.append( FaultInput(32, 17, 10, 'HVPS', 'UND1', '221' , 'HIGH' ) )
    faults.append( FaultInput(32, 17, 12, 'HVPS', 'UND1', '321' , 'HIGH' ) )
    faults.append( FaultInput(32, 17, 14, 'HVPS', 'UND1', '421' , 'HIGH' ) )
    faults.append( FaultInput(32, 17, 16, 'HVPS', 'UND1', '521' , 'HIGH' ) )
    
    faults.append( FaultInput(33, 17,  1, 'HVPS', 'UND1', '621' , 'LOW'  ) )
    faults.append( FaultInput(33, 17,  3, 'HVPS', 'UND1', '721' , 'LOW'  ) )
    faults.append( FaultInput(33, 17,  5, 'HVPS', 'UND1', '821' , 'LOW'  ) )
    faults.append( FaultInput(33, 17,  7, 'HVPS', 'UND1', '920' , 'LOW'  ) )
    faults.append( FaultInput(33, 17,  9, 'HVPS', 'UND1', '1021', 'LOW'  ) )
    faults.append( FaultInput(33, 17, 11, 'HVPS', 'UND1', '1121', 'LOW'  ) )
    faults.append( FaultInput(33, 17, 13, 'HVPS', 'UND1', '1221', 'LOW'  ) )
    faults.append( FaultInput(33, 17, 15, 'HVPS', 'UND1', '1321', 'LOW'  ) )
    faults.append( FaultInput(33, 17,  2, 'HVPS', 'UND1', '621' , 'HIGH' ) )
    faults.append( FaultInput(33, 17,  4, 'HVPS', 'UND1', '721' , 'HIGH' ) )
    faults.append( FaultInput(33, 17,  6, 'HVPS', 'UND1', '821' , 'HIGH' ) )
    faults.append( FaultInput(33, 17,  8, 'HVPS', 'UND1', '920' , 'HIGH' ) )
    faults.append( FaultInput(33, 17, 10, 'HVPS', 'UND1', '1021', 'HIGH' ) )
    faults.append( FaultInput(33, 17, 12, 'HVPS', 'UND1', '1121', 'HIGH' ) )
    faults.append( FaultInput(33, 17, 14, 'HVPS', 'UND1', '1221', 'HIGH' ) )
    faults.append( FaultInput(33, 17, 16, 'HVPS', 'UND1', '1321', 'HIGH' ) )
    
    faults.append( FaultInput(35, 17,  1, 'HVPS', 'UND1', '1421', 'LOW'  ) )
    faults.append( FaultInput(35, 17,  3, 'HVPS', 'UND1', '1521', 'LOW'  ) )
    faults.append( FaultInput(35, 17,  5, 'HVPS', 'UND1', '1621', 'LOW'  ) )
    faults.append( FaultInput(35, 17,  7, 'HVPS', 'UND1', '1720', 'LOW'  ) )
    faults.append( FaultInput(35, 17,  9, 'HVPS', 'UND1', '1821', 'LOW'  ) )
    faults.append( FaultInput(35, 17, 11, 'HVPS', 'UND1', '1921', 'LOW'  ) )
    faults.append( FaultInput(35, 17, 13, 'HVPS', 'UND1', '2021', 'LOW'  ) )
    faults.append( FaultInput(35, 17, 15, 'HVPS', 'UND1', '2121', 'LOW'  ) )
    faults.append( FaultInput(35, 17,  2, 'HVPS', 'UND1', '1421', 'HIGH' ) )
    faults.append( FaultInput(35, 17,  4, 'HVPS', 'UND1', '1521', 'HIGH' ) )
    faults.append( FaultInput(35, 17,  6, 'HVPS', 'UND1', '1621', 'HIGH' ) )
    faults.append( FaultInput(35, 17,  8, 'HVPS', 'UND1', '1720', 'HIGH' ) )
    faults.append( FaultInput(35, 17, 10, 'HVPS', 'UND1', '1821', 'HIGH' ) )
    faults.append( FaultInput(35, 17, 12, 'HVPS', 'UND1', '1921', 'HIGH' ) )
    faults.append( FaultInput(35, 17, 14, 'HVPS', 'UND1', '2021', 'HIGH' ) )
    faults.append( FaultInput(35, 17, 16, 'HVPS', 'UND1', '2121', 'HIGH' ) )
    
    faults.append( FaultInput(37, 17,  1, 'HVPS', 'UND1', '3021', 'LOW'  ) )
    faults.append( FaultInput(37, 17,  3, 'HVPS', 'UND1', '3121', 'LOW'  ) )
    faults.append( FaultInput(37, 17,  5, 'HVPS', 'UND1', '3221', 'LOW'  ) )
    faults.append( FaultInput(37, 17,  7, 'HVPS', 'UND1', '3320', 'LOW'  ) )
    faults.append( FaultInput(37, 17,  9, 'HVPS', 'UND1', '1721', 'LOW'  ) )
    faults.append( FaultInput(37, 17, 11, 'HVPS', 'UND1', '2521', 'LOW'  ) )
    faults.append( FaultInput(37, 17, 13, 'HVPS', 'UND1', '3321', 'LOW'  ) )
    faults.append( FaultInput(37, 17, 15, 'HVPS', 'UND1', 'SP3' , 'LOW'  ) )
    faults.append( FaultInput(37, 17,  2, 'HVPS', 'UND1', '3021', 'HIGH' ) )
    faults.append( FaultInput(37, 17,  4, 'HVPS', 'UND1', '3121', 'HIGH' ) )
    faults.append( FaultInput(37, 17,  6, 'HVPS', 'UND1', '3221', 'HIGH' ) )
    faults.append( FaultInput(37, 17,  8, 'HVPS', 'UND1', '3320', 'HIGH' ) )
    faults.append( FaultInput(37, 17, 10, 'HVPS', 'UND1', '1721', 'HIGH' ) )
    faults.append( FaultInput(37, 17, 12, 'HVPS', 'UND1', '2521', 'HIGH' ) )
    faults.append( FaultInput(37, 17, 14, 'HVPS', 'UND1', '3321', 'HIGH' ) )
    faults.append( FaultInput(37, 17, 16, 'HVPS', 'UND1', 'SP3' , 'HIGH' ) )
    
    mpsconfig.insert_fault_inputs(cursor, faults, True)
    
    connection.commit()
    connection.close()

    
if __name__ == '__main__':
    main()
