make_blocked_routes.py

#!/usr/bin/env python3
import ipaddress

DUMP_PATH = 'dump.csv'
BLOCKED_ROUTES_PATH = 'C:\\Program Files\\OpenVPN\\config\\blocked_routes.ovpn.conf'

ips = set()

# dump.csv format:
# ip[ | ip]; domain; url; org; id; date
with open(DUMP_PATH) as f:
    f.readline()
    while True:
        line = f.readline()
        if line == '':
            break
        l = line.split(';')[0]
        l2 = l.split(' | ')
        for i in l2:
            if len(i) > 0:
                ips.add(i)

print('Total entries:', len(ips))

nets = list()
minPrefixlen = 29
for i in ips:
    net = ipaddress.IPv4Network(i)
    if net.prefixlen <= minPrefixlen:
        nets.append(net)

nets = sorted(nets)

print('Nets with prefix <=', minPrefixlen, ':', len(nets))

with open(BLOCKED_ROUTES_PATH, 'w') as f:
    for net in nets:
        f.write('route {} {} vpn_gateway\n'.format(net.network_address, net.netmask))