merge master again (2.0-10 changelog only)
[sfa.git] / sfa / plc / pldriver.py
index 5ce3b71..2b86f6c 100644 (file)
@@ -6,12 +6,13 @@ from sfa.util.faults import MissingSfaInfo, UnknownSfaType, \
 
 from sfa.util.sfalogging import logger
 from sfa.util.defaultdict import defaultdict
-from sfa.util.sfatime import utcparse
+from sfa.util.sfatime import utcparse, datetime_to_string, datetime_to_epoch
 from sfa.util.xrn import hrn_to_urn, get_leaf, urn_to_sliver_id
 from sfa.util.cache import Cache
 
 # one would think the driver should not need to mess with the SFA db, but..
-from sfa.storage.table import SfaTable
+from sfa.storage.alchemy import dbsession
+from sfa.storage.model import RegRecord
 
 # used to be used in get_ticket
 #from sfa.trust.sfaticket import SfaTicket
@@ -41,19 +42,14 @@ def list_to_dict(recs, key):
 # can be sent as-is; it takes care of authentication
 # from the global config
 # 
-# so we inherit PlShell just so one can do driver.GetNodes
-# which would not make much sense in the context of other testbeds
-# so ultimately PlDriver should drop the PlShell inheritance
-# and would have a driver.shell reference to a PlShell instead
-# 
-class PlDriver (Driver, PlShell):
+class PlDriver (Driver):
 
     # the cache instance is a class member so it survives across incoming requests
     cache = None
 
     def __init__ (self, config):
-        PlShell.__init__ (self, config)
         Driver.__init__ (self, config)
+        self.shell = PlShell (config)
         self.cache=None
         if config.SFA_AGGREGATE_CACHING:
             if PlDriver.cache is None:
@@ -81,9 +77,9 @@ class PlDriver (Driver, PlShell):
         pl_record = self.sfa_fields_to_pl_fields(type, hrn, sfa_record)
 
         if type == 'authority':
-            sites = self.GetSites([pl_record['login_base']])
+            sites = self.shell.GetSites([pl_record['login_base']])
             if not sites:
-                pointer = self.AddSite(pl_record)
+                pointer = self.shell.AddSite(pl_record)
             else:
                 pointer = sites[0]['site_id']
 
@@ -92,38 +88,38 @@ class PlDriver (Driver, PlShell):
             for key in pl_record.keys():
                 if key not in acceptable_fields:
                     pl_record.pop(key)
-            slices = self.GetSlices([pl_record['name']])
+            slices = self.shell.GetSlices([pl_record['name']])
             if not slices:
-                 pointer = self.AddSlice(pl_record)
+                 pointer = self.shell.AddSlice(pl_record)
             else:
                  pointer = slices[0]['slice_id']
 
         elif type == 'user':
-            persons = self.GetPersons([sfa_record['email']])
+            persons = self.shell.GetPersons([sfa_record['email']])
             if not persons:
-                pointer = self.AddPerson(dict(sfa_record))
+                pointer = self.shell.AddPerson(dict(sfa_record))
             else:
                 pointer = persons[0]['person_id']
     
             if 'enabled' in sfa_record and sfa_record['enabled']:
-                self.UpdatePerson(pointer, {'enabled': sfa_record['enabled']})
+                self.shell.UpdatePerson(pointer, {'enabled': sfa_record['enabled']})
             # add this person to the site only if she is being added for the first
             # time by sfa and doesont already exist in plc
             if not persons or not persons[0]['site_ids']:
                 login_base = get_leaf(sfa_record['authority'])
-                self.AddPersonToSite(pointer, login_base)
+                self.shell.AddPersonToSite(pointer, login_base)
     
             # What roles should this user have?
-            self.AddRoleToPerson('user', pointer)
+            self.shell.AddRoleToPerson('user', pointer)
             # Add the user's key
             if pub_key:
