#!/usr/bin/env python
#---------------------------------------------------------------------
# Imports
#---------------------------------------------------------------------

import sys
import csv
import os
import sqlite3
from optparse import OptionParser, OptionGroup, SUPPRESS_HELP

from csv2mpsdb import *


class BlmChannel(object):
    def __init__(self, num, pvattr):
        self.num = num
        self.pvattr = pvattr

class Blm(object):
    def __init__(self, lnid, card, pvarea, pvpos):
        self.lnid = lnid
        self.card = card
        self.pvarea = pvarea
        self.pvpos = pvpos

def addBlmData(cursor, verbose):
    
    channels = list()
    channels.append( BlmChannel( 1, 'LOSS_L'   ))
    channels.append( BlmChannel( 2, 'LOSS_H'   ))
    channels.append( BlmChannel( 3, 'LOSS_1_L' ))
    channels.append( BlmChannel( 4, 'LOSS_1_H' ))
    channels.append( BlmChannel( 5, 'LOSS_10_L'))
    channels.append( BlmChannel( 6, 'LOSS_10_H'))
    channels.append( BlmChannel( 7, 'LOSS_30_L'))
    channels.append( BlmChannel( 8, 'LOSS_30_H'))
    channels.append( BlmChannel( 9, 'LOSS_60_L'))
    channels.append( BlmChannel(10, 'LOSS_60_H'))
    channels.append( BlmChannel(11, 'TEST_L'   ))
    channels.append( BlmChannel(12, 'TEST_H'   ))
    channels.append( BlmChannel(13, 'TEST_1_L' ))
    channels.append( BlmChannel(14, 'TEST_1_H' ))
    channels.append( BlmChannel(15, 'PED_L'    ))
    channels.append( BlmChannel(16, 'PED_H'    ))
    
    
    blms = list()
    
    blms.append( Blm(30,  9, 'LTU1', '722'  ) )
    blms.append( Blm(30, 10, 'LTU1', '722'  ) )
    blms.append( Blm(30, 13, 'UND1', '121'  ) )
    blms.append( Blm(30, 14, 'UND1', '921'  ) )
    blms.append( Blm(30, 15, 'UND1', 'BLF1' ) )
    blms.append( Blm(30, 16, 'UND1', 'BLF17') )
    
    blms.append( Blm(32,  9, 'LTU1', '762'  ) )
    blms.append( Blm(32, 10, 'LTU1', '772'  ) )
    blms.append( Blm(32, 11, 'LTU1', '980'  ) )
    blms.append( Blm(32, 12, 'UND1', '120'  ) )
    blms.append( Blm(32, 13, 'UND1', '221'  ) )
    blms.append( Blm(32, 14, 'UND1', '321'  ) )
    blms.append( Blm(32, 15, 'UND1', '421'  ) )
    blms.append( Blm(32, 16, 'UND1', '521'  ) )
    
    blms.append( Blm(33,  9, 'UND1', '621'  ) )
    blms.append( Blm(33, 10, 'UND1', '721'  ) )
    blms.append( Blm(33, 11, 'UND1', '821'  ) )
    blms.append( Blm(33, 12, 'UND1', '920'  ) )
    blms.append( Blm(33, 13, 'UND1', '1021'  ) )
    blms.append( Blm(33, 14, 'UND1', '1121'  ) )
    blms.append( Blm(33, 15, 'UND1', '1221'  ) )
    blms.append( Blm(33, 16, 'UND1', '1321'  ) )
    
    blms.append( Blm(35,  9, 'UND1', '1421'  ) )
    blms.append( Blm(35, 10, 'UND1', '1521'  ) )
    blms.append( Blm(35, 11, 'UND1', '1621'  ) )
    blms.append( Blm(35, 12, 'UND1', '1720'  ) )
    blms.append( Blm(35, 13, 'UND1', '1821'  ) )
    blms.append( Blm(35, 14, 'UND1', '1921'  ) )
    blms.append( Blm(35, 15, 'UND1', '2021'  ) )
    blms.append( Blm(35, 16, 'UND1', '2121'  ) )
    
    blms.append( Blm(37,  9, 'UND1', '3021'  ) )
    blms.append( Blm(37, 10, 'UND1', '3121'  ) )
    blms.append( Blm(37, 11, 'UND1', '3221'  ) )
    blms.append( Blm(37, 12, 'UND1', '3320'  ) )
    blms.append( Blm(37, 13, 'UND1', '1721'  ) )
    blms.append( Blm(37, 14, 'UND1', '2521'  ) )
    blms.append( Blm(37, 15, 'UND1', '3321'  ) )
    

    for blm in blms:        
        lnid       = int(blm.lnid)
        card       = int(blm.card)
        pvdevtype  = cleanString('BLM')
        pvarea     = cleanString(blm.pvarea)
        pvpos      = cleanString(blm.pvpos)
        devarea    = blm.pvarea
        faultname  = cleanString('THRESHOLD')
        okstate    = cleanString('IS_OK')
        faultstate = cleanString('IS_EXCEEDED')

        for ch in channels:
            channel    = ch.num
            devname    = 'BLM_%s_%s_%s' % (blm.pvarea, blm.pvpos, ch.pvattr)
            pvattr     = cleanString(ch.pvattr)

            addChannel      (cursor, lnid, card, channel, verbose)
            addDeviceDetails(cursor, lnid, card, channel, verbose)
            addDevices      (cursor, lnid, card, channel,
                             devname, devarea,
                             pvdevtype, pvarea, pvpos, verbose)
            addFaults       (cursor, devname, faultname, pvattr, okstate, faultstate)
            addDeviceDetailLinks(cursor, verbose)
        
            if verbose:
                print 'Added Channel %2d %2d %2d -- %s %s' % (lnid, card, channel, devname, faultname)
                None
    





def handleOptions():
    # Create parse options
    usage   = 'Usage: %prog database'
    version = '%prog 0.1'
    parser = OptionParser(usage=usage, version=version)

    parser.add_option('-v', '--verbose',           action='store_true',  dest='verbose',            help='print verbose output')
    
    # Defaults
    parser.set_defaults(verbose     = False,
                        mpsfilename = None)

    # Parse arguments
    (options, args) = parser.parse_args()

    if len(args) != 1:
        parser.error('incorrect number of arguments')

    options.mpsfilename = args[0]
        
    return options


def main():

    options = handleOptions()
    
    # Connect to database
    connection             = sqlite3.connect(options.mpsfilename)
    connection.row_factory = sqlite3.Row
    cursor                 = connection.cursor()
    
    addBlmData(cursor, options.verbose)

    connection.commit()
    connection.close()


if __name__ == '__main__':
    main()

