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))
