From 4c809198da0144b2a5901df1f93ba9995e3bc183 Mon Sep 17 00:00:00 2001 From: Tony Mack Date: Wed, 8 Jul 2009 19:01:11 +0000 Subject: [PATCH] added date_created, last_updated fields. Renamed 'name' field to 'hrn' --- sfa/util/genitable.py | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) diff --git a/sfa/util/genitable.py b/sfa/util/genitable.py index 15b244ea..8155be48 100644 --- a/sfa/util/genitable.py +++ b/sfa/util/genitable.py @@ -45,13 +45,15 @@ class GeniTable: querystr = "CREATE TABLE " + self.tablename + " ( \ key text, \ - name text, \ + hrn text, \ gid text, \ type text, \ - pointer integer);" + pointer integer, \ + date_created timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, \ + last_updated timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP);" template = "CREATE INDEX %s_%s_idx ON %s (%s);" indexes = [template % ( self.tablename, field, self.tablename, field) \ - for field in ['name', 'type' ]] + for field in ['key', 'hrn', 'type','pointer']] # IF EXISTS doenst exist in postgres < 8.2 try: self.cnx.query('DROP TABLE IF EXISTS ' + self.tablename) @@ -96,7 +98,6 @@ class GeniTable: result_dict_list = [] for dict in dict_list: if (type=="*") or (dict['type'] == type): - dict['hrn'] = dict['name'] result_dict_list.append(dict) return result_dict_list @@ -117,10 +118,10 @@ class GeniTable: return result_rec_list def resolve_dict(self, type, hrn): - return self.find_dict(type, hrn, "name") + return self.find_dict(type, hrn, "hrn") def resolve(self, type, hrn): - return self.find(type, hrn, "name") + return self.find(type, hrn, "hrn") def list_dict(self): query_str = "SELECT * FROM " + self.tablename -- 2.43.0