import argparse
import csv
import urlparse

from Common.Api import member_ids

def main(file_name):
    with open(file_name, 'rU') as infile:
        reader = csv.DictReader(infile)
        with open('result.csv', 'w') as outfile:
            writer = csv.writer(outfile)
            for row in reader:
                click_id = urlparse.parse_qs(
                    urlparse.urlparse(row['Original URL']).query)['clickid'][0]
                split_decoded_id = member_ids._decode(click_id).split('~')
​
                row['mid'] = split_decoded_id[0]
                row['campaign_id'] = split_decoded_id[1]
                del row['Original URL']
                writer.writerow(row.values())

if __name__ == '__main__':
    parser = argparse.ArgumentParser()
    parser.add_argument(
        "file_name",
        help="path to CSV file")

    args = parser.parse_args()
    main(args.file_name)