#!/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 = ('lnid', 'card', 'channel', 'fullpv')
    values = line.split()
    d = dict(zip(keys, values))
    (pvtype, pvarea, pvpos, pvattr) = d['fullpv'].split(':')
    f = mpsconfig.FaultInput(
        d['lnid'],
        d['card'],
        d['channel'],
        pvtype,
        pvarea,
        pvpos,
        pvattr,
        faultname="THRESHOLD",
        faultedname="IS_EXCEEDED",
        okname="IS_OK"
    )
    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]
        
    info = (
        '{0.lnid:>4}   '
        '{0.card:>4}   '
        '{0.channel:>4}   '
        '{0.pvdevtype:10}   '
        '{0.pvarea:10}   '
        '{0.pvpos:10}   '
        '{0.pvattr:10}'
    )
    for fault in faults:
        print info.format(fault)

    print
    print
    print
    
    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()
