#!/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 -> 722
#  29     T1       3       B912      PICS:LTU1:732 
#  31     T1       1       B913      PICS:LTU1:762 
#  31     T1       2       B913      PICS:LTU1:722 -> 772
#  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(11,  (1 - 1) * 8 + 1,  'IN20',  'BL665' ) )
#    pics.append( Pic(11,  (1 - 1) * 8 + 2,  'IN20',  'BL775' ) )
#    pics.append( Pic(11,  (1 - 1) * 8 + 3,  'IN20',  'IS933' ) )
#    pics.append( Pic(11,  (1 - 1) * 8 + 4,  'IN20',  'BL185' ) )
#    pics.append( Pic(11,  (1 - 1) * 8 + 5,  'IN20',  'BL232' ) )
#    pics.append( Pic(11,  (1 - 1) * 8 + 6,  'IN20',  'BL245' ) )
#    pics.append( Pic(16,  (1 - 1) * 8 + 1,  'LI24',  '791'   ) )
#    pics.append( Pic(16,  (1 - 1) * 8 + 2,  'LI24',  '811'   ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 3,  'LI29',  '96'    ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 4,  'LI29',  '146'   ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 5,  'LI29',  '446'   ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 6,  'LI29',  '546'   ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 7,  'LI29',  '801'   ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 8,  'LI30',  '96'    ) )
#    pics.append( Pic(22,  (1 - 1) * 8 + 1,  'LI30',  '146'   ) )
#    pics.append( Pic(22,  (2 - 1) * 8 + 2,  'LI30',  '446'   ) )
#    pics.append( Pic(22,  (2 - 1) * 8 + 3,  'LI30',  '546'   ) )
#    pics.append( Pic(22,  (2 - 1) * 8 + 4,  'LI30',  '801'   ) )
#    pics.append( Pic(23,  (1 - 1) * 8 + 1,  'CA11',  '54'    ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 1,  'MC00',  '20'    ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 2,  'MC00',  '30'    ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 3,  'MC00',  '45'    ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 4,  'MC00',  '119'   ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 5,  'MC00',  '145'   ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 6,  'MC00',  '155'   ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 7,  'MC00',  '165'   ) )
#    pics.append( Pic(25,  (1 - 1) * 8 + 8,  'MC00',  '175'   ) )
#    pics.append( Pic(25,  (2 - 1) * 8 + 1,  'MC00',  '185'   ) )
#    pics.append( Pic(25,  (2 - 1) * 8 + 2,  'MC00',  '195'   ) )
#    pics.append( Pic(25,  (2 - 1) * 8 + 3,  'MC00',  '205'   ) )
#    pics.append( Pic(25,  (2 - 1) * 8 + 4,  'MC00',  '320'   ) )
#    pics.append( Pic(25,  (2 - 1) * 8 + 5,  'MC00',  '321'   ) )
#    pics.append( Pic(28,  (1 - 1) * 8 + 1,  'LTU1',  '220'   ) )
#    pics.append( Pic(28,  (1 - 1) * 8 + 2,  'LTU1',  '252'   ) )
#    pics.append( Pic(28,  (1 - 1) * 8 + 3,  'LTU1',  '280'   ) )
#    pics.append( Pic(28,  (1 - 1) * 8 + 4,  'LTU1',  '420'   ) )
#    pics.append( Pic(28,  (1 - 1) * 8 + 5,  'LTU1',  '450'   ) )
#    pics.append( Pic(29,  (1 - 1) * 8 + 1,  'LTU1',  '480'   ) )
#    pics.append( Pic(29,  (1 - 1) * 8 + 2,  'LTU1',  '772'   ) )
#    pics.append( Pic(29,  (1 - 1) * 8 + 3,  'LTU1',  '732'   ) )
    pics.append( Pic(31,  (1 - 1) * 8 + 1,  'LTU1',  '762'   ) )
    pics.append( Pic(31,  (1 - 1) * 8 + 2,  'LTU1',  '722'   ) )

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