diff options
author | Rob Austein <sra@hactrn.net> | 2007-08-26 02:33:51 +0000 |
---|---|---|
committer | Rob Austein <sra@hactrn.net> | 2007-08-26 02:33:51 +0000 |
commit | 51541486f1a4840c5bcc2d9011cb4aeeb967e7aa (patch) | |
tree | 9a7cd8490a8aeb3fddc8fefa804430cbefb11cb1 /scripts/irdb.py | |
parent | c95c8dba0cbe8af3826005d2a16268ab3a80154a (diff) |
Checkpoint
svn path=/scripts/irdb.py; revision=914
Diffstat (limited to 'scripts/irdb.py')
-rwxr-xr-x | scripts/irdb.py | 33 |
1 files changed, 24 insertions, 9 deletions
diff --git a/scripts/irdb.py b/scripts/irdb.py index 74ca85d2..b03013cf 100755 --- a/scripts/irdb.py +++ b/scripts/irdb.py @@ -1,6 +1,6 @@ # $Id$ -import rpki.https, tlslite.api, rpki.config, MySQLdb +import rpki.https, tlslite.api, rpki.config, rpki.resource_set, MySQLdb def handler(query, path): try: @@ -39,17 +39,32 @@ def handler(query, path): # XML so maybe just punt it for now. for resource_class_id, subject_name in resource_classes: - cur.execute("""SELECT start_as, end_as - FROM asn + resource_class = rpki.left_right.resource_class_elt() + if subject_name: + resource_class.subject_name = subject_name + + cur.execute("""SELECT start_as, end_as FROM asn WHERE resource_class_id = '%s' """ % resource_class_id) - as_ranges = cur.fetchall() - cur.execute("""SELECT start_ip, end_ip, version - FROM net - WHERE resource_class_id = '%s' + resource_class.as = rpki.resource_set.resource_set_as() + for b,e = cur.fetchall(): + resource_class.as.append(rpki.resource_set.resource_range_as(b, e)) + + cur.execute("""SELECT start_ip, end_ip FROM net + WHERE resource_class_id = '%s' AND version = 4 """ % resource_class_id) - ip_ranges = cur.fetchall() - + resource_class.ipv4 = rpki.resource_set.resource_set_ipv4() + for b,e = cur.fetchall(): + resource_class.ipv4.append(rpki.resource_set.resource_range_ipv4(b, e)) + + cur.execute("""SELECT start_ip, end_ip FROM net + WHERE resource_class_id = '%s' AND version = 6 + """ % resource_class_id) + resource_class.ipv6 = rpki.resource_set.resource_set_ipv6() + for b,e = cur.fetchall(): + resource_class.ipv6.append(rpki.resource_set.resource_range_ipv6(b, e)) + + r_pdu.resources.append(resource_class) assert False, "Not finished" |