diff options
| author | Rob Austein <sra@hactrn.net> | 2007-09-25 19:21:24 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-09-25 19:21:24 +0000 |
| commit | 6e1578d6bba4920f23bf97839bdfe3a3f7e1e3a2 (patch) | |
| tree | 133998bc807aca9a2927801bfa76aba17d235452 /scripts/rpki/sql.py | |
| parent | 18067187c3a020803a2a4cec2a37349914758140 (diff) | |
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
Diffstat (limited to 'scripts/rpki/sql.py')
| -rw-r--r-- | scripts/rpki/sql.py | 11 |
1 files changed, 0 insertions, 11 deletions
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) |