#!/usr/bin/env python

import sqlite3
import sys
import os
import argparse


names = (
    ('Fast Valve VVFS LI22 Position',               'VVFS LI21-9 Position (Station 22-1)'),
    ('Fast Valve VVFS LI23 Position',               'VVFS LI22-9 Position (Station 23-1)'),
    ('Fast Valve VVFS LI24 Position',               'VVFS LI23-9 Position (Station 24-1)'),
    ('Fast Valve VVFS LI25 Position',               'VVFS LI24-9 Position (Station 25-1)'),
    ('Fast Valve VVFS LI26 Position',               'VVFS LI25-9 Position (Station 26-1)'),
    ('Fast Valve VVFS LI27 Position',               'VVFS LI26-9 Position (Station 27-1)'),
    ('Fast Valve VVFS LI28 Position',               'VVFS LI27-9 Position (Station 28-1)'),
    ('Fast Valve VVFS LI29 Position',               'VVFS LI28-9 Position (Station 29-1)'),
    ('Fast Valve VVFS LI30 Position',               'VVFS LI29-9 Position (Station 30-1)'),
    ('IV2 Position',                                'VVPG BSY0 IV2 Position'),
    ('IV3 Position',                                'VVPG BSY0 IV3 Position'),
    ('IV4 Position',                                'VVPG BSY0 IV4 Position'),
    ('PR12 Position',                               'BSY PR1 and PR2 Summary'),
    ('TIU: Beam Scraper Water: LI22',               'Scraper Water LI21-9 (Station 22-1)'),
    ('TIU: Beam Scraper Water: LI23',               'Scraper Water LI22-9 (Station 23-1)'),
    ('TIU: Beam Scraper Water: LI24',               'Scraper Water LI23-9 (Station 24-1)'),
    ('TIU: Beam Scraper Water: LI25',               'Scraper Water LI24-9 (Station 25-1)'),
    ('TIU: Beam Scraper Water: LI26',               'Scraper Water LI25-9 (Station 26-1)'),
    ('TIU: Beam Scraper Water: LI27',               'Scraper Water LI26-9 (Station 27-1)'),
    ('TIU: Beam Scraper Water: LI28',               'Scraper Water LI27-9 (Station 28-1)'),
    ('TIU: Beam Scraper Water: LI29',               'Scraper Water LI28-9 (Station 29-1)'),
    ('TIU: Beam Scraper Water: LI30',               'Scraper Water LI29-9 (Station 30-1)'),
    ('TIU: Flow Switch LI28-9',                     'COLL Flow Switch LI28-9'),
    ('TIU: Flow Switch LI29-1',                     'COLL Flow Switch LI29-1'),
    ('TIU: Flow Switch LI29-4',                     'COLL Flow Switch LI29-4'),
    ('TIU: Flow Switch LI29-5',                     'COLL Flow Switch LI29-5'),
    ('TIU: Flow Switch LI29-9',                     'COLL Flow Switch LI29-9'),
    ('TIU: Flow Switch LI30-1',                     'COLL Flow Switch LI30-1'),
    ('TIU: Flow Switch LI30-4',                     'COLL Flow Switch LI30-4'),
    ('TIU: Flow Switch LI30-5',                     'COLL Flow Switch LI30-5'),
    ('VVPG LI21 Position',                          'VVPG LI20-9 Position (Station 21-1)'),
    ('VVPG LI22 Position',                          'VVPG LI21-9 Position (Station 22-1)'),
    ('VVPG LI23 Position',                          'VVPG LI22-9 Position (Station 23-1)'),
    ('VVPG LI24 Position',                          'VVPG LI23-9 Position (Station 24-1)'),
    ('VVPG LI26 Position',                          'VVPG LI25-9 Position (Station 26-1)'),
    ('VVPG LI27 Position',                          'VVPG LI26-9 Position (Station 27-1)'),
    ('VVPG LI28 Position',                          'VVPG LI27-9 Position (Station 28-1)'),
    ('VVPG LI29 Position',                          'VVPG LI28-9 Position (Station 29-1)'),
    ('VVPG LI30 43 Slow VLV_9 Position',            'VVPG LI30-9 Position (Station 30-9)'),
    ('VVPG LI30 Position',                          'VVPG LI29-9 Position (Station 30-1)'),
    ('TIU: Slow Valve Position: LI21 Station 1',    'TIU: VVPG LI20-9 Position (Station 21-1)'),
    ('TIU: Slow Valve Position: LI22 Station 1',    'TIU: VVPG LI21-9 Position (Station 22-1)'),
    ('TIU: Slow Valve Position: LI23 Station 1',    'TIU: VVPG LI22-9 Position (Station 23-1)'),
    ('TIU: Slow Valve Position: LI24 Station 1',    'TIU: VVPG LI23-9 Position (Station 24-1)'),
    ('TIU: Slow Valve Position: LI26 Station 1',    'TIU: VVPG LI25-9 Position (Station 26-1)'),
    ('TIU: Slow Valve Position: LI27 Station 1',    'TIU: VVPG LI26-9 Position (Station 27-1)'),
    ('TIU: Slow Valve Position: LI28 Station 1',    'TIU: VVPG LI27-9 Position (Station 28-1)'),
    ('TIU: Slow Valve Position: LI29 Station 1',    'TIU: VVPG LI28-9 Position (Station 29-1)'),
    ('TIU: Slow Valve Position: LI30 Station 9',    'TIU: VVPG LI30-9 Position (Station 30-9)'),
    ('TIU: Slow Valve Position: LI30 Station 1',    'TIU: VVPG LI29-9 Position (Station 30-1)'),
    ('TIU: Fast Valve Position: LI22',              'TIU:VVFS LI21-9 Position (Station 22-1)'),
    ('TIU: Fast Valve Position: LI23',              'TIU:VVFS LI22-9 Position (Station 23-1)'),
    ('TIU: Fast Valve Position: LI24',              'TIU:VVFS LI23-9 Position (Station 24-1)'),
    ('TIU: Fast Valve Position: LI25',              'TIU:VVFS LI24-9 Position (Station 25-1)'),
    ('TIU: Fast Valve Position: LI26',              'TIU:VVFS LI25-9 Position (Station 26-1)'),
    ('TIU: Fast Valve Position: LI27',              'TIU:VVFS LI26-9 Position (Station 27-1)'),
    ('TIU: Fast Valve Position: LI28',              'TIU:VVFS LI27-9 Position (Station 28-1)'),
    ('TIU: Fast Valve Position: LI29',              'TIU:VVFS LI28-9 Position (Station 29-1)'),
    ('TIU: Fast Valve Position: LI30',              'TIU:VVFS LI29-9 Position (Station 30-1)'),
)