-                self.AddPersonKey(pointer, {'key_type' : 'ssh', 'key' : pub_key})
+                self.shell.AddPersonKey(pointer, {'key_type' : 'ssh', 'key' : pub_key})
 
         elif type == 'node':
             login_base = hrn_to_pl_login_base(sfa_record['authority'])
-            nodes = self.GetNodes([pl_record['hostname']])
+            nodes = self.shell.GetNodes([pl_record['hostname']])
             if not nodes:
-                pointer = self.AddNode(login_base, pl_record)
+                pointer = self.shell.AddNode(login_base, pl_record)
             else:
                 pointer = nodes[0]['node_id']
     
@@ -140,13 +136,13 @@ class PlDriver (Driver, PlShell):
             raise UnknownSfaType(type)
 
         if (type == "authority"):
-            self.UpdateSite(pointer, new_sfa_record)
+            self.shell.UpdateSite(pointer, new_sfa_record)
     
         elif type == "slice":
             pl_record=self.sfa_fields_to_pl_fields(type, hrn, new_sfa_record)
             if 'name' in pl_record:
                 pl_record.pop('name')
-                self.UpdateSlice(pointer, pl_record)
+                self.shell.UpdateSlice(pointer, pl_record)
     
         elif type == "user":
             # SMBAKER: UpdatePerson only allows a limited set of fields to be
@@ -159,27 +155,27 @@ class PlDriver (Driver, PlShell):
                            'password', 'phone', 'url', 'bio', 'accepted_aup',
                            'enabled']:
                     update_fields[key] = all_fields[key]
-            self.UpdatePerson(pointer, update_fields)
+            self.shell.UpdatePerson(pointer, update_fields)
     
             if new_key:
                 # must check this key against the previous one if it exists
-                persons = self.GetPersons([pointer], ['key_ids'])
+                persons = self.shell.GetPersons([pointer], ['key_ids'])
                 person = persons[0]
                 keys = person['key_ids']
-                keys = self.GetKeys(person['key_ids'])
+                keys = self.shell.GetKeys(person['key_ids'])
                 
                 # Delete all stale keys
                 key_exists = False
                 for key in keys:
                     if new_key != key['key']:
-                        self.DeleteKey(key['key_id'])
+                        self.shell.DeleteKey(key['key_id'])
                     else:
                         key_exists = True
                 if not key_exists:
-                    self.AddPersonKey(pointer, {'key_type': 'ssh', 'key': new_key})
+                    self.shell.AddPersonKey(pointer, {'key_type': 'ssh', 'key': new_key})
     
         elif type == "node":
-            self.UpdateNode(pointer, new_sfa_record)
+            self.shell.UpdateNode(pointer, new_sfa_record)
 
         return True
         
@@ -189,20 +185,20 @@ class PlDriver (Driver, PlShell):
         type=sfa_record['type']
         pointer=sfa_record['pointer']
         if type == 'user':
-            persons = self.GetPersons(pointer)
+            persons = self.shell.GetPersons(pointer)
             # only delete this person if he has site ids. if he doesnt, it probably means
             # he was just removed from a site, not actually deleted
             if persons and persons[0]['site_ids']:
-                self.DeletePerson(pointer)
+                self.shell.DeletePerson(pointer)
         elif type == 'slice':
-            if self.GetSlices(pointer):
-                self.DeleteSlice(pointer)
+            if self.shell.GetSlices(pointer):
+                self.shell.DeleteSlice(pointer)
         elif type == 'node':
-            if self.GetNodes(pointer):
-                self.DeleteNode(pointer)
+            if self.shell.GetNodes(pointer):
+                self.shell.DeleteNode(pointer)
         elif type == 'authority':
-            if self.GetSites(pointer):
-                self.DeleteSite(pointer)
+            if self.shell.GetSites(pointer):
+                self.shell.DeleteSite(pointer)
 
         return True
 
@@ -211,7 +207,7 @@ class PlDriver (Driver, PlShell):
 
 
     ##
