def getDetailsTree(self, hostname): server_info = read_server_info(hostname) content = {} #Configuring Instances if server_info: content = {"isFolder": True, "title": 'OracleDB', "key":'OracleDB', "icon":"oracle_db.png"} logger.debug('Configuring Databases') db_instances = {'title': 'Databases', 'isFolder':True, "key":"databases", "icon":"folder_database.png", "type":"databases"} dbs = [] for instance in server_info["instances"]: db = {'title':instance['instance_name'], "key":instance['instance_name'], "icon":"database.png", "type":"database", "instance":instance['instance_name'], "detailsEnabled":"true", 'url': reverse('oracledb_instance_details', kwargs={'hostname':hostname, 'database_name':instance['instance_name'], 'resource_name':instance['instance_name']})} #Configuring Applications # logger.debug('Configuring Tables') # tables = {'title': 'Tables', 'isFolder':True, "key":"tables", "icon":"folder_documents.png", "type":"tables"} # tabs = [] # for table in database['tables']: # tab = {'title':table, "key":table, "icon":"datasource.png", "type":"table", "database":database['name']} # tabs.append(tab) # tables['children'] = tabs # db['children'] = [tables] dbs.append(db) db_instances['children'] = dbs children = [] children.append(db_instances) content['children'] = children return content
def getDetailsTree(self, hostname): server_info = read_server_info(hostname) content = {} #Configuring Instances if server_info: content = { "isFolder": True, "title": 'OracleDB', "key": 'OracleDB', "icon": "oracle_db.png" } logger.debug('Configuring Databases') db_instances = { 'title': 'Databases', 'isFolder': True, "key": "databases", "icon": "folder_database.png", "type": "databases" } dbs = [] for instance in server_info["instances"]: db = { 'title': instance['instance_name'], "key": instance['instance_name'], "icon": "database.png", "type": "database", "instance": instance['instance_name'], "detailsEnabled": "true", 'url': reverse('oracledb_instance_details', kwargs={ 'hostname': hostname, 'database_name': instance['instance_name'], 'resource_name': instance['instance_name'] }) } #Configuring Applications # logger.debug('Configuring Tables') # tables = {'title': 'Tables', 'isFolder':True, "key":"tables", "icon":"folder_documents.png", "type":"tables"} # tabs = [] # for table in database['tables']: # tab = {'title':table, "key":table, "icon":"datasource.png", "type":"table", "database":database['name']} # tabs.append(tab) # tables['children'] = tabs # db['children'] = [tables] dbs.append(db) db_instances['children'] = dbs children = [] children.append(db_instances) content['children'] = children return content
def extract_instances_name(hostname): instances = [] server_info = read_server_info(hostname) if server_info: for instance in server_info['instances']: instances.append(instance['instance_name']) return instances
def get_instance_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: found_db = None for instance in server_info["instances"]: if instance["instance_name"] == database_name: found_db = instance break return render_to_response('platforms/oracledb/database.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "instance":found_db, "hostname": hostname}, context_instance=RequestContext(request)) else: return render_to_response('platforms/oracledb/database.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "hostname": hostname}, context_instance=RequestContext(request))
def get_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: version = "" if "version" in server_info: version = server_info["version"] datadir = "" if "data_dir" in server_info: datadir = server_info["data_dir"] return render_to_response('platforms/oracledb/server.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "pg_version": version, "pg_datadir": datadir, "hostname": hostname}, context_instance=RequestContext(request)) else: return render_to_response('platforms/oracledb/server.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "hostname": hostname}, context_instance=RequestContext(request))
def extract_schema(hostname, instancename): schemas = [] server_info = read_server_info(hostname) for instance in server_info['instances']: if instancename == instance['instance_name']: found_instance = instance break if found_instance: for schema in found_instance['data']: schemas.append(schema['user_name']) else: logger.info("Cannot find instance %s" % instancename) return schemas
def extract_compatible_servers(schema_name): servers = Server.objects.filter(deleted=False) compatible_servers = [] for server in servers: server_info = read_server_info(server.hostname) if server_info: for instance in server_info['instances']: for data in instance['data']: if data['user_name'] == schema_name: compatible_servers.append({"server": server.hostname, "instance": instance['instance_name']}) break return compatible_servers
def get_instance_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: found_db = None for instance in server_info["instances"]: if instance["instance_name"] == database_name: found_db = instance break return render_to_response('platforms/oracledb/database.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "instance": found_db, "hostname": hostname }, context_instance=RequestContext(request)) else: return render_to_response('platforms/oracledb/database.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "hostname": hostname }, context_instance=RequestContext(request))
def get_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: version = "" if "version" in server_info: version = server_info["version"] datadir = "" if "data_dir" in server_info: datadir = server_info["data_dir"] return render_to_response('platforms/oracledb/server.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "pg_version": version, "pg_datadir": datadir, "hostname": hostname }, context_instance=RequestContext(request)) else: return render_to_response('platforms/oracledb/server.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "hostname": hostname }, context_instance=RequestContext(request))