From 39f8909f26b1e58329796077f09bcdac0dc39cdf Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Tue, 11 Sep 2007 17:57:06 +0000 Subject: Checkpoint svn path=/scripts/rpki/left_right.py; revision=941 --- scripts/rpki/left_right.py | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'scripts/rpki/left_right.py') diff --git a/scripts/rpki/left_right.py b/scripts/rpki/left_right.py index 226d0ae4..0e3dcb78 100644 --- a/scripts/rpki/left_right.py +++ b/scripts/rpki/left_right.py @@ -57,7 +57,20 @@ class extension_preference_elt(base_elt, rpki.sql.sql_persistant): element_name = "extension_preference" attributes = ("name",) - sql_attributes = ("name", "value") + sql_select_cmd = """SELECT pref_name, pref_value FROM self_pref WHERE self_id = %(self_id)s""" + sql_insert_cmd = """INSERT self_pref (self_id, pref_name, pref_value) VALUES (%(self_id)s, %(name)s, %(value)""" + sql_update_cmd = """UPDATE self_pref SET pref_value = %(value)s WHERE self_id = %(self_id) AND pref_name = %(name)s""" + sql_delete_cmd = """DELETE FROM self_pref WHERE self_id = %(self_id) AND pref_name = %(name)s""" + + def sql_decode(self, sql_parent, self_id, name, value): + self.self_obj = sql_parent + self.name = name + self.value = value + + def sql_encode(self): + return { "self_id" : self.self_obj.self_id, + "name" : self.name, + "value" : self.value } def startElement(self, stack, name, attrs): """Handle elements.""" -- cgit v1.2.3