-    # Convert SFA fields to PLC fields for use when registering up updating
+    # Convert SFA fields to PLC fields for use when registering or updating
     # registry record in the PLC database
     #
 
@@ -229,8 +225,10 @@ class PlDriver (Driver, PlShell):
                pl_record["url"] = sfa_record["url"]
            if "description" in sfa_record:
                pl_record["description"] = sfa_record["description"]
-           if "expires" in sfa_record:
-               pl_record["expires"] = int(sfa_record["expires"])
+        if "expires" in sfa_record:
+            date = utcparse(sfa_record['expires'])
+            expires = datetime_to_epoch(date)
+            pl_record["expires"] = expires
 
         elif type == "node":
             if not "hostname" in pl_record:
@@ -292,16 +290,16 @@ class PlDriver (Driver, PlShell):
         # get pl records
         nodes, sites, slices, persons, keys = {}, {}, {}, {}, {}
         if node_ids:
-            node_list = self.GetNodes(node_ids)
+            node_list = self.shell.GetNodes(node_ids)
             nodes = list_to_dict(node_list, 'node_id')
         if site_ids:
-            site_list = self.GetSites(site_ids)
+            site_list = self.shell.GetSites(site_ids)
             sites = list_to_dict(site_list, 'site_id')
         if slice_ids:
-            slice_list = self.GetSlices(slice_ids)
+            slice_list = self.shell.GetSlices(slice_ids)
             slices = list_to_dict(slice_list, 'slice_id')
         if person_ids:
-            person_list = self.GetPersons(person_ids)
+            person_list = self.shell.GetPersons(person_ids)
             persons = list_to_dict(person_list, 'person_id')
             for person in persons:
                 key_ids.extend(persons[person]['key_ids'])
@@ -310,7 +308,7 @@ class PlDriver (Driver, PlShell):
                       'slice': slices, 'user': persons}
 
         if key_ids:
-            key_list = self.GetKeys(key_ids)
+            key_list = self.shell.GetKeys(key_ids)
             keys = list_to_dict(key_list, 'key_id')
 
         # fill record info
@@ -358,16 +356,16 @@ class PlDriver (Driver, PlShell):
         # get pl records
         slices, persons, sites, nodes = {}, {}, {}, {}
         if site_ids:
-            site_list = self.GetSites(site_ids, ['site_id', 'login_base'])
+            site_list = self.shell.GetSites(site_ids, ['site_id', 'login_base'])
             sites = list_to_dict(site_list, 'site_id')
         if person_ids:
-            person_list = self.GetPersons(person_ids, ['person_id', 'email'])
+            person_list = self.shell.GetPersons(person_ids, ['person_id', 'email'])
             persons = list_to_dict(person_list, 'person_id')
         if slice_ids:
-            slice_list = self.GetSlices(slice_ids, ['slice_id', 'name'])
+            slice_list = self.shell.GetSlices(slice_ids, ['slice_id', 'name'])
             slices = list_to_dict(slice_list, 'slice_id')       
         if node_ids:
-            node_list = self.GetNodes(node_ids, ['node_id', 'hostname'])
+            node_list = self.shell.GetNodes(node_ids, ['node_id', 'hostname'])
             nodes = list_to_dict(node_list, 'node_id')
        
         # convert ids to hrns
@@ -405,6 +403,11 @@ class PlDriver (Driver, PlShell):
                                if site_id in sites]
                 site_hrns = [".".join([auth_hrn, lbase]) for lbase in login_bases]
                 record['sites'] = site_hrns
+
+            if 'expires' in record:
+                date = utcparse(record['expires'])
+                datestring = datetime_to_string(date)
+                record['expires'] = datestring 
             
         return records   
 
@@ -427,7 +430,7 @@ class PlDriver (Driver, PlShell):
         site_pis = {}
         if site_ids:
             pi_filter = {'|roles': ['pi'], '|site_ids': site_ids} 
