From 6e1578d6bba4920f23bf97839bdfe3a3f7e1e3a2 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Tue, 25 Sep 2007 19:21:24 +0000 Subject: Get rid of child_ca_link table, as I have no current use for it and maintaining it was a pain. Add state column to ca_detail table. Rename child_ca_certificate table to child_cert and make it a first class table with an independent primary key; former key semantics were wrong (didn't handle child key rollover) and harder to implement. svn path=/docs/Makefile; revision=1027 --- scripts/rpki/sql.py | 11 ----------- 1 file changed, 11 deletions(-) (limited to 'scripts/rpki/sql.py') diff --git a/scripts/rpki/sql.py b/scripts/rpki/sql.py index c67062f2..d74be7fb 100644 --- a/scripts/rpki/sql.py +++ b/scripts/rpki/sql.py @@ -196,14 +196,3 @@ class ca_obj(sql_persistant): """Internal CA object.""" sql_template = template("ca", "ca_id", "last_crl_sn", "next_crl_update", "last_issued_sn", "last_manifest_sn", "next_manifest_update", "sia_uri", "parent_id") - - def sql_fetch_hook(self, db, cur): - self.children = fetch_column(cur, "SELECT child_id FROM child_ca_link WHERE ca_id = %s", self.ca_id) - - def sql_insert_hook(self, db, cur): - if self.children: - cur.executemany("INSERT child_ca_link (ca_id, child_id) VALUES (%s, %s)", - ((self.ca_id, x.child_id) for x in self.children)) - - def sql_delete_hook(self, db, cur): - cur.execute("DELETE FROM child_ca_link where ca_id = %s", self.ca_id) -- cgit v1.2.3