def truth_table_exists(cursor, truth_table_name):
    query = 'select * from ZMACRO where ZNAME == (?)'
    cursor.execute(query, (truth_table_name,))    
    matching_tables = cursor.fetchall()
    return (len(matching_tables) == 1)


def update_truth_table_name(cursor, old, new):
    query = 'update ZMACRO set ZNAME = (?) where ZNAME = (?)'
    cursor.execute(query, (new, old))    
    print 'Renamed "{0}" to "{1}"'.format(old, new)


def process_args(argv=None):
    if argv is None:
        argv = sys.argv[1:]
    
    parser = argparse.ArgumentParser()
    
    parser.add_argument(
        'mpl_file',
        help='MPL file to update'
    )

    try:
        args = parser.parse_args(argv)
    except IOError as e:
        sys.stderr.write('{0}\n'.format(e))
        sys.exit(e.errno)
    
    return args


def main(argv=None):
    
    args = process_args(argv)
    
    connection = sqlite3.connect(args.mpl_file)

    connection.row_factory = sqlite3.Row
    cursor = connection.cursor()

    try:
        couldnt_find = [n[0] for n in names if not truth_table_exists(cursor, n[0])]
        if couldnt_find:
            print "Couldn't find the following old names in", args.mpl_file
            for name in couldnt_find:
                print ' ' * 3, name
            raise(Exception())
        
        for old, new in names:
            update_truth_table_name(cursor, old, new)
        
    except:
        sys.stderr.write('Rolling back all updates\n')
        connection.rollback()
        connection.close()

        return 1
    
    print 'Committing changes'
    connection.commit()
    connection.close()

    return 0

if __name__ == '__main__':
    status = main()
    sys.exit(status)