-            pi_list = self.GetPersons(pi_filter, ['person_id', 'site_ids'])
+            pi_list = self.shell.GetPersons(pi_filter, ['person_id', 'site_ids'])
             for pi in pi_list:
                 # we will need the pi's hrns also
                 person_ids.append(pi['person_id'])
@@ -444,20 +447,19 @@ class PlDriver (Driver, PlShell):
         # we'll replace pl ids (person_ids) with hrns from the sfa records
         # we obtain
         
-        # get the sfa records
-        table = SfaTable()
+        # get the registry records
         person_list, persons = [], {}
-        person_list = table.find({'type': 'user', 'pointer': person_ids})
+        person_list = dbsession.query (RegRecord).filter(RegRecord.pointer.in_(person_ids))
         # create a hrns keyed on the sfa record's pointer.
         # Its possible for multiple records to have the same pointer so
         # the dict's value will be a list of hrns.
         persons = defaultdict(list)
         for person in person_list:
-            persons[person['pointer']].append(person)
+            persons[person.pointer].append(person)
 
         # get the pl records
         pl_person_list, pl_persons = [], {}
-        pl_person_list = self.GetPersons(person_ids, ['person_id', 'roles'])
+        pl_person_list = self.shell.GetPersons(person_ids, ['person_id', 'roles'])
         pl_persons = list_to_dict(pl_person_list, 'person_id')
 
         # fill sfa info
@@ -467,13 +469,14 @@ class PlDriver (Driver, PlShell):
             #    continue 
             sfa_info = {}
             type = record['type']
+            logger.info("fill_record_sfa_info - incoming record typed %s"%type)
             if (type == "slice"):
                 # all slice users are researchers
                 record['geni_urn'] = hrn_to_urn(record['hrn'], 'slice')
                 record['PI'] = []
                 record['researcher'] = []
                 for person_id in record.get('person_ids', []):
-                    hrns = [person['hrn'] for person in persons[person_id]]
+                    hrns = [person.hrn for person in persons[person_id]]
                     record['researcher'].extend(hrns)                
 
                 # pis at the slice's site
@@ -481,12 +484,13 @@ class PlDriver (Driver, PlShell):
                     pl_pis = site_pis[record['site_id']]
                     pi_ids = [pi['person_id'] for pi in pl_pis]
                     for person_id in pi_ids:
-                        hrns = [person['hrn'] for person in persons[person_id]]
+                        hrns = [person.hrn for person in persons[person_id]]
                         record['PI'].extend(hrns)
                         record['geni_creator'] = record['PI'] 
                 
             elif (type.startswith("authority")):
                 record['url'] = None
+                logger.info("fill_record_sfa_info - authority xherex")
                 if record['pointer'] != -1:
                     record['PI'] = []
                     record['operator'] = []
@@ -495,7 +499,7 @@ class PlDriver (Driver, PlShell):
                         if pointer not in persons or pointer not in pl_persons:
                             # this means there is not sfa or pl record for this user
                             continue   
-                        hrns = [person['hrn'] for person in persons[pointer]] 
+                        hrns = [person.hrn for person in persons[pointer]] 
                         roles = pl_persons[pointer]['roles']   
                         if 'pi' in roles:
                             record['PI'].extend(hrns)
@@ -509,6 +513,7 @@ class PlDriver (Driver, PlShell):
                 # xxx TODO: URI, LatLong, IP, DNS
     
             elif (type == "user"):
+                logger.info('setting user.email')
                 sfa_info['email'] = record.get("email", "")
                 sfa_info['geni_urn'] = hrn_to_urn(record['hrn'], 'user')
                 sfa_info['geni_certificate'] = record['gid'] 
@@ -521,17 +526,17 @@ class PlDriver (Driver, PlShell):
     def update_relation (self, subject_type, target_type, subject_id, target_ids):
         # hard-wire the code for slice/user for now, could be smarter if needed
         if subject_type =='slice' and target_type == 'user':
