def _check_project_to_project(self): _k_projects = keystone.get_projects_by_project_ids() _g_projects = self.gclient.get_projects(type='simple') k_projects = [] g_projects = [] for kp in _k_projects: billing_owner = kp['users']['billing_owner'] k_projects.append( keystone.Project( kp['id'], billing_owner.get('id') if billing_owner else None, kp['domain_id'])) for gp in _g_projects: g_projects.append( keystone.Project(gp['project_id'], gp['billing_owner'], gp['domain_id'])) # projects in keystone but not in gringotts creating_projects = list(set(k_projects) - set(g_projects)) # projects in gringotts but not in keystone deleting_projects = [] _deleted_projects = list(set(g_projects) - set(k_projects)) for p in _deleted_projects: if self.gclient.get_resources(p.project_id): deleting_projects.append(p) # projects whose billing owner is not equal to each other billing_projects = [] # changing billing owner projects_k = sorted(set(g_projects) & set(k_projects), key=lambda p: p.project_id) projects_g = sorted(set(k_projects) & set(g_projects), key=lambda p: p.project_id) for k, g in zip(projects_k, projects_g): if k.billing_owner_id != g.billing_owner_id: billing_projects.append(k) return (creating_projects, deleting_projects, billing_projects)
def get_all(self, user_id=None, type=None, duration=None): """Get all projects.""" user_id = acl.get_limited_to_user(request.headers, 'projects_get') or user_id self.conn = pecan.request.db_conn result = [] if not type or type.lower() == 'pay': # if admin call this api, limit to admin's user_id if not user_id: user_id = request.context.user_id try: user_projects = self.conn.get_user_projects(request.context, user_id=user_id) except Exception as e: LOG.exception('Fail to get all projects') raise exception.DBError(reason=e) project_ids = [up.project_id for up in user_projects] if not project_ids: LOG.warn('User %s has no payed projects' % user_id) return [] projects = keystone.get_projects_by_project_ids(project_ids) for u, p in itertools.product(user_projects, projects): if u.project_id == p['id']: billing_owner = p['users']['billing_owner'] project_owner = p['users']['project_owner'] project_creator = p['users']['project_creator'] up = models.UserProject(user_id=user_id, project_id=u.project_id, project_name=p['name'], user_consumption=u.user_consumption, project_consumption=u.project_consumption, billing_owner=dict(user_id=billing_owner.get('id') if billing_owner else None, user_name=billing_owner.get('name') if billing_owner else None), project_owner=dict(user_id=project_owner.get('id') if project_owner else None, user_name=project_owner.get('name') if project_owner else None), project_creator=dict(user_id=project_creator.get('id') if project_creator else None, user_name=project_creator.get('name') if project_creator else None), is_historical=u.is_historical, created_at=timeutils.parse_isotime(p['created_at']) if p['created_at'] else None) result.append(up) elif type.lower() == 'all': # if admin call this api, limit to admin's user_id if not user_id: user_id = request.context.user_id k_projects = keystone.get_projects_by_user(user_id) project_ids = [p['id'] for p in k_projects] if not project_ids: LOG.warn('User %s has no projects' % user_id) return [] try: g_projects = self.conn.get_projects_by_project_ids(request.context, project_ids) except Exception as e: LOG.exception('Fail to get all projects') raise exception.DBError(reason=e) for k, g in itertools.product(k_projects, g_projects): if k['id'] == g.project_id: billing_owner = k['users']['billing_owner'] project_owner = k['users']['project_owner'] project_creator = k['users']['project_creator'] up = models.UserProject(user_id=user_id, project_id=g.project_id, project_name=k['name'], project_consumption=g.consumption, billing_owner=dict(user_id=billing_owner.get('id') if billing_owner else None, user_name=billing_owner.get('name') if billing_owner else None), project_owner=dict(user_id=project_owner.get('id') if project_owner else None, user_name=project_owner.get('name') if project_owner else None), project_creator=dict(user_id=project_creator.get('id') if project_creator else None, user_name=project_creator.get('name') if project_creator else None), is_historical=False, created_at=timeutils.parse_isotime(k['created_at']) if k['created_at'] else None) result.append(up) elif type.lower() == 'simple': duration = gringutils.normalize_timedelta(duration) if duration: active_from = datetime.datetime.utcnow() - duration else: active_from = None g_projects = list(self.conn.get_projects(request.context, user_id=user_id, active_from=active_from)) project_ids = [p.project_id for p in g_projects] if not project_ids: LOG.warn('User %s has no payed projects' % user_id) return [] k_projects = keystone.get_projects_by_project_ids(project_ids) for k, g in itertools.product(k_projects, g_projects): if k['id'] == g.project_id: up = models.UserProject(project_id=g.project_id, project_name=k['name'], domain_id=g.domain_id, billing_owner=dict(user_id=g.user_id)) result.append(up) return result