#!/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


#  LN    Card    Chan    Location       PV Prefix
#  --    ----    ----    --------    --------------
#  11     T1       1       IN20      PICS:IN20:BL665    
#  11     T1       2       IN20      PICS:IN20:BL775    
#  11     T1       3       IN20      PICS:IN20:IS933    
#  11     T1       4       IN20      PICS:IN20:BL185    
#  11     T1       5       IN20      PICS:IN20:BL232    
#  11     T1       6       IN20      PICS:IN20:BL245    
#  16     T1       1       LI24      PICS:LI24:791  
#  16     T1       2       LI24      PICS:LI24:811  
#  22     T1       3       LI29      PICS:LI29:96  
#  22     T1       4       LI29      PICS:LI29:146 
#  22     T1       5       LI29      PICS:LI29:446 
#  22     T1       6       LI29      PICS:LI29:546 
#  22     T1       7       LI29      PICS:LI29:801 
#  22     T1       8       LI30      PICS:LI30:96  
#  22     T1       1       LI30      PICS:LI30:146 
#  22     T2       2       LI30      PICS:LI30:446 
#  22     T2       3       LI30      PICS:LI30:546 
#  22     T2       4       LI30      PICS:LI30:801 
#  23     T1       1       B136      PICS:CA11:54  
#  25     T1       1       BSY       PICS:MC00:20  
#  25     T1       2       BSY       PICS:MC00:30  
#  25     T1       3       BSY       PICS:MC00:45  
#  25     T1       4       BSY       PICS:MC00:119 
#  25     T1       5       BSY       PICS:MC00:145 
#  25     T1       6       BSY       PICS:MC00:155 
#  25     T1       7       BSY       PICS:MC00:165 
#  25     T1       8       BSY       PICS:MC00:175 
#  25     T2       1       BSY       PICS:MC00:185 
#  25     T2       2       BSY       PICS:MC00:195 
#  25     T2       3       BSY       PICS:MC00:205 
#  25     T2       4       BSY       PICS:MC00:320 
#  25     T2       5       BSY       PICS:MC00:321 
#  28     T1       1       B911      PICS:LTU1:220 
#  28     T1       2       B911      PICS:LTU1:252 
#  28     T1       3       B911      PICS:LTU1:280 
#  28     T1       4       B911      PICS:LTU1:420 
#  28     T1       5       B911          pic cedl3 
#  29     T1       1       B912      PICS:LTU1:480 
#  29     T1       2       B912      PICS:LTU1:772 
#  29     T1       3       B912      PICS:LTU1:732 
#  31     T1       1       B913      PICS:LTU1:762 
#  31     T1       2       B913      PICS:LTU1:722 
#  34     T1       1       B921      PICS:DMP1:???     
#  34     T1       2       B921      PICS:DMP2:??? 

pic_channels = [
    "LOSSL",
    "LOSSH",
    "LOSS1L", 
    "LOSS1H", 
    "LOSS10L", 
    "LOSS10H", 
    "LOSS30L", 
    "LOSS30H", 
    "LOSS60L", 
    "LOSS60H"
]

class Pic(object):
    def __init__(self, lnid, card, pvarea, pvpos, pvdevtype='PICS'):
        self.lnid = lnid
        self.card = card
        
        self.pvdevtype = pvdevtype
        self.pvarea = pvarea
        self.pvpos = pvpos
        self.fault_list = list()
        
    def fault_input_list(self):
        if not self.fault_list:
            chan_num = 1
            for chan_name in pic_channels:
                self.fault_list.append( mpsconfig.FaultInput(
                    self.lnid, 
                    self.card + 8,
                    chan_num,
                    self.pvdevtype,
                    self.pvarea,
                    self.pvpos,
                    chan_name,
                    faultname = 'THRESHOLD',
                    faultedname = 'EXCEEDED'))
                chan_num += 1
        
        return self.fault_list
    

def main():
    pics = list()
    pics.append( Pic(34, 1, 'DMP1', '100') )
    pics.append( Pic(34, 2, 'DMP2', '200') )
    
    faults = list()
    for pic in pics:
        faults += pic.fault_input_list()

    # Insert new faults
    connection = sqlite3.connect(sys.argv[1])
    connection.row_factory = sqlite3.Row
    cursor = connection.cursor()

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

    
if __name__ == '__main__':
    main()