-            subject=self.GetSlices (subject_id)[0]
+            subject=self.shell.GetSlices (subject_id)[0]
             current_target_ids = subject['person_ids']
             add_target_ids = list ( set (target_ids).difference(current_target_ids))
             del_target_ids = list ( set (current_target_ids).difference(target_ids))
             logger.debug ("subject_id = %s (type=%s)"%(subject_id,type(subject_id)))
             for target_id in add_target_ids:
-                self.AddPersonToSlice (target_id,subject_id)
+                self.shell.AddPersonToSlice (target_id,subject_id)
                 logger.debug ("add_target_id = %s (type=%s)"%(target_id,type(target_id)))
             for target_id in del_target_ids:
                 logger.debug ("del_target_id = %s (type=%s)"%(target_id,type(target_id)))
-                self.DeletePersonFromSlice (target_id, subject_id)
+                self.shell.DeletePersonFromSlice (target_id, subject_id)
         else:
             logger.info('unexpected relation to maintain, %s -> %s'%(subject_type,target_type))
 
@@ -567,7 +572,7 @@ class PlDriver (Driver, PlShell):
                 return slices
     
         # get data from db 
-        slices = self.GetSlices({'peer_id': None}, ['name'])
+        slices = self.shell.GetSlices({'peer_id': None}, ['name'])
         slice_hrns = [slicename_to_hrn(self.hrn, slice['name']) for slice in slices]
         slice_urns = [hrn_to_urn(slice_hrn, 'slice') for slice_hrn in slice_hrns]
     
@@ -615,14 +620,18 @@ class PlDriver (Driver, PlShell):
         # find out where this slice is currently running
         slicename = hrn_to_pl_slicename(slice_hrn)
         
-        slices = self.GetSlices([slicename], ['slice_id', 'node_ids','person_ids','name','expires'])
+        slices = self.shell.GetSlices([slicename], ['slice_id', 'node_ids','person_ids','name','expires'])
         if len(slices) == 0:        
             raise SliverDoesNotExist("%s (used %s as slicename internally)" % (slice_hrn, slicename))
         slice = slices[0]
         
         # report about the local nodes only
