#!/usr/bin/env python

import pyperclip
import argparse
import io

parser = argparse.ArgumentParser()

parser.add_argument("--filename", "-f", help="Query filename")
parser.add_argument("--parameters", "-p", help="Query parameters")

args = parser.parse_args()

with io.open(args.filename, 'r') as file:
    query = file.read()

with io.open(args.parameters, 'r') as file:
    for line_number, line in enumerate(file):
        parameter_key = "{" + line.split(':')[0].strip() + "}"
        parameter_value = line.split(':')[1].strip()
        print(">>> Replacing: {}\t\t->\t{}".format(parameter_key, parameter_value))
        query = query.replace(parameter_key, parameter_value)

pyperclip.copy(query)
print("SUCCESS: Query replaced and copied to clipboard")