#!/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():
    
    connection             = sqlite3.connect(sys.argv[1])
    connection.row_factory = sqlite3.Row
    cursor                 = connection.cursor()
    
    FaultInput = mpsconfig.FaultInput
    faults = list()
    
    faults.append( FaultInput(32, 1,  7, 'BFW', 'UND1',  '110', 'IN'         ))
    faults.append( FaultInput(32, 1,  8, 'BFW', 'UND1',  '210', 'IN'         ))
    faults.append( FaultInput(32, 1,  9, 'BFW', 'UND1',  '310', 'IN'         ))
    faults.append( FaultInput(32, 1, 10, 'BFW', 'UND1',  '410', 'IN'         ))
    faults.append( FaultInput(32, 1, 11, 'BFW', 'UND1',  '510', 'IN'         ))

    faults.append( FaultInput(33, 1,  9, 'BFW', 'UND1',  '610', 'IN'         ))
    faults.append( FaultInput(33, 1, 10, 'BFW', 'UND1',  '710', 'IN'         ))
    faults.append( FaultInput(33, 1, 11, 'BFW', 'UND1',  '810', 'IN'         ))
    faults.append( FaultInput(33, 1, 12, 'BFW', 'UND1',  '910', 'IN'         ))
    faults.append( FaultInput(33, 1, 13, 'BFW', 'UND1', '1010', 'IN'         ))
    faults.append( FaultInput(33, 1, 14, 'BFW', 'UND1', '1110', 'IN'         ))
    faults.append( FaultInput(33, 1, 15, 'BFW', 'UND1', '1210', 'IN'         ))
    faults.append( FaultInput(33, 1, 16, 'BFW', 'UND1', '1310', 'IN'         ))

    faults.append( FaultInput(35, 1,  9, 'BFW', 'UND1', '1410', 'IN'         ))
    faults.append( FaultInput(35, 1, 10, 'BFW', 'UND1', '1510', 'IN'         ))
    faults.append( FaultInput(35, 1, 11, 'BFW', 'UND1', '1610', 'IN'         ))
    faults.append( FaultInput(35, 1, 12, 'BFW', 'UND1', '1710', 'IN'         ))
    faults.append( FaultInput(35, 1, 13, 'BFW', 'UND1', '1810', 'IN'         ))
    faults.append( FaultInput(35, 1, 14, 'BFW', 'UND1', '1910', 'IN'         ))
    faults.append( FaultInput(35, 1, 15, 'BFW', 'UND1', '2010', 'IN'         ))
    faults.append( FaultInput(35, 1, 16, 'BFW', 'UND1', '2110', 'IN'         ))

    faults.append( FaultInput(36, 1,  9, 'BFW', 'UND1', '2210', 'IN'         ))
    faults.append( FaultInput(36, 1, 10, 'BFW', 'UND1', '2310', 'IN'         ))
    faults.append( FaultInput(36, 1, 11, 'BFW', 'UND1', '2410', 'IN'         ))
    faults.append( FaultInput(36, 1, 12, 'BFW', 'UND1', '2510', 'IN'         ))
    faults.append( FaultInput(36, 1, 13, 'BFW', 'UND1', '2610', 'IN'         ))
    faults.append( FaultInput(36, 1, 14, 'BFW', 'UND1', '2710', 'IN'         ))
    faults.append( FaultInput(36, 1, 15, 'BFW', 'UND1', '2810', 'IN'         ))
    faults.append( FaultInput(36, 1, 16, 'BFW', 'UND1', '2910', 'IN'         ))

    faults.append( FaultInput(37, 1,  5, 'BFW', 'UND1', '3010', 'IN'         ))
    faults.append( FaultInput(37, 1,  6, 'BFW', 'UND1', '3110', 'IN'         ))
    faults.append( FaultInput(37, 1,  7, 'BFW', 'UND1', '3210', 'IN'         ))
    faults.append( FaultInput(37, 1,  8, 'BFW', 'UND1', '3310', 'IN'         ))

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

    
if __name__ == '__main__':
    main()
