csv_to_nsot.py

'''
Convert nsot csv to commands
'''
PATH = 'update.csv'

def create_net_cmd(resource):
    '''pynsot bulk csv (colon) -> cli commands'''
    cidr, attrs = resource.rsplit(':', 1)
    return 'nsot networks add -c %s -a \'%s\'' % (cidr, attrs)


def main():
    '''Entrypoint'''
    with open(PATH) as file_:
        resources = file_.read() \
                         .splitlines()[1:]  # First line is csv header

    commands = [create_net_cmd(i) for i in resources]
    print '\n'.join(commands)


if __name__ == '__main__':
    main()

update.csv

cidr:attributes
2001::/64:desc=test
2001:1::/64:desc=test2