#!/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 make_fault_input(line):
    keys = ('card', 'channel', 'fullpv', 'faultname', 'faultedname', 'okname')
    values = line.split()
    d = dict(zip(keys, values))
    (pvtype, pvarea, pvpos, pvattr) = d['fullpv'].split(':')
    f = mpsconfig.FaultInput(
        23,
        d['card'],
        d['channel'],
        pvtype,
        pvarea,
        pvpos,
        pvattr,
        faultname=d['faultname'],
        faultedname=d['faultedname'],
        okname=d['okname']
    )
    return f
    
def main():
    arg_keys = ('prog', 'db', 'input')
    args = dict(zip(arg_keys, sys.argv))
    
    with open(args['input']) as f:
        faults = [make_fault_input(line) for line in f]
        
    connection             = sqlite3.connect(args['db'])
    connection.row_factory = sqlite3.Row
    cursor                 = connection.cursor()
    
    mpsconfig.insert_fault_inputs(cursor, faults, True)
    
    connection.commit()
    connection.close()
    
if __name__ == '__main__':
    main()
