def get_data(self): try: owner = str(self.request.user) db = pymysql.connect(host='10.29.16.253', port=3306, user='******', passwd='BSoniC', db='expo_sahara') cursor = db.cursor() get_clusters = "select Cluster_id from lease_active_clusters where owner='" + owner + "'" cursor.execute(get_clusters) cluster_user_list = [item[0] for item in cursor.fetchall()] search_opts = {} filter = self.get_server_filter_info(self.request) if filter['value'] and filter['field']: search_opts = {filter['field']: filter['value']} clusters = saharaclient.cluster_list(self.request, search_opts) except Exception: clusters = [] exceptions.handle(self.request, _("Unable to fetch cluster list")) clusters_user_filter = [] for x in clusters: if ( x.id in cluster_user_list ): clusters_user_filter.append(x) #return clusters return clusters_user_filter
def populate_cluster_choices(self, request, context): try: clusters = saharaclient.cluster_list(request) except Exception: clusters = [] exceptions.handle(request, _("Unable to fetch clusters.")) choices = [(cluster.id, cluster.name) for cluster in clusters] return choices
def get_data(self): try: search_opts = {} filter = self.get_server_filter_info(self.request) if filter['value'] and filter['field']: search_opts = {filter['field']: filter['value']} clusters = saharaclient.cluster_list(self.request, search_opts) except Exception: clusters = [] exceptions.handle(self.request, _("Unable to fetch cluster list")) return clusters
def populate_cluster_choices(self, request, context): try: clusters = saharaclient.cluster_list(request) except Exception: clusters = [] exceptions.handle(request, _("Unable to fetch clusters.")) choices = [(cluster.id, cluster.name) for cluster in clusters] return choices
def get_data(self): try: search_opts = {} filter = self.get_server_filter_info(self.request) if filter['value'] and filter['field']: search_opts = {filter['field']: filter['value']} clusters = saharaclient.cluster_list(self.request, search_opts) except Exception: clusters = [] exceptions.handle(self.request, _("Unable to fetch cluster list")) return clusters