-        nodes = self.GetNodes({'node_id':slice['node_ids'],'peer_id':None},
+        nodes = self.shell.GetNodes({'node_id':slice['node_ids'],'peer_id':None},
                               ['node_id', 'hostname', 'site_id', 'boot_state', 'last_contact'])
+
+        if len(nodes) == 0:
+            raise SliverDoesNotExist("You have not allocated any slivers here") 
+
         site_ids = [node['site_id'] for node in nodes]
     
         result = {}
@@ -631,7 +640,7 @@ class PlDriver (Driver, PlShell):
             top_level_status = 'ready'
         result['geni_urn'] = slice_urn
         result['pl_login'] = slice['name']
-        result['pl_expires'] = datetime.datetime.fromtimestamp(slice['expires']).ctime()
+        result['pl_expires'] = datetime_to_string(utcparse(slice['expires']))
         
         resources = []
         for node in nodes:
@@ -640,7 +649,8 @@ class PlDriver (Driver, PlShell):
             res['pl_boot_state'] = node['boot_state']
             res['pl_last_contact'] = node['last_contact']
             if node['last_contact'] is not None:
-                res['pl_last_contact'] = datetime.datetime.fromtimestamp(node['last_contact']).ctime()
+                
+                res['pl_last_contact'] = datetime_to_string(utcparse(node['last_contact']))
             sliver_id = urn_to_sliver_id(slice_urn, slice['slice_id'], node['node_id']) 
             res['geni_urn'] = sliver_id
             if node['boot_state'] == 'boot':
@@ -695,7 +705,7 @@ class PlDriver (Driver, PlShell):
 
     def delete_sliver (self, slice_urn, slice_hrn, creds, options):
         slicename = hrn_to_pl_slicename(slice_hrn)
-        slices = self.GetSlices({'name': slicename})
+        slices = self.shell.GetSlices({'name': slicename})
         if not slices:
             return 1
         slice = slices[0]
@@ -707,23 +717,23 @@ class PlDriver (Driver, PlShell):
         peer = peers.get_peer(self, slice_hrn)
         try:
             if peer:
-                self.UnBindObjectFromPeer('slice', slice['slice_id'], peer)
-            self.DeleteSliceFromNodes(slicename, slice['node_ids'])
+                self.shell.UnBindObjectFromPeer('slice', slice['slice_id'], peer)
+            self.shell.DeleteSliceFromNodes(slicename, slice['node_ids'])
         finally:
             if peer:
-                self.BindObjectToPeer('slice', slice['slice_id'], peer, slice['peer_slice_id'])
+                self.shell.BindObjectToPeer('slice', slice['slice_id'], peer, slice['peer_slice_id'])
         return 1
     
     def renew_sliver (self, slice_urn, slice_hrn, creds, expiration_time, options):
         slicename = hrn_to_pl_slicename(slice_hrn)
-        slices = self.GetSlices({'name': slicename}, ['slice_id'])
+        slices = self.shell.GetSlices({'name': slicename}, ['slice_id'])
         if not slices:
             raise RecordNotFound(slice_hrn)
         slice = slices[0]
         requested_time = utcparse(expiration_time)
-        record = {'expires': int(time.mktime(requested_time.timetuple()))}
+        record = {'expires': int(datetime_to_epoch(requested_time))}
         try:
-            self.UpdateSlice(slice['slice_id'], record)
+            self.shell.UpdateSlice(slice['slice_id'], record)
             return True
         except:
             return False
@@ -731,29 +741,29 @@ class PlDriver (Driver, PlShell):
     # remove the 'enabled' tag 
     def start_slice (self, slice_urn, slice_hrn, creds):
         slicename = hrn_to_pl_slicename(slice_hrn)
-        slices = self.GetSlices({'name': slicename}, ['slice_id'])
+        slices = self.shell.GetSlices({'name': slicename}, ['slice_id'])
         if not slices:
             raise RecordNotFound(slice_hrn)
         slice_id = slices[0]['slice_id']
-        slice_tags = self.GetSliceTags({'slice_id': slice_id, 'tagname': 'enabled'}, ['slice_tag_id'])
+        slice_tags = self.shell.GetSliceTags({'slice_id': slice_id, 'tagname': 'enabled'}, ['slice_tag_id'])
         # just remove the tag if it exists
         if slice_tags:
-            self.DeleteSliceTag(slice_tags[0]['slice_tag_id'])
+            self.shell.DeleteSliceTag(slice_tags[0]['slice_tag_id'])
         return 1
 
     # set the 'enabled' tag to 0
     def stop_slice (self, slice_urn, slice_hrn, creds):
         slicename = hrn_to_pl_slicename(slice_hrn)
-        slices = self.GetSlices({'name': slicename}, ['slice_id'])
+        slices = self.shell.GetSlices({'name': slicename}, ['slice_id'])
         if not slices:
             raise RecordNotFound(slice_hrn)
         slice_id = slices[0]['slice_id']
-        slice_tags = self.GetSliceTags({'slice_id': slice_id, 'tagname': 'enabled'})
+        slice_tags = self.shell.GetSliceTags({'slice_id': slice_id, 'tagname': 'enabled'})
         if not slice_tags:
-            self.AddSliceTag(slice_id, 'enabled', '0')
+            self.shell.AddSliceTag(slice_id, 'enabled', '0')
         elif slice_tags[0]['value'] != "0":
             tag_id = slice_tags[0]['slice_tag_id']
-            self.UpdateSliceTag(tag_id, '0')
+            self.shell.UpdateSliceTag(tag_id, '0')
         return 1
     
     def reset_slice (self, slice_urn, slice_hrn, creds):